12c的一个坑,使用alter pluggable database all open;打开所有pdb,然后这是节点一的查询结果
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 xxxxxxxxxxxx READ WRITE NO
4 xxxxxxxxxxxx READ WRITE NO
5 xxxxxxxxxxxx READ WRITE NO
6 xxxxxxxxxxxx READ WRITE NO
7 xxxxxxxxxxxx READ WRITE NO
8 xxxxxxxxxxxx READ WRITE NO
9 xxxxxxxxxxxx READ WRITE NO
10 xxxxxxxxxxxx READ WRITE NO
11 xxxxxxxxxxxx READ WRITE NO
12 xxxxxxxxxxxx READ WRITE NO
然后尝试连接报了这个错
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0
查看二号节点
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 xxxxxxxxxxxx MOUNTED
4 xxxxxxxxxxxx MOUNTED
5 xxxxxxxxxxxx MOUNTED
6 xxxxxxxxxxxx MOUNTED
7 xxxxxxxxxxxx MOUNTED
8 xxxxxxxxxxxx MOUNTED
9 xxxxxxxxxxxx MOUNTED
10 xxxxxxxxxxxx MOUNTED
11 xxxxxxxxxxxx MOUNTED
12 xxxxxxxxxxxx MOUNTED
……--_--!!!
把二号节点的pdb启动后一切正常