2 Replies Latest reply on Jun 12, 2019 3:11 PM by Arturo Gutierrez

    ORA-01537 when I try to sync a PDB

    Arturo Gutierrez

      Hi,

      I've an application container called CRM_ROOT.

      I several PDBs created under it.

       

      I've installed an application that create a tablespace,user, tables and so on.

      And when I try to sync the CRM_SPAIN pdb fails with this error:

       

      SQL> show user

      USER is "SYS"

      SQL> show con_name

       

      CON_NAME

      ------------------------------

      CRM_SPAIN

      SQL> ALTER PLUGGABLE DATABASE APPLICATION crm_app SYNC;

      ALTER PLUGGABLE DATABASE APPLICATION crm_app SYNC

      *

      ERROR at line 1:

      ORA-01537: cannot add file '/u01/app/oracle/oradata/CDB1/CRM_ROOT/crm_tbs.dbf'

      - file already part of database

       

      I've defined the parameter:

      alter system set pdb_file_name_convert='/u01/app/oracle/oradata/CDB1/CRM_ROOT/','/u01/app/oracle/oradata/CDB1/CRM_SPAIN/';

       

      But the same error happen.

      And the PDB was created without OMF files.

       

      CREATE PLUGGABLE DATABASE  CRM_SPAIN

      ADMIN USER PDBADMIN IDENTIFIED BY oracle

      ROLES=(CONNECT)

      file_name_convert=('/u01/app/oracle/oradata/CDB1/CRM_ROOT/crm_seed/','/u01/app/oracle/oradata/CDB1/CRM_ROOT/CRM_SPAIN/')

      STORAGE ( MAXSIZE UNLIMITED MAX_SHARED_TEMP_SIZE UNLIMITED)

      /

       

      I'm working with:

      Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production  Version 19.3.0.0.0 on Linux.

       

      Is possible to fix this issue?

       

      Many thanks

      Arturo