Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
Solved
Identify the local Oracle Client version in a Windows machine
Posted on 2004-10-04
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?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3 Comments
Active today
I believe that with the introduction of the Universal Installer, this is nearly impossible.
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.
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.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Working with Network Access Control Lists in Oracle 11g (part 1)
Part 2: http://www.e-e.com/A_9074.html
So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Configuring and using Oracle Database Gateway for ODBC
Introduction
First, a brief summary of what a Database Gateway is. A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows syntax for various backup options while discussing how the different basic backup types work. It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses
Course of the Month14 days, 2 hours left to enroll
656 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.