Hi Henry/Nancy,
On UNIX there is a new directory created (as default) in $ORACLE_BASE titled
'oraInventory'. The installer creates several sub-dirs/files in there. From
these files the installer collects information about what's installed (with
their version numbers). I fount it rather difficult to scan these files to
figure out how installer gets that information. And finally gave up..
Also, Oracle expects the conents of 'oraInventory' to reflect what's
installed in $ORACLE_HOME, but does not take extra precautions to make it
certain. Case in point, when my 8.1.6.2 patch failed, the 'oraInventory'
directory got out of synch with what was in $ORACLE_HOME. OWS asked me to
reinstall 8.1.6.0.0 and reapply the patch with a workaround. That was the
only way to get 'oraInventory' fixed. Tampering with it is not supported.
Whenever I tried to re-apply the patch.. installer told me I was already
up-to-date and there was nothing to patch. Only re-installing 8.1.6.0.0 is
the option. And I will have to do that in the near future...
We are now backing up 'oraInventory' along with $ORACLE_HOME to keep those
in sync....
HTH..
- Kirti
> -----Original Message-----
> From: Henry Poras [SMTP:Henry.Poras_at_ctp.com]
> Sent: Wednesday, October 04, 2000 3:06 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Another Version Question
>
> Nancy,
> Once you get to 8.1, I have heard the only way to get this stuff is
> through
> the installer (but where does the installer get it from?).
>
> Henry
>
> -----Original Message-----
> Sent: Wednesday, October 04, 2000 1:26 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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
Received on Wed Oct 04 2000 - 15:12:48 CDT
