Pages

Saturday, November 23, 2013

ORA-65149 - Conflicting With Non-Existent DBs


Continuing from my previous post, I was trying to clone a PDB that was originally created through
DBCA, (a non-PDB) and 'converted' into a PDB. Converted in the loosest sense, since it was more
'cloned' into a pluggable database, and plugged in to the root container DB, but for simplicitity's sake we'll just say converted :).

Anyway, just to do a quick recap on the situation thus far:
  • Create database with DBCA. 
  • Convert into PDB. 
  • Plug into CDB. 
  • Try and clone said PDB. 
So without any fancy options on storage, tempfile usage, admin, etc, we'll try and clone using the most minimal (oxymoron?) statement:

SQL> create pluggable database pdb2 from nonpdb;
create pluggable database pdb2 from nonpdb
*
ERROR at line 1:
ORA-65149: PDB name conflicts with existing service name in the CDB or the 
PDB

Huh. That doesn't seem right. Well let's check anyway:

SQL> select name, open_mode from v$pdbs;

NAME                           OPEN_MODE
------------------------------ ----------
PDB$SEED                       READ ONLY
NONPDB                         MOUNTED

Nothing there either. Maybe in oratab?

[oracle@localhost ~]$ more /etc/oratab
...
HOME:/u01/app/oracle/product/12.1.0/dbhome_1:N 
BASEDB:/u01/app/oracle/product/12.1.0/dbhome_1:N
NONPDB:/u01/app/oracle/product/12.1.0/dbhome_1:N

That's weird. Maybe changing the name of the database that we want to create?

SQL> create pluggable database "PDB2" from pdb3;
create pluggable database "PDB2" from pdb3
*
ERROR at line 1:
ORA-65149: PDB name conflicts with existing service name in the CDB or the 
PDB

SQL> create pluggable database "ASDASDASDASD" from pdb3;
create pluggable database "ASDASDASDASD" from pdb3
*
ERROR at line 1:
ORA-65149: PDB name conflicts with existing service name in the CDB or the 
PDB

So something definitely wrong there, I'm pretty sure that's a unique enough database name that it's not
some coincidence that it conflicts with an already existing database and/or service. After finally getting access to Metalink, what do you, know it's a bug listed under Doc ID 1569267.1 with plans to be fixed in 12c R2.

No comments:

Post a Comment