My Oracle Support Banner

ORA-604 Signalled During: Alter Pluggable Database "<dbname>" Open Upgrade (Doc ID 2679604.1)

Last updated on APRIL 17, 2023

Applies to:

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

Symptoms

 ORA-604 signalled during: alter pluggable database "<dbname>" open upgrade

++++pdb_create_convert.log in pdb_create_convert.log



Elapsed: 00:00:00.01
15:56:45 SQL> WHENEVER SQLERROR EXIT;
15:56:45 SQL>
15:56:45 SQL> alter pluggable database "&pdbname" open upgrade;
alter pluggable database "<dbname>" open upgrade
*
ERROR at line 1:
ORA-44303: service name exists  <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
ORA-44775: Pluggable database service cannot be created. <<<<<<<<<<<<<<<<<<<<<<<<


Elapsed: 00:00:00.07
15:57:28 SQL> WHENEVER SQLERROR EXIT;
15:57:28 SQL>
15:57:28 SQL> alter pluggable database "&pdbname" open upgrade;
alter pluggable database "<dbname>" open upgrade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00060: deadlock detected while waiting for resource

Changes

 converting non-cdb to pdb fails.

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!

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