Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to find the Database version without opening the Database

Re: How to find the Database version without opening the Database

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Fri, 18 Oct 2002 16:57:37 GMT
Message-ID: <3DB03D75.4BB5A9C3@exesolutions.com>

TB wrote:

> run this query
> SELECT * FROM V$VERSION;
>
> "Enzo Maini" <touringcarclub_at_hotmail.com> wrote in message
> news:MP5q9.27581$OB5.2356743_at_newsread2.prod.itd.earthlink.net...
> > look in the init<sid_name>.ora file. The compatibility parameter will
> give
> > the version. While the installation may have been set to emulate a
> pervious
> > version 90% of the time that will not be the case
> >
> >
> > "Wenyu Kong" <kongwenyu_at_yahoo.com> wrote in message
> > news:6d998252.0210101048.1f5e0683_at_posting.google.com...
> > > Rauf,
> > >
> > > I tried to find file version (c:\Oracle\Ora81\bin\oracle.exe) to
> > > decide the Oracle product version, but find out that file the version
> > > of file oracle.exe is 0.0.0.0, any advise ? Thanks!
> > >
> > > Wenyu Kong
> > > rs_arwar_at_hotmail.com (Rauf Sarwar) wrote in message
> > news:<92eeeff0.0209202158.4a56b6b_at_posting.google.com>...
> > > > YasinQ_at_yahoo.com (Yasin) wrote in message
> > news:<f1159af4.0209201048.6ad1eb67_at_posting.google.com>...
> > > > > Hi: I am intresting in knowing if there is way to know the version
> of
> > > > > the Database without opening it, or even putting it in mount state.
> > > > >
> > > > > Many thanks.
> > > >
> > > >
> > > > First...Please do not cross post in multiple groups. You will only
> > > > tick people off and will definitely get fewer responses.
> > > >
> > > > In the absence of any Oracle provided tool to do this (that I am not
> > > > aware of), there isn't a sure shot way, however, there are couple of
> > > > ways to get to it. Little easier on Windows then on Unix though.
> > > >
> > > > Windows:
> > > > 1) Query [ImagePath] registry value of a SID service at
> > > > HKLM\System\CurrentControlSet\Services\OracleService<SID>[ImagePath].
> > > > This will give you a string e.g. C:\Oracle\Ora81\bin\Oracle <SID>.
> > > > Parse the string and get the first token which is full path and name
> > > > to Oracle executable. use Windows API function GetFileVerInfo() or NT
> > > > resource kit utility like "filever" to get the version. It may not
> > > > give you the patchset version but it will give you the major version.
> > > >
> > > > 2) For 8.1 and above, query registry at
> > > > HKLM\Software\Oracle[inst_loc]. This will give you location of
> > > > Inventory...Typically under C:\Program files\Oracle. For base version,
> > > > get folder name immediately under C:\Program
> > > > files\Oracle\Inventory\Components\oracle.rdbms\. For patchset
> > > > information, get most recent folder name under C:\Program
> > > > files\Oracle\Inventory\PatchSets\oracle.server\.
> > > >
> > > > Unix:
> > > > 1) This is Windows equivalent in step 1. Get the SID Oracle home by
> > > > parsing SID entry in /etc/oratab file. Goto $SID_HOME/bin and get file
> > > > version of oracle executable. I don't know if there is any equivalent
> > > > of GetFileVerInfo() in Unix but you may use commands like "ident" or
> > > > "what" or some third party tool.
> > > >
> > > > 2) This is Windows equivalent in step 2. Get oraInventory location
> > > > from ../orainst.loc file and follow steps like in Windows step 2.
> > > >
> > > > It is not 100% gauranteed but it will get you close enough without
> > > > database being open. Maybe someone else may have a better way to do
> > > > this.
> > > >
> > > > /Rauf Sarwar
> > >
> >
> >

Without opening the database? How?

Daniel Morgan Received on Fri Oct 18 2002 - 11:57:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US