Update the Oracle Client form 10.2 to 11.2 under Linux Redhat

[ahmed_ibrahim2]

Update  the Oracle Client form 10.2 to 11.2 under Linux Redhat

As of   SAPINST versions of release 6.40/7.00/7.01/7.02 do not allow to install Instant Client 11.2. we have to replace Instant Client 10.2 by Instant Client 11.2 after the SAP installation , according to SAP recommendation 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

Use Oracle Instant Clients of release 11.2 if your database is running on Oracle Database Release 11.2.

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

accordingly we have to update all Oracle Client form 10.2 to 11.2 in mix environments ,and  because of that , i prepared the following Document and I hope it will be beneficiary for all

1 - Download the Required Oracle client version (11.2) from SMP

2 - Check the SAP Kernel Patch Level if the Level Less than 51 you should Update the Kernel

2a - To check the Kernel level , Logon to the system select Status from SYSTEM Menu

2b - Click  other Kernel Info

2c - Check sub package Level

Kernel Should Be Higher than 51

2d -  Stop SAP to Upgrade the Kernal

2e - Extract the New Kernel in /sapmnt/SID/exe

2f - Check the Kernel

SAP Kernel Update is done and SAP Kernel Level become higher than 51

Continue with Oracle client update

The default path for the installed instant client in an SAP environment is:

Instant Client Release 11.2:  /oracle/client/11x_<wordsize>/instantclient

3 - Extract the SAR File downloaded from SMP in to the following directory

/ORACLE /client

4 - Go to /oracle /Client/11x_64

Create Symbolic Link as following

5 - Edit the client Version in the following Profiles  (.dbenv_HOSTNAME.csh , .dbenv.csh) in /ORACLE/SID Directory  and .dbenv_HOSTNAME.csh in Oracle home Directory

Change 10x in the profile to 11x

Edit the profile

Change 10 to 11

Edit  the profile

Modify the client directory  to be

6 - Confirm that the New Oracle client is running OK

7 - Run the following command in Os Level

>> su  - <SID>adm

>> cd /oracle/client/11x_64/instantclient

>> ./genezi -v

8 - Check the Version of the running  Oracle client .

System >> Status >> moreinfo

Done

In the cluster environment there are additional 2 steps

Same modification should be done on the following two files (.dbenv_VhostNameforDB.csh , .dbenv_VhostNameforDB.csh)

And

Add the following parameter in the SQLNET.ORA file

DIAG_ADR_ENALBLED=OFF

In

$TNS_ADMIN/SQLNET.ORA

Make a test

Confirm that the New Oracle client is running by  Running  the following command in Os Level

correction by   reagan.benjamin Dec 7, 2013 3:56 PM

>> su  - <SID>adm

>> cd /oracle/client/11x_64/instantclient

>> ./genezi -v

Done

Reference SAP Note 819829

Best Regards

AhMeD IbRaHiM