ORA - 600 errors reported

From: Ranganath K <ranganathk_at_subexgroup.com>
Date: Wed, 18 Apr 2001 09:09:58 -0700
Message-ID: <F001.002EBE63.20010418082041@fatcity.com>

Dear DBA Gurus,

                   I am running Oracle 8.1.6 on Sun Solaris 2.8.  One of the

developers issued a delete command on a table without a where clause which contained 80,000 records which caused the oracle session to hang. He forcefully closed the session. Then he tried to issue the truncate command on the same table. Then he got the error Ora-00054 (resource busy and acquire with nowait specified). Then he called me. I identified the process which was locking the object by querying v$locked_object. Then I killed the session through alter system kill session.... command after identifying the sid and serial# from the process. Then I received the message the process is marked for kill. I again tried to issue the truncate command on the same table. I got the same error Ora-00054. Then I forcefully closed the session and issued shutdown immediate and restarted the database. Then when I issued select count(*) from tablename or truncate table tablename I received the below error:

ORA - 00600: internal error code, arguments: [kcbgcur_3], [4], [12], [54525964], [11281], [11294], [0], [ ]

I checked the alert log file which said that errors in file $ORACLE_HOME/admin/udump/mercedes_ora_43798.trc file. When I checked that file it had given the same error along with some block addresses from I couldn't decipher anything.

Any idea as to why are these errors generated? Any help in this regard will be appreciated.

TIA and regards,

Ranganath

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ranganath K
  INET: ranganathk_at_subexgroup.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Apr 18 2001 - 11:09:58 CDT