Re: Oracle versioning discovery

desertflowerln_at_yahoo.com (Alan) writes:

> Does anyone know a reliable way to find out 1) whether a Oracle
> version is installed and 2) if so, what version (x.x.x at least,
> ideally x.x.x.x.x) of Oracle is installed? This is on the Windows
> platform. If there are multiple Oracle Homes, I want to find out all
> the versions of each home.
> Is there a Windows tool/utility to check this? Just right click on the
> oracle.exe and look at the version tab, it doesn't tell you that. The
> only exception is v9204. Maybe Oracle is moving to that direction. But
> I need to discover all the v7.x.x and v8.0.x and v8.1.x etc. The
> registry doesn't tell you what version it is either.

You can look under metalink for OPatch. OPatch provides a perl script with that you can list the available versions of the installed products. E.g.

Harald

,----
| $ perl opatch lsinventory
| PERL5LIB=/O2/oracle/9.2.0/Apache/perl/lib/5.00503; export PERL5LIB
| /O2/oracle/9.2.0/Apache/perl/bin/perl ./opatch.pl lsinventory
| Using oraInst.loc to look up oui libs...
|
| Parsing /O2/oracle/oraInventory/ContentsXML/comps.xml
|
| Found "oracle.swd.oui" version "2.2.0.18.0"
| on "/O2/oracle/oui"
|
| Found JRE version "1.3.1.0.0"
| on "/O2/oracle/jre/1.3.1/bin/java"
|
| Oracle Home = /O2/oracle/9.2.0
| inventory_location = /O2/oracle/oraInventory
| liboraInstaller_lib= /O2/oracle/oui/bin/linux/liboraInstaller.so
| path_to_java = /O2/oracle/jre/1.3.1/bin/java
| path_to_oI_loc = /etc/oraInst.loc
| oui_component_loc = /O2/oracle/oui
| required_jar_file under oui = lib/OraInstaller.jar
|
| Retrieving inventory.
|
| PRODUCT NAME VERSION
| ============ =======
| Advanced Queueing (AQ) API 9.2.0.1.0
| Advanced Queueing (AQ) API Patch 9.2.0.4.0
| Advanced Replication 9.2.0.1.0
| Advanced Replication Patch 9.2.0.4.0
| Agent Required Support Files 9.2.0.1.0
| Agent Required Support Files Patch 9.2.0.4.0
| Apache Configuration for Oracle Java Server Pages 1.1.2.3.0
| Apache Configuration for Oracle XML Developer's Kit 9.2.0.1.0
| Apache JServ 1.1.0.0.0g
| Apache Web Server files 1.3.22.0.0a
| Assistant Common Files 9.2.0.1.0
| Assistant Common Files Patch 9.2.0.4.0
| Authentication and Encryption 9.2.0.1.0
| Authentication and Encryption Patch 9.2.0.4.0
| Bali Share 1.1.17.0.0
| BC4J Runtime for Database 9.0.2.692.1
| Capacity Planner 9.2.0.1.0
| Change Management Common Files 9.2.0.1.0
| Character Set Migration Utility 9.2.0.1.0
| Character Set Migration Utility 9.2.0.4.0
| Data Management Services Common Files 9.2.0.1.0
| Data Management Services Common Files Patch 9.2.0.4.0
| Database Configuration Assistant 9.2.0.1.0
| Database SQL Scripts 9.2.0.1.0
| Database SQL Scripts Patch 9.2.0.4.0
| Database Upgrade Assistant 9.2.0.1.0
| Database Verify Utility 9.2.0.1.0
| Database Verify Utility Patch 9.2.0.4.0
| Database Workspace Manager 9.2.0.1.0
| DBJAVA Required Support Files 9.2.0.1.0
| DBJAVA Required Support Files Patch 9.2.0.4.0
| Documentaion Required Support Files 9.2.0.1.0
| Enterprise Edition Options 9.2.0.1.0
| Enterprise Login Assistant 9.2.0.1.0
| Enterprise Manage Website Translated Files 9.2.0.1.0
| Enterprise Manager Base Classes 9.2.0.1.0
| Enterprise Manager Client 9.2.0.1.0
| Enterprise Manager Common Files 9.2.0.1.0
| Enterprise Manager Console 9.2.0.1.0
| Enterprise Manager Database Applications 9.2.0.1.0
| Enterprise Manager Events 9.2.0.1.0
| Enterprise Manager Installation Prerequisite Checks 9.2.0.1.0
| Enterprise Manager Integrated Applications 9.2.0.1.0
| Enterprise Manager Minimal Integration 9.2.0.1.0
| Enterprise Manager Paging and OMS Common Files 9.2.0.1.0
| Enterprise Manager Quick Tours 9.2.0.1.0
| Enterprise Manager Translated Files 9.2.0.1.0
| Enterprise Manager Web Site 9.2.0.1.0
| Enterprise Manager Webserver Integration 9.2.0.1.0
| Export/Import 9.2.0.1.0
| Export/Import Patch 9.2.0.4.0
| Generic Connectivity Common Files 9.2.0.1.0
| Generic Connectivity Common Files Patch 9.2.0.4.0
| Generic Connectivity Using ODBC 9.2.0.1.0
| Generic Connectivity Using ODBC Patch 9.2.0.4.0
| Installation Common Files 9.2.0.1.0
| Installation Common Files Patch 9.2.0.4.0
| iSQL*Plus 9.2.0.1.0
| iSQL*Plus Patch 9.2.0.4.0
| JDBC Common Files 9.2.0.1.0
| JDBC Common Files Patch 9.2.0.4.0
| JDBC/OCI Common Files 9.2.0.1.0
| JDBC/OCI Common Files Patch 9.2.0.4.0
| JSDK 2.0.0.0.0d
| LDAP Required Support Files 9.2.0.1.0
| LDAP Required Support Files Patch 9.2.0.4.0
| Migration Utility 9.2.0.1.0
| Migration Utility Patch 9.2.0.4.0
| New Database ID 9.2.0.1.0
| New Database ID Patch 9.2.0.4.0
| Object Type Translator 9.2.0.1.0
| Object Type Translator Patch 9.2.0.4.0
| Oracle Advanced Security 9.2.0.1.0
| Oracle Applications Extensions 9.2.0.1.0
| Oracle Applications Extensions Patch 9.2.0.4.0
| Oracle C++ Call Interface 9.2.0.1.0
| Oracle C++ Call Interface Patch 9.2.0.4.0
| Oracle Caching Service for Java 2.1.0.0.0a
| Oracle Call Interface (OCI) 9.2.0.1.0
| Oracle Call Interface (OCI) Patch 9.2.0.4.0
| Oracle Change Management Pack 9.2.0.1.0
| Oracle Client Required Support Files 9.2.0.1.0
| Oracle Client Required Support Files Patch 9.2.0.4.0
| Oracle Code Editor 1.2.1.0.0A
| Oracle Common Schema Demos 9.2.0.1.0
| Oracle Common Schema Demos Patch 9.2.0.4.0
| Oracle Complete DSS Starter Database 9.2.0.1.0
| Oracle Complete OLTP Starter Database 9.2.0.1.0
| Oracle Core Required Support Files 9.2.0.1.0
| Oracle Core Required Support Files Patch 9.2.0.4.0
| Oracle Data Mining 9.2.0.1.0
| Oracle Data Mining Patch 9.2.0.4.0
| Oracle Database Demos 9.2.0.1.0
| Oracle Database Demos Patch 9.2.0.4.0
| Oracle Database User Interface 2.2.11.0.0
| Oracle Database Utilities 9.2.0.1.0
| Oracle Database Utilities Patch 9.2.0.4.0
| Oracle Diagnostics Pack 9.2.0.1.0
| Oracle Directory Manager 9.2.0.1.0
| Oracle Display Fonts 9.0.2.0.0
| Oracle Dynamic Services Server 9.2.0.1.0
| Oracle eBusiness Management Extensions 9.2.0.1.0
| Oracle eBusiness Management Extensions Patch 9.2.0.4.0
| Oracle EMD Agent Extensions 9.2.0.1.0
| Oracle EMD Agent Extensions Patch 9.2.0.4.0
| Oracle Enterprise Manager Products 9.2.0.1.0
| Oracle Extended Windowing Toolkit 3.4.13.0.0
| Oracle Forms Extensions 9.2.0.1.0
| Oracle Help For Java 3.2.13.0.0
| Oracle Help For Java 4.1.13.0.0
| Oracle Help for the Web 1.0.7.0.0
| Oracle HTTP Server 9.2.0.1.0
| Oracle HTTP Server Extensions 9.2.0.1.0
| Oracle Ice Browser 5.06.8.0.0
| Oracle Intelligent Agent 9.2.0.1.0
| Oracle Intelligent Agent Base Component Files 9.2.0.1.0
| Oracle Intelligent Agent Base Component Files Patch 9.2.0.4.0
| Oracle Intelligent Agent Config Tool 9.2.0.1.0
| Oracle Intelligent Agent Extensions 9.2.0.1.0
| Oracle interMedia 9.2.0.1.0
| Oracle interMedia Annotator 9.2.0.1.0
| Oracle interMedia Audio 9.2.0.1.0
| Oracle interMedia Audio 9.2.0.4.0
| Oracle interMedia Client Compatibility Files 9.2.0.1.0
| Oracle interMedia Client Compatibility Files Patch 9.2.0.4.0
| Oracle interMedia Client Demos 9.2.0.1.0
| Oracle interMedia Client Demos Patch 9.2.0.4.0
| Oracle interMedia Client Option 9.2.0.1.0
| Oracle interMedia Common Files 9.2.0.1.0
| Oracle interMedia Common Files Patch 9.2.0.4.0
| Oracle interMedia Image 9.2.0.1.0
| Oracle interMedia Image 9.2.0.4.0
| Oracle interMedia Java Advanced Imaging 9.2.0.1.0
| Oracle interMedia Java Advanced Imaging Patch 9.2.0.4.0
| Oracle interMedia Java Client 9.2.0.1.0
| Oracle interMedia Java Media Framework Client 9.2.0.1.0
| Oracle interMedia Locator 9.2.0.1.0
| Oracle interMedia Locator Patch 9.2.0.4.0
| Oracle interMedia Video 9.2.0.1.0
| Oracle interMedia Video 9.2.0.4.0
| Oracle interMedia Web Client 9.2.0.1.0
| Oracle Internet Directory Client 9.2.0.1.0
| Oracle Internet Directory Client Common Files 9.2.0.1.0
| Oracle Internet Directory Client Common Files Patch 9.2.0.4.0
| Oracle Internet Directory Client Patch 9.2.0.4.0
| Oracle Internet Directory Tools 9.2.0.1.0
| Oracle Java Core Patch 9.2.0.4.0
| Oracle Java Layout Engine 2.0.1.0.0
| Oracle Java Server Pages 1.1.3.1.0
| Oracle Java Tools 9.2.0.1.0
| Oracle Java Tools Patch 9.2.0.4.0
| Oracle JDBC Development Drivers 9.2.0.1.0
| Oracle JDBC Development Drivers Patch 9.2.0.4.0
| Oracle JDBC Thin Driver for JDK 1.1 Patch 9.2.0.4.0
| Oracle JDBC Thin Driver for JDK 1.1 9.2.0.1.0
| Oracle JDBC Thin Driver for JDK 1.2 Patch 9.2.0.4.0
| Oracle JDBC Thin Driver for JDK 1.2 9.2.0.1.0
| Oracle JDBC Thin Driver for JDK 1.4 9.2.0.1.0
| Oracle JDBC Thin Driver for JDK 1.4 Patch 9.2.0.4.0
| Oracle JDBC/OCI Driver for JDK 1.1 9.2.0.1.0
| Oracle JDBC/OCI Driver for JDK 1.2 9.2.0.1.0
| Oracle JDBC/OCI Driver for JDK 1.4 9.2.0.1.0
| Oracle JDBC/OCI Interfaces 9.2.0.1.0
| Oracle JFC Extended Windowing Toolkit 4.1.10.0.0
| Oracle JVM 9.2.0.1.0
| Oracle JVM Patch 9.2.0.4.0
| Oracle Label Security 9.2.0.1.0
| Oracle Label Security Patch 9.2.0.4.0
| Oracle Management Pack for Oracle Applications 9.2.0.1.0
| Oracle Management Server 9.2.0.1.0
| Oracle Message Gateway Common Files 9.2.0.1.0
| Oracle Mod PL/SQL Gateway 3.0.9.8.3b
| Oracle Net 9.2.0.1.0
| Oracle Net Configuration Assistant 9.2.0.1.0
| Oracle Net Configuration Assistant Patch 9.2.0.4.0
| Oracle Net Integration 9.2.0.1.0
| Oracle Net Listener 9.2.0.1.0
| Oracle Net Listener Patch 9.2.0.4.0
| Oracle Net Manager 9.2.0.1.0
| Oracle Net Manager Patch 9.2.0.4.0
| Oracle Net Patch 9.2.0.4.0
| Oracle Net Required Support Files 9.2.0.1.0
| Oracle Net Required Support Files Patch 9.2.0.4.0
| Oracle Net Services 9.2.0.1.0
| Oracle OLAP 9.2.0.1.0
| Oracle OLAP API 9.2.0.1.0
| Oracle OLAP API Patch 9.2.0.4.0
| Oracle OLAP Cube Viewer 9.2.0.1.0
| Oracle OLAP CWM Lite 9.2.0.1.0
| Oracle OLAP CWM Lite Patch 9.2.0.4.0
| Oracle OLAP Patch 9.2.0.4.0
| Oracle OLAP Worksheet 9.2.0.1.0
| Oracle Partitioning 9.2.0.1.0
| Oracle Partitioning Patch 9.2.0.4.0
| Oracle Perl Interpreter 5.00503.0.0.0c
| Oracle Programmer 9.2.0.1.0
| Oracle SOAP Client 2.0.0.0.0a
| Oracle SOAP for JServ 2.0.0.0.0a
| Oracle SOAP Server 2.0.0.0.0a
| Oracle Spatial 9.2.0.1.0
| Oracle Spatial Patch 9.2.0.4.0
| Oracle SQLJ 9.2.0.1.0
| Oracle SQLJ Patch 9.2.0.4.0
| Oracle Starter Database 9.2.0.1.0
| Oracle Text 9.2.0.1.0
| Oracle Text Patch 9.2.0.4.0
| Oracle Trace 9.2.0.1.0
| Oracle Trace Patch 9.2.0.4.0
| Oracle Trace Required Support Files 9.2.0.1.0
| Oracle Trace Required Support Files Patch 9.2.0.4.0
| Oracle Tuning Pack 9.2.0.1.0
| Oracle UIX 2.0.21.0.0
| Oracle Ultra Search Common Files 9.2.0.1.0
| Oracle Ultra Search Common Files Patch 9.2.0.4.0
| Oracle Ultra Search Middle-Tier 9.2.0.1.0
| Oracle Ultra Search Middle-Tier Patch 9.2.0.4.0
| Oracle Ultra Search Server 9.2.0.1.0
| Oracle Ultra Search Server Patch 9.2.0.4.0
| Oracle Wallet Manager 9.2.0.1.0
| Oracle Wallet Manager Patch 9.2.0.4.0
| Oracle Workflow Manager 9.2.0.1.0
| Oracle XML Developer's Kit 9.2.0.1.0
| Oracle XML Developer's Kit Patch 9.2.0.4.0
| Oracle XML Runtime Components 9.2.0.1.0
| Oracle XML SQL Utility 9.2.0.1.0
| Oracle XML SQL Utility Patch 9.2.0.4.0
| Oracle9i 9.2.0.1.0
| Oracle9i Database 9.2.0.1.0
| Oracle9i Development Kit 9.2.0.1.0
| Oracle9i for UNIX Documentation 9.2.0.1.0
| Oracle9i Globalization Support 9.2.0.1.0
| Oracle9i Globalization Support Patch 9.2.0.4.0
| Oracle9i Patch 9.2.0.4.0
| Oracle9i Syndication Server 9.2.0.1.0
| Oracle9iR2 Patch Set 3 9.2.0.4.0
| Parser Generator Required Support Files 9.2.0.1.0
| Performance Manager 9.2.0.1.0
| PL/SQL 9.2.0.1.0
| PL/SQL Embedded Gateway 9.2.0.1.0
| PL/SQL Patch 9.2.0.4.0
| PL/SQL Required Support Files 9.2.0.1.0
| PL/SQL Required Support Files Patch 9.2.0.4.0
| Platform Required Support Files 9.2.0.1.0
| Precompiler Common Files 9.2.0.1.0
| Precompiler Common Files Patch 9.2.0.4.0
| Precompiler Required Support Files 9.2.0.1.0
| Precompiler Required Support Files Patch 9.2.0.4.0
| Pro*C/C++ 9.2.0.1.0
| Pro*C/C++ Patch 9.2.0.4.0
| RDBMS Required Support Files 9.2.0.1.0
| RDBMS Required Support Files Patch 9.2.0.4.0
| Recovery Manager 9.2.0.1.0
| Recovery Manager Patch 9.2.0.4.0
| regexp 2.0.21.0.0
| Reporting Framework 9.2.0.1.0
| Required Support Files 9.2.0.1.0
| Secure Socket Layer 9.2.0.1.0
| Secure Socket Layer Patch 9.2.0.4.0
| SQL*Loader 9.2.0.1.0
| SQL*Loader Patch 9.2.0.4.0
| SQL*Plus 9.2.0.1.0
| SQL*Plus Patch 9.2.0.4.0
| SQL*Plus Required Support Files 9.2.0.1.0
| SQL*Plus Required Support Files Patch 9.2.0.4.0
| SQLJ Runtime 9.2.0.1.0
| SQLJ Runtime Patch 9.2.0.4.0
| SQLJ Translator 9.2.0.1.0
| SQLServer Monitoring Option 9.2.0.1.0
| SSL Required Support Files 9.2.0.1.0
| SSL Required Support Files Patch 9.2.0.4.0
| Sun JDK 1.3.1.0.1a
| Sun JDK extensions 9.2.0.1.0
| Utilities Common Files 9.2.0.1.0
| Utilities Common Files Patch 9.2.0.4.0
| Visigenics ORB 3.4.0.0.0
| XDK Required Support Files 9.2.0.1.0
| XDK Required Support Files Patch 9.2.0.4.0
| XML 9.2.0.1.0
| XML 9.2.0.4.0
| XML Class Generator for C++ 9.2.0.1.0
| XML Class Generator for C++ 9.2.0.4.0
| XML Class Generator for Java 9.2.0.1.0
| XML Class Generator for Java 9.2.0.4.0
| XML Parser for C 9.2.0.1.0
| XML Parser for C Patch 9.2.0.4.0
| XML Parser for C++ 9.2.0.1.0
| XML Parser for C++ Patch 9.2.0.4.0
| XML Parser for Java 9.2.0.1.0
| XML Parser for Java Patch 9.2.0.4.0
| XML Parser for Oracle JVM 9.2.0.1.0
| XML Parser for Oracle JVM Patch 9.2.0.4.0
| XML Parser for PL/SQL 9.2.0.1.0
| XML Parser for PL/SQL Patch 9.2.0.4.0
| XML Transviewer Beans 9.2.0.1.0
| XML Transviewer Beans 9.2.0.4.0
| XML Transx 9.2.0.1.0
| XML Transx 9.2.0.4.0
| XSQL Servlet 9.2.0.1.0
| XSQL Servlet 9.2.0.4.0
|
|
| OPatch finishes successfully.

`---- Received on Wed Oct 29 2003 - 23:11:53 CST