Oracle Server goes down with a trace file.

The alert log shows the following.

ORA-00600: internal error code, arguments: [kcblibr_1], [4294967295], [1], [3338911984], [1025], [], [], []
Thu Mar 30 00:54:11 2006
Non-fatal internal error happenned while SMON was doing temporary segment drop.
SMON exceeded the maximum limit of 100 internal error(s).
Thu Mar 30 00:54:11 2006
Errors in file /oracle/P25/saptrace/background/p25_smon_67452.trc:
ORA-00600: internal error code, arguments: [kcblibr_1], [4294967295], [1], [3338911984], [1025], [], [], []
SMON: terminating instance due to error 600


The trace file is a 125 MB file which has the following text in the end:

error 600 detected in background process
ORA-00600: internal error code, arguments: [kcblibr_1], [4294967295], [1], [3338911984], [1025], [], [], []

I checked on Oracle Metalink, there is no clear cut explaination about this, only possible error texts, this looks like a unknow issue, has anyone encountered the same ?

Any help is appreciated.

Regards,
Siddhesh

LVL 5
cryptosidAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
what is your version of oracle?
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I guess 9.2.0.6, where the solution would be fixed in 9.2.0.7
0
cryptosidAuthor Commented:
Hi angelIII,

yes that's correct. But do you know why this problem occurs. I have confirmed in oracle.metalink.com  that this problem is fixed in the patch.

But i just wanted to know the cause so that we can think about the work around till we apply the patch.

Regards,
Siddhesh
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
as by the metalink, there is no workaround, while one possible cause has been identified
Note 2881246.8 - Bug 2881246 - Incorrect OERI[kcblibr_1] / OERI[kxttdropobj-1] can occur
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
cryptosidAuthor Commented:
Hi angelIII,

I had seen the same note number and confirmed that the problem would be fixed in the next patch.

Thanks for all the help.

I would like to wait for some more inputs from other members before closing this question.

Regards,
Siddhesh
0
schwertnerCommented:
ORA-600 shows bugs (in almost all cases).
The best reaction is to move to next version of Oracle.
Another possible fix is to analyze the server machine.

Possibly you will encounter one or more of the following:
1. Not all kernel parameters are set correctly
2. Other huge software products are installed after - e.g. Application servers, other oracle products
3. In Unix/Linux not all needed environment variables are set correctly
4. Firewalls and Antivureses are running

All this can cause accidents in the Oracle instance.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.