Simple Queries to retrieve the Version Information
Oracle Applications Version
SQL> select RELEASE_NAME from fnd_product_groups;
Oracle Database Version
select * from v$version;
select * from v$version wherebanner 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
- In Linux Systems