Oracle client upgrade on SAP

Hi,

This document expains the step by step procedure to upgrade oracle client on SAP.

Platform:

Source

OS- AIX 7.1

Oracle client- 10.

Target

ORACLE Client- 11.2.0.4 V3

Media Used- 51049326 for ORACLE Client 11.2.0.4 V3

1. create a   dir 11x_64 in /oracle/client

os> mkdir -p /oracle/client/11x_64

2. dump the oracle client software to this new direcotry(only keep the directory name with ‘instantclient_11204’ in this new dir.)

change the permission of ‘instantclient_11204’ to sidadm:sapsys

3. creating soft link for this new client

os> cd /oracle/client/11x_64

os> ln -s /oracle/client/11x_64/instantclient_11204 instantclient

4. Change the entries of all env files under home dir(/home/sidadm). in these env files we have to replace the value of old client (10x_64) to new client(11x_64).

the files where change is required are:(1).dbenv_hostname.sh (2).dbenv_hostname.csh (3).dbenv.sh (4).dbenv.csh

5. check whether 11x has been reflected in the whole env files:

sidadm> env | grep 11x(it must give some output)

sidadm> env | grep 10x(output must be blank)

6. check whether soft link created or not?

go to this directory->

/oracle/client/11x_64

ls -lrt

total 8

drwxrwxrwx    2 sidadm   sapsys         4096 Dec 25 16:15 instantclient_11204

lrwxrwxrwx    1 root     system           41 Dec 25 16:18 instantclient -> /oracle/client/11x_64/instantclient_11204

**the output must be like this

7. check the version of current soft link client

sidadm> cd /oracle/client/11x_64/instantclient_11204

sidadm> ./genezi -v

Client Shared Library 64-bit – 11.2.0.4.0