HPE Community
Operating System - HP-UX
1752701 Members
6823 Online
108789 Solutions
New Discussion юеВ

vesrion

 
Waugh
Frequent Advisor

тАО12-26-2008 05:43 AM

тАО12-26-2008 05:43 AM

vesrion

Hi,

How to check the oracle version on hpunix 11.11

Regards
Rkumar
0 Kudos
Reply
3 REPLIES 3
f. halili
Trusted Contributor

тАО12-26-2008 06:12 AM

тАО12-26-2008 06:12 AM

Re: vesrion

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
derekh
0 Kudos
Reply
Johnson Punniyalingam
Honored Contributor

тАО12-26-2008 07:13 AM

тАО12-26-2008 07:13 AM

Re: vesrion

Hi Kumar,

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

will also show the Oracle Version.

Thanks,
Johnson
Problems are common to all, but attitude makes the difference
0 Kudos
Reply
Srimalik
Valued Contributor

тАО12-26-2008 08:17 AM

тАО12-26-2008 08:17 AM

Re: vesrion

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
<>
##########################################
abandon all hope, ye who enter here..
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.