ANIL VEJENDLA

Issue: PDB is in Restricted mode. Today we have upgraded 11g datbase to 12c and plugged in container. After running noncdb_to_pdb.sql we tried to open PDB, PDB status Restricted is  YES.. CDB$ROOT@ AGIIPRDC > sho pdbs     CON_ID CON_NAME                       OPEN MODE  RESTRICTED ---------- ------------------------------ ---------- ----------          3  RQBIPRDPDB1                             READ WRITE YES Reason : Rows with type ERROR and status PENDING from pdb_plug_in_violations select name, cause, type, message, status from pdb_plug_in_violations where type = 'ERROR' and status != 'RESOLVED'  order by name, time; CDB$ROOT@AGIIPRDC> set linesize 150 col name for a15 col cause for a15 col message for a50 select name, cause, type, message, status from pdb_plug_in_violations where type = 'ERROR' and status != 'RESOLVED'  order by name, time;CDB$ROOT@AGIIPRDC> CDB$ROOT@AGIIPRDC> CDB$ROOT@AGI

Error:  ORA-00600 : internal error code, arguments: [qksvcGetGuardCol:2], [100313], [0], [], [], [], [], [], [], [], [], []   We have upgraded Database from 11.2.0.2 to 12.2.0.1 from Exadata ASM to Normal File system. and plugged into container. Everything went fine .. but we encountered ORA-600 error with Few ETL Tables . select  count(*) from table  is working fine..but select * from table is failing. CDB$ROOT@EBTUPRDC> select count(*) from "EBAOREP"."F_POLICY_CT_TRANS";   COUNT(*) ----------    9208566 select * from is failing with ORA-600 Error. CDB$ROOT@EBTUPRDC> select * from EBTUS_GS.T_AS_MAILING_ADDRESS;   select * from EBTUS_GS.T_AS_MAILING_ADDRESS   *   ERROR at line 1:   ORA-00600: internal error code, arguments: [qksvcGetGuardCol:2], [228717], [0],   [], [], [], [], [], [], [], [], []   Solution :  We Exported Failed Tables from source database and imported into Upgraded 12c database. Solution Provided by Oracle support :