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

From: Enzo Maini <touringcarclub_at_hotmail.com>
Date: Sun, 13 Oct 2002 03:33:00 GMT
Message-ID: <MP5q9.27581$OB5.2356743_at_newsread2.prod.itd.earthlink.net>


[Quoted] look in the init<sid_name>.ora file. The compatibility parameter will give [Quoted] the version. While the installation may have been set to emulate a pervious [Quoted] 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
>
Received on Sun Oct 13 2002 - 05:33:00 CEST

Original text of this message