programmatically determine Oracle Home installed version?

Question

I need to determine from a program what version of Oracle is installed in each of the Oracle Homes on a server. As there may not be any databases created in the Home yet, I need to be able to do this outside of the database (i.e., without connecting to the database). Also, it would be highly preferable to be able to do this from a remote program.

This is from a windows program running .Net (C#, if that matters).

I am currently reading remote registry keys (using this technique: How to Read Remote Registry Keys?), to find all of the Oracle Homes according to this method. This works fine, however, I have looked around those keys and do not see any information on the exact version/release.

The name of an Oracle Home itself is of course 1) not a reliable indicator and 2) does not have the exact version/release (for instance "10.2.0.4.0"). Basically I am looking for a way to figure out what the Oracle Universal Installer tells you in the Installed Products button.

Wernfried Domscheit · Answer 1 · 2016-02-25T06:32:19.510

3

Search for file oci.dll in PATH, this is one of the major files of an Oracle Client installation. You can read version of this file with FileVersionInfo.GetVersionInfo("oci.dll");

In order the get the Registry Hive, search for file oracle.reg in PATH (i.e. Oracle Home). This file is a simple text file containing the Registry key, for example SOFTWARE\ORACLE\KEY_OraClient11g_home1. You will find related registry values in HK_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient11g_home1 `

edited Feb 25 '16 at 06:32

answered Feb 24 '16 at 18:16

Wernfried Domscheit

54,457
9
76
110

Do you mean in `ORACLE_Home\bin`? – RBarryYoung Feb 24 '16 at 18:34
I just checked and this does not match what Universal Installer says. Example: Ora10g home has 10.2.0.1.0 installed and applied patch set 3 so that the resulting version is 10.2.0.4.0. However, OCI.DLL FileVersion property says "10.2.0.1.0". – RBarryYoung Feb 24 '16 at 18:41
Yes, there you will find it. – Wernfried Domscheit Feb 24 '16 at 18:41
Are you really interested in the Patch level? Usually mayor and minor version (e.g. 10.2) should be sufficient. – Wernfried Domscheit Feb 24 '16 at 18:43
Yes, I really do need it. It's the kind of thing that we frequently have to check for product compatibility issues when planning. – RBarryYoung Feb 24 '16 at 18:58

score 0 · Answer 2 · answered Feb 24 '16 at 20:49

0

I don't be exact, but i think you should try to look into v$parameter system view.

answered Feb 24 '16 at 20:49

Dart XKey

54
3

How would I look at that for a Home without a database? That's what I am asking for... – RBarryYoung Feb 24 '16 at 20:58

psaraj12 · Answer 3 · 2020-05-05T16:51:31.610

0

You can go to the oracle home path given in the registry and try to execute below command in the command prompt if the home is in Windows

    $ORACLE_HOME\OPatch\opatch lsinventory | find "Oracle Database"

edited May 05 '20 at 16:51

answered May 05 '20 at 16:05

psaraj12

4,772
2
21
30

programmatically determine Oracle Home installed version?

3 Answers3