通过scan ip连接rac数据库:
$ oerr ora 1033 01033, 00000, "ORACLE initialization or shutdown in progress" // *Cause: An attempt was made to log on while Oracle is being started up // or shutdown. // *Action: Wait a few minutes. Then retry the operation.
查看pdb状态:
SQL> @pdb_status INST_ID CON_ID NAME OPEN_MODE ---------- ---------- --------------------- -------------------- 1 2 PDB$SEED READ ONLY 1 3 PDBMES READ WRITE 1 4 PDBAPP MOUNTED 2 2 PDB$SEED READ ONLY 2 3 PDBMES READ WRITE 2 4 PDBAPP READ WRITE
节点1的pdbapp处于mounted状态,启动并保存状态:
alter pluggable database PDBAPP open instances=all; alter pluggable database all save state instances=all;
oracle最佳实践:
1. Create a CRS service with a name other than the PDB name - e.g.: $ORACLE_HOME/bin/srvctl add service -database racdb -pdb pdb_name -s pdb_srv -i "<instance1>,<instance2>" 2. Start the service through srvctl: $ORACLE_HOME/bin/srvctl start service -database racdb -pdb pdb_name -s pdb_srv 3. Have users connect using the new service - here's a sample TNS entry for the tnames.ora: PDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = <SCAN_NAME>)(PORT = <PORT>)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pdb_srv) ) )
参考:
Connecting To A 12c RAC Pluggable Database Intermittently Fails With ORA-1033 (Doc ID 1998112.1)