ORA-00600

AzureSky · **Joined:** Tue May 15, 2007 3:53 pm **Posts:** 9

Hibernate version:
NHibernate-1.2.0.GA

Name and version of the database you are using:
Oracle 9i

For a web app for a client of ours, we are using NHibernate with ASP.Net 2.0 and Oracle 9i. Mostly, the app is working fine, except that it will occasionally fail with Oracle errors like this:

Code:

ORA-00600: internal error code, arguments: [kghfrf2], [0x800003FB00067A68], [], [], [], [], [], []

ORA-00600: internal error code, arguments: [17182], [0x800003FA80003088], [], [], [], [], [], [] 

ORA-00600: internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s] 
(this actually comes back like this, with %s instead of useful arguments)

From researching this, I don't think this is our app's fault. This error (ORA-00600) is apparently the Oracle equivalent of a "kernel panic". Our clients are moving from an Oracle/Apache set up, to Oracle/IIS, and ours is the first major app to use the new servers. When we've told them that this is something they should contact Oracle support about, they've either ignored us or not told us the what Oracle has said. We don't see this error on our locally-maintained dev servers (though we use 10g, not 9i), and the sql calls NHibernate is performing (when we can figure it out) is simple stuff, like "select * from AdminUsers where username = ?" on the login page.

However, I don't know what else to do to resolve this, so I thought I'd ask here, has anyone ever seen NHibernate cause this kind of problem? Or something similar? If so, what was the issue? If not, what can I do to figure out what is wrong?

Thanks

wolli · **Posted:** Thu Jun 19, 2008 2:24 am

I can remember a similar problem in the past, though in a completely different environment. It was solved by applying some Oracle patches.
If I remember correctly, that problem wasn't directly related to our application but merely "bad luck". There wasn't anything we could do on the application side.
I'm afraid, there isn't much you can do except contacting Oracle support. Maybe check the version of your oracle client software, if there are known problems with the target setup.

Campmaster · **Joined:** Fri Jun 20, 2008 4:48 am **Posts:** 1

When Oracle promts a ORA-00600 it usally saves a Trace-File for your session. You can find it in the corresponding udump-directory on your Oracle-Server. In the trace you can find more details about which statement caused the internal error and maybe the reason for the error.

But don't get your hopes up. 90% of the times I got this error it was a Oracle-Bug which may be fixed by a already existing patch. If no patch exists you most likely won't get any because 9i isn't supported any longer by Oracle (support ended July 2007).