ORA-12154: TNS:could not resolve the connect identifier specified

In Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 , when you try to login any PDB (pluggable database) then you may face as given below error. Error:- SQL> conn gg2/gg2@PDBGG2; (gg2 is user created for PDB,PDBGG2) ERROR: ORA-12154: TNS:could not resolve the connect identifier specified Solution:- 1.. Make sure your pluggable databse is open if … Continue reading ORA-12154: TNS:could not resolve the connect identifier specified

ORA-00333: redo log read error block count

SQL> startup ORACLE instance started. Total System Global Area ***** bytes Fixed Size ***** bytes Variable Size ***** bytes Database Buffers ***** bytes Redo Buffers ***** bytes Database mounted. ORA-00333: redo log read error block *Number* count *Number* Step 1: As the Database is in mount mode, query v$log & v$logfile to identify the status … Continue reading ORA-00333: redo log read error block count