Skip to Content
avatar image
Former Member

Oracle logs

I need to know the alerts of oracle database and troubleshooting logs and location in SAP directory

Scenario 1

I start listener and DB ..both are not coming up.

Scenario 2

startup mount ;

failed..

Kindly need your help

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 28, 2010 at 07:21 PM

    Listener Logs

    As the listener.log file grows, the DBA will want to either remove or rename this log file. I dont know if its there while installing the SAP by default, havenot got any situation or something like it.

    Windows

    %\network\log> lsnrctl set log_status on

    On Unix

    Oracle/product/netwrok/log

    lsnrctl set log_status_on

    if you starting the DB and its failed you can see the Oracle alert file all the information captures here...Whatever happens on Oracle you can see all the information in Oracle Alerts in SAP the filename is AlertSID.log and you can find the same in

    Drive:\oracle\SID\saptrace\

    background\alert_<DBSID>.log Oracle Alert file

    usertrace\*.trc User trace files

    For more information on SAP Directory structure you can goto below link

    http://help.sap.com/saphelp_nwpi71/helpdata/en/47/050747e74266c0e10000000a1553f7/content.htm

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 28, 2010 at 10:23 PM

    sqlplus / as sysdba

    show parameter pfile

    if you get a result, you will get all your directories in taht file

    Add comment
    10|10000 characters needed characters exceeded