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