No question at this time
DBA Top 10
1 A. Kavsek 12200
2 M. Cadot 7000
3 P. Wisse 5600
4 B. Vroman 5400
5 J. Péran 1900
6 . Lauri 1500
7 T. P 500
7 R. Pattyn 500
9 T. Boles 400
10 A. Chavan 300
10 J. Schnackenberg 300
10 D. Johnson 300
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48454
Total active users1499
Act. users last 24h5
Act. users last hour0
Registered user hits last week216
Registered user hits last month950
Go up

Your pactice about ORA-600
Next thread: ORA-00363: log is not the archived version
Prev thread: Grid Infrastructure Ora12r2

Message Score Author Date
Hi, ORA-600 are internal errors generated by th...... Lauri Aug 12, 2019, 16:38
Nice IMHO subject! ... Philip Wisse Aug 27, 2019, 12:16
Hi Lauri, Speaking for myself, most of the t...... Joël Péran Aug 27, 2019, 13:52

Follow up by mail Click here


Subject: Your pactice about ORA-600
Author: Lauri, Netherlands
Date: Aug 12, 2019, 16:38, 99 days ago
Os info: All
Oracle info: 11g, 12c, 18c, 19c
Error info: ORA-00600
Message: Hi,

ORA-600 are internal errors generated by the generic kernel code of the Oracle RDBMS software. They are different from other Oracle errors in many ways.
These are typically errors handled by Oracle Support.
Usually, even if there is no user report for being impacted by this error I do a check on MOS, without going to deep, meaning not necessarily creating an SR for it.
I create an SR if that error really imapcts business.
Applying a patch for an ORA-600 error might be beneficial for a system. Should such a patch be applied to all systems for wich that patch apply, even if the error does not appear in the alert log or even if it does not imapact the business?
Especially when hundreds of systems are concerned.
What is your experience about it? What is your company policy for handling these errors?

Thanks by advance for sharing your experience and ideas.

Kind Regards
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Your pactice about ORA-600
Author: Philip Wisse, Netherlands
Date: Aug 27, 2019, 12:16, 84 days ago
Message: Nice IMHO subject!
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Your pactice about ORA-600
Author: Joël Péran, France
Date: Aug 27, 2019, 13:52, 84 days ago
Message: Hi Lauri,

Speaking for myself, most of the time, these errors were handled quite easily, thanks to MOS support Tool. Most of the time, it was related to bad sql or memory consumption. That kind of things. I did have to patch once for this kind of error, but it is a very tideous thing to do. Patching our oracle clusters. Usually, I use the latest and safiest version of Oracle to install. For instance 11.2.0.4 directly instead of other version, or 12.1.0.2 for Oracle 12 (I already mentionned that I was wrong, thinking that 12.2 version would not allow non PDB databases). I prefer to chose PSU version directly. The last Patch I had to install was the July 2017 patch for 12.1.0.2. And it took alot of time to do it.
Our configuration is based on clusters, multi nodes (one with two nodes, the other with four nodes), about 6 databases on each node and also different kind of applications. So stopping one node or moving all the databases to another node (in order to patch the Oracle engine) means to stop a big part of the factory.
In conclusion, I prefer to use the latest complete PSU for the version I want to install than to regularly patch my servers (which is always a difficult operation to do ...).

Regards,
Joel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here