Connecting To 12CR2 RAC Pluggable Database With ORA-1033
作業系統為Oracle Linux 7.1 資料庫為Oracle 12.2.0.1,今天在登入pdb時使用sysdba許可權登入正常,使用非sysdba許可權登入出現ora-01033錯誤,錯誤資訊如下:
[root@jytest1 ~]# su - oracle Last login: Tue May 16 18:32:29 CST 2017 [oracle@jytest1 ~]$ sqlplus /nolog SQL*Plus: Release 12.2.0.1.0 Production on Tue May 16 18:39:42 2017 Copyright (c) 1982, 2016, Oracle. All rights reserved. SQL> conn sys/xxzx7817600@jypdb as sysdba Connected. SQL> conn jy/jy@jypdb ERROR: ORA-01033: ORACLE initialization or shutdown in progress Process ID: 0 Session ID: 0 Serial number: 0 Warning: You are no longer connected to ORACLE.
在MOS上有篇文件" Connecting To A 12c RAC Pluggable Database Intermittently Fails With ORA-1033 (Doc ID 1998112.1)"描述相關問題,原因有兩個,一是pdb所使用的服務名與pdb資料庫名相同,二是PDB沒有在所有RAC例項上open,說使用pdb資料庫名作為服務名對於RAC來說不是一個最佳方案,因為當例項使用SCAN來註冊pdb名時並且節點監聽到pdb被mounted。這可能造成連線被髮送到pdb被mounted的例項上,當以非sysdba許可權登入時就會出現ora-0133錯誤。
pdb的服務名確實是使用pdb名作為其服務名
[grid@jytest1 ~]$ lsnrctl status LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 16-MAY-2017 18:42:17 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 02-MAY-2017 11:14:02 Uptime 14 days 7 hr. 28 min. 15 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.175)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.138.130.171)(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 "4e0ba8d9d278217be053ab828a0a1330" has 1 instance(s). Instance "jycs1", 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 "jycs" has 1 instance(s). Instance "jycs1", status READY, has 1 handler(s) for this service... Service "jycsXDB" has 1 instance(s). Instance "jycs1", status READY, has 1 handler(s) for this service... Service "jycspdb" has 1 instance(s). Instance "jycs1", 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... Service "orcl" has 1 instance(s). Instance "orcl1", status READY, has 1 handler(s) for this service... The command completed successfully
pdb資料庫在所有例項上都open了
SQL> select open_mode from v$database; OPEN_MODE -------------------- READ WRITE
給pdb增加服務名jypdb_srv
[grid@jytest1 ~]$ su - oracle Password: Last login: Tue May 16 18:39:02 CST 2017 on pts/0 [oracle@jytest1 ~]$ srvctl add service -db jy -pdb jypdb -s jypdb_srv -preferred "jy1" -available "jy2" [oracle@jytest1 ~]$ srvctl start service -db jy -s jypdb_srv [grid@jytest1 ~]$ lsnrctl status LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 16-MAY-2017 18:56:55 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 02-MAY-2017 11:14:02 Uptime 14 days 7 hr. 42 min. 54 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.175)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.138.130.171)(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 2 instance(s). Instance "jy1", status READY, has 1 handler(s) for this service... Instance "jy1", status READY, has 2 handler(s) for this service... Service "4e0ba8d9d278217be053ab828a0a1330" has 1 instance(s). Instance "jycs1", 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 "jycs" has 1 instance(s). Instance "jycs1", status READY, has 1 handler(s) for this service... Service "jycsXDB" has 1 instance(s). Instance "jycs1", status READY, has 1 handler(s) for this service... Service "jycspdb" has 1 instance(s). Instance "jycs1", status READY, has 1 handler(s) for this service... Service "jypdb" has 2 instance(s). Instance "jy1", status READY, has 1 handler(s) for this service... Instance "jy1", status READY, has 2 handler(s) for this service... Service "jypdb_srv" has 2 instance(s). Instance "jy1", status READY, has 1 handler(s) for this service... Instance "jy1", status READY, has 2 handler(s) for this service... Service "orcl" has 1 instance(s). Instance "orcl1", status READY, has 1 handler(s) for this service... The command completed successfully
使用新服務名再次以非sysdba許可權登入成功
SQL> conn jy/jy@jypdb
Connected.
SQL>
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26015009/viewspace-2139166/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Connecting to Nomounted databaseDatabase
- 12CR2 using create database command for create non-CDB rac databaseDatabase
- 12c-RECOVER PLUGGABLE DATABASEDatabase
- 【PDB】Oracle 建立pdb說明(create pluggable database)OracleDatabase
- Oracle 12C pluggable database自啟動OracleDatabase
- Create RAC Standby Database for RAC Primary DatabaseDatabase
- Oracle 12Cr2 Using CloneDB to clone a databaseOracleDatabase
- 12C-ORA-65086: cannot open/close the pluggable databaseDatabase
- 小丸子學Oracle 12c系列之——Oracle Pluggable DatabaseOracleDatabase
- Oracle Database 12cR2/R1中的更改OracleDatabase
- Oracle Database 12cR2多租戶權威指南OracleDatabase
- Check database status in RACDatabase
- Oracle VM上實施Oracle 12cR2 RACOracle
- Oracle 12CR2 RAC ORA-01033Oracle
- ORA-65122: Pluggable database GUID conflicts with the GUID of an existingDatabaseGUI
- [20181018]12c Pluggable Database save state.txtDatabase
- oracle12c新特點之可插拔資料庫(Pluggable Database,PDB)Oracle資料庫Database
- RAC DATABASE關機步驟Database
- How to drop Oracle RAC database manually?OracleDatabase
- Hide RMAN Passwords when Connecting to a Target Database (Doc ID 183377.1)IDEDatabase
- Oracle 12cR2 RAC安裝配置及問題解決Oracle
- [20181011]ORA-65086 cannot openclose the pluggable database.txtDatabase
- RMAN Duplicate Database From RAC ASM To RAC ASM [ID 461479.1]DatabaseASM
- Oracle 12C ORA-12545 While Connecting to RAC through SCAN NameOracleWhile
- 11.2.0.2管理Oracle RAC One Node DatabaseOracleDatabase
- Connecting to the MySQL ServerMySqlServer
- [20181011]ORA-44777 – Pluggable database service cannot be started.txtDatabase
- 基於Linux的oracle 12cR2 RAC 標準化安裝(一)LinuxOracle
- 基於Linux的oracle 12cR2 RAC 標準化安裝(二)LinuxOracle
- 基於Linux的oracle 12cR2 RAC 標準化安裝(三)LinuxOracle
- 基於Linux的oracle 12cR2 RAC 標準化安裝(四)LinuxOracle
- Oracle RAC Database 11.1.0.6監聽故障案例OracleDatabase
- Top 5 Database and/or Instance Performance Issues in RAC EnvironmentDatabaseORM
- rac中database啟動方式的設定Database
- Oracle DataBase單例項遷移到Oracle RACOracleDatabase單例
- [RAC]ORACLE Database 10g RAC for Administrators學習筆記(五)OracleDatabase筆記
- [RAC]ORACLE Database 10g RAC for Administrators學習筆記(一)OracleDatabase筆記
- [RAC]ORACLE Database 10g RAC for Administrators學習筆記(二)OracleDatabase筆記