Oracle Client OCI_102

[former_member233385]

Hi Basis Expert,

Recently we did oracle client (OCL11264.SAR) update for 11g database (11.2.0.2).

After updating the Oracle Client in System->Status->Database information it is showing as OCI_102 , 11.2.0.2 V1, default.

Please find the screen shot below

Also we checked LD_LIBRARY_PATH and it is pointing to 11x_64 instantclient

LD_LIBRARY_PATH=/usr/sap/SID/SYS/exe/run:/usr/sap/SID/SYS/exe/uc/sun_64:/oracle/client/11x_64/instantclient

From OS level we executed genezi -v and below is the result

:sidadm 38% genezi -v

Client Shared Library 64-bit - 11.2.0.2.0

System name:    SunOS

Release:  5.10

Version: Generic_147440-26

Machine:sun4u

Operating in Instant Client mode.

Small timezone file = timezone_14.dat

Large timezone file = timezlrg_14.dat

We would like to know why in System->Status it is still reflecting as OCI_102 even after updating the client (11.2.0.2).

Appreciate your input.

Regards,

Anil Shenoy

[Former Member]

Don't worry, it's all ok. Your kernel is linked against DBMS client library OCI_102, therefore your kernel is using calls of version 10. That you see in your screen OCI_102, but instantclient versiob 11.2.0.2.

[shashisingh]

Hi,

I also faced the same issue, it was  due to the missing symbolic link.Please create a link and take a restart of SAP.

cd $ORACLE_HOME/lib

ln –s libnnz11.so libnnz10.so ( AIX/ Liunx/Solaris)

ln –s libnnz11.sl libnnz10.sl ( HPUX)

Thanks,

Shashi

[former_member188883]

Hi Anil,

Hope your issue is resolved.

Regards,

Deepak Kori

[Former Member]

Hi Anil,

Please execute R3trans -d and attach the trans.log for  more analysis.

Thanks and Regards,

Vimal

[Former Member]

As well as please ensure that you have updated the oracle client as per the below note.

Note 819829 - Oracle Instant Client Installation and Configuration on Unix

Thanks and Regards,

Vimal

[former_member188883]

Hi Anil,

Please check whether following symbolic links have been maintained.

cd $ORACLE_HOME/lib

ln –s libnnz11.so libnnz10.so ( AIX/ Liunx/Solaris)

ln –s libnnz11.sl libnnz10.sl ( HPUX)

After the client updated have you taken SAP restart ?

Regards,

Deepak Kori