Oracle Instant Client Installation and Configuration on Unix or Linux

Symptom

Oracle Instant Client in SAP Environments

This note describes how to install and configure the Oracle Instant Client in an SAP environment on Unix and Linux platforms. Oracle Instant Clients (IC) that are built for SAP environments are also denoted as 'SAP Instant Client (SAP IC)' in the context of this SAP note.

This SAP Note is valid for Oracle Instant Client Versions 11.2, 12.1, 12.2, 18c, 19c.

For Installation and Configuration of Oracle Instant Client on Windows platforms, see SAP Note 998004.

News

Date News
February 22, 2024

New: Oracle Instant Client 19c V5 SAP DVD 51057419 released (replaces SAP DVD 51055071, based on release update 19.20)
October 7, 2021

New: Oracle Instant Client 19c V4 SAP DVD 51055071 released (new version, release date 2021-Oct-06)
October 5, 2021

Info: Oracle Instant Client 19c V4 SAP DVD 51055071 cancelled
September 28, 2021

New: Oracle Instant Client 19c V4 SAP DVD 51055071 released (replaces SAP DVD 51054541, based on release update 19.12)
October 26, 2020

Info: Oracle Instant Client 19c name of SAR file corrected: OCL1964.SAR instead of OCL19064.SAR
September 16, 2020

New: Oracle Instant Client 19c V3 for AIX released (SAP DVD 51054541, replaces 51054415)
May 14, 2020

New: Oracle Instant Client 12.2.0.1 V3 for Solaris SPARC released (SAP DVD 51054433, replaces SAP DVD 51054241)
May 5, 2020

New: Oracle Instant Client 19c V2 released (SAP DVD 51054415, replaces SAP DVD 51053890)
February 14, 2020

New: Oracle Instant Client 12.1.0.2 V5 released (SAP DVD 51054219)
February 14, 2020

New: Oracle Instant Client 12.2.0.1 V2 released (SAP DVD 51054241)
December 19, 2019

New: Oracle Instant Client 19c V1 released (SAP DVD 51053890)
December 10, 2019

New: Oracle Instant Client 11.2.0.4 V5 released (SAP DVD 51054174), Extended Support required (SAP Note 2717456)
September 30, 2019

Info: Update for Oracle Instant Client version 19c
July 23, 2019

Info: Preliminary information for Oracle Instant Client version 19c
January 28, 2019

Info: Updated sections 'Configuring Oracle Instant Client for SAP BR*Tools 7.40' and 'Installing the Oracle Instant Client in an SAP Environment'
October 29, 2018

Info: Update for Oracle Instant Client version 18c
July 25, 2018

New: Oracle Instant Client 12.1.0.2 V4 released (SAP DVD 51053249, replaces SAP DVD 51052742)
July 25, 2018

Info: SAP IC 12.1.0.2 is last supported version for Linux on Power Big Endian (64-bit)
May 24, 2018

New: Oracle Instant Client 12.2.0.1 V1 released (SAP DVD 51052986 with SAP IC for Windows and Unix, replaces SAP DVD 51052766)
January 22, 2018

New: Oracle Instant Client 11.2.0.4 V4 released (SAP DVD 51052783)
December 29, 2017

Info: Oracle Instant Client 12.2.0.1 V1 released (SAP DVD 51052766, replaces SAP DVD 51051867)
December 18, 2017

New: Oracle Instant Client 12.2.0.1 V1 released (SAP DVD 51051867, SAP IC for Windows only)
New: Oracle Instant Client 12.1.0.2 V3 released (SAP DVD 51052742)
November 21, 2017

Info: Update for 12.2.0.1
October 5, 2017

Info: SAP IC for Linux on Power only as Big Endian
April 26, 2017

New: Oracle Instant Client 12.1.0.2 (V2) released (SAP DVD 51050832) (now with IC for Linux on Power Big Endian)
December 23, 2016 Update: Old SAP Service Portal link http://service.sap.com/oracle  replaced by new link https://support.sap.com/swdc
January 11, 2016 Update: occurrences of platform 'AIX5L' renamed to 'AIX'
November 20, 2015 Update: Instant Client DVD information updated
October 26, 2015 Update: Support Status for Oracle Instant Client 11.2.0.4 updated
April 13, 2015 New: Oracle Instant Client 11.2.0.4 V3 released (SAP DVD 51049326)

 

 

Other Terms

Oracle Instant Client
Easy Client
Instant Client Basic
Instant Client Light

Reason and Prerequisites

The currently used Oracle Instant Client is not up-to-date. You need to download and configure the current version of the Oracle Instant Client.

Updating and replacing the currently installed Oracle instant client is required if

  • the instant client version is not supported any more (too old), or
  • the instant client version is incompatible with the Oracle database server version (database upgrade), or
  • the instant client needs to be patched (a new patched version is available)

Solution

Oracle Instant Client

The Oracle Instant Client contains the complete Oracle client software required for an SAP system in an easy-to-install way. Oracle Instant Clients replace the full client installations ("Oracle-Home-based client") that were required prior to Oracle release 10.2.

In this SAP note the term 'SAP IC' stands for 'SAP Instant Client' and means 'Oracle Instant Client built for SAP Applications'.

This SAP note is structured as follows:

Choosing the Right Oracle Instant Client
Downloading Oracle Instant Client Software

Oracle Instant Client Packages for SAP
Oracle Instant Client Standard Path and Symbolic Link

Installing the Oracle Instant Client in an SAP Environment
Configuring Oracle Instant Client for SAP BR*Tools 7.40
Configuring Oracle Instant Client 11.2 for SAP BR*Tools 7.20

Verifying the Oracle Instant Client Version
Verifying the Oracle Client Operation Mode

Installing the Oracle Instant Client for Secondary Connections
Oracle Instant Client in Failover-Cluster on Unix Platforms

Choosing the Right Oracle Instant Client

An Oracle Instant Client must be installed for SAP Kernels that are linked with Oracle release 10.2, 11.2, 12.1, 12.2 or higher.

General Recommendations for Oracle Instant Clients in SAP Environments

  • SAP customers must use instant client versions from the SAP Software Download Center that are released for SAP. The use of Oracle Instant Client versions that are available from other Oracle sources (i.e. OTN) is not supported.
  • SAP customers are strongly advised not to create their own patched versions of the Oracle Instant Client. Updated versions of the instant client are made available for download on the SAP Service Marketplace if this is required.
  • All SAP application servers of an SAP system should run with the same version of the instant client. Running a mix of different instant client versions in one SAP system is not recommended.
  • There are also some dependencies between SAP BR*Tools versions and Oracle instant client versions. See below 'Configuring Oracle Instant Client 11.2 for SAP BR*Tools 7.20'.

Operating System Specific Requirements

  • For Installation and Configuration of Oracle Instant Client on Windows platforms, refer to SAP note 998004.
  • For Red Hat Enterprise Linux 6 (RHEL 6), you must use Oracle Instant Client 11.2.0.3 or higher. See SAP note 1642058.
  • For Oracle Linux 6 (OL 6), you must use Oracle Instant Client 11.2.0.3 or higher. See SAP note 1642058.
  • For Solaris 11, you must use Oracle Instant Client 11.2.0.3 or higher. See SAP note 1642058.
  • For Linux on Power only the Instant Client for Linux on Power Big Endian is available for SAP.

Use of Oracle Instant Client 19c / SAP IC 19c

  • If you are using Oracle Native Network Encryption (NNE), you must use SAP IC 19c V4 or higher to fix CVE-2021-2351 (SQLNET.ALLOW_WEAK_CRYPTO_CLIENTS). For more information, refer to SAP Note 3085920.
  • If your SAP database is running on Oracle Database 19c, then you can use SAP IC 19c (see SAP Note 2799900).
  • If your SAP database is running on Oracle Database 19c, then you can use SAP IC 12.1.0.2 or SAP IC 12.2.0.1 (see below).
  • In general we recommend to use Oracle Instant Client 19c (SAP IC 19c) when you upgrade your Oracle database to 19c or when you install a new SAP system with Oracle Database 19c as the Premier Support for Oracle Instant Client 12.2.0.1 ends November 20, 2020 and for Oracle Instant Client 12.1.0.2 ended July 31, 2019 (see SAP Note 2799900).

Use of Oracle Instant Client 18c / SAP IC 18c

  • SAP IC 18c is not available for SAP NetWeaver systems.
  • If your SAP database is running on Oracle Database 18c, then you can use SAP IC 12.1.0.2 or SAP IC 12.2.0.1 (see below).

Use of Oracle Instant Client 12.2.0.1 / SAP IC 12.2.0.1

  • If your SAP database is running on Oracle Database 19c, then you can use SAP IC 12.2.0.1 (see SAP Note 2799900).
  • If your SAP database is running on Oracle Database 18c, then you can use SAP IC 12.2.0.1 (see SAP Note 2660020).
  • If your SAP database is running on Oracle Database 12c Release 12.2.0.1, then you can use SAP IC 12.2.0.1.
  • On Windows Server 2016, you must use SAP IC 12.2.0.1 or higher.
  • SAP DVD 51054241 contains Oracle Instant Client 12.2.0.1 V2 (all platforms).
  • SAP DVD 51054433 contains Oracle Instant Client 12.2.0.1 V3 for Solaris SPARC (built on Solaris 10, contains additional fixes) and Oracle Instant Client 12.2.0.1 V2 for all other platforms as on  SAP DVD 51054241.

Use of Oracle Instant Client 12.1.0.2 / SAP IC 12.1.0.2

  • If your SAP database is running on Oracle Database 19c, then you can use SAP IC 12.1.0.2 (V4 or higher, see SAP Note 2799900).
  • If your SAP database is running on Oracle Database 18c, then you can use SAP IC 12.1.0.2 (V4 or higher, see SAP Note 2660020).
  • If your SAP database is running on Oracle Database 12c Release 12.2.0.1, then you can use SAP IC 12.1.0.2 (V3 or higher, see SAP Note 2470660).
  • If your SAP database is running on Oracle Database 12c Release 12.1.0.2, then you can use SAP IC 12.1.0.2 (see SAP Note 1914631).

Use of Oracle Instant Client 11.2 / SAP IC 11.2

  • Oracle Instant Client 11.2.0.4 (V5) requires Oracle Extended Support. For more information see SAP Note 2717456.
  • Oracle Instant Client 11.2.0.4 (V4) is the last version that can be used without Oracle Extended Support.
  • Oracle Instant Clients of release 11.2 are not supported for SAP databases of release Oracle Database 12c (12.2.0.1) or higher.
  • If your SAP database is running on Oracle Database 11g Release 11.2.0.X, then you should use the current version of Oracle Instant Client 11.2.
  • If your SAP database is running on Oracle Database 11g Release 11.2.0.4, then you should use Oracle Instant Client version 11.2.0.4 (same version on server and client).
  • If your SAP database is running on Oracle Database 12c Release 12.1.0.2, then you can use Oracle Instant Client version 11.2.0.4 (latest version, versions lower than 11.2.0.4 are not supported).
  • If your SAP database is running on Oracle Database 12c Release 12.2.0.1, then you must not use Oracle Instant Client of version 11.2.0.X.
  • If you are upgrading the SAP database to 11.2.0.4 and the SAP application is currently running with Instant Client 11.2.0.3, then you can either continue using Instant Client 11.2.0.3 (as long as this release is supported, see SAP Note 1431799), or you can upgrade the Instant Clients to release 11.2.0.4.
  • If you are upgrading the SAP database to 11.2.0.4 and the SAP application is currently running with Instant Client 11.2.0.2 (or older), then you should also upgrade the Instant Clients to release 11.2.0.4 after (or before) the upgrade of the database.

Use of Oracle Instant Client 10.2

  • Use Oracle Instant Clients of release 10.2 only if your database is running on Oracle Database Release 10.2.

Support Status of Oracle Instant Clients

  • For current support status of Oracle Database 19c incl. Instant Client see SAP note 2799900.
  • For current support status of Oracle Database 18c incl. Instant Client see SAP note 2660020.
  • For current support status of Oracle Database 12c Release 2 (12.2) incl. Instant Client see SAP note 2470660.
  • For current support status of Oracle Database 12c Release 1 (12.1) incl. Instant Client see SAP note 1914631.
  • For current support status of Oracle Database 11g Release 2 (11.2) incl. Instant Client see SAP Note 1431799.
  • For current support status of Oracle database releases that have been certified by SAP, see SAP Note 1174136.
  • For Oracle Database Roadmap in SAP NetWeaver environments, see SAP Note 2606828.

Oracle Reference: Oracle Support Document 742060.1 ("Release Schedule of Current Database Releases")

Release Support Status References (SAP)
19c SAP note 2799900 SAP Note 1174136
18c

SAP Note 2660020

 SAP Note 1174136
12.2.0.1

SAP Note 2470660

 SAP Note 1174136
12.1.0.2

SAP Note 1914631

 SAP Note 1174136
11.2.0.4

SAP Note 1431799

 SAP Note 1174136
SAP Note 2098258
10.2.0.5 LIMITED EXTENDED SUPPORT UNTIL JUNE 2015 SAP Note 1174136
SAP Note 1110995
SAP Note 1654734
10.2.0.4 and older NOT SUPPORTED SAP note 1339724

 

Oracle Instant Client Compatibility Matrix

The Oracle Instant Client interoperates with any database version that the full Oracle Client interoperates with.

Reference: Oracle Support Document 207303.1 (Client / Server Interoperability Support Matrix for Different Oracle Versions)

Replacing Oracle Instant Clients

  • Oracle Instant Clients of release 11.2 are downward compatible with Instant Clients of release 10.2. Therefore SAP Kernels that are linked with Oracle 10.2 (7.XX, 640_EX2) can use Instant Clients of release 11.2.0.X.
    Note that older SAPINST versions of release 6.40/7.00/7.01/7.02 do not allow/support to install Instant Client 11.2. You can replace Instant Client 10.2 by Instant Client 11.2 after the SAP installation.
  • When you replace the 10.2 instant client on the SAP application server with the 11.2 instant client you have to ensure that the software requirements for the new instant client version are met. Check the software requirements in the Database Client Installation Guide for your platform in the Oracle Database Documentation Library for Release 11.2.
  • For minimum SAP kernel version required with Instant Client 11.2 see SAP note 1331586. If you have an too old SAP kernel installed, you get 'ORA-24315: illegal attribute type'.

 

 

Downloading Oracle Instant Client Software

Download

You can download Oracle database software and patches for SAP environments from the 'SAP Software Download Center'.

Here's the direct link (URL ) for Oracle Patch and Software Downloads.

URLs for 'SAP Software Download Center'
https://support.sap.com/software.html -> Databases Access Downloads -> Database and Database Patches -> Oracle
https://launchpad.support.sap.com/#/softwarecenter  -> Databases -> Database and Database Patches -> Oracle
https://launchpad.support.sap.com/#/softwarecenter/database -> Database and Database Patches -> Oracle

Known Issues

Issue 2021-10-05:

SAP DVD 51055071 (release date 2021-09-20) cannot be used for installations with SWPM: 
SWPM fails with the following error: 
Data unit /sapcd/51055071_1/OCL_LINUX_X86_64 is not signed with an official SAP signature.
DETAILS: The found data unit must not be used.

Solution:
A new version of SAP DVD 51055071 has been released on 2021-10-06.

SAP DVDs with Oracle Client Software

The following Oracle Instant Client SAP DVDs are available:

Oracle Client Release Description Available SAP DVDs 
Oracle Client 19c Oracle Instant Client 19c software for SAP (SWDC)

SAP DVD 51057419

Instant Client 19c V5

 
Oracle Client 18c This version is not available for SAP. (not available)

Oracle Client 12.2.0.1

Oracle Instant Client 12.2.0.1 software for SAP (SWDC Download Link) is available for the following platforms:

  • AIX
  • HP-UX Itanium
  • Linux x86_64
  • Solaris SPARC
  • Solaris x86-64
  • MS Windows x64

DVD_51054433

Instant Client 12.2.0.1 V2 (V3 on Solaris SPARC)

Oracle Client 12.1.0.2

Oracle Instant Client 12.1.0.2 software for SAP (SWDC Download Link) is available for the following platforms:

  • AIX
  • HP-UX Itanium
  • Linux x86_64
  • Linux on Power Big Endian (64-bit) (*)
  • Solaris SPARC
  • Solaris x86-64
  • MS Windows x64

(*) SAP IC 12.1.0.2 is last supported version for Linux on Power Big Endian (64-bit)

DVD 51054219

Instant Client 12.1.0.2 (V5)
Oracle Client 11.2.0.4 (V5) (ES)

Oracle Instant Client 11.2.0.4 (V5) software for SAP (SWDC Download Link).

Note: This version requires Oracle Extended Support (ES). For more information see SAP Note 2717456.

DVD 51054174

Instant Client 11.2.0.4 (V5)

Oracle Client 11.2.0.4 (V4)

Oracle Instant Client 11.2.0.4 (V4) software.

Note: This version can be used without Oracle Extended Support.

Oracle Instant Client 11.2.0.4 (V4) software for SAP (SWDC Download Link) is available for the following platforms:

  • AIX
  • HP-UX Itanium
  • HP-UX PA RISC
  • Linux x86 (32-bit)
  • Linux x86_64
  • Linux on Power Big Endian (64-bit)
  • Solaris SPARC
  • Solaris x86-64
  • MS Windows (32-bit)
  • MS Windows x64

DVD 51052783

Instant Client 11.2.0.4 (V4)
Oracle Client 11.2.0.3

Oracle Instant Client 11.2.0.3 software for SAP (SWDC Download Link) is available for the following platforms:

  • AIX
  • HP-UX Itanium
  • HP-UX PA RISC
  • Linux x86 (32-bit)
  • Linux x86_64
  • Solaris SPARC
  • Solaris x86-64
  • MS Windows (32-bit)
  • MS Windows x64

DVD 51047747

Instant Client 11.2.0.3 (V2)
Oracle Client 11.2.0.2

Oracle Instant Client 11.2.0.2 software for SAP (SWDC Download Link) is available for the following platforms:

  • AIX
  • HP-UX Itanium
  • HP-UX PA RISC
  • Linux x86 (32-bit)
  • Linux x86_64
  • Solaris SPARC
  • Solaris x86-64
  • MS Windows (32-bit)
  • MS Windows x64

DVD 51042930

Instant Client 11.2.0.2 (V2)
ORACLE Client 10.2.0.5

The DVD contains the Oracle Instant Client 10.2.0.5 software for the following platforms:

  • AIX
  • HP-UX PA-RISC
  • HP-UX Itanium
  • Linux x86 (32-bit)
  • Linux Itanium (64-bit)
  • Linux x86_64
  • Linux on Power Big Endian (64-bit)
  • Solaris SPARC
  • Solaris x86-64
  • MS Windows (32-bit)
  • MS Windows Itanium (64-bit)
  • MS Windows x64

DVD 51042929

Instant Client 10.2.0.5 V3
Oracle Client V5 10.2.0.4

The DVD contains the Oracle Instant Client 10.2.0.4 V5 software for the following platforms:

  • AIX
  • HP-UX PA-RISC
  • HP-UX Itanium
  • Linux x86 (32-bit)
  • Linux Itanium (64-bit)
  • Linux x86_64
  • Linux on Power Big Endian (64-bit)
  • Solaris SPARC
  • Solaris x86-64
  • MS Windows (32-bit)
  • MS Windows Itanium (64-bit)
  • MS Windows x64

DVD 51039412

Instant Client 10.2.0.4 V5

Oracle Instant Client Packages for SAP

Instant client packages use the following naming conventions: OCL<RELEASE><WORDSIZE>.SAR

Note: if a new version is released, the package will be renamed to OCL<RELEASE><WORDSIZE>_<VERSION>.SAR

Release Wordsize IC Package
19c 64bit OCL1964.SAR
18c 64bit (not available)
12.2.0.1 64bit OCL12264.SAR
12.1.0.2 64bit OCL12164.SAR
11.2.0.X 64bit OCL11264.SAR
32bit OCL11232.SAR
10.2.0.X 64bit OCL10264.SAR
32bit OCL10232.SAR

 

 

Oracle Instant Client Standard Path and Symbolic Link (UNIX)

The standard path for the Oracle instant client in an SAP environment is documented in the following table:

Oracle Instant Client Release Standard Path Install Path / Installation Directory
19.X.0 /oracle/client/19/instantclient /oracle/client/19/instantclient_19000
18.X.0 (not available) (not available)
12.2.0.1 /oracle/client/122/instantclient /oracle/client/122/instantclient_12201
12.1.0.2 /oracle/client/12x/instantclient /oracle/client/12x/instantclient_12102
11.2.0.x /oracle/client/11x_<wordsize>/instantclient /oracle/client/11x_<wordsize>/instantclient_<release>
10.2.0.x /oracle/client/10x_<wordsize>/instantclient /oracle/client/10x_<wordsize>/instantclient_<release>

The instant client standard path is typically a symbolic link pointing to the instant client installation directory. <wordsize> is either '64' for 64-bit platforms or '32' for 32-bit platforms like Linux 32-bit.

Examples:

Oracle Instant Client Release Standard path -> Installation Directory
19.X.0

/oracle/client/19/instantclient -> instantclient_19000
18.X.0

(not available)
12.2.0.1

/oracle/client/122/instantclient -> instantclient_12201
12.1.0.2

/oracle/client/12x/instantclient -> instantclient_12102
11.2.0.x

/oracle/client/11x_64/instantclient -> instantclient_11204
/oracle/client/11x_64/instantclient -> instantclient_11203
/oracle/client/11x_64/instantclient -> instantclient_11202
10.2.0.5 /oracle/client/10x_64/instantclient -> instantclient_10205

During an SAP installation SAPINST/SWPM automatically installs the instant client as described above for all new installations based on the 7.00 kernel (and for 6.40-based installations on the IBM PPC platform).

Starting with Oracle release 10.2 it does not make any difference whether the SAP system is a central system (DB/CI) or only an application server. SAPINST installs the instant client in both cases. SAPINST furthermore installs the instant client on the database server, since this is a prerequisite for the BR*Tools version 7.00 to be started as the <sapsid>adm user.

In the following scenarios the Oracle Instant Client needs to be installed manually as described in the following section:

    1. The database was upgraded to Oracle 10.2 or newer.
    2. The PREPARE phase of the upgrade to release 7.00 has to be run.

Installing the Oracle Instant Client in an SAP Environment

Please keep the following in mind when manually installing or updating the Oracle Instant Client:

  • It is recommended to extract the instant client package following the defaults defined by SAP (see previous section).
  • NEVER extract or copy instant client packages to directories '$ORACLE_HOME/lib' or '$ORACLE_HOME/bin'.
  • The library search path ('LD_LIBRARY_PATH', 'SHLIB_PATH', 'LIBPATH') must refer to only one instant client directory. It must not contain more than one instant client directory or any Oracle Home directory ('$ORACLE_HOME/lib'), regardless of the order.
  • Under no circumstances set the environment variable ORA_NLS10 for the <sapsid>adm user.
  • Before you replace an instant client with a newer version, stop all your SAP systems, SAP application servers, and any other processes that use the instant client.
  • Never replace an instant client of an SAP system while the system is up and running!

Perform the following steps to install a new version of the Oracle Instant Client as user <sapsid>adm:

SAP IC Installation Steps Overview (Generic):

  1. Download Oracle Instant Client Software DVD from SAP Support Portal to <stage>
  2. Create directory for Oracle Instant Client
  3. Rename old Oracle Instant Client (if exists)
  4. Extract new Oracle Instant Client
  5. Configure Oracle Instant Client
  6. Update  user environment configuration files (.dbenv*, .sapenv*)
    Check and Update the path variable for dynamically linked libraries ('LD_LIBRARY_PATH', 'SHLIB_PATH', 'LIBPATH')

SAP IC Installation Steps for Instant Client 19.X.0:

OS> mkdir -p /oracle/client/19
OS> cd /oracle/client/19; SAPCAR -xvf <stage>/OCL1964.SAR
OS> ln -s /oracle/client/19/instantclient_19000 /oracle/client/19/instantclient

SAP IC Installation Steps for Instant Client 12.2.0.1:

OS> mkdir -p /oracle/client/122
OS> cd /oracle/client/122; SAPCAR -xvf <stage>/OCL12264.SAR
OS> ln -s /oracle/client/122/instantclient_12201 /oracle/client/122/instantclient

SAP IC Installation Steps for Instant Client 12.1.0.2:

OS> mkdir -p /oracle/client/12x
OS> cd /oracle/client/12x; SAPCAR -xvf <stage>/OCL12164.SAR
OS> ln -s /oracle/client/12x/instantclient_12102 /oracle/client/12x/instantclient

SAP IC Installation Steps for Instant Client 11.2.0.4 (64-bit):

OS> mkdir -p /oracle/client/11x_64
OS> cd /oracle/client/11x_64; SAPCAR -xvf <stage>/OCL11264.SAR
OS> ln -s /oracle/client/11x_64/instantclient_11204 /oracle/client/11x_64/instantclient

SAP IC Installation Steps for Instant Client 10.2.0.5 (64-bit):

OS> mkdir -p /oracle/client/10x_64
OS> cd /oracle/client/10x_64; SAPCAR -xvf <stage>/OCL10264.SAR
OS> ln -s /oracle/client/10x_64/instantclient_10205 /oracle/client/10x_64/instantclient

 

Additional steps for SAP Systems with ABAP Stack (SAP Kernel 7.xx)

Execute the following additional steps to check whether the SAP DBSL can load the newly installed instant client correctly.

Step 1: Change to the exe directory as user <sapsid>adm and run the ldd command on dboraslib.so:

OS> ldd dboraslib.so

Step 2: If this command succeeds, verify that the SAP system is able to connect to the database.

OS> R3trans -x

Step 3: Otherwise, if ldd cannot resolve all libraries, then verify the value of the library search path for the <sid>adm user. It should be set as shown in the following table.

Oracle Instant Client Release Library Search Path (LD_LIBRARY_PATH, LIBPATH) Remark
10.2.0.X /usr/sap/SID/SYS/exe/run:/oracle/client/10x_64/instantclient -
11.2.0.X /usr/sap/SID/SYS/exe/run:/oracle/client/11x_64/instantclient -
12.1.0.2 /usr/sap/SID/SYS/exe/run:/oracle/client/12x/instantclient -
12.2.0.1 /usr/sap/SID/SYS/exe/run:/oracle/client/122/instantclient -
18c /usr/sap/SID/SYS/exe/run:/oracle/client/18/instantclient (not available)
19c /usr/sap/SID/SYS/exe/run:/oracle/client/19/instantclient -

Table: Library Search Path for <sapsid>adm for Unix platforms

Additional steps for SAP Systems with Java Stack (SAP Kernel 7.xx)

Execute the following additional steps:

  1. Update all references from the J2EE engine to the JDBC driver jars such that they point to the JDBC driver in the instant client directory. This is described in detail in SAP note 867976.
  2. When you refer to the instant client location, you should always use the path with the symbolic link like '/oracle/client/10x_64/instantclient', '/oracle/client/11x_64/instantclient' or  '/oracle/client/12x/instantclient' to avoid the need to update these references when you install an instant client of a newer patch set release. Using the path with release information like '/oracle/client/<rel>_<wordsize>/instantclient_<release>' is therefore not recommended.

Configuring Oracle Instant Client for SAP BR*Tools 7.40

SAP BR*Tools Release 7.40 are based on Oracle Database Release 11.2 and therefore expect the Instant Client version 11.2 to be installed in '/oracle/client/11x_64/instantclient'. In order to use SAP BR*Tools 7.40 with an Instant Client version > 11.2 that is installed in the corresponding installation directory, you have to create an additional symbolic link so that BR*Tools can find this SAP instant client. With this symbolic link SAP BR*Tools are able to find and use an SAP IC of a higher version in '/oracle/client/11x_64/instantclient'.

This additional link is needed only on the database server where SAP BR*Tools are installed and only until SAP BR*Tools Release 7.40_EXT will be available which then will be based on a higher version of Oracle instant client. As soon as SAP BR*Tools Release 7.40_EXT are available, you can replace SAP BR*Tools 7.40 by SAP BR*Tools 7.40_EXT and remove the link again.

The following table shows the corresponding OS commands to create the additional symbolic link:

Oracle Client Release Command Remark
19.X.0 OS> ln -s /oracle/client/19   /oracle/client/11x_64 -
18.X.0 OS> ln -s /oracle/client/18   /oracle/client/11x_64 SAP IC 18c is not available.
12.2.0.1 OS> ln -s /oracle/client/122 /oracle/client/11x_64 -
12.1.0.2 OS> ln -s /oracle/client/12x /oracle/client/11x_64 -

 

Procedure to Use BR*Tools 7.40 with SAP IC 19

  1. Install SAP IC 19.
  2. Rename Oracle Instant Client 11.2, if installed
    OS> mv /oracle/client/11x_64 /oracle/client/11x_64.save
  3. Create symbolic link for SAP BR*Tools
    OS> ln -s /oracle/client/19 /oracle/client/11x_64

Procedure to Use BR*Tools 7.40 with SAP IC 18

SAP IC 18c is not available.

Procedure to Use BR*Tools 7.40 with SAP IC 12.2.0.1

  1. Install SAP IC 12.2.0.1.
  2. Rename Oracle Instant Client 11.2, if installed
    OS> mv /oracle/client/11x_64 /oracle/client/11x_64.save
  3. Create symbolic link for SAP BR*Tools
    OS> ln -s /oracle/client/122 /oracle/client/11x_64

Procedure to Use BR*Tools 7.40 with SAP IC 12.1.0.2

  1. Install SAP IC 12.1.0.2.
  2. Rename Oracle Instant Client 11.2, if installed
    OS> mv /oracle/client/11x_64 /oracle/client/11x_64.save
  3. Create symbolic link for SAP BR*Tools
    OS> ln -s /oracle/client/12x /oracle/client/11x_64

Procedure to Use BR*Tools 7.40 with SAP IC 11.2

  1. Install SAP IC 11.2. For details, see above.

 

Configuring Oracle Instant Client 11.2 for SAP BR*Tools 7.20

SAP BR*Tools Release 7.20 are based on release 10.2 and therefore expect the Oracle Instant Client to be installed in the default path for the 10.2 instant client '/oracle/client/10x_64/instantclient'. Therefore, in order to use the 11.2 instant client with SAP BR*Tools 7.20, (temporarily) create the following additional symbolic link:

OS> ln -s /oracle/client/11x_64 /oracle/client/10x_64

This link is needed only until SAP BR*Tools Release 7.20_EXT are available which then will be based on 11.2 instant client. As soon as SAP BR*Tools Release 7.20_EXT are available, you can replace SAP BR*Tools 7.20 by SAP BR*Tools 7.20_EXT and remove the link again.

For a more detailled description of dependencies between SAP BR*Tools and Oracle instant client versions see SAP note 1638356.

 

Verifying the Oracle Instant Client Version

There are several ways to determine which instant client version is installed and used by the SAP system.

Option Description
Using the genezi utility

Goto the instant client directory and run 'genezi -v':
OS> cd /oracle/client/11x_64/instantclient
OS> ./genezi -v

You should receive a version info like 'Client Shared Library 64-bit - 11.2.0.3.0'

If you receive an error like 'error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory', check your environment variable LD_LIBRARY_PATH (LIBPATH, SHLIB_PATH).
Checking the SAPIC_README

Starting with release 10.2.0.4, the Oracle Instant Clients released for SAP may be identified by a unique instant client version. The instant client packages built for SAP contain a readme file called SAPIC_README with the following information:

  • SAP Instant Client version
  • Oracle release
  • installed Oracle patches
  • build date
  • platform
Checking with SAP transaction SM51 As of SAP kernel 7.00, you find the instant client version in the 'SAP Release Information'. In SM51 (SAP Servers), click button 'Release Notes' and search for 'Database Client Library'.
Checking with SAP transction SM50 As of SAP kernel 7.00, you find the instant client version in all work process logs (SM50). Example: Oracle Client Version: '10.2.0.4.0'
As of SAP kernel 7.10, you find the instant client version in all work process logs (SM50) including client subversion Vn and all installed client patches. Example: Oracle Client Version: '10.2.0.4.0', V5

Please note that the instant client versions are not synchronized across platforms. In particular, instant clients with identical versions may contain different bug fixes on different platforms.

Sample output for 'genezi -v'
OS> cd /oracle/client/10x_64/instantclient
OS> ./genezi -v
Client Shared Library 64-bit - 10.2.0.4.0

System name:    Linux
Release:        2.6.32.12-0.7-default
Version:        #1 SMP 2010-05-20 11:14:20 +0200
Machine:        x86_64

Verifying the Oracle Client Operation Mode

With 'genezi -v' you check whether the instant client is running in 'instant client' mode or 'Oracle home' mode (Instant client release 11.2 or higher). The instant client must always operate in 'Instant Client' mode. If this is not the case, you should check whether the instant client is complete, whether the environment is correct and you should ensure that no other Oracle clients are installed in the library search path.

Sample Output for 'Instant Client Mode'

The instant client is operating in 'Instant Client' mode if the output is similar to the following example(s):

OS> cd /oracle/client/12x/instantclient
OS> ./genezi -v
Client Shared Library 64-bit - 12.1.0.2.0

System name: Linux
Release: 3.0.34-0.7-default
Version: #1 SMP Tue Jun 19 09:56:30 UTC 2012 (fbfc70c)
Machine: x86_64

Operating in Instant Client mode.
Small timezone file = timezone_18.dat
Large timezone file = timezlrg_18.dat
OS>

OS> cd /oracle/client/11x_64/instantclient
OS> ./genezi -v
Client Shared Library 64-bit - 11.2.0.2.0

System name:    Linux
Release:        2.6.32.12-0.7-default
Version:        #1 SMP 2010-05-20 11:14:20 +0200
Machine:        x86_64

Operating in Instant Client mode.
Small timezone file = timezone_14.dat
Large timezone file = timezlrg_14.dat
OS>

Sample Output for 'Oracle Home Mode'

In the following example the instant client is running in 'Oracle Home' mode:

OS> cd /oracle/client/11x_64/instantclient
OS> ./genezi -v
Client Shared Library 64-bit - 11.2.0.2.0

System name:    Linux
Release:        2.6.32.12-0.7-default
Version:        #1 SMP 2010-05-20 11:14:20 +0200
Machine:        x86_64

Operating in ORACLE_HOME environment.
Small timezone file = <ORACLE_HOME>/oracore/zoneinfo/timezone_14.dat
Large timezone file = <ORACLE_HOME>/oracore/zoneinfo/timezlrg_14.dat

OS>

If the data shared library libociei.so is not found, the instant client switches back to 'Oracle Home' mode.

Installing the Oracle Instant Client for Secondary Connections

If you manually install the Oracle Instant Client on a system to open secondary connections to an Oracle instance, you need to make sure that the Oracle Net Services files sqlnet.ora and tnsnames.ora both exist and that the environment variable TNS_ADMIN points to the directory location of these two files.

Oracle Instant Client in Failover-Cluster on Unix Platforms

Symptom:
On Unix platforms it can happen that the SAP application instance that runs on the database server does not reconnect after a failover of the database instance to another cluster node. The SAP kernel crashes when the Oracle instant client tries to reconnect.

Cause:
This can be Oracle Bug 14042380. This bug affects Oracle instant client versions 11.2.0.2/11.2.0.3.
Instant client uses file $ORACLE_HOME/rdbms/mesg/diaus.msb.

Prerequisites:

  • Oracle Instant client 11.2.0.x
  • Database Failover situation in a cluster environment
  • SAP instance running on the database server
  • ORACLE_HOME environment variable is set
  • ORACLE_HOME is moved during failover

Workaround:
Disable client-side diagnostic tracing by adding the following entry in $TNS_ADMIN/SQLNET.ORA:
DIAG_ADR_ENABLED=OFF

Solution:
This issue is fixed in SAP Instant Client 11.2.0.3 V2 and SAP Instant Client 11.2.0.4.

posted on 2025-01-10 16:11  BASIS/老应  阅读(221)  评论(0)    收藏  举报

导航