RE: Show Oracle products and versions

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Wed, 5 Jul 2000 23:18:14 -0000
Message-Id: <10549.111292@fatcity.com>

Hi,

I'm also on NT and can't comment on inspdver.

However, under NT you can also get some other information from the OUI logfiles

	located at \program files\oracle\inventory\logs 
	(this can also be seen by running the OUI and choosing to show

installed products).
This will only help you find products that have been installed via the OUI - eg patch 81611 but not patch 81612

If you are using forms then there is a file located at ORACLE_HOME\ORAINST\nt.rgs which contains information such as your forms / graphics runtime version.

Apart from checking the time date of specific files does any one know how to determine whether the 81612 patch is installed?

Thanks,

Bruce Reardon
Analyst / Programmer
Comalco Aluminium (Bell Bay)

mailto:bruce.reardon_at_comalco.riotinto.com.au

-----Original Message-----
From: Gaja Krishna Vaidyanatha [mailto:gajav_at_yahoo.com] Sent: Thursday, 6 July 2000 7:34
To: Multiple recipients of list ORACLE-L Subject: Re: Show Oracle products and versions

Winnie,

Does this provide more information than what is listed in v$version? I can't test it in my current environment, as I am running Oracle on an NT machine and "inspdver" does not exist under NT on Oracle 8.1.5. Of course, to view v$version the database needs to be up, but I am wondering if "inspdver" provides something that v$version does not provide. Please let me know if it does.

Just curious,

Gaja.

• Winnie_Liu_at_infonet.com wrote:
  > Under ORACLE_HOME/orainst. THe file is called inspdver. Run it
  > and it will
  > show you what products you have installed
  >
  > Winnie
  >
  >
  >
  >
  >
  > blair_at_pjm.com on 07/05/2000 01:15:49 PM
  >
  > Please respond to ORACLE-L_at_fatcity.com
  >
  > To: Multiple recipients of list ORACLE-L
  > <ORACLE-L_at_fatcity.com>
  > cc: (bcc: Winnie Liu/HQ/ISC)
  >
  >
  >
  >
  >
  > What is the executable under $ORACLE_HOME that I run to see
  > what Oracle7
  > products (and versions) are installed?
  >
  > tia,
  >
  > ...tom
  >
  >
  >
  > --
  > Author:
  > INET: blair_at_pjm.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX: (858)
  > 538-5051
  > San Diego, California -- Public Internet access /
  > Mailing Lists
  >

  ---

  
  > 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).
  >
  >
  >
  >
  >
  >
  >
  > --
  > Author:
  > INET: Winnie_Liu_at_infonet.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX: (858)
  > 538-5051
  > San Diego, California -- Public Internet access /
  > Mailing Lists
  >

  ---

  
  > 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).

  ---

Gaja Krishna Vaidyanatha
Director, I-O Management Products
Quest Software Inc.
(972)-304-1170
gajav_at_yahoo.com

"Opinions and views expressed are my own and not of Quest"

---

Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/

-- 
Author: Gaja Krishna Vaidyanatha
  INET: gajav_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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

Received on Wed Jul 05 2000 - 18:18:14 CDT