rac环境中连接pdb报ORA-01033(转)
sqlplus system/dingjia@192.168.82.139:1528/third
连接时遇到下面的提示:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0
觉得奇怪,这个pdb明明是打开的,原来在12c RAC 中每个节点的CDB 管理自己的PDB,也就是说,当我们在节点1对PDB进行操作时,不会影响到节点2的PDB。两个节点都有打开才行!
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 THIRD MOUNTED
SQL> alter pluggable database third open;
Pluggable database altered.
SQL> alter pluggable database all save state;
Pluggable database altered.