ORA-65122: Pluggable Database GUID Conflicts With The GUID Of An Existing Container
(Doc ID 2416798.1)
Last updated on OCTOBER 05, 2024
Applies to:
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and laterOracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Restored Pluggable database in a different container and unplugged. Dropped existing old PDB and trying to plug in new PDB and getting error:
ORA-65122: Pluggable database GUID conflicts with the GUID of an existing container.
SQL> drop pluggable database PDB1 INCLUDING DATAFILES;
Pluggable database dropped.
SQL> SET SERVEROUTPUT ON
DECLARE
compatible CONSTANT VARCHAR2(3) := CASE DBMS_PDB.CHECK_PLUG_COMPATIBILITY(pdb_descr_file => '/tmp/cdbrf_pdb1.xml')
WHEN TRUE THEN
'YES'
ELSE 'NO'
END;
BEGIN
DBMS_OUTPUT.PUT_LINE(compatible);
END;
/SQL>
YES
PL/SQL procedure successfully completed.
SQL> create pluggable database PDB1
using '/tmp/cdbrf_pdb1.xml'
COPY FILE_NAME_CONVERT = ('+DATA', '+EON_DAT_QA');
; 2 3
create pluggable database pdb1
*
ERROR at line 1:
ORA-65122: Pluggable database GUID conflicts with the GUID of an existing container.
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 |
| Cause |
| Solution |