1. How to determine Oracle Apps 11i Version ?

Ans : select RELEASE_NAME from fnd_product_groups;

You should see output like


2. How to find Database version ?

Ans : SQL> select * from v$version;

The command returns the release information, such as the following:Oracle9i Enterprise Edition Release – ProductionPL/SQL Release – ProductionCORE ProductionTNS for 32-bit Windows: Version – ProductionNLSRTL Version – Production

3. How to find opatch Version ?

Ans : opatch is utility to apply database patch , In order to find opatch version execute”$ORACLE_HOME/OPatch/opatch version”

You can check OPatch -lsinventory

4. How to find out invalid objects in the database

Ans : select count(*) from dba_objects where status =’INVALID’
(More …)