Re: Oracle Verison Information

From: Pete Finnigan <oracle_list_at_peterfinnigan.demon.co.uk>
Date: Mon, 30 Jun 2003 07:48:37 -0700
Message-ID: <F001.005BC1A4.20030630070439@fatcity.com>

Hi

The O'Reilly book "Oracle scripts" has a shell script products.sh that does this, although it uses the file unix.rgs instead although for 9iR1 which i can check now this file only contains the line

rdbms 9.0.0.0.0 Beta

so i guess the install log in $ORACLE_BASE/oraInventory/logs/installActi ons.log might be the best source to use. on 9iR1 it contains a section listing the current inventory, this should include patches but how reliably updated it is I am not sure!:

<snip>
Current Inventory:

        Independent Products:
                Java Runtime Environment 1.1.8.12.0
                Oracle Universal Installer 2.0.1.4.0
        Oracle Home: /export/home/u01/app/oracle/product/9.0.1
                LDAP Required Support Files 9.0.1.0.0
                Database SQL Scripts 9.0.1.0.0
                Precompiler Required Support Files 9.0.1.0.0
                RDBMS Required Support Files 9.0.1.0.0
                ...

</snip>

There should also be a file $ORACLE_BASE/oraInventory/Contents/PatchesLi st0.ser that looks like it might contain patch info?, it is binary so you could investigate this file also with the strings command.

hth

kind regards

Pete

--

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Pete Finnigan
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Jun 30 2003 - 09:48:37 CDT