ORA-00600: internalerrorcode, arguments: [kqlnrc_1], [0x70

Database inspection this morning, found the alert Log in the following error: Warning: ORA-00600: Internal error code, parameters: [kqlnrc_1], [0x15E465678], [], [], [], [], [], [] MonJun1810: 11: 31CST2012Er

This morning, I performed database inspection and found the following error in the alert Log: Errors in file/home/Oracle/admin/exmxsbusi/udump/exmxsbusi2_ora_27477.trc: ORA-00600: Internal error code, parameter: [kqlnrc_1], [0x15E465678], [], [], [], [], [], [], [] Mon Jun 18 10:11:31 CST 2012 Er

This morning, I performed a database inspection and found the following error in the alert Log:

Errors in file/home/Oracle/admin/exmxsbusi/udump/exmxsbusi2_ora_27477.trc:
ORA-00600: Internal error code, parameter: [kqlnrc_1], [0x15E465678], [], [], [], [], [], [], [], []
Mon Jun 18 10:11:31 CST 2012


Errors in file/home/Oracle/admin/exmxsbusi/udump/exmxsbusi2_ora_27477.trc:
ORA-00600: Internal error code, parameter: [kqlnrc_1], [0x15E465678], [], [], [], [], [], [], [], []
Mon Jun 18 10:11:55 CST 2012
Errors in file/home/Oracle/admin/exmxsbusi/udump/exmxsbusi2_ora_27477.trc:
ORA-00600: Internal error code, parameter: [kqlnrc_1], [0x15E465678], [], [], [], [], [], [], [], []
View the trace file:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
And Real Application Testing options
Oracle_HOME =/home/oracle/db
System name: Linux
Node name: cpexmxsii-coddb-02
Release: 2.6.18-194.1.AXS3
Version: #1 SMP Fri May 7 10:03:53 CST 2010
Machine: x86_64
Instance name: exmxsbui2
Redo thread mounted by this instance: 2
Oracle process number: 504
Unix process pid: 27477, image: Oracle @ cpexmxsii-coddb-02

* ** Action name :( Main session) 10:11:14. 231
* ** Module name: (PL/SQL Developer) 10:11:14. 231
* ** Service name :( exmxsbusi) 10:11:14. 231
* ** Session id: (155.2098) 10:11:14. 231
* ** 10:11:14. 231
Ksedmp: internal or fatal error
ORA-00600: Internal error code, parameter: [kqlnrc_1], [0x15E465678], [], [], [], [], [], [], [], []
Current SQL statement for this session:
Declare
C integer: = 0;
P1 varchar2 (500 );
P2 varchar2 (500 );
Expr varchar2 (500 );
Dblink varchar2 (500 );
Part1_type integer;
Object_number integer;
Dp integer;
Begin
: Object_type: = null;
: Object_owner: = null;
: Object_name: = null;
: Sub_object: = null;
Expr: =: part1;
If: part2 is not null then expr: = expr | '.' |: part2; end if;
If: part3 is not null then expr: = expr | '.' |: part3; end if;
Loop
Begin
Sys. dbms_utility.name_resolve (name => expr,
Context => c,
Schema =>: object_owner,
Part1 => p1,
Part2 => p2,
Dblink => dblink,
Part1_type => part1_type,
Object_number => object_number );
If part1_type = 1 then: object_type: = 'index'; end if;
If part1_type = 2 then: object_type: = 'table'; end if;
If part1_type = 4 then: object_type: = 'view'; end if;
If part1_type = 5 then: object_type: = 'synonym'; end if;
If part1_type = 6 then: object_type: = 'sequence '; end if;
If part1_type = 7 then: object_type: = 'processed'; end if;
If part1_type = 8 then: object_type: = 'function'; end if;
If part1_type = 9 then: object_type: = 'package'; end if;
If part1_type = 12 then: object_type: = 'trigger'; end if;
If part1_type = 13 then: object_type: = 'type'; end if;
If part1_type = 28 then: object_type: = 'java source'; end if;
If part1_type = 29 then: object_type: = 'java class'; end if;
If: object_type is null then
Select object_type into: object_type
From sys. all_objects
Where object_id = object_number;
End if;
Exception
When others then null;
End;
C: = c + 1;
If c> 9 then
Dp: = instr (expr, '.',-1 );
If dp> 0 then
If: sub_object is not null then
: Sub_object: = '.' |: sub_object;
End if;
: Sub_object: = upper (substr (expr, dp + 1) |: sub_object;
Expr: = substr (expr, 1, dp-1 );
C: = 0;
End if;
End if;
Exit when (: object_type is not null) or (c> 9 );
End loop;
If: object_type is not null then
If p1 is null then
: Object_name: = p2;
Elsif p2 is null then
: Object_name: = p1;
If: object_name =: part1 and: part2 is not null then
: Sub_object: =: part2;
End if;
If: object_name =: part2 and: part3 is not null then
: Sub_object: =: part3;
End if;
Else
: Object_name: = p1;
: Sub_object: = p2;
End if;
Return;
End if;
Begin
If: part2 is null and: part3 is null then
Select 'user', null,: part1
Into: object_type,: object_owner,: object_name
From sys. all_users u
Where u. username =: part1
And rownum = 1;
Return;
End if;
Exception
When no_data_found then
Null;
End;
Begin
If: part2 is null and: part3 is null and: deep! = 0 then
Select 'role', null,: part1
Into: object_type,: object_owner,: object_name
From sys. session_roles r
Where r. role =: part1
And rownum = 1;
Return;
End if;
Exception
When no_data_found then
Null;
End;
If: deep! = 0 then
Begin
If: part2 is null then
Select constraint_type, owner, constraint_name
Into: object_type,: object_owner,: object_name
From sys. all_constraints c
Where c. constraint_name =: part1
And c. owner =: cur_schema
And rownum = 1;
Else
Select constraint_type, owner, constraint_name,: part3
Into: object_type,: object_owner,: object_name,: sub_object
From sys. all_constraints c
Where c. constraint_name =: part2
And c. owner =: part1
And rownum = 1;
End if;
If: object_type = 'P' then
: Object_type: = 'Primary key ';
End if;
If: object_type = 'U' then
: Object_type: = 'unique key ';
End if;
If: object_type = 'R' then
: Object_type: = 'forn n key ';
End if;
If: object_type = 'C' then
: Object_type: = 'check constraint ';
End if;
Return;
Exception
When no_data_found then
Null;
End;
End if;
End;

Check again

----- PL/SQL Call Stack -----
Object line object
Handle number name
0x15d17ad68 116 package body SYS. DBMS_UTILITY

......

......

SO: 0x13667b708, type: 54, owner: 0x149fa2a30, flag: INIT/-/0x00
Library object pin: pin = 0x13667b708 handle = 0x15e465678 mode = S lock = 11a0570c8
User = 15a46c3d0 session = 15a46c3d0 count = 1 mask = 0001 savepoint = 0x7675 flags = [00]
Library object handle: handle = 15e465678 CTX = 0x15e3167a8 (0) lct = 1 pct = 0 cdp = 0
Name = EXMXSQUERY. VW_EBAY_MAIL_CLCT @ EBAYTRACK
Hash = f0cd4f621dedeac376c5bc759c015f5e timestamp = 12-22-2011 17:03:45
Namespace = TABL flags = REM/KGHP/TIM/XLR/[00020020]
Kkkk-dddd-llll = 0000-0001-0001 lock = S pin = S latch # = 14 hpc = 0002 hlc = 0002
Lwt = 0x15e0000720 [0x15e0000720, 0x15e0000720] ltm = 0x15e0000730 [0x15e0000730, 0x15e0000730]
Pwt = 0x15e4656e8 [0x15e4656e8, 0x15e4656e8] ptm = 0x15e4656f8 [0x15e4656f8, 0x15e4656f8]
Ref = 0x15e0000750 [0x15e0000750, 0x15e0000750] lnd = 0x15e0000768 [0x15e0000768, 0x15e0000768]
Lock instance lock: id = LBf0cd4f621dedeac3
Pin instance lock: id = NBf0cd4f621dedeac3 mode = S release = F flags = [00]
Library object: bject = 1432efc78
Type = SYNM flags = EXS/LOC [0005] pflags = [0000] status = INVLload = 0
Data blocks:

From this point, VW_EBAY_MAIL_CLCT is a synonym of EXMXSQUERY user in the EBAYTRACK database. It should be the Synonym that is invalid. Generally, the synonym is deleted and rebuilt by its synonymous object, or the select permission is revoked. In order to confirm this understanding, I called the development engineer to ask if I had changed the view at the time. I answered the question and said, but at that time I was creating or replace, so that the synonym would automatically become invalid. Query through the following SQL:

SQL> SELECT object_name, object_type, owner, status
2 FROM dba_objects
3 WHERE object_name = 'vw _ EBAY_MAIL_CLCT ';

OBJECT_NAME OBJECT_TYPE OWNER STATUS
--------------------------------------------------------
VW_EBAY_MAIL_CLCT VIEW EMSTRC VALID
VW_EBAY_MAIL_CLCT SYNONYM EMSQUERY INVALID

It is invalid. Note that in 10 Gb, synonyms are invalid, but can still be queried:

Select count (*) from vw_ebay_mail_clct;

COUNT (*)
------------------
3398700

Reconstruction synonym:

Create or replace synonym VW_EBAY_MAIL_CLCT for emstrc. VW_EBAY_MAIL_CLCT;

Re-query status:

SQL> SELECT object_name, object_type, owner, status
2 FROM dba_objects
3 WHERE object_name = 'vw _ EBAY_MAIL_CLCT ';

OBJECT_NAME OBJECT_TYPE OWNER STATUS
--------------------------------------------------------
VW_EBAY_MAIL_CLCT VIEW EMSTRC VALID
VW_EBAY_MAIL_CLCT SYNONYM EMSQUERY VALID

The status has changed to valid.

Reference:

How To Find The Object That Causing ORA-600 [kqlnrc_1] [ID 1190673.1]

The above is the ORA-00600: internal error code, arguments: [kqlnrc_1], [0x70 content, more relevant content please pay attention to PHP Chinese Network (www.php1.cn )!