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;
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
3-. Alter the table again
alter table <table name> modify (<column name> not null enable novalidate);
alter table <table name> modify (<column name> null);
alter table <table name> modify (<column name> null);
Comments
Post a Comment