[Info-vax] Compatible versions of Oracle Server and Oracle Client

[Tom Wade]

Hi,

I was asked by a friend trying to support an application on OpenVMS I64 
8.4, that uses Oracle Client to talk to a remote Oracle database on a 
Windows server.  I have had very little experience with Oracle (enough 
to stay well clear of it!), so all I could do was offer to put the 
question to this forum in case somebody has been through this themselves.

Oracle server is 11g release 1.2.0.4.0 on Windows 2012 Rel 2 64 bit.
Oracle client is 10.2.0.2.0 on OpenVMS I64 8.4 (rx 2800).

This was working fine until the Windows servers were rebuilt after a 
cyber attack.  Since then, the server produces intermittent error TNS 
12531, and needs to be rebooted.  Searching on this code indicates some 
kind of memory allocation problem (probably a leak) on the Windows server.

The people supporting the Windows server are suggesting upgrading to 
Oracle 19, but (strangely enough) don't know whether the existing Oracle 
client software will work with it.

Apparently there is an 11.2 for the Oracle client, but my friend is 
having great difficulty in getting any help from Oracle as to whether it 
is needed, or how to obtain it.

So if anybody knows whether it is necessary to upgrade the Oracle 
client, and if so, where to get it, it would be a great help, and I will 
pass the information on.

Many thanks

Tom Wade

tom dot wade at tomwade dot eu