Alter New Primary Open Hang After Switchover
(Doc ID 2663273.1)
Last updated on AUGUST 29, 2020
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
1. All was working well until the switchover. After Data Guard switchover, unable to open PDB.
alter pluggable database <pdb_name> open
* ERROR at line 1:
ORA-65054: Cannot open a pluggable database in the desired mode.
There's no service that's created for the PDB at this point
$ srvctl config database -db <DATABASE_NAME>
Database unique name: <DATABASE_NAME>
Oracle home: /u01/app/oracle/product/18.104.22.168/db_1
Oracle user: oracle
Password file: +<DG_NAME>/<DATABASE_NAME>/orapwcaprd
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups: <DG_NAME>,<DG_NAME1>,<DG_NAME2>
Mount point paths:
OSDBA group: dba
OSOPER group: oper
Database instances: <instane_name1>,<instane_name2>
Configured nodes: <node_name1>,<node_name2>
2. Turns out the CDB was not open and the alter database open (for cdb) was hung on follow SQL:
3. wait information:
- 'row cache lock'
- 'cursor: pin S wait on X'
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document