ORA-00600 [17113] and Code Assistant

[Rob Nasser]

Running into an issue where the code assistant is causing an ORA-00600 [17113] error when fetching a list of tables or columns. We can repeat this across any client. Anyone seen this issue before or have any notes on it. We can turn off the code assistant, but you know the basic user just has to have that... We are running on Oracle 9.2.0.3 and PL/SQL Developer 5.1.0.656.

Thanks in advance!
Rob Nasser
rnasser@reedbusiness.com

[This message has been edited by Rob Nasser (edited 09 July 2003).]

 

[Marco Kalter]

This could indicate an Oracle Server resource leak. If a shutdown/startup of the database instance fixes this problem, this would be confirmed. Can you try this?

------------------
Marco Kalter
Allround Automations

 

[chanatuke]

We are using Oracle 9.2.0.3 and PL/SQL Developer 5.1.2.687. We also get an ORA-00600 internal error [17113] when compiling packages. This seems to happen randomly (at least, we haven't been able to pinpoint any trend). Our DBA also says that it could be a resource leak. Once this error comes up, we cannot compile the package anymore, until the server is bounced. However, we've also noticed that TOAD is able to recompile the package without error after this happens. So while this may be a resource leak issue on the server, is there some chance that something is happening with the PL/SQL Dev app, since A) TOAD allows us to compile when this error comes up; and B) this does not happen with TOAD, at least in the experience of the implementation team we are working with.

Thanks! overall this is a great product!

Corey
chanatuke@stantec.com

Originally posted by mkalter:
This could indicate an Oracle Server resource leak. If a shutdown/startup of the database instance fixes this problem, this would be confirmed. Can you try this?

 

[Marco Kalter]

For stability issues during package compilation, please try this remedy .

------------------
Marco Kalter
Allround Automations

 

[tjdefoe]

I recently began receiving an ORA-00600 [17113] that appears to be caused by the code assistant. The problem appears to be isolated to my desktop since I can connect to the same Oracle instance from a different desktop and the code assitant works just fine. What is strange is that I can connect to a different Oracle instance from my desktop and the code assistant works just fine. When I disable the code assistant on my desktop I no longer recieve the error in any instances.

Any ideas would be greatly appreciated.

Thanks!

 

[Marco Kalter]

Perhaps you are using different versions of Oracle Net on these 2 PC's?

 

[tjdefoe]

I don't think that was the issue since everything was working fine up until last week when I suddenly started getting the errors. We insatlled version 9.2.0.6 of the Oracle client on my desktop and that seems to have resolved the issue.