19c cloning- pluggable database naming failed.

Posted by raiq1 on Aug 10, 2022; 9:00am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/19c-cloning-pluggable-database-naming-failed-tp11013.html

Dear Erman sir,

Hope you are fine there, yesterday I have created a new clone from Prod to test environment, this is first clone after 19c production upgrade.

Once database restore is finished, I have removed pluggable database and create a newly pluggable database are TEST.

create pluggable database TEST using '/u02/oracle/TEST/19.0.0/dbhome_2/dbs/PROD_PDBDesc.xml' NOCOPY SERVICE_NAME_CONVERT=('PROD','TEST');

ORA-65174: invalid or conflicting name in service TEST found in the pluggable database

I have searched that error in oracle support, found this note. (Doc ID 2682761.1)

As per this note ,  I cannot given the name TEST because that name are already exist in the repository,

so I have given TEST1.

As per  note to avoid that error and I am willing to gives pluggable database name to TEST in future , we have to removed it in Production.

Below are the details for all services available in PROD pluggable database repo.

alter session set container=PROD;

SQL> select name from service$ order by name;

NAME
----------------------------------------------------------------
FINPRD19
PRB19
PRD10202
PRODPACK
PROD_STDBY
R1211BLN
RUP4BLP
TEST        ------exist
ebs_PROD
prd11510
prod

11 rows selected.


Need your advice to delete TEST Service in Production pluggable database service list.

Regards,
Raiq.