Some useful database commands for OIM

SQL> select value from v$parameter where name='background_dump_dest';

VALUE
--------------------------------------------------------------------------------
/u0/app/oracle/diag/rdbms/orcl/orcl/trace

-bash-3.2$ cd /u0/app/oracle/diag/rdbms/orcl/orcl/trace
-bash-3.2$ ls
alert_orcl.log       orcl_j001_25686.trm  orcl_ora_20641.trc


QL> show parameter background_dump_dest
To find the location of the diagnostic_dest, can use the following select

SQL> select value from v$parameter where name='diagnostic_dest';

VALUE
--------------------------------------------------------------------------------
/u0/app/oracle
To know the current ORACLE_SID, you can use following select:

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
ORCL
Alert log file consist alert_.log
Therefore my alert log file is : /u0/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log