又是个ora-00600错误-CSDN博客

又碰到一个oracle600错误，这次和位图索引有关系。

ORA-00600: internal error code, arguments: [qknAddSib1], [], [], [], [], [],[], []

感觉简单处理方式就是重建位图索引，由于是别人维护的数据库，所以没去实验。

所以他们打补丁，下面是这个bug在metalink中的具体说明。

Bug 属性

类型	B - Defect	已在产品版本中修复	11.2
严重性	2 - Severe Loss of Service	产品版本	10.2.0.3
状态	80 - Development to Q/A	平台	59 - HP-UX PA-RISC (64-bit)
创建时间	30-Mar-2008	平台版本	11.23
更新时间	04-Jan-2011	基本 Bug	-
数据库版本	10.2.0.3
影响平台	Generic
产品源	Oracle

显示相关产品 相关产品

产品线	Oracle Database Products	系列	Oracle Database
区域	Oracle Database	产品	5 - Oracle Server - Enterprise Edition

Hdr: 6928035 10.2.0.3 RDBMS 10.2.0.3 SQL EXECUTION PRODID-5 PORTID-59 ORA-600
Abstract: ORA-600 [QKNADDSIB1] REPORTED ON A QUERY WHEN ENABLING VPD

*** 03/30/08 08:20 am ***
TAR:
----

PROBLEM:
--------
1. Clear description of the problem encountered

   ORA-600 [qknAddSib1] reported on a query when enabling VPD

   Disabling VPD the query runs through but only shows 'no rows selected'

2. Pertinent configuration information (MTS/OPS/distributed/etc)

   N/A

3. Indication of the frequency and predictability of the problem

   Always - see testcase

4. Sequence of events leading to the problem

   See testcase

5. Technical impact on the customer. Include persistent after effects.

   N/A

DIAGNOSTIC ANALYSIS:
--------------------
ALERT LOG
-----------
Mon Dec 10 10:14:02 2007
Errors in file /u01/app/oracle/admin/VADB1/udump/vadb1_ora_4793.trc:
ORA-600: internal error code, arguments: [qknAddSib1], [], [], [], [], [], 
[],
 []

TRACE FILE /u01/app/oracle/admin/VADB1/udump/vadb1_ora_25620.trc
------------
*** NAME:() 2008-01-25 13:17:46.126
*** NAME:(SQL*Plus) 2008-01-25 13:17:46.126
*** NAME:(SYS$USERS) 2008-01-25 13:17:46.126
*** ID:(120.54982) 2008-01-25 13:17:46.126
*** 13:17:46.126
ksedmp: internal or fatal error
ORA-600: internal error code, arguments: [qknAddSib1], [], [], [], [], [], 
[],
 []
Current SQL statement for this session:
SELECT
AvgorandePom.ID,
AvgorandePom.AVGORANDE_ID,
AvgorandePom.PERSON_ID,
AvgorandePom.LAGAKRAFT,
AvgorandePom.BEVAKNING_ID,
AvgorandePom.REGDATUM,
AvgorandePom.DOMSTOL_NR,
AvgorandePom.BEVAKNING_ID_LAGAKRAFT,
AvgorandePom.DELGIVNINGSDATUM,
AvgorandePom.GEN_KOD_ID_AVGPOMTYP,
AvgorandePom.DOMSLUT_ID,
AvgorandePom.TILLHOR_DOMSLUT_ID,
AvgorandePom.PERSON_UPPGIFT_ID,
AvgorandePom.
ORGANISATION_UPPGIFT_ID,
AvgorandePom.ADRESS_ID,
AvgorandePom.AKTORROLL_ID
FROM
AVGORANDE_POM AvgorandePom
WHERE (
AKTORROLL_ID = 12863
AND
ORGANISATION_ID = 62343
AND
EXISTS
(
SELECT 1
FROM
AVGORANDE A,
MAL_AVGORANDE MA
WHERE A.ID = AvgorandePom.AVGORANDE_ID
AND
A.ID = MA.AVGORANDE_ID
AND
MA.MAL_ID = 5790
AND
A.GEN_KOD_ID_AVGSTATUS <> 67)
) ORDER BY ID
----- Call Stack Trace -----
ksedst qkabix kksFullTypeCheck kksfbc opiodr opimai_real 
WORKAROUND:
-----------
None

RELATED BUGS:
-------------
None

REPRODUCIBILITY:
----------------
Release     Platform         Reproducible
-------     --------         ------------
10.2.0.3    HP-UX (64-Bit)   Yes
10.2.0.1    Win/XP           Yes

TEST CASE:
----------
SQL> connect system/oracle

SQL> @create_tbs
SQL> @create_usr

SQL> create directory datapump as '';

impdp parfile=impdp.par

SQL> connect vera/vera

SQL> SELECT
  2  AvgorandePom.ID,
  3  AvgorandePom.AVGORANDE_ID,


 39  A.GEN_KOD_ID_AVGSTATUS <> 67)
 40  ) ORDER BY ID;

Er zijn geen rijen geselecteerd.

SQL> exec vpd(642)

PL/SQL-procedure is geslaagd.

SQL> SELECT
  2  AvgorandePom.ID,
  3  AvgorandePom.AVGORANDE_ID,


 39  A.GEN_KOD_ID_AVGSTATUS <> 67)
 40  ) ORDER BY ID;
SELECT
*
FOUT in regel 1:
.ORA-600: Interne foutcode, argumenten: [qknAddSib1], [], [], [], [], [], 
[], 
[].

STACK TRACE:
------------
ksedst qkabix kksFullTypeCheck kksfbc opiodr opimai_real 
SUPPORTING INFORMATION:
-----------------------
N/A

24 HOUR CONTACT INFORMATION FOR P1 BUGS:
----------------------------------------
N/A

DIAL-IN INFORMATION:
--------------------
N/A

IMPACT DATE:
------------
N/A

*** 03/30/08 12:04 pm ***
Addition to the testcase:

After importing the schema and before running the failing query, you have to 
create some contexts otherwise you will get an ORA-1031 on DBMS_SESSION:

SQL> connect system

SQL> grant execute on dbms_session to VERA;

SQL> create context DVCTX using vera.VERA_SECURITY;
SQL> create context DVCTX_TABLE_POLICY using vera.VERA_SECURITY;
*** 03/30/08 12:24 pm *** (CHG: Sta->16)
*** 03/30/08 12:24 pm ***
*** 03/30/08 03:49 pm *** 
*** 03/31/08 05:01 am *** (CHG: Sta->10)
*** 03/31/08 05:01 am ***
*** 04/17/08 05:41 am *** (CHG: Sta->16)
*** 04/17/08 05:41 am ***
*** 04/17/08 06:36 am ***
*** 04/17/08 06:51 am *** (CHG: Sta->11 SubComp->SQL EXECUTION)
*** 04/17/08 06:51 am ***
*** 04/17/08 06:51 am *** (ADD: Impact/Symptom->INTERNAL ERROR )
*** 04/17/08 06:51 am *** 
*** 04/17/08 06:51 am ***
*** 04/17/08 10:04 pm *** 
*** 04/17/08 10:04 pm ***
*** 04/18/08 12:27 am *** 
*** 04/18/08 12:27 am *** 
*** 04/18/08 12:27 am ***
*** 04/18/08 12:28 am ***
*** 04/18/08 12:28 am *** 
*** 05/02/08 05:11 pm *** 
*** 05/23/08 06:26 am ***
*** 05/23/08 06:29 am ***
*** 05/23/08 10:34 am *** ESCALATED
*** 05/23/08 10:34 am ***
*** 06/02/08 11:08 am *** 
*** 06/03/08 09:09 pm *** 
*** 06/03/08 09:09 pm ***
*** 06/23/08 06:56 am ***
*** 06/23/08 01:59 pm ***
*** 06/23/08 05:28 pm *** (CHG: Sta->30)
*** 06/23/08 05:28 pm ***
*** 06/25/08 07:25 am *** (CHG: Sta->11)
*** 06/25/08 07:25 am ***
*** 06/25/08 07:42 am ***
*** 07/03/08 09:59 am ***
*** 07/04/08 01:52 am ***
*** 07/08/08 09:58 am ***
*** 07/22/08 09:39 am ***
*** 07/29/08 07:11 pm ***
*** 08/26/08 10:09 am ***
*** 09/09/08 10:36 am ***
*** 09/18/08 11:00 pm ***
RELEASE NOTES:
]]ORA-600 [QKNADDSIB1] was reported on a query when using bitmap plans.
REDISCOVERY INFORMATION:
If you receive an error ORA-600 [QKNADDSIB1] when using bitmap plans you might
have reproduced this issue.
WORKAROUND:
None
*** 09/22/08 05:05 pm *** 
*** 09/22/08 05:05 pm *** (CHG: Sta->80)
*** 09/23/08 07:16 am ***
*** 09/23/08 07:28 am ***
*** 09/23/08 09:23 am *** -> CLOSED
*** 09/24/08 07:34 am ***
*** 09/24/08 07:58 am ***
*** 09/25/08 04:41 am ***
*** 09/25/08 07:23 pm ***
*** 09/26/08 10:40 am ***
*** 09/26/08 10:45 am ***
*** 09/26/08 02:41 pm ***
*** 09/27/08 03:24 am ***
*** 09/29/08 07:40 pm ***
*** 09/30/08 09:38 am ***
*** 10/04/08 02:15 pm ***
*** 10/04/08 03:15 pm ***
*** 10/04/08 06:56 pm ***
*** 10/06/08 10:51 am ***
*** 10/06/08 08:49 pm ***
*** 10/07/08 11:00 am ***
*** 10/08/08 08:04 am ***
*** 10/08/08 11:27 am ***
*** 10/23/08 04:46 pm ***
*** 11/04/08 11:01 am ***
*** 11/07/08 02:08 am ***
*** 11/17/08 10:08 am ***
*** 11/22/08 10:31 pm ***
*** 11/28/08 08:40 pm ***
*** 12/05/08 11:12 am ***
*** 12/08/08 08:18 pm ***
*** 12/09/08 05:45 am ***
*** 01/07/09 06:18 am ***
*** 01/07/09 06:18 am ***
*** 01/27/09 10:45 am ***
*** 02/10/09 09:55 am ***
*** 02/12/09 04:18 am ***
*** 08/06/09 02:14 am ***
*** 08/11/09 06:32 am ***
*** 09/16/09 06:42 am ***
*** 01/04/11 01:39 am ***