RE: ORA-600 [3708] During Database SHUTDOWN

Vivek:

Oracle Support is right. THis is a typical LGWR problem.

The first thing you should do is.. You need to reduce the size of Log Buffer
(it should be in KBs..

NEVER configure log buffer in MBs)

Try setting log buffer in KBs.

Best Regards,
K Gopalakrishnan
Bangalore, INDIA

-----Original Message-----
VIVEK_SHARMA
Sent: Wednesday, May 22, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L

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 :-

• Remove the REDO log files from RAID5
• Check OS & H/W, RAID for any performance issues specifically during that time.

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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  INET: kaygopal_at_yahoo.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).