How to Check DB Status by Script
To check if a databae is alive or not, we already have a way to do it. However, such script can't tell NOMOUNT, MOUNT or… Read More »How to Check DB Status by Script
OPEN State
How to Resolve ORA-00214: control file
ORA-00214 Tried to startup or mount a database, we got ORA-00214. SQL> startup ORACLE instance started. ... ORA-00214: control file '/u01/app/oracle/fast_recovery_area/ORCLCDB/control02.ctl' version 2286 inconsistent with… Read More »How to Resolve ORA-00214: control file
How to Resolve ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
ORA-01219 Tried to query a data dictionary, but it failed with ORA-01219. SQL> select * from dba_tablespaces; select * from dba_tablespaces … Read More »How to Resolve ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
How to Resolve ORA-65011: Pluggable database does not exist
ORA-65011 There're several use cases that may throw ORA-65011. Switch Session Container Tried to set a PDB as the current session container, but it failed… Read More »How to Resolve ORA-65011: Pluggable database does not exist
Database States Differentiations in Oracle
We have already known that there're 4 states in life cycle of an instance. They are idle, nomount, mount and open. In this post, we… Read More »Database States Differentiations in Oracle
How Srvctl Start Database
To startup a RAC database, we'd better NOT use commands that we used to startup a normal single-instance database, we should use Server Control Utility… Read More »How Srvctl Start Database