on 12-03-2013 4:22 AM
Hi Experts,
Suddenly my application has down.We checked from our end and couldn't find error logs.We have got it which was due to DB relarted.How to check and where to check database related logs? Please find below on my server details
OS:Windows
DB:oracle 11g
Hi,
Please use the below command to check the location of the alert.log.
sql>show parameter background
;
This will show you the directory where you will find the alert.log.
But still the dev_w0 should show that the db not reachable .
Thanks
Rishi abrol
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Dheen,
FYI....Whenever you will get issue then You need to check 2 files because these files have information of issue.
Alert_SID.log at Database level which exist in :\oracle\NDR\saptrace\background
Dev_w0 at SAP level which exist in \usr\sap\NDR\DVEBMGS00\work
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All,
I am facing portal connectiong issues.Where to check if portal systems are down?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All,
If application is down , What are the logs need to be be checjked in "Work" directory?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks again..
I have found some db related logs in GUI via T-Code: DB01& ST04..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dheen,
Check whether your database is up, open and running.
Connect to sql prompt and with the command:
select status from v$instance;
If it is not showing the status open, then check your alert log file which is present in
oracle\SID\saptrace\diag\trace directory.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Have you check your db services ,weather its in running are stop ,if its not running make to run & monitor its
For more clarification pls check this links...
SAP System Monitoring & Performance Checks « Sap Training Hub
SAP Database performance monitor introduction | SAP application performance
Checking Consistency of the Database (SAP Library - BC R/3 Database Guide: MS SQL Server)
SAP Library - BC R/3 Database Guide: MS SQL Server
Regards
Nayeem
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
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.