Oracle-L: RE: Oracle version??

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Wed, 26 Feb 2003 22:59:07 -0800
Message-ID: <F001.0055AF28.20030226225907@fatcity.com>

I just plugged through a "$ strings oracle" to see if the version information is in there anyplace. On an 8.1.7 kernel, I was surprised to find that version numbers all the way from 8.0.0 through 8.2.0 show up in the file. The string I was really looking for was "Oracle8i Enterprise Edition Release %d.%d.%d.%d.%d %s"--the release number is stored in five separate variables, which are printed through this printf format string...

However, there are a couple of tricks you might engage. I just did this on my Linux system and found what version my kernel *thinks* it is:

$ strace -s100 oracle 2>&1 | grep "Oracle.*Release"

This strace command catches the kernel's write() call of the release number into a background trace file. You could also look at the background trace files if you wanted to conserve the overhead of invoking the oracle executable. The thing exit()s, so I think it's safe to run it this way, but you probably don't want the side effects of extra trace file writing, etc.

I think peeking into the trace file is a possible solution for you, but then I'd take the wise advice of people of those on the list who might be able to prove that the kernel can actually lie about its own release number...

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- RMOUG Training Days 2003, Mar 5-6 Denver - Hotsos Clinic 101, Mar 25-27 London

-----Original Message-----

Dayal
Sent: Wednesday, February 26, 2003 11:49 PM To: Multiple recipients of list ORACLE-L

Hi Sunil,

The tragedy is that even if you logon to database, you may not find the precise
patch level from database.

The best location is orainventory/log directory. OK on MS machines
C:\Program Files\Oracle\Inventory\logs. Go to this directory and check the latest log
file from this location.

HTH,
Rajesh
-----Original Message-----

Sent: Thursday, February 27, 2003 7:09 AM To: Multiple recipients of list ORACLE-L

List,

Can Oracle version be determined based on size of Oracle.EXE file on Windows?
I am looking for a valid way of determining the patch level without having
to log onto the database and check
v$instance.

appreciate any feedback.

Sunil Nookala
Dell Corp.
Austin, TX.

--

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

Author:
INET: Sunil_Nookala_at_Dell.com

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: ListGuru_at_fatcity.com (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).
--

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

Author: Rajesh Dayal
INET: Rajesh_at_ohitelecom.com

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

--

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

Author: Cary Millsap
INET: cary.millsap_at_hotsos.com

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