Message-ID:

24 Apr, 2024: Testing a new version of the Overboard here. If you have an issue post about it to rocksolid.nodes.help (I know. Everyone on Usenet has issues)

computers / comp.os.vms / Re: Compatible versions of Oracle Server and Oracle Client

Compatible versions of Oracle Server and Oracle Client

<t1fktc$an4$1@gioia.aioe.org>

https://www.novabbs.com/computers/article-flat.php?id=21513&group=comp.os.vms#21513

Path: i2pn2.org!i2pn.org!aioe.org!sxggKrrMa4bYZzUlWvCgwA.user.46.165.242.75.POSTED!not-for-mail
From: nos...@void.blackhole.mx (Tom Wade)
Newsgroups: comp.os.vms
Subject: Compatible versions of Oracle Server and Oracle Client
Date: Wed, 23 Mar 2022 17:20:44 +0000
Organization: Aioe.org NNTP Server
Message-ID: <t1fktc$an4$1@gioia.aioe.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Info: gioia.aioe.org; logging-data="10980"; posting-host="sxggKrrMa4bYZzUlWvCgwA.user.gioia.aioe.org"; mail-complaints-to="abuse@aioe.org";
User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:91.0) Gecko/20100101
Thunderbird/91.7.0
Content-Language: en-US
X-Notice: Filtered by postfilter v. 0.9.2

by: Tom Wade - Wed, 23 Mar 2022 17:20 UTC

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

Re: Compatible versions of Oracle Server and Oracle Client

<472cd168-0d44-455f-aee2-3b590191b176n@googlegroups.com>

copy mid

https://www.novabbs.com/computers/article-flat.php?id=21514&group=comp.os.vms#21514

copy link Newsgroups: comp.os.vms

X-Received: by 2002:a05:622a:208:b0:2e1:b3ec:b7ce with SMTP id b8-20020a05622a020800b002e1b3ecb7cemr811507qtx.345.1648056391150;
Wed, 23 Mar 2022 10:26:31 -0700 (PDT)
X-Received: by 2002:ad4:5cc7:0:b0:441:17d2:3b70 with SMTP id
iu7-20020ad45cc7000000b0044117d23b70mr629751qvb.7.1648056390918; Wed, 23 Mar
2022 10:26:30 -0700 (PDT)
Path: i2pn2.org!i2pn.org!news.neodome.net!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.os.vms
Date: Wed, 23 Mar 2022 10:26:30 -0700 (PDT)
In-Reply-To: <t1fktc$an4$1@gioia.aioe.org>
Injection-Info: google-groups.googlegroups.com; posting-host=96.230.211.194; posting-account=Ysq9BAoAAACGX1EcMMPkdNg4YcTg0TxG
NNTP-Posting-Host: 96.230.211.194
References: <t1fktc$an4$1@gioia.aioe.org>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <472cd168-0d44-455f-aee2-3b590191b176n@googlegroups.com>
Subject: Re: Compatible versions of Oracle Server and Oracle Client
From: dansabrs...@yahoo.com (abrsvc)
Injection-Date: Wed, 23 Mar 2022 17:26:31 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 39

by: abrsvc - Wed, 23 Mar 2022 17:26 UTC

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

Re: Compatible versions of Oracle Server and Oracle Client

<t1fm0l$6pp$2@dont-email.me>

copy mid

https://www.novabbs.com/computers/article-flat.php?id=21515&group=comp.os.vms#21515

copy link Newsgroups: comp.os.vms

Path: i2pn2.org!i2pn.org!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: jan-erik...@telia.com (Jan-Erik Söderholm)
Newsgroups: comp.os.vms
Subject: Re: Compatible versions of Oracle Server and Oracle Client
Date: Wed, 23 Mar 2022 18:39:32 +0100
Organization: A noiseless patient Spider
Lines: 42
Message-ID: <t1fm0l$6pp$2@dont-email.me>
References: <t1fktc$an4$1@gioia.aioe.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Wed, 23 Mar 2022 17:39:33 -0000 (UTC)
Injection-Info: reader02.eternal-september.org; posting-host="c96ed52c4383bd2268198a62581381f3";
logging-data="6969"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/CLdpmClex2WgKJvtOFBgd"
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:91.0) Gecko/20100101
Thunderbird/91.6.1
Cancel-Lock: sha1:3vQ0HIpvCAdi94mcavfJqHnTU7s=
In-Reply-To: <t1fktc$an4$1@gioia.aioe.org>
Content-Language: sv

by: Jan-Erik Söderholm - Wed, 23 Mar 2022 17:39 UTC

Den 2022-03-23 kl. 18:20, skrev 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
>

The 10.2 client is not compatible with 19 server.
The 11.2 client is, and that seems to be available for IA64 8.4 and up.

Check Oracle support doc 207303.1 (need an account and a login).

I'm sure all kits are available throught your Oracle support contract.

Subject	Author
Compatible versions of Oracle Server and Oracle Client	Tom Wade
Re: Compatible versions of Oracle Server and Oracle Client	abrsvc
Re: Compatible versions of Oracle Server and Oracle Client	Jan-Erik Söderholm