4 Replies Latest reply: Oct 3, 2011 4:15 AM by anand prakash - oracle RSS

    location of alert log in 11g

    876265
      what is the location of alert log file in 11g as it has diagnostic des?
        • 1. Re: location of alert log in 11g
          imran khan
          According to metalink note - 438148.1, beginning with Release 11g, the alert log file is written as XML formatted and as a text file (like in previous releases). The default location of both these files is the new ADR home (Automatic Diagnostic Respository, yet another new dump dest in 11g).

          The ADR is set by using the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted, then, the default location of ADR is, 'u01/oracle/product/ora11g/log' (depends on ORACLE_HOME settings).

          The location of an ADR home is given by the following path, which starts at the ADR base directory: ADR_BASE/diag/product_type/product_id/instance_id

          If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST is set to ORACLE_HOME/log.

          Within the ADR home directory are subdirectories:
          alert - The XML formatted alertlog
          trace - files and text alert.log file
          cdump - core files

          The XML formatted alert.log is named as 'log.xml'

          Cheers!
          • 2. Re: location of alert log in 11g
            Fran
            select * FROM V$PARAMETER where name like '%background_dump_dest%';
            • 3. Re: location of alert log in 11g
              CKPT
              Sandy wrote:
              what is the location of alert log file in 11g as it has diagnostic des?
              SQL> select * from v$version;
              
              BANNER
              --------------------------------------------------------------------------------
              Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
              PL/SQL Release 11.1.0.7.0 - Production
              CORE    11.1.0.7.0      Production
              TNS for Linux: Version 11.1.0.7.0 - Production
              NLSRTL Version 11.1.0.7.0 - Production
              
              SQL>  show parameter background
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              background_core_dump                 string      partial
              background_dump_dest                 string      /oracle/app/oracle/diag/rdbms/PROD/PROD/trace
              
              SQL> !ls -ltr /oracle/app/oracle/diag/rdbms/PROD/PROD/trace/al*
              -rw-r----- 1 oracle oinstall 78512424 2011-10-03 02:00 /oracle/app/oracle/diag/rdbms/PROD/PROD/trace/alert_PROD.log
              
              SQL>
              • 4. Re: location of alert log in 11g
                anand prakash - oracle
                Still in 11g you can find using
                show parameter background_dump_dest
                By default its --> $diagnostic_dest/diag/rdbms/<db_unique_name>/<instance_name>/trace


                Anand