Databases
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