pluggable database could not open

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

pluggable database could not open

Arsalan

Hello Arslan,

1- I took ramn full backup fron noncdb 12c R1 OS is windows 12 and restored on vm windows 7 env
without any issue.

2-i try to convert noncdb to pluggable db in windows i follow below step then finally i face error please help me  i searched a lot i could found the solution even i do not have oracle support account.


i wanted to convert noncdb to pluggable i face below error please help me

1-oracle 12c r1
2 windows 7

BEGIN
DBMS_PDB.DESCRIBE(pdb_descr_file => 'C:\app\ali\Oradata\PDB\NonCDB.xml');
END;
/

SET SERVEROUTPUT ON

DECLARE
compatible CONSTANT VARCHAR2(3) :=
CASE DBMS_PDB.CHECK_PLUG_COMPATIBILITY(
pdb_descr_file => 'C:\app\ali\Oradata\PDB\NonCDB.xml',pdb_name => 'NonCDB')
WHEN TRUE THEN 'YES'
ELSE 'NO'
END;
BEGIN
DBMS_OUTPUT.PUT_LINE(compatible);
END;
/

YES

CREATE PLUGGABLE DATABASE AFGPROD
USING 'C:\app\ali\Oradata\PDB\NonCDB.xml'
NOCOPY TEMPFILE REUSE;

exec dbms_rmin.rm$_noncdb_to_pdb;
BEGIN dbms_rmin.rm$_noncdb_to_pdb; END;

*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kkkivldpln:!ftc1], [1403], [], [],

SP2-0158: unknown SHOW option "dpbs"

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           READ WRITE NO
         4 AFGPROD                        MOUNT      
SQL>











 
Reply | Threaded
Open this post in threaded view
|

Re: pluggable database could not open

ErmanArslansOracleBlog
Administrator
Hi Arsalan,

That ORA-600 is not registered in Oracle Support. No clues about it. But I think your method is wrong.
You are trying to convert a Non-PDB to PDB.. Well, you need to follow the standard procedure.
What document did you follow for this? -> where does that "dbms_rmin.rm$_noncdb_to_pdb;" come from?