4 Replies Latest reply on Jan 3, 2019 4:20 PM by BPeaslandDBA

    Creating PDB with old pdb name fails with  ORA-65149:PDB name conflicts with existing service name in the CDB or the PDB

    User420750

      Getting ORA-65149 error while creating pdb with old pdb name that was dropped and dbms_service.delete_service says no such service exist to delete . This is 12.2 version, there was a bug listed in 12.1 but says it is fixed in 12,2.

       

      create pluggable database pdb1 from pdb2;

      ERROR at line 1:

      ORA-65149: PDB name conflicts with existing service name in the CDB or the PDB

       

       

      SQL> select name, network_name, con_id# from cdb_service$;

       

       

      NAME             NETWORK_NAME        CON_ID#

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

      ..................

      ............

      pdb1             pdb1                      4

       

      SQL> exec dbms_Service.delete_service('pdb1');

      BEGIN dbms_Service.delete_service('pdb1'); END;

       

       

      *

      ERROR at line 1:

      ORA-44304: service pdb1 does not exist

      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86

      ORA-06512: at "SYS.DBMS_SERVICE_ERR", line 23

      ORA-06512: at "SYS.DBMS_SERVICE", line 453

      ORA-06512: at line 1