Select Fails With ORA-600 [kdsgrp1] (Doc ID 1331499.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 10.2.0.4 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 27-Jun-2013***

Symptoms

Select fails with  ORA-600 [kdsgrp1].

Example:
SELECT SUM (assigned_storage) / 1024
FROM san_stor
WHERE server_name IN (SELECT server_name FROM all_server_info WHERE LOCATION LIKE 'ATL%' AND os = 'HP-UX')
AND array_type NOT LIKE ('%HP%D%')
AND array_type NOT LIKE ('%HP%G%')
AND array_type NOT LIKE ('%SEAGATE%')
AND array_type NOT LIKE ('%Quantum%')
AND array_type NOT LIKE ('%COMPAQ%')

Stack trace:
ksedst ksedmp ksfdmp kgerinv kgeasnmierr kdsgrp kdsgnp kafger qerixGetNonKeyCol qerixFetchIOTRangeScan
qerjotFetch qerjotFetch qerjotFetch qerjotFetch qerjotFetch subex1 subsr3 evaopn2 expepr expeal
qerflFetchOutside qergsFetch opifch2 opiall0 opial7 opiodr ttcpip opitsk opiino opiodr opidrv sou2o
opimai_real main main_opd_entry

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms