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