ERROR ORA-00600

[CHRIS ANORUO]

The situition is that I have one database in mts mode and the other is not, a distributed transaction consistently logs ora-00600 with the following attached (tailed alert log and trace files)

[Alexander M. Ermes]

Hi there.
The problem is, that Oracle support does not hand out the explanation for the arguments in an ORA-00600. You have to open a TAR at Oracle support. I think, that you need some event entry in your init.ora file, but this is just a guess. Perhaps you can find some people in here, which have the ideas about the arguments of your ORA-00600.
Rgds
Alexander M. Ermes

[Steve Slade · Accepted solution]

Chris,

I notice from your logfile that you are running Oracle 8.0.5.2. We have just started using MTS in production, (under Oracle 8.0.6.2), and found a number of bugs to do with MTS under the 8.0.5.2 version. Our problems were primarily to do with a server running MTS initiating a distributed transaction via a procedural gateway. The problems we encountered were the reasons we upgraded to Oracle 8.0.6.2 - which was pretty painless. Also, we found that 8.0.5.2 is no longer fully supported by Oracle, so if you are suffering the effects from a bug, they will instruct you to upgrade to 8.0.6.2 before they will work on sending you a patch.

From memory, the problems we found were :

1. v$dblink view is not populated when links are open.
2 We did get some ora-600 error messages. This turned out to be that we had a non-enterprise version of 8.0.5.2. installed. MTS is only approved with the enterprise version.
3. There were some funnies reported with regards to the tnsnames entry. White space 'can' make it do funny things.?.? (The tnsnames parse processing is so crap I think it might have been somebody's cse computers project.)
4. There were instances where the shared servers were becoming dedicated. I believe that this was specific to our gateway - but I am not too sure.