My Oracle Support Banner

Renaming 19c PDB Fails With "ORA-65174: invalid or conflicting name in service" (Doc ID 2682761.1)

Last updated on FEBRUARY 15, 2023

Applies to:

Oracle Applications Manager - Version 12.2.3 and later
Oracle E-Business Suite Technology Stack - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3+ version with 19c database, Rapidclone

When attempting to rename the PDB as per note "Cloning Oracle E-Business Suite Release 12.2 with Multitenant Database using Rapid Clone (Doc ID 2552208.1)", Section 4.1.6 Restore and Start the Target Database, Step 4, the following error occurs.

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


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgraded Production EBS PROD database to 19c with PSU to 19.x

2. Attempting to clone source production PROD to new clone TEST using
    Cloning Oracle E-Business Suite Release 12.2 with Multitenant Database using Rapid Clone (Doc ID 2552208.1)

3. Finished restoring PROD to TESTCDB with RMAN -- at this time, the PDB restored is still named PROD

4. In Section 4: Clone and Configure the Database Tier,
        4.1.6 Restore and Start the Target Database
        Step 4. If the PDB name needs to be changed, execute the following steps to rename the PDB.

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

show pdbs
Database mounted.
Database opened.
SQL>
  CON_ID CON_NAME         OPEN MODE     RESTRICTED
---------- ------------------------------ ---------- ----------
  2            PDB$SEED          READ ONLY      NO
  3            PROD                  MOUNTED

SQL> alter pluggable database "PROD" close;
alter pluggable database "PROD" close
*
ERROR at line 1:
ORA-65020: pluggable database PROD already closed

SQL> alter pluggable database "PROD" unplug into '/tmp/PROD.xml';
Pluggable database altered.

SQL> drop pluggable database "PROD";
Pluggable database dropped.

SQL> create pluggable database "TEST" using '/tmp/PROD.xml' NOCOPY SERVICE_NAME_CONVERT=('ebs_PROD','ebs_TEST','PROD_ebs_patch','TEST_ebs_patch');
create pluggable database "TEST" using '/tmp/PROD.xml' NOCOPY SERVICE_NAME_CONVERT=('ebs_PROD','ebs_TEST','PROD_ebs_patch','TEST_ebs_patch')
*
ERROR at line 1:
ORA-65174: invalid or conflicting name in service TEST found in the pluggable database

Changes

The Source database was upgraded to 19c multitenant and now attempting clone PROD to TEST.  The source database PROD had been created from another cloned gold database named TEST during go-live, years ago.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.