Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1750
  • Last Modified:

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

0
cryptosid
Asked:
cryptosid
  • 3
  • 2
1 Solution
 
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
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

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now