on 01-26-2014 8:34 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.