on 07-28-2010 8:05 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
sqlplus / as sysdba
show parameter pfile
if you get a result, you will get all your directories in taht file
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.