ora-3114 trying to use Object Browser after logging in

wiedman

Member²
Customer has a new PC with plsql developer 8.04 installed. He can connect to the databases, but gets "ORA03114: not connected to ORALCE" error message and "Access violation at address 00B51817 in module 'plsqldev.exe'. Read of address 0000001C" when trying to use the sql window. Any time he tries to use the Object Browser he gets the ORA-03114 error. We deinstalled v8 and installed plsql developer v7, and everything works without errors. If needed, I can supply the Support Info for both v7 and v8 on the PC.
 
Can you go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?
 
Info from the user is below. I don't see any options in the Preferences,Oracle,Connection tab that would apply to holding a connection. His Connect preferences are set the same as mine which is working.

After setting the preference to OraHome8176, I am getting the error
message "Initialization error Could not locate OCI dll". When I changed the
preference back to OraHome81, I am able to connect to ctcc032@prod240 for a
second. After a second or so, it loses the connection and the window title
shows "PL/SQL Developer - (Not logged on)". I think, it is able to connect to Oracle
but not holding the connection.
 
Hi,

Ora-3114 is most often 'supported' by an Ora-600 on db-server-side. Ask your DBA to finde them an have a look at the logfiles there. There you can see the causing Query and further Information about the Error like ORA-00600: internal error code, arguments: [15570] ... and cearch for an avalable patch.

An other cause, is using an wrong/older Oracle-Client, and then this causing an Ora-600.

HTH
 
Back
Top