5 Replies Latest reply: Oct 16, 2012 4:44 PM by 968777 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
                • 5. Re: location of alert log in 11g
                  968777
                  Sandy,

                  I know which this answer is later... but is valid know...

                  About alert log on oracle 11g:


                  SQL> desc v$diag_info;


                  Name                         Null? Type
                  ----------------------------------------- -------- ----------------------------
                  INST_ID                         NUMBER
                  NAME                              VARCHAR2(64)
                  VALUE                              VARCHAR2(512)



                  SQL> select * from v$diag_info where name='Diag Alert';


                  INST_ID

                  1
                  ------------------------------------------------------------------------------
                  NAME

                  Diag Alert

                  ---------- ----------------------------------------------------------------
                  VALUE
                  --------------------------------------------------------------------------------

                  /u01/app/diag/rdbms/orcl/orcl/alert

                  ----------------------------------------------------------------------------------

                  on bash comand line:

                  $ ls /u01/app/diag/rdbms/orcl/orcl/alert

                  result: log.xml

                  Edited by: 965774 on Oct 16, 2012 2:44 PM