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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
