bees
asked on
Identify the local Oracle Client version in a Windows machine
Hi,
I need to identify the version of the local oracle client in a Windows machine. The requirement is to get the Client version using a VB program and then do required database export only if the client version is the desired one.
The export utility is identified from the ORACLE_HOME\bin folder, but it is not possible to identify the version of the selected export utility.
The problem is that there is no standard product versioning info (using Windows version.dll) for Oracle exes.
It does not seem feasible to capture the log of SQLPlus or so to get the client version to get the client version.
Is there any environment setting for the Client version, any registry setting or any file that has the client details? Any file names that are maintained properly with version numbers across different versions of Oracle from 7 to 10g?
I need to identify the version of the local oracle client in a Windows machine. The requirement is to get the Client version using a VB program and then do required database export only if the client version is the desired one.
The export utility is identified from the ORACLE_HOME\bin folder, but it is not possible to identify the version of the selected export utility.
The problem is that there is no standard product versioning info (using Windows version.dll) for Oracle exes.
It does not seem feasible to capture the log of SQLPlus or so to get the client version to get the client version.
Is there any environment setting for the Client version, any registry setting or any file that has the client details? Any file names that are maintained properly with version numbers across different versions of Oracle from 7 to 10g?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
According to Oracle the best way to determine this is by running the Universal Installer and checking the Installed Products.
Another way, which may work, is to look in the C:\Program Files\Oracle\Inventory\Com
Of course, this implies that users are not smart enough th change the inventory location. I am not sure if it can be done in Windows, but it s pretty easy to do in the Unix world.