After creating a CDB the instructions ask you to run catcdb.sql, the file was not shipped on GA, this is reported as a bug (Doc ID 17316776.8) but I don't think there is a fix nor couldn't find an official workaround, should I run:
catproc and catalog instead?
I have not run anything but I believe the CDB is not completed until this is not done.
I left my CDB as it is and createt a PDB based on a non-CDB, one of the last steps is to run: @$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql which I did but at the end of the script is trying to execute:
alter session set container = CDB$ROOT;
So now I'm getting the error: ORA-06553: PLS-213: package STANDARD not accessible
Which I believe is the result of not running catcdb on the CDB.
Anyway, could anyone clarify what's the right workaround? I don't want to mess up my CDB by running catalog and catproc and then find out I shouldn't have.
thank you all.
To solve the: ORA-06553: PLS-213: package STANDARD not accessible after alter session set container = CDB$ROOT;
I ran catproc and catalog however when attempting to create a PDB from a seed I got this error:
SQL> CREATE PLUGGABLE DATABASE PLUG1 ADMIN USER plgadmin IDENTIFIED BY plgadmin
FILE_NAME_CONVERT = ('/data1/oradata/PDBSEED/CDB1/', '/data1/oradata/PLUG1/'); 2
CREATE PLUGGABLE DATABASE PLUG1 ADMIN USER plgadmin IDENTIFIED BY plgadmin
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 <--- fails once again a catalog problem
ORA-00942: table or view does not exist
This is because I only ran the catalog and catproc sql on the root but not on the seed, the right way to do it is to run them using catcon.pl supplied by Oracle and documented here:
But who really wants to read all this...copy and paste? go here:
That solved my problem so far. If somebody knows what's the official way to fix the missing catcdb.sql script please let us know.