Oracle 12c Container RAC Database Pluggable Error ORA-01033

Today I will talk about a problem I encountered in pdbs “ORA-01033” error on Oracle Container Database.

Query existing databases running on the container.

SELECT inst_id,con_id,name,open_mode FROM gv$pdbs ORDER BY con_id,inst_id

CON_ID CON_NAME                       OPEN MODE  RESTRICTED

     2 PDB$SEED                     READ ONLY  NO
     3 TEST1                        MOUNTED
     4 TEST2                        MOUNTED
     5 TEST3                        MOUNTED
     6 TEST4                        MOUNTED
     7 TEST5                        MOUNTED
     8 TEST6                        MOUNTED
     9 TEST7                        MOUNTED
    10 TEST8                        MOUNTED
    11 TEST9                        MOUNTED
    12 TEST10                       MOUNTED

If the databases are “ALTER PLUGGABLE DATABASE ALL OPEN” If you opened it with the command, you just opened it on the relevant cdb. In this case, other pdb’s remained in mount mode.

You can start by giving the names of the relevant pdb.

SQL> ALTER PLUGGABLE DATABASE pdb1 OPEN INSTANCES=(‘TEST1’);

Pluggable database altered.

You can also start at the same time by adding the parameter INSTANCES = ALL for all pdb.

Or

alter pluggable database all open read write;

Congrat, have a nice day.

You can also browse the other article.