Detect all Oracle versions installed

oracle command-line version detect

35,514

Solution 1

Simplest method is to run command prompt and type sqlplus it will show you the oracle version without actually logging into it.

Example: Run -> cmd

C:\Users\xyz>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 1 16:46:40 2014

Enter user-name:

Solution 2

You'll want to query the Oracle Inventory.

For every Oracle installation, there is an entry in the "Oracle inventory". By default, the Oracle inventory is located under "C:\Program Files\Oracle\Inventory". However, this location can be changed.

In the Registry, the location of the Oracle inventory is in "HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE", where you'll find the key "inst_loc". There, you'll find an XML file containing all installed versions (inventory.xml). See the Oracle documentation for an example.

Solution 3

Go here and open with Notepad:

C:\Program Files (x86)\Oracle\Inventory\ContentsXML
C:\Program Files\Oracle\Inventory\ContentsXML

Open File: inventory.xml

<?xml version="1.0" standalone="yes" ?>
<!-- Copyright (c) 1999, 2006, Oracle. All rights reserved. -->
<!-- Do not modify the contents of this file by hand. -->
<INVENTORY>
<VERSION_INFO>
   <SAVED_WITH>11.1.0.6.0</SAVED_WITH>
   <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME="OraClient11g_home1" LOC="D:\Oracle\product\11.1.0\client_1" TYPE="O" IDX="1"/>
</HOME_LIST>
</INVENTORY>

35,514

Author by

Epligam

Updated on July 09, 2022

Comments

Epligam almost 2 years

How can I check all oracle versions and platforms that installed on windows machine from a command line or byscript ? Till now I was using tnsping and check for the output but it only show the first version according to the path environment variable. Is there a way to get this info from the registry and without actually connect to DB ?