本文共 13111 字，大约阅读时间需要 43 分钟。
在12C RAC中登录pdb时出现了ORA-01033错误
[oracle@jytest1 ~]$ sqlplus hr/hr@JYPDBSQL*Plus: Release 12.2.0.1.0 Production on Tue Apr 11 18:15:26 2017Copyright (c) 1982, 2016, Oracle. All rights reserved.ERROR:ORA-01033: ORACLE initialization or shutdown in progressProcess ID: 0Session ID: 0 Serial number: 0
如是查看pdb数据库的状态，从以下信息来看pdb是正常的
[grid@jytest1 ~]$ lsnrctl statusLSNRCTL for Linux: Version 12.2.0.1.0 - Production on 11-APR-2017 18:03:18Copyright (c) 1991, 2016, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 12.2.0.1.0 - ProductionStart Date 21-MAR-2017 19:13:39Uptime 20 days 22 hr. 49 min. 38 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /u01/app/product/12.2.0/crs/network/admin/listener.oraListener Log File /u01/app/grid/diag/tnslsnr/jytest1/listener/alert/log.xmlListening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.138.130.171)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.138.130.175)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=jytest1.jydba.net)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/product/12.2.0/db/admin/jy/xdb_wallet))(Presentation=HTTP)(Session=RAW))Services Summary...Service "+ASM" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service...Service "+ASM_CRS" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service...Service "+ASM_DATA" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service...Service "+ASM_TEST" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service...Service "4b2c6373ae2547cce053ab828a0a7ca3" has 1 instance(s). Instance "jy1", status READY, has 1 handler(s) for this service...Service "jy" has 1 instance(s). Instance "jy1", status READY, has 1 handler(s) for this service...Service "jyXDB" has 1 instance(s). Instance "jy1", status READY, has 1 handler(s) for this service...Service "jypdb" has 1 instance(s). Instance "jy1", status READY, has 1 handler(s) for this service...The command completed successfully[grid@jytest2 ~]$ lsnrctl statusLSNRCTL for Linux: Version 12.2.0.1.0 - Production on 11-APR-2017 18:16:50Copyright (c) 1991, 2016, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 12.2.0.1.0 - ProductionStart Date 21-MAR-2017 19:11:40Uptime 20 days 23 hr. 5 min. 10 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /u01/app/product/12.2.0/crs/network/admin/listener.oraListener Log File /u01/app/grid/diag/tnslsnr/jytest2/listener/alert/log.xmlListening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.138.130.172)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.138.130.176)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=jytest2.jydba.net)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/product/12.2.0/db/admin/jy/xdb_wallet))(Presentation=HTTP)(Session=RAW))Services Summary...Service "+ASM" has 1 instance(s). Instance "+ASM2", status READY, has 1 handler(s) for this service...Service "+ASM_CRS" has 1 instance(s). Instance "+ASM2", status READY, has 1 handler(s) for this service...Service "+ASM_DATA" has 1 instance(s). Instance "+ASM2", status READY, has 1 handler(s) for this service...Service "+ASM_TEST" has 1 instance(s). Instance "+ASM2", status READY, has 1 handler(s) for this service...Service "4b2c6373ae2547cce053ab828a0a7ca3" has 1 instance(s). Instance "jy2", status READY, has 1 handler(s) for this service...Service "jy" has 1 instance(s). Instance "jy2", status READY, has 1 handler(s) for this service...Service "jyXDB" has 1 instance(s). Instance "jy2", status READY, has 1 handler(s) for this service...Service "jypdb" has 1 instance(s). Instance "jy2", status READY, has 1 handler(s) for this service...The command completed successfully[grid@jytest1 ~]$ crsctl stat res -t--------------------------------------------------------------------------------Name Target State Server State details --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.ASMNET1LSNR_ASM.lsnr ONLINE ONLINE jytest1 STABLE ONLINE ONLINE jytest2 STABLEora.CRS.dg ONLINE ONLINE jytest1 STABLE ONLINE ONLINE jytest2 STABLEora.DATA.dg ONLINE ONLINE jytest1 STABLE ONLINE ONLINE jytest2 STABLEora.LISTENER.lsnr ONLINE ONLINE jytest1 STABLE ONLINE ONLINE jytest2 STABLEora.TEST.dg ONLINE ONLINE jytest1 STABLE ONLINE ONLINE jytest2 STABLEora.chad ONLINE ONLINE jytest1 STABLE ONLINE ONLINE jytest2 STABLEora.net1.network ONLINE ONLINE jytest1 STABLE ONLINE ONLINE jytest2 STABLEora.ons ONLINE ONLINE jytest1 STABLE ONLINE ONLINE jytest2 STABLEora.proxy_advm OFFLINE OFFLINE jytest1 STABLE OFFLINE OFFLINE jytest2 STABLE--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE jytest1 STABLEora.LISTENER_SCAN2.lsnr 1 ONLINE ONLINE jytest2 STABLEora.LISTENER_SCAN3.lsnr 1 ONLINE ONLINE jytest1 STABLEora.MGMTLSNR 1 ONLINE ONLINE jytest2 169.254.237.250 88.8 8.88.2,STABLEora.asm 1 ONLINE ONLINE jytest1 Started,STABLE 2 ONLINE ONLINE jytest2 Started,STABLE 3 OFFLINE OFFLINE STABLEora.cvu 1 ONLINE ONLINE jytest2 STABLEora.jy.db 1 ONLINE ONLINE jytest1 Open,HOME=/u01/app/o racle/product/12.2.0 /db,STABLE 2 ONLINE ONLINE jytest2 Open,HOME=/u01/app/o racle/product/12.2.0 /db,STABLEora.jytest1.vip 1 ONLINE ONLINE jytest1 STABLEora.jytest2.vip 1 ONLINE ONLINE jytest2 STABLEora.mgmtdb 1 ONLINE ONLINE jytest2 Open,STABLEora.qosmserver 1 ONLINE ONLINE jytest2 STABLEora.scan1.vip 1 ONLINE ONLINE jytest1 STABLEora.scan2.vip 1 ONLINE ONLINE jytest2 STABLEora.scan3.vip 1 ONLINE ONLINE jytest1 STABLE--------------------------------------------------------------------------------[grid@jytest2 ~]$ crsctl stat res -t--------------------------------------------------------------------------------Name Target State Server State details --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.ASMNET1LSNR_ASM.lsnr ONLINE ONLINE jytest1 STABLE ONLINE ONLINE jytest2 STABLEora.CRS.dg ONLINE ONLINE jytest1 STABLE ONLINE ONLINE jytest2 STABLEora.DATA.dg ONLINE ONLINE jytest1 STABLE ONLINE ONLINE jytest2 STABLEora.LISTENER.lsnr ONLINE ONLINE jytest1 STABLE ONLINE ONLINE jytest2 STABLEora.TEST.dg ONLINE ONLINE jytest1 STABLE ONLINE ONLINE jytest2 STABLEora.chad ONLINE ONLINE jytest1 STABLE ONLINE ONLINE jytest2 STABLEora.net1.network ONLINE ONLINE jytest1 STABLE ONLINE ONLINE jytest2 STABLEora.ons ONLINE ONLINE jytest1 STABLE ONLINE ONLINE jytest2 STABLEora.proxy_advm OFFLINE OFFLINE jytest1 STABLE OFFLINE OFFLINE jytest2 STABLE--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE jytest1 STABLEora.LISTENER_SCAN2.lsnr 1 ONLINE ONLINE jytest2 STABLEora.LISTENER_SCAN3.lsnr 1 ONLINE ONLINE jytest1 STABLEora.MGMTLSNR 1 ONLINE ONLINE jytest2 169.254.237.250 88.8 8.88.2,STABLEora.asm 1 ONLINE ONLINE jytest1 Started,STABLE 2 ONLINE ONLINE jytest2 Started,STABLE 3 OFFLINE OFFLINE STABLEora.cvu 1 ONLINE ONLINE jytest2 STABLEora.jy.db 1 ONLINE ONLINE jytest1 Open,HOME=/u01/app/o racle/product/12.2.0 /db,STABLE 2 ONLINE ONLINE jytest2 Open,HOME=/u01/app/o racle/product/12.2.0 /db,STABLEora.jytest1.vip 1 ONLINE ONLINE jytest1 STABLEora.jytest2.vip 1 ONLINE ONLINE jytest2 STABLEora.mgmtdb 1 ONLINE ONLINE jytest2 Open,STABLEora.qosmserver 1 ONLINE ONLINE jytest2 STABLEora.scan1.vip 1 ONLINE ONLINE jytest1 STABLEora.scan2.vip 1 ONLINE ONLINE jytest2 STABLEora.scan3.vip 1 ONLINE ONLINE jytest1 STABLE--------------------------------------------------------------------------------
虽然，从监听与集群资源来看是正常，但因为这里pdb数据库（jypdb）使用的服务名与pdb数据库名相同，还有就是因为是RAC数据库，因为在RAC环境中，当PDB被mount时，实例将使用pdb数据库名向SCAN与本地监听程序注册PDB，如果使用SCAN IP来登录pdb数据库，就可能将连接请求指派给PDB只被mounted的实例(没有open)，如是检查pdb是否open，发现果然pdb在节点2上的实例没有被open，如是执行以下
命令:[root@jytest2 ~]# su - oracleLast login: Tue Apr 11 17:37:14 CST 2017[oracle@jytest2 ~]$ sqlplus / as sysdbaSQL*Plus: Release 12.2.0.1.0 Production on Tue Apr 11 18:17:44 2017Copyright (c) 1982, 2016, Oracle. All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit ProductionSQL> alter session set container=jypdb;Session altered.SQL> alter pluggable database jypdb open;Pluggable database altered.
[oracle@jytest1 ~]$ sqlplus hr/hr@JYPDBSQL*Plus: Release 12.2.0.1.0 Production on Tue Apr 11 18:18:18 2017Copyright (c) 1982, 2016, Oracle. All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit ProductionSQL> conn system/xxzx7817600@JYPDBConnected.
在RAC所有节点上open pdb数据库jypdb后，登录就恢复正常了。
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26015009/viewspace-2137039/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/26015009/viewspace-2137039/