Oracle 12CR2 RAC ORA-01033

在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后，登录就恢复正常了。