Queries to Check Versions

Simple Queries to retrieve the Version Information

Oracle Applications Version

SQL> select RELEASE_NAME from fnd_product_groups;

 Oracle Database Version

• SQL> select * from v$version;

• SQL> select * from v$version where banner like ‘Oracle%’; 

• Version information can also be checked from Installed Products from the Oracle Universal Installer. 

  It will tell you what products is installed on the machine and also its version information. 

  The installer is located at $ORACLE_HOME/bin/runInstaller  

•  Connect to sqlplus as sysdba it will give you the database version 

Operating System 32/64 Bit?

• In Solaris Systems

/usr/bin/isainfo -kv

• In Linux Systems

uname -m