Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> ORA-600 [3708] During Database SHUTDOWN
O.S. Solaris 8
Oracle 8.1.7.2 + 3 Stand Alone Patches
CASE - On Database SHUTDOWN Got the Error ora-600 [3708 ]
Messages
ALTER DATABASE CLOSE NORMAL
Tue May 21 01:30:36 2002
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue May 21 01:46:23 2002
Errors in file /oracle734/ver817/rdbms/userlog/bby01_ora_19332.trc:
ORA-00600:internal error code,arguments:[3708], [910], [], [], [], [], [], []
Tue May 21 01:46:39 2002
SMON: enabling cache recovery
SMON: enabling tx recovery
NOTE Shutdown process took about 15 Minutes to Complete & gave this Error
EXPLANATION By Oracle Corp. :-
Basically this error is raised because LGWR timmed out.
While shutdown, Oracle routine (kcttsc()) sends a message to LGWR to change the state
of a redo thread and waits for confirmation.
If the return message never comes, then LGWR times out after 15 minutes which is
the second argument in the ora-600 (910 secs ie. 15mins.)
In the situation we faced , lgwr had RT enqueue and waiting for 'direct path read'
on file 197. Becuase of some OS issues the read took more than 15 minutes and lgwr
gave a timeout.
There is a workaround to keep a underscore init parameter to overcome any OS issues
and tell lgwr to wait for more time. But this is suggested only after checking OS for any
performance issues.
SOLUTION / Suggestion by Oracle Corp :-
GENERAL INFO :-
log_buffer = 4M (High Volume OLTP / Batch Transactions 3 Million in a 5 Hours Window Exist)
Size of online Redo Logfile = 500M ( Is This Excessive ?)
Logfiles are Multiplexed .
All Datafiles & Online Redo logfiles Exist on a SINGLE RAID 5 Volume
All Hard Disks Clubbed into a Single RAID 5 Volume
Storage Box = HP having VXFS Filesystems mounted thereon even though O.S. = Solaris 8
Any Advice for approach / resolution ?
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: VIVEK_SHARMA_at_infosys.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 May 22 2002 - 16:03:32 CDT