7 Replies Latest reply: May 23, 2011 7:03 AM by user522961 RSS

    where is alertlog

    user522961
      Hi,
      on 11g R1 on UNIX HP,
      I can not find alertlog. I have the following :
      /data01/oracle/diag/rdbms/MYDB/MYDB/trace/alert_MYDB.log

      In which only :

      DIA-48494: ADR home is not set, the corresponding operation cannot be done

      And also :
      SQL> show parameter user
      
      NAME                                 TYPE        VALUE
      ------------------------------------ ----------- ------------------------------
      license_max_users                    integer     0
      parallel_adaptive_multi_user         boolean     TRUE
      redo_transport_user                  string
      user_dump_dest                       string      /data01/oracle/d
                                                       iag/rdbms/MYDB/MYDB/trace
      Where is alertlog ??

      Thank for help.
        • 1. Re: where is alertlog
          user61472
          Have you tried a search from root (/) downwards to look for it?

          IS your DB definately up and running? If the alert.log has been deleted and your DB is not up and running then no alert.log will exist.
          • 2. Re: where is alertlog
            Chinar
            What is value of diagnostic_dest parameter?
            • 3. Re: where is alertlog
              user522961
              Thanks to all.
              DB is up :
              SQL> show parameter diagnostic_dest
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              diagnostic_dest                      string      /data01/oracle
              
              Exit :
              find /data01/oracle alert_MYDB.log
              
              no file of this category
              • 4. Re: where is alertlog
                Helios-GunesEROL
                Hi;

                What below return:

                SQL>show parameter background_dump_dest

                or

                SQL>show parameteruser_dump_dest

                Regard
                Helios
                • 5. Re: where is alertlog
                  P.Forstmann
                  Right Unix command should be:
                  find /data01/oracle  -name alert_MYDB.log
                  And we already know part of the result:
                  >
                  /data01/oracle/diag/rdbms/MYDB/MYDB/trace/alert_MYDB.log
                  • 6. Re: where is alertlog
                    user522961
                    Thanks.
                    sudo find / alert_MYDB.log

                    find: : no file of this category
                    SQL> show parameter background_dump_dest
                    
                    NAME                                 TYPE        VALUE
                    ------------------------------------ ----------- ------------------------------
                    background_dump_dest                 string      /data01/oracle/d
                                                                     iag/rdbms/mydb/MYDB/trace
                    
                    NAME                                 TYPE        VALUE
                    ------------------------------------ ----------- ------------------------------
                    user_dump_dest                       string      /data01/oracle/d
                                                                     iag/rdbms/mydb/MYDB/trace
                    • 7. Re: where is alertlog
                      user522961
                      yes thank you.
                      I found it :
                      /home/oracle> find /data01/oracle -name alert_MYDB.log
                      
                      
                      /data01/oracle/MYDB/diag/rdbms/MYDB/MYDB/trace/alert_MYDB.log