Monday, May 23, 2011

Location of Alert.log and trace files in Oracle 11g

There are 2 options.

From SQLPlus

Show Parameter dump_dest

Using a Query

select * from v$diag_info
Labels:

3 comments:

  1. Oracle DBAFebruary 8, 2012 at 5:05 PM

    similar post here :
    http://chandu208.blogspot.com/2011/04/alert-log-location-in-oracle-11gr2.html

    ReplyDelete
  2. AnonymousJanuary 26, 2013 at 3:26 PM

    diag\rdbms\yemendb\yemendb\trace

    Thank you.
    it means inside the( ALERT dir.) I got log.xml then (I should go to )( trace dir.) to read the alert_file in txt mode

    ReplyDelete
  3. UnknownNovember 2, 2013 at 6:58 AM

    Thanks for your post.i think itb is very common to me.I also wish that you will be aware of it.
    Spiritual Comics

    ReplyDelete

Subscribe to: Post Comments (Atom)