Bruce,
It's a very annoying "feature" of Oracle on NT that
v$version does not always show the full 5-digit patch
release. It's something to do with the interaction of
.dll's and .exe's on NT and how all of them are not
updated with each patch release (or at least that's
how support explained it to me). I've certainly
complained enough about it (yet another use for the
feedback button on MetaLink!).
I usually check the bin directory for the
size/timestamp of ORACLExx.EXE before and after I
install the patch and compare it with the one included
in the patch.
HTH,
- Anita
- "Reardon, Bruce (CALBBAY)"
<Bruce.Reardon_at_comalco.riotinto.com.au> wrote:
> 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-----
> Sent: Thursday, 6 July 2000 7:34
> To: Multiple recipients of list ORACLE-L
>
>
> 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
> (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: Reardon, Bruce (CALBBAY)
> INET: Bruce.Reardon_at_comalco.riotinto.com.au
>
> 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
Received on Thu Jul 06 2000 - 01:27:07 CDT
