<div>
type in:<br />
file $ORACLE_HOME/bin/oracle<br />
<br />

</div>


<div>
$ORACLE_HOME/bin/sqlplus -version<br />
<br />
Wesly
</div>


<div>
The SQLPLUS version is the same as the installed Oracle's.<br />
<br />
Wesly<br />

</div>


The SQLPLUS version is the same as the installed Oracle's.

Wesly


<div>
The method I mentioned works for Oracle 9.<br />
yuzh's method is for Oracle 7 and 8. I don't have inspdver in oracle 9.<br />
<br />
Wesly
</div>


The method I mentioned works for Oracle 9.
yuzh's method is for Oracle 7 and 8. I don't have inspdver in oracle 9.

Wesly

<div>
you can look for column named &quot;version&quot; etc.<br />
<br />

</div>


you can look for column named "version" etc.



<div>
cat /etc/oratab | grep prod<br />
<br />
above works for aix &amp;&nbsp;hp-ux <br />
<br />
for solaris <br />
<br />
cat /var/opt/oracle/oratab | grep prod<br />
<br />
hth<br />

</div>


cat /etc/oratab | grep prod

above works for aix & hp-ux

for solaris

cat /var/opt/oracle/oratab | grep prod

hth


<div>
Mine is not very accurate.<br />
<br />
I'd try `what` and `strings` first, accountant records after, and only then go to SQL....
</div>


Mine is not very accurate.

I'd try `what` and `strings` first, accountant records after, and only then go to SQL....

<div>
<div class="content wysiwyg-content">
hai friends,<br />
&nbsp; &nbsp; &nbsp; &nbsp;Is there any command in unix to find the Oracle version number of a oracle that set in the ORACLE_HOME environment variable.<br />
<br />
Thanks
</div>
</div>


hai friends,
       Is there any command in unix to find the Oracle version number of a oracle that set in the ORACLE_HOME environment variable.

Thanks

Unix command to find Oracle version number

Unix is a multitasking, multi-user computer operating system originally developed in 1969 at Bell Labs. Today, it is a modern OS with many commercial flavors and licensees, including FreeBSD, Hewlett-Packard’s UX, IBM AIX and Apple Mac OS-X. Apart from its command-line interface, most UNIX variations support the standardized X Window System for GUIs, with the exception of the Mac OS, which uses a proprietary system.