ORA-01041:internal error.hostdef extension doesn't exist error in Plsql developer too

[Prakash]

The following error message is thrown when trying to use the PlSql developer tool.

"ORA-01041:internal error.hostdef extension doesn't exist"

I think it keeps loosing it's connection.

Can any one please write to me the cause and the solution of the problem.

 

[Marco Kalter]

When does this error occur? For example during logon, when running queries, during compilation, ...?

Can you go to Help > About, press the 'Info' button, press the 'Copy all pages' button on this info screen, and paste this text into a reply?

 

[R. Kelder]

I'm also experiencing this problem. I have a 8.0.5.0.0 client, sql*plus is running fine against a 9.2.0.6.0 database. When I connect with pl/sql it connects fine. When I execute a query (any query), there is an ora-1041 (always).
When I run PL/SQL to an 8.1.7.4.1 database, it does work.

 

[Marco Kalter]

Can you go to Tools > Preferences > Debugger, disable the "Add debug information when compiling" preference, restart PL/SQL Developer, and try again?

 

[R. Kelder]

Marco, thanks for your quick reply. I already tried something else, I upgraded my Oracle client to 9.0.1.3.0, this solved the problem.

 

[dpmar]

Originally posted by Marco Kalter:
Can you go to Tools > Preferences > Debugger, disable the "Add debug information when compiling" preference, restart PL/SQL Developer, and try again?

 

[dpmar]

Originally posted by Marco Kalter:
Can you go to Tools > Preferences > Debugger, disable the "Add debug information when compiling" preference, restart PL/SQL Developer, and try again?

 

[dpmar]

This does work, however what if you realy need to debug, if you turn this off you cannot. If our dba recyles the instance then the error goes away and we candebug again.

 

[Marco Kalter]

You can try to explicitly add debug information by right-clicking on the program unit and selecting "Add debug information". Let me know if this works or also causes a problem.

Can you also let me know Oracle Server version?