标题: PDB Creation From non-CDB Using an XML file Fails with ORA-60522 Errors When ... [打印本页] 作者: 刘泽宇 时间: 2026-7-12 18:00 标题: 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.