Skip to main content

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

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

Error: CDB$ROOT@EBTUPRDC> CREATE PLUGGABLE DATABASE EBTUSPRDPDB1 using '/home/oracle/EBTUSPRDC.xml' nocopy tempfile reuse; CREATE PLUGGABLE DATABASE EBTUSPRDPDB1 using '/home/oracle/EBTUSPRDC.xml' nocopy tempfile reuse * ERROR at line 1: ORA-65139: Mismatch between XML metadata file and data file /u05/odb/ORADATA_1/EBTUSPRDC/datafile/system.1531.807800993 for value of fcpsb (2230502002 in the plug XML file, 2230505492 in the data file) Fix: Don't open Non-CDB database until we complete pdb creation other wise we will get above error. Shutdown immediate; startup mount; alter database open read only; create xml file. shutdown immediate; Connect to CDB and Create Pluggable database .

Useful OEM Queries to get Target details from OEM Repository

List Targets with TNS Listener ports configured : SELECT mgmt$target.host_name , mgmt$target.target_name , mgmt$target.target_type , mgmt$target_properties.property_name , mgmt$target_properties.property_value FROM mgmt$target , mgmt$target_properties WHERE ( mgmt$target.target_name = mgmt$target_properties.target_name ) AND ( mgmt$target.target_type = mgmt$target_properties.target_type ) and ( mgmt$target.target_type = 'oracle_listener' ) and ( mgmt$target_properties.property_name = 'Port' ); Devora02       LISTENER_ora02                       oracle_listener Port 1529 Devora01       LISTENER_ora01                       oracle_listener Port 1529 Devora04       LISTENE...

TFA-00002 : Oracle Trace File Analyzer (TFA) is not running

TFA Failed to start listening for commands on one of the Rac Node : As a root user /etc/init.d/init.tfa  start Starting TFA.. start: Job is already running: oracle-tfa Waiting up to 100 seconds for TFA to be started.. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Successfully started TFA Process.. . . . . . TFA-00002 : Oracle Trace File Analyzer (TFA) is not running TFA Failed to start listening for commands Solution : run synctfanodes.sh  if you have root password . if no root password copy below files to TFA Failed node and try to restart TFA .. Please check whether these 4 files exist on all nodes are similar. TFA_HOME/server.jks TFA_HOME/client.jks TFA_HOME/internal/ssl.properties   TFA_HOME/internal/ portmapping.txt If not similar just copy these files to TFA Failing node and try TFA Restart ..It Worked for me .   [root@host01]# ./tfactl  -v "debug" start Starting TFA...