在12C RAC中登录pdb时出现了ORA-01033错误
[oracle@jytest1 ~]$ sqlplus hr/hr@JYPDB SQL*Plus: Release 12.2.0.1.0 Production on Tue Apr 11 18:15:26 2017 Copyright (c) 1982, 2016, Oracle. All rights reserved. ERROR: ORA-01033: ORACLE initialization or shutdown in progress Process ID: 0 Session ID: 0 Serial number: 0
如是查看pdb数据库的状态，从以下信息来看pdb是正常的
[grid@jytest1 ~]$ lsnrctl status
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 11-APR-2017 18:03:18
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 21-MAR-2017 19:13:39
Uptime 20 days 22 hr. 49 min. 38 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/product/12.2.0/crs/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/jytest1/listener/alert/log.xml
Listening 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 status
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 11-APR-2017 18:16:50
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 21-MAR-2017 19:11:40
Uptime 20 days 23 hr. 5 min. 10 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/product/12.2.0/crs/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/jytest2/listener/alert/log.xml
Listening 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 STABLE
ora.CRS.dg
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.DATA.dg
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.TEST.dg
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.chad
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.net1.network
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.ons
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.proxy_advm
OFFLINE OFFLINE jytest1 STABLE
OFFLINE OFFLINE jytest2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE jytest1 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE jytest2 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE jytest1 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE jytest2 169.254.237.250 88.8
8.88.2,STABLE
ora.asm
1 ONLINE ONLINE jytest1 Started,STABLE
2 ONLINE ONLINE jytest2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE jytest2 STABLE
ora.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,STABLE
ora.jytest1.vip
1 ONLINE ONLINE jytest1 STABLE
ora.jytest2.vip
1 ONLINE ONLINE jytest2 STABLE
ora.mgmtdb
1 ONLINE ONLINE jytest2 Open,STABLE
ora.qosmserver
1 ONLINE ONLINE jytest2 STABLE
ora.scan1.vip
1 ONLINE ONLINE jytest1 STABLE
ora.scan2.vip
1 ONLINE ONLINE jytest2 STABLE
ora.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 STABLE
ora.CRS.dg
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.DATA.dg
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.TEST.dg
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.chad
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.net1.network
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.ons
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.proxy_advm
OFFLINE OFFLINE jytest1 STABLE
OFFLINE OFFLINE jytest2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE jytest1 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE jytest2 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE jytest1 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE jytest2 169.254.237.250 88.8
8.88.2,STABLE
ora.asm
1 ONLINE ONLINE jytest1 Started,STABLE
2 ONLINE ONLINE jytest2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE jytest2 STABLE
ora.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,STABLE
ora.jytest1.vip
1 ONLINE ONLINE jytest1 STABLE
ora.jytest2.vip
1 ONLINE ONLINE jytest2 STABLE
ora.mgmtdb
1 ONLINE ONLINE jytest2 Open,STABLE
ora.qosmserver
1 ONLINE ONLINE jytest2 STABLE
ora.scan1.vip
1 ONLINE ONLINE jytest1 STABLE
ora.scan2.vip
1 ONLINE ONLINE jytest2 STABLE
ora.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 - oracle Last login: Tue Apr 11 17:37:14 CST 2017 [oracle@jytest2 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Tue Apr 11 18:17:44 2017 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL> alter session set container=jypdb; Session altered. SQL> alter pluggable database jypdb open; Pluggable database altered.
[oracle@jytest1 ~]$ sqlplus hr/hr@JYPDB SQL*Plus: Release 12.2.0.1.0 Production on Tue Apr 11 18:18:18 2017 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL> conn system/xxzx7817600@JYPDB Connected.
在RAC所有节点上open pdb数据库jypdb后，登录就恢复正常了。