cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Down due to DB

anvardheen_jabarullah
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (5)

Answers (5)

former_member182034
Active Contributor
0 Kudos

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,

anvardheen_jabarullah
Participant
0 Kudos

Hi All,

I am facing portal connectiong issues.Where to check if portal systems are down?

Reagan
Advisor
Advisor
0 Kudos

I am facing portal connectiong issues.Where to check if portal systems are down?

Run jcmon / jsmon against the instance profile and see whether the processes are running.

Check the log files present at /usr/sap/SID/JC00/work

Also check the default traces.

Regards

RB

Former Member
0 Kudos

Hi,

Yes you can also check as per the release.

Till NW 7.02 check that jlaunch process is running.

After release Nw 7.1 check jstart process.

use jsmon and jcmon also.

jsmon pf=instance profile

jcmon pf=instance profile

Thanks

Rishi Abrol

anvardheen_jabarullah
Participant
0 Kudos

Hi All,

If application is down , What are the logs need to be be checjked in "Work" directory?


Former Member
0 Kudos

Hi,

Please check dev_w0, dev_ms and disp logs for abap.

Thanks

Rishi Abrol

ashish_vikas
Active Contributor
0 Kudos

First check

dev_disp - trace for Dispatcher

dev_w0 - trace for work process

best regards

ashish

anvardheen_jabarullah
Participant
0 Kudos

Thanks again..

I have found some  db related logs in GUI via T-Code: DB01& ST04..

Former Member
0 Kudos

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.

former_member45419
Active Contributor
anvardheen_jabarullah
Participant
0 Kudos

Thanks buddies for your prompt solution.  Now DB is back to normal. DB team has done but not updated why it was caused.

For that BASIS we want to analyze where and why.

Former Member
0 Kudos

Hi,

Can try to see check the alert log and see the issue .

From the sap side you can check the SM21 logs.Can also check db02 -> Alert -> Alert monitor.

Thanks

RishI abrol

Former Member
0 Kudos

Hi Dheen,

Related to database issues, you can start analyzing from the alert log file because every activity will be noted in that file.

Regards

Sudhir Sadhu

Former Member
0 Kudos

Dear Dheen AJ

Definitely, they restore the old password which was causing to down the database.

Its my experience because of work as Team Leader

Regards