RE: Questions about ORA-600
Date: Wed, 28 Jan 2015 17:29:41 +0000
Message-ID: <9F15274DDC89C24387BE933E68BE3FD31767D54F_at_MISOUT7MSGUSRCD.ITServices.sbc.com>
Ideally it should never happen. Have you checked to see if the OS was patched but Oracle was not relinked ? This can sometimes lead to spurious ORA-600, 7445 errors. Check the date on the oracle executable and compare that to the package install dates for the key things required by Oracle and kernel. If the date of Oracle is older than the patches / kernel then you know a relink was not performed.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Prem J
Sent: Wednesday, January 28, 2015 3:38 AM
To: oracle-l_at_freelists.org
Subject: Questions about ORA-600
Friends ,
Got below ORA-600 on one of our customer's 10.2.0.3 (sparc) box .
ORA-600 [KCBGET_37] / ORA-600 [1100] AND INSTANCE CRASH (not reproducible at will . and this bug is related to some buffer cache corruption)
So we suggested to apply patch 6110331 - and to monitor the instance for a week .
Questions from user :
- User : what's the frequency at which ora-600 error occurs ? Me : ora-600 is mostly due to bugs and can't really say when it will pop up . there is so clear cut way to say when it will happen again.
- user : when you ora-600 are rare and happens at random - on what basis do you 1 week of monitoring the instance (after patch) will suffice ? me : usually - 1 week is the minimum time you monitor the instance - ensure that you test all your important business processes and if all goes thro' fine and if ora-600 does not happen again . then you should be safe .
What would have been your reply for the above 2 questions ? I am looking for stronger/deeper points about ORA-600 occurrence and how it should be tested (after patch) . Would like to rephrase my next (to user) reply more technically & politically correct.
Regards,
JP
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 28 2015 - 18:29:41 CET