topic Re: vesrion in Operating System - HP-UX

vesrion

Waugh — Fri, 26 Dec 2008 13:43:22 GMT

Hi,

How to check the oracle version on hpunix 11.11

Regards
Rkumar

Re: vesrion

f. halili — Fri, 26 Dec 2008 14:12:20 GMT

if you can login into oracle:
select banner from v$version

if you are at unix only, going to the home directory will show w/c is oracle's home directory.

#cd $ORACLE_HOME

cheers,
f. halili

Re: vesrion

Johnson Punniyalingam — Fri, 26 Dec 2008 15:13:00 GMT

Hi Kumar,

how about talking look at the /etc/rc.log

will also show the Oracle Version.

Thanks,
Johnson

Re: vesrion

Srimalik — Fri, 26 Dec 2008 16:17:24 GMT

When you connect to a running database using sqlplus it shows you the oracle db version.
#########################################
SQL*Plus: Release 9.2.0.6.0 - Production on Tue Oct 18 17:58:57 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
<>
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data
Mining options
<>
##########################################