Oracle Client version

[Former Member]

How can I find current oracle client version ? We are using oracle 10.2.0.2 with client 9.2 . I need to know exact version with patch level of the client.

Please help

[Former Member]

Hi

This can be done by just executing tnsping and piping the output to a file and parsing that file for the version info. tnsping will get installed with each client install regardless of the install options choosen and itu2019s version is the same as the Oracle client dll versions. So this is what we can do:

Have a text file dynamically created with the version banner in it:

a. create a batch file called version.bat

b. put 1 line in test.bat:

tnsping > version.txt

c. execute version.bat

d. version.txt will have your version string in it

In the event of multiple Oracle homes, the one that is set as the default is the one that will be shown in this version information.

Thanks

Bharathi.Ch

[fidel_vales]

Hi,

That is NOT valid for SAP installations.

The client delivered by SAP is a reduced version of the client with "few" files. and it does not contain the tnsping.

[Former Member]

... and it is stolen from http://decipherinfosys.wordpress.com/2007/02/10/checking-for-oracle-client-version-on-windows/

[Former Member]

Bharathi,

You have been reported before for copy&pasting other peoples work (in this case containing incorrect information...) and points-gaming with clone ID's to cheat the points system.

Your various user ID's will be deleted and you will loose all your points.

Julius

[matt]

He's already lost the points on this id...!