Re: Questions about ORA-600

From: Jack van Zanen <jack_at_vanzanen.com>
Date: Fri, 30 Jan 2015 13:43:37 +1100
Message-ID: <CAFeFPA-NDxQLZT3S6KEQLjjKdXg6wQZkAovyt68Qz=ns6yr95A_at_mail.gmail.com>



Hi

I am assuming that oracle has supplied the "solution" by analysing the logs send to them.
If that is the case, than the monitoring of the system is for 2 purposes. 1. See if the bug is fixed (one week may not be enough as previously pointed out)
2. Test that the application still works as before and a week should be plenty to test that.

purpose 2 is more important than 1 in my opinion as the proposed solution has a very high probability of succes

Jack

Jack van Zanen



This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation

On Wed, Jan 28, 2015 at 7:37 PM, Prem J <jprem_at_outlook.com> wrote:

> 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 :
>
> 1) 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.
>
> 2) 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-l
Received on Fri Jan 30 2015 - 03:43:37 CET

Original text of this message