[Info-vax] Oracle Client on OpenVMS --> Oracle DB
Chris Townley
news at cct-net.co.uk
Wed Mar 31 15:20:27 EDT 2021
On 31/03/2021 17:56, John H. Reinhardt wrote:
> On 3/31/2021 10:22 AM, Landon Statis wrote:
>> Hello,
>>
>> We have just upgraded from Oracle 11g (11.2.0.4 to 12c (12.2.0.1). We
>> also have a system running OpenVMS 8.3, using the client 8.1.7. This
>> was connecting fine under 11g. But, once we upgraded to 12c, the
>> application on OpenVMS no longer connects to the database.
>>
>> Some strange error messages:
>>
>> Error - ORA-03137: malformed TTC packet from client rejected:
>> [kpoal8Check-5] [0] [0x000000000] [0x000000000] [0] [0] [265256] []
>>
>> Error - ORA-03138: Message 3138 not found; product=RDBMS; facility=ORA
>>
>> Error - ORA-03114: not connected to ORACLE
>>
>> Is there an updated client for OpenVMS? Or, perhaps another solution?
>>
>> Please advise, and thank you.
>>
>
> If you have Oracle support, check Doc ID 207303.1 which has the
> compatibility index for Oracle RDBMS vs Oracle Client
> <https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=40441758044272&id=207303.1&_afrWindowMode=0&_adf.ctrl-state=hlqd6swrn_298>
>
>
> You need to upgrade to the Oracle 11gR2 client which will work up to
> Oracle 19c.
> For Oracle 21c you need the 12c client which means you are screwed since
> there is no OpenVMS 12c anything.
>
> Client
> Version Server Version
> 21c 19c 18c 12.2.0 12.1.0 11.2.0
> 11.1.0 10.2.0 10.1.0 9.2.0
> 21c Yes Yes Yes Yes Yes No No No
> No No
> 19c Yes Yes Yes Yes Yes Yes#9 No No
> No#3 No#3
> 18c Yes Yes Yes Yes Yes Yes#9 No No
> No#3 No#3
> 12.2.0 Yes Yes Yes Yes Yes Yes#9 No
> No No#3 No#3
> 12.1.0 Yes Yes Yes Yes Yes Yes Was
> Was#7 No#3 No#3
> 11.2.0 No Yes#9 Yes#9 Yes#9 Yes Yes Was
> Was#7 No Was#5
> 11.1.0 No No No No Was Was Was Was#7
> Was#6 Was#5
> 10.2.0 No No#10 No#10 No#10 Was#7 Was#7
> Was#7 Was Was Was#5
> 10.1.0#4 No No No No No Was#6 Was#6
> Was Was Was
> 9.2.0 No No No No No#8 Was#5 Was#5
> Was#5 Was Was
>
> Key:
>
> Yes Supported
> ES Supported but fixes only possible for customers with Extended
> Support .
> MDS Supported, but fixes only possible for customer with a valid
> Market-Driven Support contract.
> Was Was a supported combination but one of the releases is no
> longer covered by any of Premier Support, Primary Error Correct support,
> Extended Support, nor Extended Maintenance Support. Fixes are no longer
> possible.
> No Has never been Supported
>
> Specific Notes:
>
> #1 - See Note 207319.1
>
> #2 - An ORA-3134 error is incorrectly reported if a 10g client
> tries to connect to an 8.1.7.3 or lower server. See Note 3437884.8 .
>
> #3 - An ORA-3134 error is correctly reported when attempting to
> connect to this version.
>
> #4 - There are problems connecting from a 10g client to 8i/9i
> where one is EBCDIC based. See Note 3564573.8
>
> #5 - For connections between 10.2 (or higher) and 9.2 the 9.2
> end MUST be at 9.2.0.4 or higher. Connections between 10.2 (or higher)
> and 9.2.0.1, 9.2.0.2 or 9.2.0.3 have never been supported.
>
> #6 - For connections between 11.1 (or higher) database server
> and 10.1 / 10.2 database server across a database link the 10g end MUST
> be at 10.1.0.5 / 10.2.0.2 (or higher) respectively in order to use PLSQL
> between those versions. (This does not apply to normal 11g clients to
> 10g database server only server to server and a few very specific client
> products, such as Oracle Forms). See Note 4511371.8 for more details.
>
> #7 - For database link connections between 11.1 (or higher) and
> 10.2 the 10g end MUST be at 10.2.0.2 (or higher) in order to use PLSQL
> between those versions. See Note 4511371.8 for more details.
>
> #8 - Attempting to connect from 9.2 to 12.1 will fail with an
> "ORA-28040: No matching authentication protocol" error.
>
> #9 - 11.2.0.3 or 11.2.0.4 only. For Oracle Autonomous
> Transaction Processing and Oracle Autonomous Data Warehouse, there is
> additional limitation and 11.2.0.4 is the minimum supported client version.
>
> #10 - For the IBM z/OS platform only, Oracle will continue to test
> past 2014, at its discretion, new versions of the database running on
> non-z/OS platforms with the older 10.2 client running on z/OS. For more
> information, please refer to Note 461234.1 - Oracle Database on z/OS
> Support Status.
>
>
>
> You don't say if you are on Alpha or Itanium.
> If you are on Alpha you are also screwed as Alpha only goes up to V10gR2
> (10.2.0.4) See Oracle Doc ID 62150.1 - hp Alpha OpenVMS Certification
> Matrix
> <https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=40106098785961&parent=DOCUMENT&sourceId=52574.1&id=62150.1&_afrWindowMode=0&_adf.ctrl-state=hlqd6swrn_171>
>
>
> Last Update: 06-NOV-2012
> Updated by: Grant Hayden
>
> ALPHA/OpenVMS (Refer to Note:170199.1 for recommended OpenVMS ECO levels)
> -----------------------------------------------------------------------------------------|
>
> | | |
> | | |
> 7.1 | 7.2 | 7.3 | 8.2 |
> 8.3 | 8.4 |
> | |** see Note L |** see Note M
> | | |
> --------------|--------------|--------------|--------------|--------------|--------------|
>
> | | |
> | | 10.2.0.5.0 |
> | | |
> | |** see Note A |
> | | | 10.2.0.4.0 |
> 10.2.0.4.0 | 10.2.0.4.0 |
> | | | 10.2.0.2.0 |
> 10.2.0.2.0 | |
> | | | ** see Note
> B | |
> =========================================================================================|
>
> | | 10.1.0.5.0 | 10.1.0.5.0 |
> 10.1.0.5.0 | |
> | | 10.1.0.3.0 | 10.1.0.3.0 |
> 10.1.0.3.0 | |
> | | ** see Note
> C | |
> --------------|--------------|--------------|--------------|--------------|--------------|
>
> | | 9.2.0.8.0 | 9.2.0.8.0 |
> 9.2.0.8.0 | |
> | | ** see Note
> D | |
> | | 9.2.0.7.0 | 9.2.0.7.0 |
> 9.2.0.7.0 | |
> | | 9.2.0.5.0 | 9.2.0.5.0 |
> 9.2.0.5.0 | |
> | | 9.2.0.4.0 | 9.2.0.4.0 |
> 9.2.0.4.0 | |
> | | 9.2.0.3.0 | 9.2.0.3.0 |
> 9.2.0.3.0 | |
> | | 9.2.0.2.0 | 9.2.0.2.0 |
> 9.2.0.2.0 | |
> --------------|--------------|--------------|--------------|--------------|--------------|
>
> | 9.0.1.4.0 | 9.0.1.4.0 |
> | | |
> | ** see Note E |
> | | |
> | 9.0.1.3.0 | 9.0.1.3.0 |
> | | |
> | 9.0.1.0.0 | |
> | | |
> | ** see Note F |
> | | |
> --------------|--------------|--------------|--------------|--------------|--------------|
>
> | 8.1.7.4.0 | 8.1.7.4.0 | 8.1.7.4.0
> | | |
> | ** see Note G
> | | |
> | 8.1.7.3.0 | 8.1.7.3.0 | 8.1.7.3.0
> | | |
> | 8.1.7.1b | 8.1.7.1b | 8.1.7.1b
> | | |
> | 8.1.7.0.0 | 8.1.7.0.0 | 8.1.7.0.0
> | | |
> | ** see Note H
> | | |
> --------------|--------------|--------------|--------------|--------------|--------------|
>
> | 8.1.6.0.0 | |
> | | |
> --------------|--------------|--------------|--------------|--------------|--------------|
>
> 8.0.5.1.0 | 8.0.5.1.0 | | |
> | |
> 8.0.5.0.1 | 8.0.5.0.1 | | |
> | |
> 8.0.5.0.0 | 8.0.5.0.0 | | |
> | |
> 8.0.3.2.0 | | | |
> | |
> --------------|--------------|--------------|--------------|--------------|--------------|
>
> 7.3.4.4 | 7.3.4.4 | | |
> | |
> 7.3.4.3 | 7.3.4.3 | | |
> | |
> 7.3.3.6 | 7.3.3.6 | | |
> | |
> 7.3.3.4 | | | |
> | |
> 7.3.2.3.2 | | | |
> | |
> 7.3.2.3.0 | | | |
> | |
> =========================================================================================|
>
> (For hp Itanium OpenVMS Certification matrix - see Note:377470.1)
> (For hp VAX OpenVMS Certification matrix - see Note:52574.1)
>
>
> If you are on Itanium then you are good through Oracle 19c with the
> Oracle 11gR2 (11.2.0.4) client See Oracle OpenVMS: hp Itanium OpenVMS
> Certification Matrix (Doc ID 377470.1)
> <https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=40120666942707&parent=DOCUMENT&sourceId=62150.1&id=377470.1&_afrWindowMode=0&_adf.ctrl-state=hlqd6swrn_220>
>
>
> Last Update: 10-May-2018
> Updated by: Dave Hayter
>
> ITANIUM/OpenVMS (Refer to Note:377480.1 for recommended OpenVMS ECO
> levels)
> -------------------------------------------------------------------------------------------------------
>
> | | |
> | | | |
> 8.2-1 | 8.3 | 8.3-1H1 | 8.4 |
> 8.4-1H1 | 8.4-2 | 8.4-2L1 |
> | | | **see Note A | **see Note
> B | **see Note B | **see Note C |
> --------------|--------------|--------------|--------------|--------------|--------------|--------------|
>
> | | | 11.2.0.4.0 |
> 11.2.0.4.0 | 11.2.0.4.0 | 11.2.0.4.0 |
> | | | **see Note D
> | | **see Note H | **see Note H |
> --------------|--------------|--------------|--------------|--------------|--------------|--------------|
>
> | | | 10.2.0.5.0 |
> 10.2.0.5.0 | 10.2.0.5.0 | 10.2.0.5.0 |
> | | | **see Note E
> | | | |
> 10.2.0.4.0 | 10.2.0.4.0 | 10.2.0.4.0 | 10.2.0.4.0
> | | | |
> 10.2.0.2.0 | 10.2.0.2.0 | 10.2.0.2.0 |
> | | | |
> **see Note F |
> | | | |
> ==========================================================================================================
>
>
>
>
You should be OK for the moment on Alpha. Rule of thumb is that an
Oracle client will connect up to 2 version out - up or down.
Hence I could connect to two apps - one on 8.17, the other 11G from 10
clients. Sadly all gone now...
Chris
More information about the Info-vax
mailing list