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

[abrsvc]

On Wednesday, March 23, 2022 at 1:21:36 PM UTC-4, Tom Wade wrote:
> 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

Tom,

See if this helps:  https://support.oracle.com/knowledge/Oracle%20Database%20Products/2000927_1.html

Dan