My Oracle Support Banner

noncdb_to_pdb.sql Script calls insert into pdb_alert$ sql Which fails With ORA-00060: Deadlock Detected (Doc ID 2792867.1)

Last updated on OCTOBER 08, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 19.11.0.0.0 and later
Information in this document applies to any platform.

Symptoms

While converting NON-CDB database to CDB:


noncdb_to_pdb.sql script fails with  ORA-00060: deadlock detected

ERROR
-----------------------

SQL> -- if pdb was already closed, don't exit on error
SQL> WHENEVER SQLERROR CONTINUE;
SQL> alter pluggable database "&pdbname" close immediate instances=all;
alter pluggable database "pdb1" close immediate instances=all
*
ERROR at line 1:
ORA-65020: pluggable database pdb1 already closed


SQL> WHENEVER SQLERROR EXIT;
SQL>
SQL> alter pluggable database "&pdbname" open upgrade;
alter pluggable database "pdb1" open upgrade
*
ERROR at line 1:
ORA-00060: deadlock detected while waiting for resource



Changes

 None.

Cause

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
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.