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
> >
>
>
Received on Fri Oct 18 2002 - 00:21:55 CDT
