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後，登入就恢復正常了。
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29734436/viewspace-2137983/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Oracle VM上實施Oracle 12cR2 RACOracle
- Oracle 12cR2 RAC安裝配置及問題解決Oracle
- 基於Linux的oracle 12cR2 RAC 標準化安裝（一）LinuxOracle
- 基於Linux的oracle 12cR2 RAC 標準化安裝（二）LinuxOracle
- 基於Linux的oracle 12cR2 RAC 標準化安裝（三）LinuxOracle
- 基於Linux的oracle 12cR2 RAC 標準化安裝（四）LinuxOracle
- Oracle 12CR2 dbca -silent -createDatabaseOracleDatabase
- ORA-01033: ORACLE initialization or shutdown in progress錯誤Oracle
- Oracle 12CR2 Install the Sample SchemasOracle
- ora-01033:oracle initialization or shutdown in progress 解決方法Oracle
- Oracle 12Cr2 Using CloneDB to clone a databaseOracleDatabase
- RHEL6.4安裝Oracle 12cR2Oracle
- DG配置錯誤：ORA-01033: ORACLE initialization or shutdown in progressOracle
- ORA-01033:ORACLE initialization or shutdown in progress錯誤解決Oracle
- Oracle Data Guard Feature 12cR2系列（二）Oracle
- Oracle Data Guard Feature 12cR2系列（一）Oracle
- 12CR2 using create database command for create non-CDB rac databaseDatabase
- Connecting To 12CR2 RAC Pluggable Database With ORA-1033Database
- Oracle 12CR2 Oracle Restart - ASM Startup fails with PRCR-1079OracleRESTASMAI
- Oracle Database 12cR2/R1中的更改OracleDatabase
- Oracle Database 12cR2多租戶權威指南OracleDatabase
- oracle RACOracle
- ORA-01033: ORACLE initialization or shutdown in progress 實用的處理方法Oracle
- Error:ORA-01033:ORACLE initialization or shutdown in progress錯誤解決（轉）ErrorOracle
- Oracle RAC Cache Fusion 系列十七：Oracle RAC DRMOracle
- Oracle 12CR2查詢轉換之謂詞推送Oracle
- Oracle 12CR2查詢轉換之星型轉換Oracle
- Oracle 12cR2中的ADG會話保留特性Oracle會話
- Oracle RAC CacheFusion 系列十五：Oracle RAC CRServer Part TwoOracleServer
- ORACLE RAC clusterwareOracle
- oracle rac oemOracle
- oracle rac + dataguardOracle
- Oracle 11.2 DataGuard RAC To RAC搭建Oracle
- Oracle 12CR2查詢轉換之檢視合併Oracle
- Oracle 12CR2查詢轉換之表擴充套件Oracle套件
- oracle 12cR2 new feature dbca 命令可以建立standby 庫Oracle
- oracle斷電重啟之ORA-01033和ORA-01172Oracle
- Oracle RAC Cache Fusion系列十八：Oracle RAC Statisticsand Wait EventsOracleAI