Re: Oracle Inventory Infomation

From: Pete Finnigan <pete_at_petefinnigan.com>
Date: Tue, 29 Jul 2003 12:35:14 +0100
Message-ID: <8GdD8AByvlJ$Ew7c@peterfinnigan.demon.co.uk>

Hi

Check the InstallActions.log file $ORACLE_BASE/oraInventory/logs it includes a list of installed components near the end an example is:

...

Initializing installer save inventory WCCE Current Inventory:

        Independent Products:
                Java Runtime Environment 1.1.8.10a
                Oracle Universal Installer 1.7.1.8.0
        Oracle Home: /u01/app/oracle/product/8.1.7
                Precompiler Required Support Files 8.1.7.0.0
                Platform Required Support Files 8.1.7.0.0
                JDBC Common Files 8.1.7.0.0
                NLS Required Support Files 8.1.7.0.0
                Oracle Core Required Support Files 8.1.7.0.0
                DBUI 1.1.2.0.0
                Extended Windowing Toolkit 3.3.6.0.0a
                Net8 Required Support Files 8.1.7.0.0

...

You can parse this with a shell/awk script and get a list of installed components.

Also v$version shows the versions of the main components. And the file $ORACLE_HOME/install/unix.rgs shows names and versions of some of the main items, example is:

oracle:venus> more unix.rgs
sql*plus 8.1.7.0.0 Production
Java 8.1.7.0.0 Production
rdbms 8.1.7.0.0 Production
svrmgr 8.1.7.0.0 Production
Oracle8 Spatial Cartridge 8.1.7.0.0 Production Oracle8i interMedia Locator Service 8.1.7.0.0 Production

Oracle8i interMedia Text Manager 8.1.7.0.0 Production
Oracle8i interMedia Image Management 8.1.7.0.0 Production
Oracle8i interMedia Audio Management 8.1.7.0.0 Production
Oracle8i interMedia Video Management 8.1.7.0.0 Production

interMedia 8.1.7.0.0 Production
Oracle8 Visual Information Retrieval Cartridge 8.1.7.0.0 Production Oracle Time Series 8.1.7.0.0 Production

There is a script in the O'Reilly book "Oracle scripts" by Kreines and Lomasky called products.sh that lists this file.

Also go to the directory $ORACLE_BASE/oraInventory/Components and there is a list of all installed components there, each has its own directory. Then each has a version directory below that, i.e.

oracle:venus> pwd
/u02/app/oracle/oraInventory/Components
oracle:venus> ls
analyzer
BC4JIAS0
occm

oracle.apache
oracle.apache.apache
oracle.apache.jdk
oracle.apache.jsdk
oracle.apache.jserv
oracle.apache.mod8i
oracle.apache.ojsp
oracle.apache.perlint
oracle.apache.xdk
oracle.assistants
oracle.assistants.acf
oracle.assistants.dbca
oracle.assistants.dbma

...

perhaps you can do something with that listing in shell?, also the $ORACLE_BASE/oraInventory/Conents directory seems to hold some inventory list files for components, patches and libraries. They are binary though.

Maybe someone knows if there is a command line tool to list the inventory???, as that would be your best option?

hth

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.

Received on Tue Jul 29 2003 - 06:35:14 CDT