[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

How do I verify the Oracle ODBC driver version?

Posted on 2013-11-08
6
Medium Priority
?
628 Views
Last Modified: 2013-11-08
Hi,

I am having an issue with an ODBC driver, and I am trying to determine what version the Oracle ODBC driver is. I asked the tech person to install a patch to get it to v10.2.03, but when I go to the driver, and click on help, it is still saying that it is version 10.1.0.2.0 on the top ribbon. Is there another location that I can verify that this patch has been installed, and see the true version of the driver?

Thanks,

Brian
0
Comment
Question by:Whah
  • 3
  • 3
6 Comments
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 39634456
Yes, in "Windows Explorer" (or "My Computer", not: "Internet Explorer") navigate to your "Oracle_home" folder, then go to the "\inventory\ContentsXML" directory under that and open the "comps.xml" file with Word or a text editor and do a search for "VER" (in upper case).  That will show you the version of the Oracle software that you have installed.

If you don't know where your "Oracle_home" directory is, run "regedit", and go to: "HkeyLocalMachine, Software, Oracle".  Look for keys like: "Home0", "Home1", etc. or: "Key_Ora10g..." and look at the value for "ORACLE_HOME".  That should indicate a physical disk location like "C:\..." or possibly a directory on a network drive that you have access to.
0
 

Author Comment

by:Whah
ID: 39634529
Thank you, Mark. So simply the oracle client version will be the version of the ODBC driver as well. It appears in the screen shot that the v10.0.2.0.3 patch was not installed correctly/successfully if it is still showing client version 10.2.0.1.0. Correct?

Oracle version
0
 
LVL 35

Accepted Solution

by:
Mark Geerlings earned 2000 total points
ID: 39634619
That's what it looks like to me.  I admit that I haven't looked in this file very often to confirm a version number after applying a patch, but I would expect the latest patch version number to be reflected here.

Another option would be to start the Oracle installer (that got installed somewhere in your Oracle_home when your oracle software was installed) and have it display the version(s) of Oracle software that are installed.  The Oracle installer can do that without changing anything.  You may have an icon for the Oracle installer somewhere in your Start menu.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 

Author Comment

by:Whah
ID: 39634742
Ok, thanks again. I see a "Universal Installer." Would that be the one?
0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 39634825
Yes.  If you launch that, it should give you the option to see what version(s) you have installed now.
0
 

Author Closing Comment

by:Whah
ID: 39634890
Thank you, Mark. I really appreciate your help.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question