[Info-vax] Oracle Client on OpenVMS --> Oracle DB
John H. Reinhardt
johnhreinhardt at thereinhardts.org
Wed Mar 31 12:56:24 EDT 2021
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 | | | | |
==========================================================================================================
--
John H. Reinhardt
More information about the Info-vax
mailing list