Oracle client 9.2 complete version information

[valeriocicchiel]

Hi community,

how can I detect the complete version informations of of an Oracle client 9.2 ?

I can have information of the 9.2 version from the directory naming conventions (that is 92x_64) but I need to know the complete version of the client installed in that directory

Thanks to everybody who will reply,

Valerio

[stefan_koehler · Accepted solution]

Hello Valerio,

as Lars said .. there is no official way to determine the exact oracle client version (except the exhausting way to compare the file sizes, etc.)

But here is a dirty hack .. that works too.

shell> strings /oracle/client/92x_32/lib/libclntsh.a | grep "XML Schema Processor version"

Regards

Stefan

[Former Member]

Hello All,

you can find via T-code - ST04-----click on detail analysis menu -

---

display V$ values-----find V$VERSION - double click on that ---

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi

PL/SQL Release 10.2.0.2.0 - Production

CORE#10.2.0.2.0#Production

TNS for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Productio

NLSRTL Version 10.2.0.2.0 - Production

you are able to see whole information about your database !

Thanks & Regards

Shishir Bajpai

[Former Member]

Hi,

We can see the cleint complete version from SAP.

goto system --- > status ---> click on arrow mark at the bottom .. you can find the oracle client version in the Database information.

Thanks,

Phani.

[markus_doehr2]

> you are able to see whole information about your database !

Just to add: the question was not the database version but the Oracle client that is actually used (see subject).

Markus

[fidel_vales]

Hello Phani,

Unfortunately that is not correct

There you can find the Oracle client the kernel is linked to and the API version. For example. In my "old testy" 46C system with a plain 46D kernel I can see:

OCI_920__OCI_7_API

and that give me no information about the real oracle client being used.

Kernels linked against 10g provide the client information:

OCI_102 (10.2.0.2.0)

Added:

I tried the "hack" from Stefan and it works in Oracle 9 client.

> strings /oracle/client/92x_64/lib/libclntsh.so| grep "XML Schema Processor version"

Oracle XML Schema Processor version 9.2.0.6.0 Production

good, because I thought I had tested it and failed.

Edited by: Fidel Vales on Apr 21, 2009 7:04 PM

[Former Member]

Hi

The dirty hack command is successfully on Linux enivronment,Unfortunately on Unix its not wokring.

Please suggest

sam

[markus_doehr2]

> The dirty hack command is successfully on Linux enivronment,Unfortunately on Unix its not wokring.

What "Unix" are you referring to?

Markus

[Former Member]

Hi

My Unix version is - HP-UX B.11.23 U ia64

Kernel - 640 (64 Bit) Unicode system.

Regards

sam

[markus_doehr2]

Ok.

So can you check if the trace file dev_w0 shows you enough information?

Markus

[Former Member]

HI

I have checked dev_w0 trace files in usr/sap/SID/DV*/work directory for Kernel 640 release,but unable to find the Oracle client version.

How can version will be found for Kernel 640?

Where as in Kernel 700 release I am able to see Oracle Client full version in dev_w0 trace files.

Regards

sam

[fidel_vales]

The dirty trick works on some *nix versions.

I tried Solaris and it worked there. I tried in others and it does not work (do not ask for the "others" I do not remember)

AFAIK, the client version does not appear on any dev_* file (unless you use a kernel that uses 10g client)

for kernel 640, as there is no reliable method you have to do as Lars mentioned before (check sizes and dates) or, if you have some downtime, replace it with the last one. Then you will know which one is installed.

for kernel 700 (not to be installed in any 6* basis) you find the information when the connection to the DB is established.

[markus_doehr2]

You can also check the dev_w* traces, at least you will find there a version as e. g. 9.2.0.8.

Markus

[valeriocicchiel]

It seems that the dirty hack works fine...

Thanks everybody for your support

Regards,

Valerio

[former_member204746]

run sqlplus from your client directory,. the first oracle version you get is the Oracle client version.

[lbreddemann]

Unfortunately this won't help on the SAP application servers since there is no sqlplus installed.

Actually there is no way to exactly find out the client software version.

All you can do is to compare the file sizes & dates with the ones from a known client software package (like the ones you download from service marketplace).

If the files on your machine are older than those in the package, you may want to install the newer ones.

regards,

Lars