regarding directory structure in sap

[Former Member]

At OS level in which directory oracle alerts are stored?

[Former Member]

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

[Former Member]

Hi .

/oracle/SID/saptrace/background -->

alert_SID.log

Regards.