TO CHECK ALERT LOG FILES IN ORACLE

TO CHECK ALERT LOG FILES IN ORACLE


$ adrci

ADRCI: Release 11.2.0.2.0 - Production on Thu Dec 1 15:38:15 2011
ADR base = "/u01/app"

adrci> show homes
diag/tnslsnr/ip-10-100-255-165/listener
diag/rdbms/uw01/uw01

adrci> set home diag/rdbms/uw01/uw01
adrci> show alert -tail 100
Alternately, do it the old-fashioned way (on Linux or Unix):

$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Thu Dec 1 15:43:43 2011

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show parameter background_dump

NAME                     TYPE    VALUE
------------------------------------ ----------- -----------------------------------
background_dump_dest             string  /u01/app/diag/rdbms/uw01/uw01/trace

SQL> exit
Disconnected from Oracle Database 11g...

$ tail -100 /u01/app/diag/rdbms/uw01/uw01/trace/alert_uw01.log