Renaming PDB after clone
Dear Experts,
We are cloning from PROD to UAT. This is the first clone from PROD. We are facing issue while renaming PDB from PRODDB to UATDB. Please need your suggestion to fix this issue.
ENV:
=====
2 node RAC 19c 19.12
Source CDB prodcdb--> prodcdb1 and prodcdb2
Source PDB name PRODDB
Target CDB uatcdb-->uatcdb1 and uatcdb2
Target PDB name UATDB
After completion of RMAN duplicate:
==================================
[orauat@erpuatdb1 ~]$ sqlplus "/as sysdba"
Version 19.17.0.0.0
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PRODDB READ WRITE NO
SQL> alter session set container=PRODDB;
Session altered.
SQL> select count(*) from cdb_services c, service$ s
where upper(s.name) = upper('UATDB')
and s.deletion_date is null
and s.name = c.name; 2 3 4
COUNT(*)
----------
0
We are trying to rename PDB from PRODDB to UATDB:
================================================
[orauat@erpuatdb1 ~]$ cd /u02/UAT19CBASE/19chome/appsutil
[orauat@erpuatdb1 appsutil]$ . txkSetCfgCDB.env dboraclehome=/u02/UAT19CBASE/19chome
Oracle Home being passed: /u02/UAT19CBASE/19chome
[orauat@erpuatdb1 appsutil]$ export ORACLE_SID=uatcdb1
[orauat@erpuatdb1 appsutil]$
[orauat@erpuatdb1 appsutil]$ sqlplus "/as sysdba"
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 22 17:13:43 2023
Version 19.17.0.0.0
Copyright (c) 0