Database Administration (MOSC)

MOSC Banner

Alert Log gets written to two different locations in 11g

edited Jul 10, 2011 10:45PM in Database Administration (MOSC) 1 commentAnswered

Oracle 11.2 logs into two different alert.log files. Sometimes in

a) ~oracle/product/11.2.0/log/diag/rdbms/lola/LOLA/trace/
   Instance terminated by USER, pid = 13953
   Mon Jun 27 14:18:03 2011
   Instance shutdown complete

b)  ~oracle/diag/rdbms/lola/LOLA/trace/
   Mon Jun 27 16:13:13 2011
   Archived Log entry 7 added for thread 1 sequence 68 ID
   0x8d24c110 dest 1:
   Archived Log entry 8 added for thread 1 sequence 68 ID
   0x8d24c110 dest 2:

SQL> select * from v$diag_info ;
   INST_ID NAME
---------- ----------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
         1 Diag Enabled
TRUE
         1 ADR Base
/app/oracle
         1 ADR Home
/app/oracle/diag/rdbms/lola/LOLA
         1 Diag Trace
/app/oracle/diag/rdbms/lola/LOLA/trace
         1 Diag Alert

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center