Hi,
In my alert.log I see some ORA-00600 errors. It is my production database and I have no clue as to what is this error for.
I am running Oracle 8.0.5 on Windows NT 4.0.
Please Help.......
The Alert File
--------------
CKPT started with pid=6
SMON started with pid=7
RECO started with pid=8
Wed Apr 18 21:51:24 2001
alter database sid8 mount
Wed Apr 18 21:51:24 2001
Errors in file C:\orant\RDBMS80\trace\ORA00140.TRC:
ORA-00600: internal error code, arguments: [SKGMBUSY], [1], [0], [0], [0], [], [], []
The Trace File
---------------
Dump file C:\orant\RDBMS80\trace\ORA00140.TRC
Wed Apr 18 21:51:24 2001
ORACLE V8.0.5.0.0 - Production vsnsta=0
vsnsql=c vsnxtr=3
Windows NT V4.0, OS V5.101, CPU type 586
Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
With the Objects option
PL/SQL Release 8.0.5.0.0 - Production
Windows NT V4.0, OS V5.101, CPU type 586
Instance name: sid8
ORA-600 messages are usually bugs with the database software. They should be reported to Oracle Support.
04-19-2001, 10:24 AM
Dave_A
I have seen ORA-0600 with the same flags on IBM AIX, where IIRC it was problems with shared memory. It all went away after a reboot of the server.
A search for SKGMBUSY on Metalink gave an Oracle forum thread, the response from the Oracle analyst is pasted below (hope nobody gets too upset about me cutting info from Metalink, and posting it here :))
HTH
David.
-------------
From: Oracle, Helen Schoone 26-Jan-00 15:33
Subject: Re : Ora-00600 [SKGMBUSY]
Hi. It appears that on NT, this error can be signalled due to the OracleService not being stopped after shutdown and restarted prior to attempting to restart the database. Please confirm if this is your scenario. The fix is to stop and restart the OracleService prior to attempting to restart the database.
In addition, this error can be signalled to a process instead of ORA-1034 when a process attempts to connect to the database when it is being started. The reporting of an ORA-600 instead of ORA-1034 in this case is considered a bug (939689) and is fixed in 8.0.6.