Access violation at address 640B4564 in module 'ORA805.dll' connecting to 19c database

[jesc]

Hi all,

This is my first post here, so please be gentle with me ;-)

At a new client, whose environment I'm still getting to know, I'm hitting this error on a 19c instance, although connections to lower DB versions are successful.

From the same Citrix server, Oracle SQL Developer connects OK to the 19c environment.

As I don't know PL/SQL Developer at all, can anyone suggest where I should start troubleshooting the issue please. We have a 10g client installed, but I don't know what, it any, interaction there is between PL/SQL Developer and this client installation.

Thanks in advance for any suggestions.

 

[jhughes]

Well, you are trying to have PL/SQL Developer (assuming recent 13 or 14) connect to an Oracle 19c DB using an Oracle 8 (appears to be even before 8i) client. I searched for that DDL to verify it was as old as I thought and over on the Toad support knowledge base from 2008 - 2010 time-frame it suggests that Oracle changed internal communications between 8.0 and 8.1. In short, go get the latest Oracle Instant Client for 19c and use that for communications with 19c and older databases.

Note: Lots of assumptions in my answers so additional details will help refine future answers.

 

[Marco Kalter]

According to the "Client / Server Interoperability Support Matrix for Different Oracle Versions (Doc ID 207303.1)" you will need an Oracle 11.2 or later client. An Oracle 8.0 Client is indeed not compatible with a 19c Server.

Note that if you are using a 32 bit version of PL/SQL Developer, you will also need a 32 bit version of the Oracle Client.