RE: Another Version Question

v$version, which displays with sqlplus, does list your current versions. v$option shows you your installed options, there used to be like 5, now there's dozens.

On NT, there's a file in the ORAINST subdir of ORACLE_HOME called NT.RGS. I'm pretty sure there's a similar file on Solaris, called <something>.rgs, but as I've been off Solaris for more than a year, I don't remember what it is exactly.

hth,

yosi

> -----Original Message-----
> From: Nancy Mccormick [mailto:nancy.mccormick_at_sbti.com]
> Sent: Wednesday, October 04, 2000 1:26 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Another Version Question
>
>
> OK, I am feeling stupid today.
>
> Now I want to see what Oracle products and versions are installed for
> this instance on this server. I tried "inspdver" but
> apparently that is
> not available anymore. I tried v$version but that just has the
> information you get when you log into SQL*Plus. And the documentatin
> was not very helpful on this topic. I found a directory on the server
> called oraInventory but I am still trying to navigate through all it's
> subdirectories. So... can anyone help me with this? Right now I am
> looking for what version of SQL*Net (NET8) is installed but I should
> know how to find this information for any product without starting up
> the Installer. I will keep exploring but any suggestion/directions
> would be helpful.
>
> Thanks,
> Nancy
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nancy Mccormick
> INET: nancy.mccormick_at_sbti.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).
Received on Wed Oct 04 2000 - 12:40:23 CDT