Login  Register

Re: 19c cloning- pluggable database naming failed.

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

sir,

Now I got it, I have delete the TEST Service name in Production PDB database.

Follow are the steps.

Connect to PROD

sqlplus / as sysdba

SQL> alter session set container=PROD;

Session altered.
SQL> select name from service$ order by name;

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

11 rows selected.

SQL > delete from service$ where name = 'TEST';

SQL >  commit;

Is it right steps to do it on PROD instance that  issue will not exist in future Clone.

Kindly confirm sir,

Regards,
Raiq