cancel
Showing results for 
Search instead for 
Did you mean: 

Update instant client 10.2.0.4 to 11.2.0.3 HPUX

former_member204618
Active Contributor
0 Kudos

Hi All,

We would like to start using SUM (Software Update Manager 1.0 SP09) but according to the oracle additional information sap note (1843967) "Support for the Oracle db client 10.x terminated - use 11.2 instead"

So I have read SAP note 819829 - Oracle Instant Client Installation and Configuration on Unix version 71, but am little confused as to where the instant client should go. It seems to contradict itself by first saying 11.2.0.x /oracle/client/11x_<wordsize>/instantclient_<rel> with a symbolic link to instantclient

Then it gives the example /oracle/client/10x_64/instantclient -> instantclient_11203

Then in the section Perform the following steps for manually installing a new version of the Oracle Instant Client:

For 11.2.0.x

mkdir -p /oracle/client/11x_64 (if it doesn't exist already)

cd /oracle/client/11x_64

SAPCAR -xvf OCL11264.SAR

ln -s instantclient_11203 instantclient

So what is it I am supposed to do if I am running Oracle 10.2.0.4 and currently Instant Client 10.2.0.4?

Thanks

Craig

Accepted Solutions (1)

Accepted Solutions (1)

Reagan
Advisor
Advisor
0 Kudos

Hello

What is the version of Oracle database you use ?

If you have a 10G database then use 10G latest version of the Oracle instant client.

Here is what the SAP note 819829 says.


Choosing between Oracle Instant Client 10.2 and 11.2

  • 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.

Regards

RB

former_member204618
Active Contributor
0 Kudos

Hi Reagan,

I am using 10G but you can use a later version of the client libraries are per this section of that same note


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.

Thanks

Craig

Former Member
0 Kudos

Hi Craig

I suppose you can use the instant client 11.2 even when you have the oracle DB running in 10g version.

Thanks

Rishi

former_member204618
Active Contributor
0 Kudos

OK now that that is clarified, how to go about it?

Thanks

Craig

Former Member
0 Kudos

For 11.2.0.x

mkdir -p /oracle/client/11x_64 (if it doesn't exist already)

cd /oracle/client/11x_64

SAPCAR -xvf OCL11264.SAR

ln -s instantclient_11203 instantclient

This is what you need to do.

You will find /oracle/client/10x_64 for your current client (10G)

You have to have new folder 11x_64 in same directory to install the 11g client (mkdir -p /oracle/client/11x_64)

Download the file OCL11264.SAR, place it in newly created folder (/oracle/client/11x_64)

Extract the client (SAPCAR -xvf OCL11264.SAR)

Create a soft link to your instant client (ln -s instantclient_11203 instantclient)

Correct the environment variables (You should replace the client path of 10G with 11g) -  env command can give you the environment variables of user

Regards,

Nick Loy

former_member204618
Active Contributor
0 Kudos

Hi Nick,

I figured this is what was required but since the SAP note was a little vague I wanted to be sure.

So when I run env | grep oracle I get


SHLIB_PATH=/usr/sap/<SID>/SYS/exe/run:/oracle/client/10x_64/instantclient

So I need to replace /oracle/client/10x_64/instantclient with /oracle/client/11x_64/instantclient. 

Now presumably this is set in $HOME/.dbenv_`hostname`.csh or $HOME/.dbenv.csh or $HOME/.dbenv_`hostname`.sh or $HOME/.dbenv.sh

Are these the only places I need to change this assignment?

Thanks again.

Craig

Former Member
0 Kudos

You are absolutely right Craig.

As an additional check, check all the profiles and ensure that old client path is replaced with new one.

Regards,

Nick Loy

former_member204618
Active Contributor
0 Kudos

Thanks Nick much appreciated.

Cheers

Craig

Answers (0)