Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> ORA-600 [3708] During Database SHUTDOWN

ORA-600 [3708] During Database SHUTDOWN

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Wed, 22 May 2002 13:03:32 -0800
Message-ID: <F001.004684DA.20020522130332@fatcity.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US