PDB Creation From non-CDB Using an XML file Fails with ORA-60522 Errors When ...

刘泽宇

现象：
A new PDB creation from non-CDB Database using an XML file fails with an ORA-60522 error code. The "create pluggable database" statement is making use of the FILE_NAME_CONVERT clause and Oracle Managed Files are being used. Both non-CDB and CDB Databases are running on the same host.


The failing statement is something like:

CREATE PLUGGABLE DATABASE newPDB USING 'originalDB.xml' COPY FILE_NAME_CONVERT =('+DATA/originalDB/','+DATA/targetCDB/newPDB/');


解决方案：
Remove the FILE_NAME_CONVERT clause from the "create pluggable database" statement and re-try the PDB creation.

When there is a combination of OMF and ASM then a command like the one below should by default copy the new PDB datafiles to the path: +<ASM_DISKGROUP>/<CDB_DATABASE_UNIQUE_NAME>/<PDB_GUID>/DATAFILE

CREATE PLUGGABLE DATABASE "<PDB_NAME>" USING '<desc_file>.xml' COPY;

The diskgroup to use would be determined by the db_create_file_dest parameter in the destination CDB.



原因：
A non-CDB Database is being plugged in as a new PDB is being created in an existing CDB within the same host.

A similar issue was reported in unpublished Bug 31853129 - ORA-65180: DUPLICATE FILE NAME ENCOUNTERED WHEN ATTEMPTING TO PLUG IN A NON-CDB INTO A CDB.

The Development team confirmed that the FILE_NAME_CONVERT clause is not required when Oracle Managed Files are being used and datafiles are on ASM.