Oracle client during oracle upgrade

[former_member610738]

Hi

As we have upgrade our system from 10.2.0.4 to 11.2.0.3 and we have not upgraded our oracle client.

I have a small doubt about it.

Is that if we dnt upgrade our client.

Also during post upgrade activity , 1st point says changes you made to the Oracle user environment are permanently.

so iwas checking /oracle/GSP  -> ls -a-> dbenv.sh

one parameter is maintained as
set ADD=/oracle/client/10x_64/instantclient

Is it ok? to proceed. 

or need to edit it to something else

i hope this will not cause error...!

WR

Swati

[former_member206552 · Accepted solution]

Hi Swati,

if you want to keep the client for 10g for now then you need to leave the parameter, i have left it as this before and was able to complete all my activities,

kr

marius

[former_member610738 · Accepted solution]

Hi Marius

As suggested by deepak , i shuld extract oracle client 11g software into the given folder.

Just wanted to confirm , if you have also extracted oracle client 11g in /oracle/client/10x_64 or it worked w/o extracting also.

WR

Swati

[former_member188883 · Accepted solution]

Hi Swati,

I had done this for more than 30 systems. It works.

Regards,

Deepak Kori

[former_member206552 · Accepted solution]

Hi Swati,

sorry for the late reply,

yes deepak solution will work as i have also done it before

Keep the environment variable as /oracle/client/10x_64/instantclient. But extract Oracle 11g client into the folder /oracle/client/10x_64.

Post extraction re-link instantclient to 11g instantclient using the command

ln -sf instantclient /oracle/client/10x_64/instantclient

After doing this your oracle client is configured correctly. Do not keep Oracle 10g client as it might lead to some issues in future.

Best Regards

Marius

[Former Member]

Hi,

Please proceed as follows

Updating Oracle instant client

    1.As <sid>adm user Extract client file OCL11264.SAR to /oracle/client/11x_64

     >cd /oracle/client/11x_64

     > SAPCAR -xvf <location of OCL<11264>.SAR>

    2.>ln -s instantclient_11202 instantclient

    3.Maintain new Oracle client library path as per your OS flavor.

    4. Check if the SAP DBSL can load the newly installed instant client correctly

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

      >ldd dboraslib.so

Also do update br*(brtools) binary files using DBATOOLS.SAR otherwise your br*  execution will result unwanted error.

Thanks,

Amarnath.

[Reagan]

Hello

Have you checked this note :

Note 819829 - Oracle Instant Client Installation and Configuration on Unix

It clearly says what and how you should install Oracle instant client.

You need to create a new directory called /oracle/client/11x_64 and will put the extracted file (instantclient_11203) there and create a symbolic link.

All you need to change is to replace 0 with 1 in the environment files for the LIBPATH.

change /oracle/client/10x_64 to /oracle/client/11x_64

Cheers

RB

[former_member188883]

Hi Swati,

Keep the environment variable as /oracle/client/10x_64/instantclient. But extract Oracle 11g client into the folder /oracle/client/10x_64.

Post extraction re-link instantclient to 11g instantclient using the command

ln -sf instantclient /oracle/client/10x_64/instantclient

After doing this your oracle client is configured correctly. Do not keep Oracle 10g client as it might lead to some issues in future.

Regards,

Deepak Kori