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