AppSync: rename of Oracle Pluggable Database (PDB) fails on recovery if the PDB is opened when the Container Database (CDB) starts on Mount host.

Summary: Rename of Oracle Pluggable Database (PDB) fails on recovery if the PDB is opened when the Container Database (CDB) starts on Mount host.

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

When AppSync must rename an Oracle PDB during recovery, like adding a prefix for example, it fails if the PDB is automatically opened when the CDB is started on the mount host.

The Service plan events show:

Recover copy,94790a69-c3f8-4509-a5b2-b71bd9981796,ORCL_000042,<asServer>,One or more databases failed to recover. Check server and agent logs for details.
Recover copy,94790a69-c3f8-4509-a5b2-b71bd9981796,ORCL_000185,<asServer>,AppSync failed to recover one or more Pluggable database for Container database NEWCDBDB. Recovery failed during Pluggable database Open and Rename.

The AppSync Plugin logs on the Mount host named with Suffix: _dropAndOpenPluggableDatabase.log shows:

oracle.py[5136]:_execSql() SQLresult: Connected to:
oracle.py[5136]:_execSql() SQLresult: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
oracle.py[5136]:_execSql() SQLresult: Version 19.12.0.0.0
oracle.py[5136]:_execSql() SQLresult: 
oracle.py[5136]:_execSql() SQLresult: SQL> SQL> alter pluggable database all OPEN RESTRICTED
oracle.py[5136]:_execSql() SQLresult: *
oracle.py[5136]:_execSql() SQLresult: ERROR at line 1:
oracle.py[5136]:_execSql() SQLresult: ORA-65019: pluggable database ORIGPDB already open
oracle.py[5136]:_execSql() SQLresult: 
oracle.py[5136]:_execSql() SQLresult: 
oracle.py[5136]:_execSql() SQLresult: Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
oracle.py[5136]:_execSql() SQLresult: Version 19.12.0.0.0
oracle.py[5139]:_execSql() Error:Raising SQLPlusException
oracle.py[3297]:dropAndOpenPluggableDatabase() Error:An error occurred with CDB NEWCDBDB
oracle.py[3298]:dropAndOpenPluggableDatabase() Error:An error occurred while renaming pdb

Cause

The PDB was opened automatically when the CDB was started, causing the "alter pluggable database all OPEN RESTRICTED" command AppSync was submitting to Oracle to fail.

In the specific incident this article was written for, the PDB was automatically opened when the CDB started by a Trigger that was found in the dba_triggers table.

Resolution

A hotfix exists for AppSync 4.4.0.0.
Note this Article when calling in service request.

See the release notes of versions of AppSync following 4.4.0.0 to determine if fix is included.

Additional Information

The following may be helpful:

SQL command to show state of PDB:
 
SQL> sho pdbs ;

    CON_ID CON_NAME                                     OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
                2 PDB$SEED                                         READ ONLY  NO
                3 ORIGPDB                                          READ WRITE NO

SQL Command to show all triggers:
 
SQL> select * from dba_triggers

Qualifiers such as where owner='SYS' may be helpful

Products

AppSync
Article Properties
Article Number: 000197094
Article Type: Solution
Last Modified: 18 Sept 2025
Version:  4
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.