Skip to Content
avatar image
Former Member

regarding directory structure in sap

At OS level in which directory oracle alerts are stored?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 05, 2008 at 09:00 AM

    Hi .

    /oracle/SID/saptrace/background -->

    alert_SID.log

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 05, 2008 at 02:27 PM

    Hi Praveen,

    just some additional information for your question.

    The most important information is written to the alert_<SID>.log. In an SAP environment you usually place this log under %SAPDATA_HOME%\saptrace\background (Windows), $SAPDATA_HOME/saptrace/background for Linux/Unix.

    If you cannot find it there then you are not using the default location for the alert_<SID>.log. In this case you need to check the value of the oracle parameter background_dump_dest - the value of this parameter tells you where the alert_<SID>.log is written to. You can check this by logging on to the database and showing the parameter:

    sqlplus "/as sysdba"

    show parameter background_dump_dest

    If an error occurs that requires additional logs to be written then you can find them under %SAPDATA_HOME%\saptrace\background or %SAPDATA_HOME%\saptrace\usertrace

    But if Oracle writes some traces to the last 2 directories mentioned, you will see an explicit information about this in the alert_<SID>.log, e.g.

    Tue Sep 27 08:34:58 2005

    Errors in file /oracle/Q72/saptrace/usertrace/q72_ora_27044.trc:

    ORA-00600: internal error code, arguments: [stsRelSlot_1], [], [], [],

    [], [], [], []

    Regards,

    beate

    Add comment
    10|10000 characters needed characters exceeded