2009-07-01

Find oracle product version

APEX:
select version_no from apex_release;

Oracle Application Server (OAS 10.1.2 and 10.1.3):
grep -i version $ORACLE_HOME/config/ias.properties

OAS Java version (JDK)
cd $ORACLE_HOME/jdk/bin
java -version

OAS 10.1.3 "System Properties"
Use Application Server Control.
From main page "Cluster Topology" go to OC4J "home". Click "Administration" tab. Go to "Server Properties". Scroll down and click the link "System Properties".

Oracle Database Server (RDBMS):
1.
select * from v$version;
2.
cd $ORACLE_HOME/bin
file oracle
If the output of the "file oracle" command does not say 64-bit explicitly then you are running 32-bit Oracle.
3.
check banner of sqlplus
4.
Check for lib, lib32
$ORACLE_HOME/lib32
$ORACLE_HOME/lib
If there is only an ORACLE_HOME/lib directory then it is 32 bit

modified on 2011-04-15