Thursday, April 9, 2009

How to Verify Oracle Client Version

I had an ORA-600 error occur on a production SAP BW 3.5/Oracle this week. During the investigation with SAP support I was asked to confirm that I was running Oracle client 9208 or above.

Now that seemed pretty straight forward enough however when I actually went to verify it and show the information to the SAP support personnel I was stuck. How do I verify the client? I know that I can verify the Oracle version using a number of different methods such as : -

Using SQL Plus
1. Logon to UNIX using ora account
2. sqlplus “/ as sysdba”
3. select version from v$instance;

Using OPatch
1. Logon to UNIX using ora account
2. cd $ORACLE_HOME/OPatch
3. opatch lsinventory

But this only verifies the database version not the Oracle client. After checking the SAP SDN forums and of course the official SAP knowledge base I was still stuck until I came across the following command which SAP support seem to accept: -

Checking the Oracle client version using the UNIX command line tool ldd
1. Logon to UNIX using adm
2. cdexe
3. ldd => /usr/lib/hpux64/ => /usr/lib/hpux64/ => /oracle/client/9208/lib/ => /oracle/client/9208/lib/ => /usr/lib/hpux64/ => /usr/lib/hpux64/ => /oracle/client/9208/lib/ => /usr/lib/hpux64/ => /usr/lib/hpux64/ => /usr/lib/hpux64/ => /usr/lib/hpux64/ => /usr/lib/hpux64/ => /usr/lib/hpux64/ => /usr/lib/hpux64/

No comments: