How do I check the oracle client version?

[Former Member]

Hi All,

How do I check the oracle client version installed from the OS level. I do know my database version I need to check which client is being used. Is there a table where this information is stored.

Thanks

Shabna

[Former Member · Accepted solution]

Hi,

same was alredy discussed in the SAP WEB as general

you can find in st04-> detailed analysis menu->display V$ values->V$VERSION

Samrat

[Former Member · Accepted solution]

Hello,

That is not correct.

The oracle client does not have to match the RDBMS version.

For example, Kernel 4.6D_EXT is linked against (uses) oracle client 9.2 but you could be using oracle 10g ( V$version will tell you that you are using 10.2.0.2, for example )

The note 521230 FAQ: Client software 9i or earlier on UNIX gives you an explanation and a list of what oracle client uses what kernel.

Currently, 46D_EXT and 6.40 needs 9.2 client and 700 uses 10 instantclient.

For 10g instant client is possible to know the exact version at OS level, you have to use genezi ( check note 819829 )

For 9.2, there is no such utility, therefore you will have to check the date and size and compare it with the ones delivered by SAP.

[Former Member]

I had similar issues where I needed to verify the running Oracle client version for an open SAP message and found that the following steps seem to verify the running Oracle client all the other steps seem to only display the RDBMS version.

Checking the Oracle client version using the UNIX (HP-UX) command line tool ldd

1. Logon to UNIX using <SID>adm

2. cdexe

3. ldd dboraslib.so

libnsl.so.1 => /usr/lib/hpux64/libnsl.so.1

libpthread.so.1 => /usr/lib/hpux64/libpthread.so.1

libclntsh.so.9.0 => /oracle/client/9208/lib/libclntsh.so.9.0

libwtc9.so => /oracle/client/9208/lib/libwtc9.so

libc.so.1 => /usr/lib/hpux64/libc.so.1

libxti.so.1 => /usr/lib/hpux64/libxti.so.1

libwtc9.so => /oracle/client/9208/lib/libwtc9.so

librt.so.1 => /usr/lib/hpux64/librt.so.1

libnss_dns.so.1 => /usr/lib/hpux64/libnss_dns.so.1

libdl.so.1 => /usr/lib/hpux64/libdl.so.1

libm.so.1 => /usr/lib/hpux64/libm.so.1

libpthread.so.1 => /usr/lib/hpux64/libpthread.so.1

libunwind.so.1 => /usr/lib/hpux64/libunwind.so.1

libuca.so.1 => /usr/lib/hpux64/libuca.so.1

[Former Member]

THanks! It helped me a lot too.

But I executed in other way,

ldd dboraslib.sl

libnsl.1 => /usr/lib/pa20_64/libnsl.1

libpthread.1 => /usr/lib/pa20_64/libpthread.1

libclntsh.sl.10.1 => /oracle/YR2/102_64/lib/libclntsh.sl.10.1

libnnz10.sl => /oracle/YR2/102_64/lib/libnnz10.sl

libCsup.2 => /usr/lib/pa20_64/libCsup.2

libc.2 => /usr/lib/pa20_64/libc.2

libxti.2 => /usr/lib/pa20_64/libxti.2

libnnz10.sl => /oracle/YR2/102_64/lib/libnnz10.sl

librt.2 => /lib/pa20_64/librt.2

libpthread.1 => /lib/pa20_64/libpthread.1

libnss_dns.1 => /lib/pa20_64/libnss_dns.1

libdl.1 => /lib/pa20_64/libdl.1

libnsl.1 => /lib/pa20_64/libnsl.1

libm.2 => /lib/pa20_64/libm.2

libc.2 => /lib/pa20_64/libc.2

libcl.2 => /lib/pa20_64/libcl.2

libdl.1 => /usr/lib/pa20_64/libdl.1

libdl.1 => /usr/lib/pa20_64/libdl.1

[Former Member]

Hi All,

Best way to check the oracle client version is as follow:

1) Go to Path :  /oracle/client/10x_64

in case of oracle 10g, you will fine 10x_64 or 11x_64 directory for 11g

then you will find the file named instantclient with complete version.

% pwd

/oracle/client/10x_64

drwxrwxrwx   2 <SID>adm   sapsys      8192 Oct  8  2009 instantclient_10202

This shows the complete version of installed oracle client.

You can also verify the same from SAP menu:

System -> Status -> Other Kernel info. (Shift+F5) --> Database information

you will see the DB Client lib. (OCI_102, 10.2.0.2.0).

Thank you,

Sudhir Kumar

[Former Member]

Thanks All for all your replies, the only conclusion from all this discussion is there is no direct way of finding out which client, rather to look up where from the library is read. Therefore, since my library path variable is pointing to the 9.2.0.7 client that is the client.

And V$VERSION table gives the database version and any of the other ways like disp+work, sm51, st02 all give the database versions.

I am sure about this because I have verified this with a system which 10.2.0.2 using 9.2.0.7 client.

Thanks a bunch

[Former Member]

> And V$VERSION table gives the database version and

> any of the other ways like disp+work, sm51, st02 all

> give the database versions.

no, SM51 and disp+work will show you the make environment which will at least on unix reflect the Oracle Client used. The number in brackets is the information the Oracle Client Library will provide if at least 10.2.

peter

[Former Member]

Hi Shabnam,

Simply go to:

1- Start / cmd

2- log on to oracle

3- Execute the command: select banner from V$version;

Regards,

Lachker

[Former Member]

disp+work.exe -V will tell you which OCI version was used during compiling and linking.

Oracle uses release independent DLL Names (Unix people would say Shared Libraries) and therefore the SAP Kernel will dynamically load any Oracle Client Version found in the standard DLL Load Path during startup.

If you have more versions installed on your computer and you are not shure which one is loaded you can use Process Explorer (freeware, see www.sysinternals.com) to find out which one is loaded. If they belong to an Oracle_home (up to release 9.2) refere to Oracle Universal Installers Inventory information in order to find out which exact version is used.

If an Oracle10 Instant Client is used, there is no corresponding Oracle_Home. In this case you can use Windows Explorer (right click on the DLL -for example oci.dll), select properties, the Version Tab and File Version).

But unfortunately Oracle is not updating the File Version every time they are patching something.

An SAP ABAP Server Integrated Resource is the version information disp+work.exe -V is listing (evquivalent to SM51 - Release Information).

<b>Datenbank Client Library : OCI_10201_SHARE (10.2.0.2.0)</b>

OCI_10201_SHARE is telling us the compile/link environment, the number in brackets (only available starting with Oracle10) tells us the the result of an Oracle Client GetVersion call. Unfortunately this one does also not reflect the installed Minipatch version up to now.

Here are some results on 10.2.0.2 Windows X86_64:

SM51: Datenbank Client Library : OCI_10201_SHARE (10.2.0.2.0)

Explorer (OCI.DLL located in the same directory as disp+work.exe):

10.2.0.2.0 Patch2

Explorer (oraociicus10.dll - the instant client implementation, this version is the one actual since mini patch 10.2.0.2.5 and it was definitely changed in 10.2.0.2.5):

OraOCIICUS10.dll - 10.2.0.1.0

oracore10.dll - 10.2.0.1.0 Production

oranls10.dll - 10.2.0.1.0 Production

orasnls10.dll - 10.2.0.1.0 Production

oraunls10.dll - 10.2.0.1.0 Production

oravsn10.dll - 10.2.0.1.0 Production

oracommon10.dll - 10.2.0.1.0 Patch1

orageneric10.dll - 10.2.0.2.0 Patch2

oraclient10.dll - 10.2.0.2.0 Patch2

orapls10.dll - 10.2.0.1.0 Patch1

orasql10.dll - 10.2.0.1.0 Production

oraxml10.dll - 10.1.0.2.0

orahasgen10.dll - 10.2.0.1.0 Production

oraocrutl10.dll - 10.2.0.1.0 Production

oraocr10.dll - 10.2.0.1.0 Production

oraocrb10.dll - 10.2.0.1.0 Production

oranbeq10.dll - 10.2.0.1.0 Production

orantcp10.dll - 10.2.0.1.0 Production

oracommon10.dll from the rdbms server does report 10.2.0.2.0 Patch5 at the same time. compare it with the version information of oracommon10.dll included in oraociicus10.dll. Both patches are included in the same patchset (10.2.0.2.5).

there are two possible conclusions about this:

1. the version infomation is not very reliable.

2. the Oracle Patch and Build environment is not very reliable

Peter

[Former Member]

Hello,

I know that the "client" is a confusing "issue", so I could be mistaken about what it is really asked.

I understand the question as what oracle client version the SAP kernel is using.

I mentioned before that the SAP kernel can be using ( and this was very usual on older releases ) a different version than the RDBMS version.

For that reason, V$VERSION will not provide us with the client version that is used by SAP.

Same can be said about sqlplus -version

Waqas Ahmad points you to one place where you can see the Oracle Client that the kernel was linked against.

Same information can be found in SM51 -> Release Notes

or doing

disp+work -V | more

Now the "game" began if you want to know the EXACT version that is being used, as, for example, SAP indicate that you MUST install 9.2.0.7 if you want to use 4.6C_EXT or 6.40 with Oracle 10g.

It is not possible to know the version of the client 9i, this means that you have to take a look at the date ( size ) and if it is a bit old, install 9.2.0.7 patch available in SAP Service Marketplace.

Before Oracle 10, there is no "real" posibility of running a program that tells you the exact version ( as in version.release.AS.patchset ) of the oracle client used by SAP.

I'm not entering discussing older kernels, where SAP was linked agains oracle 80x but it was possible to use 8.1 client as they were compatible.

[Former Member]

Hi

You can check client version by running sqlplus -version from client machine.

When u install client it will create some log and xml files.Through those files also you can find your client version.

Regards

vinod

[Former Member]

Hii,

You can check it on System-->Status menu option. and then by clicking "Other kernel info" button next to "Navigate" button.

See in database information and check your db releases.

Regards

Waqas