Renaming PDB error out R12.2 19c

Posted by satish on Feb 22, 2023; 2:39pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Renaming-PDB-error-out-R12-2-19c-tp11636.html

Hi erman,

We are cloning uat from prod.

ENV:
2 node RAC 19c 19.12
Source CDB prodcdb--> prodcdb1 and proddb2
Source PDB name PRODDB
Target CDB uatcdb-->uatcdb1 and uatcdb2
Target PDB name UATDB

Rman duplicate completed successfully.

[orauat@erpuatdbl ~I$ sqlplus "/as sysdba"
SQL*Plus: Release 19.0.0.0.0 - Production on Wed
Feb 22 17:05:50 2023
Version 19.17.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19 Enterprise Edition Release
19.0.0.0.0 - Production
Version 19.17.0.0.0
SOL> alter session set container=PRODDB;

No service with target PDB name which is UATDB

SOL> select count (*) from cd services c, service$
where upper (s.name) = upper ('UATDB')
and s.deletion date is null
and s.name = c. name;

COUNT (*)
-----------------
0


We are trying to rename PDB from PRODDB to UATDB

[orauat@erpuatdb1 -1$ cd /u02/UAT19CBASE/19chome/appsutil
[orauat@erpuatdb1 appsutill$ . txkSetC{gCDB.env doraclehome=/u02/UAT19CBASE/19chome
Oracle Home being passed: /u02/UAT19CBASE/19chome
[orauat@erpuatdb1 appsutil]$ export
ORACLE SID=uatcdbl

[orauat@erpuatdb1 appsutil]$
[orauat@erpuatdb1 appsutill$ sqlplus "/ as sysdba"
SOL*Plus: Release 19.0.0.0.0 - Production on Wed
Feb 22 17:13:43 2023
Version 19.17.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19 Enterprise Edition Release
19.0.0.0.0 - Production
Version 19.17.0.0.0
SOL> sho pdbs
CON ID CON NAME
RESTRICTED
OPEN MODE
2 PDBSSEED
READ ONLY
NO
3 PRODDB
READ
WRITE NO


SQL> alter pluggable database "PRODDB" close;
Pluggable database altered.
SOL>
SQL> alter pluggable database "PRODDB" unplug into
"/u02/UAT19CBASE/19chome/dbs/EBSDB PDBDesc.xm1'

Pluggable database altered.


SOL> drop pluggable database "PRODDB";
Pluggable database dropped.


Error:
SOL> create pluggable database "UATDB" using
"/u02 /UAT1 9CBASE/19chome/dbs/EBSDB PDBDesc.xm1'
NOCOPY SERVICE NAME CONVERT= ('ebs PRODDB',
"ebs UAIDB' , 'PRODDB ebs patch' , 'UATDB
ebs patch");
create pluggable database "UATDB" using
"/u02/UAT19CBASE/19chome/dbs/EBSDB PDBDesc.xmI'
NOCOPY SERVICE NAME CONVERT= ('ebs PRODDB'
'ebs UATDB'
, 'PRODDB_ebs_patch', 'UATDB
ebs batch')
ERROR at line 1:
ORA-65174: invalid or conflicting name in service
PRODDBXDB found in the pluggable database



SOL> select name from service$ order by name;
NAME
PRODDBXDB
SYSSBACKGROUND
SYSSUSERS
UATCDB
UATDBXDB prodcdb
prodcdb.ttd.com
prodcdbXDB
8 rows selected.

SQL> select name from v$services;
NAME
SYSSBACKGROUND
SYSSUSERS
UATCDB
UATDBXDB
SOL>

Can you pls guide,how can we proceed furthur.

Thanks,
Satish