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.
alter pluggable database all open read write;
Congrat, have a nice day.