ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

CA Gen 8.6 applications/CSE & 8.5 CSE with Oracle Database 18c or 19c

book

Article ID: 133228

calendar_today

Updated On:

Products

Gen

Issue/Introduction

This article describes the current support available for using Oracle Database 18c or 19c with Gen 8.6 generated applications and the Client Server Encyclopedia (CSE). It also covers internal support testing done for the Gen 8.5 Client Server Encyclopedia (CSE). 

Environment

Release: CA Gen 8.6
Component: Generated applications, Client Server Encyclopedia

Release: CA Gen 8.5
Component: Client Server Encyclopedia

Resolution

Gen 8.6 Generated Applications

Oracle 18c:
Gen 8.6 Windows runtime PTF RTN86121/SS08664 (ORACLE 18C SUPPORT) provides the ability to rebuild Gen runtimes aecoran.dll and stuboran.exe for respective Windows C and GUI applications plus the Oracle DDL Loader tioraddl.exe. NOTE: This PTF has now been superseded by CA Gen 8.6 GA Complete (WKS86200/SO09618)

For Gen applications running under Unix/Linux no PTF is required and all that is needed is to relink the Gen DBMS shared library for Oracle (libae_oracle.*) using the ORACLE_HOME for 18c.  This is documented on the Gen 8.6 techdocs page: Implementation Toolset > UNIX and Linux Implementation Toolset > Rebuilding DBMS Shared Libraries

Oracle 19c:
As of September 21, 2020, Oracle 19c is officially supported. No PTFs required for runtime.
See Community announcement: Certification Complete: Oracle 19c for Runtime and CSE

Gen 8.6 Client Server Encyclopedia (CSE)

** As of the September 21, 2020 announcement (Certification Complete: Oracle 19c for Runtime and CSE), the following information has also now been superseded by official support of Oracle 19c for Windows CSE in PTF CSN86204/SS14886 **

The Gen 8.6 Windows/Oracle CSE is 32-bit software and requires the 32-bit Oracle 12c (12.1.0.x or 12.2.0.x) client. The CSE runtime file csedb.dll is dependent on Oracle 32-bit client runtime file ORASQL12.DLL and therefore the Oracle client must stay at version 12c. However per "Client / Server Interoperability Support Matrix for Different Oracle Versions (Doc ID 207303.1)" an Oracle 12.1.0 or 12.2.0 client is compatible with an 18c and 19c server and thus the CSE database itself can in theory be at version Oracle 18c or 19c and still be compatible with the CSE server software running an Oracle 12c client i.e.

The CA Gen support team have successfully conducted basic testing for the configuration and usage of a Gen 8.6 Windows CSE against an Oracle 18c (18.3) and Oracle 19c (19.3) database using the Oracle 12.2 32-bit client. For AIX & HP Gen 8.6 CSE software which is 64-bit it is also expected that there will be no problems using Oracle 12c 64-bit client with an Oracle 18c or 19c database.
NOTE: These test results do not represent an official certification.

Gen 8.5 Client Server Encyclopedia (CSE)

Along the same lines as the Gen 8.6 Windows/Oracle CSE, the Gen 8.5 Windows/Oracle CSE is 32-bit software and requires the 32-bit Oracle 11g (11.1.0.x and 11.2.0.x) client. The CSE runtime file csedb.dll is dependent on Oracle 32-bit client runtime file ORASQL11.DLL and therefore the Oracle client must stay at version 11g. However per "Client / Server Interoperability Support Matrix for Different Oracle Versions (Doc ID 207303.1)" an Oracle 11.2.0.3 or 11.2.0.4 client is compatible with an 18c or 19c server and so the CSE database itself can in theory be at version Oracle 18c or 19c and still be compatible with the CSE server software running an Oracle 11g client i.e.

 

The CA Gen support team have successfully conducted basic testing for the configuration and usage of a Gen 8.5 Windows CSE against an Oracle 18c (18.3) and Oracle 19c (19.3) database using an Oracle 11.2 32-bit client. For AIX & HP Gen 8.5 CSE software which is 64-bit it is also expected that there will be no problems using Oracle 11g 64-bit client with Oracle 18c or 19c database. 
NOTE: These test results do not represent an official certification.
As Gen 8.5 is no longer the latest release, no official certification of the combinations Gen 8.5 Oracle CSE/Oracle 18c or Gen 8.5 Oracle CSE/Oracle 19c are being planned.

Additional Information

CA Gen 8.6 Technical Requirements:
CA GEN 8.6 > Technical Requirements > Third-Party Software Version
CA GEN 8.6 > Technical Requirements > Development Platform Environments

CA Gen 8.5 Technical Requirements:
CA GEN 8.5 > Technical Requirements > Third-Party Software Version
CA GEN 8.5 > Technical Requirements > Development Platform Environments

Attachments