cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle logs

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (1)

Answers (1)

former_member204746
Active Contributor
0 Kudos

sqlplus / as sysdba

show parameter pfile

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