Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

How to check oracle version in HP-UX

GSB_3
Frequent Advisor

How to check oracle version in HP-UX

Hi,

Please tell me how to check the oracle version running on my HP-UX server.

Thanks
3 REPLIES
Sergey Akifiev_1
Frequent Advisor

Re: How to check oracle version in HP-UX

su - oracle
check if ORACLE_HOME and ORACLE_SID are set correctly
$ORACLE_HOME/bin/sqlplus "/ as sysdba"
select * from v$version;
Yogeeraj_1
Honored Contributor

Re: How to check oracle version in HP-UX

hi,

Below the database version as well the details about the client software (sqlplus in this case):
yd@mydb.mu>select * from v$version;

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi
PL/SQL Release 10.2.0.2.0 - Production
CORE 10.2.0.2.0 Production
TNS for HPUX: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production

5 rows selected.

Elapsed: 00:00:00.53
yd@mydb.mu>exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64
bit Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engin
e options
$

hope this helps too!
kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
GSB_3
Frequent Advisor

Re: How to check oracle version in HP-UX

thanks for the help