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

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

### Detailed Problem Statement ###
ORA-00600: internal error code, arguments: [kgl_max_opr_exceeded],

PMON: terminating instance due to error 474
Tue Mar 31 00:33:51 2009
Errors in file sid_lms0_21814.trc:
ORA-00474: SMON process terminated with error
Tue Mar 31 00:33:51 2009
Errors in file sid_lmon_21782.trc:
ORA-00474: SMON process terminated with error
Tue Mar 31 00:33:51 2009
Errors in file sid_dbw0_21820.trc:
ORA-00474: SMON process terminated with error

ALERT LOG
-------------------

Tue Mar 31 00:33:41 2009
Errors in file /u01/ptyp/ptypdb/10.2.0/admin/PTYP2_pebpdb02/udump/ptyp2_ora_21976.trc:
ORA-00600: internal error code, arguments: [kgl_max_opr_exceeded], [], [], [], [], [], [], []


TRACE FILE
------------
sid_ora_21976.trc


Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ORACLE_HOME =

System name: HP-UX
Node name:
Release: B.11.23
Version: U
Machine: 9000/800
Instance name:
Redo thread mounted by this instance: 2
Oracle process number: 0
Unix process pid: 21976, image: oracle@
*** SERVICE NAME:(PTYP) 2009-03-31 00:33:41.008
*** SESSION ID:(1423.10903) 2009-03-31 00:33:41.008
*** 2009-03-31 00:33:41.008
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kgl_max_opr_exceeded], [], [], [], [], [], [], []



STACK TRACE
------------
kglobf0 <- kglhpd_internal

----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
Error from U_get_previous_frame_x is 1
Stack is not Windable
Stack has no Unwind_descriptor
sdsnm: dlmodinfo failed for address : 0x40000000
ksedst()+40 ? ksedst1() 090072FFF ?
80000001000164D8 ?
80000001000164D8 ?
800000010012D388 ?
ksedmp()+168 ? ksedst() 80000001000164D8 ?
800000010012D388 ?
C0000001F0B55478 ?
4000000001B5446F ?
ksfdmp()+32 ? ksedmp() 80000001000164D8 ?
800000010013F6D8 ?
80000001000164D8 ?
00000000C ?
kgerinv()+152 ? ksfdmp() 80000001000164D8 ?
00000000C ?
4000000004E70BE7 ?
1700016098 ?
kgeasnmierr()+88 ? kgerinv() C0000001B8503080 ?
000000000 ?
C0000001FF92E798 ?
800000010012D388 ?
kglobf0()+992 ? kgeasnmierr() A9A00000000 ?
80000001000165B0 ?
4000000001AB89EB ?
000000000 ?
kglhpd_internal()+2 ? kglobf0() C000000100E0BB60 ?
92 4000000004E7368B ?
000000000 ?
800000010012D388 ?
0x0000000040000000 ? kglhpd_internal() 80000001000165B0 ?
C0000001B1D5DC98 ?
000000000 ?
4000000001B374F3 ?

--------------------- Binary Stack Dump ---------------------


SQL
-----
No current SQL statement being executed.


PROCESS STATE
---------------
user: 44/APPS
O/S info: user: applptyp, term: unknown, ospid: , machine: pebpap05.dubaiworld.ae
program: JDBC Thin Client
client info: 104 0
application name: JDBC Thin Client, hash value=0
last wait for 'SQL*Net message from client' blocking sess=0x0000000000000000 seq=46 wait_time=326 seconds since wait started=3
driver id=28444553, #bytes=1, =0
Dumping Session Wait History
for 'SQL*Net message from client' count=1 wait_time=326
driver id=28444553, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=2
driver id=28444553, #bytes=1, =0
for 'SQL*Net message from client' count=1 wait_time=53405
driver id=28444553, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=2
driver id=28444553, #bytes=1, =0
for 'SQL*Net message from client' count=1 wait_time=302
driver id=28444553, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=3
driver id=28444553, #bytes=1, =0
for 'SQL*Net message from client' count=1 wait_time=626
driver id=28444553, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=2
driver id=28444553, #bytes=1, =0
for 'SQL*Net message from client' count=1 wait_time=10639
driver id=28444553, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=3
driver id=28444553, #bytes=1, =0
temporary object counter: 0
----------------------------------------
******************** Session Cursor Dump **********************
Current cursor: 19, pgadep: 0
Open cursors(pls, sys, hwm, max): 19(13, 2, 64, 2500)
NULL 3 SYNTAX 0 PARSE 0 BOUND 16 FETCH 0 ROW 0
----------------------------------------
Cursor#19(800003ffbfdc1f78) state=NULL curiob=800003ffbfc2da80
curflg=44 fl2=0 par=0000000000000000 ses=c0000001fedbeee8
sqltxt(c0000001e752ad38)=SELECT SERVER_ID,TYPE_ID,MEMBER_SVR_GROUP_ID, DNS_NAME,IP_ADDRESS,LOCATION FROM IEO_SVR_SERVERS WHERE SERVER_NAME = :1
hash=befdfc91dcf1de63a98a59741d85d682
parent=c0000001e951d278 maxchild=02 plk=c0000001d8af18e0 ppn=n
cursor instantiation=800003ffbfc2da80 used=1238445218
child#0(c0000001e74fd758) pcs=c0000001e74fda88
clk=c0000001bfed4500 ci=c0000001b859aa38 pn=c0000001c96dc160 ctx=c0000001e949fd38
kgsccflg=0 llk[800003ffbfc2da88,800003ffbfc2da88] idx=0
xscflg=20028 fl2=0 fl3=2022000 fl4=0
Bind bytecodes
Frames pfr 0000000000000000 siz=0 efr 0000000000000000 siz=0
Cursor frame dump
enxt: 1.0x00000000
pnxt: 1.0x00000000
Session cached cursors
-----------------------------------------------------------

Solution:

If you see the call stack information in the trace file : -

Error from U_get_previous_frame_x is 1
Stack is not Windable
Stack has no Unwind_descriptor

Please refer the Note below : -

Article-ID: Note 73835.1
Circulation: PUBLISHED (EXTERNAL)
Folder: ST.Server.DBA.Admin
Topic: Archives
Title: ALERT:HP-UX: ORA-7445 and Core Dump Generating Oracle Stack Trace .

This patch is very, very old. Release date was: 1998/11/30
This patch is not appropriate for 11.23. 11.23 was released September 2003!

Please go back to Oracle and ask for more details and a fix for 11.23.

---------------------------------

This patch as per HP is for 11.00 Platform and we are having 11.23 release

Article-ID: Note 43507.1
Circulation: PUBLISHED (EXTERNAL)
Folder: ST.Platform.Unix.HPUX
Topic: Configuration
Title: HP-UX: Patch Levels Advised

Check with HP for details and do the needful.

Oracle must be relinked after applying this patch, as follows:
%cd $ORACLE_HOME/rdbms/lib
%make -f ins_rdbms.mk ioracle
The instance needs to be shutdown when relinking.

Get Oracle Certifications for all Exams
Free Online Exams.com