ORA-00600: internal error code, arguments: [qksvcGetGuardCol:2], [100313], [0] After upgraded to 12C


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 :  ORA-600 [qkebCreateColById:1] After upgraded to 12c (Doc ID 2281396.1)

1-. Identify Affected Tables and columns by running:

select a.obj#,c.name table_name,a.intcol#,a.name column_name,a.property,b.guard_id
from col$ a,ecol$ b,obj$ c
where a.obj#=b.tabobj#
and a.intcol#=b.colnum
and a.obj#=c.obj#
and a.property=1073741824
and a.null$=0
and b.guard_id is null;

2-. Set compatible to 12.1 in the database.
3-. Alter the table again
alter table <table name> modify (<column name> not null enable novalidate);
alter table <table name> modify (<column name> null);







Comments

Popular posts from this blog

Useful OEM Queries to get Target details from OEM Repository

WARNING: Subscription for node down event still pending' in Listener Log

ORA-65139: Mismatch between XML metadata file and data file