work+disp stopped

[Former Member]

Hi gentlemen,

I have SAP system ECC6 SR3 on SQL server DB and windows server, during the work accidentally electricity come down, after that when i try to start up the instance from MMC, it stayed in yellow color, and work+disp stopped, i cann't solve this issue, while it is critical situation because it is the DEV server included all configurations.

i wait your help.

thank you in advance.

[Former Member]

Dear Ahmed,

I tell you a very simple method.Sometimes it can happen that the dispatcher doesn't start after a sudden power faliure.

Stop you MMC so that it turns grey colour.

Now Goto start>run>write services.msc-->now look for SQL Server(MSSQLSERVER) services and just stop and restart it.

Now start your MMC.I am sure it will start.

Note: This is for your case i.e SQL database.

PS: Do let me know your result.

Regards,

Ashutosh

[Former Member]

Thank you alot Mr. Ashutosh and all you Gentelmen.

[Former Member]

Hello,

Please paste the following log files for further investigation:

1. dev_disp

2. dev_ms

3. dev_w0

Do mention the date/time when the problem happened.

Best regards,

Warren

[Former Member]

Hi

1 .Please check your database is it opened properly.

select status from V$Instance;

result shall be "open".

if not you have to do a recovery.

Simply

recover database;

2.Look for alertsid.log file under saptrace.

3.Look for error in th event log.

4.Ensure that all of the systems processes have stopped.

If necessary, run the files kill.sap and shutdown.sap in the SAP System

Delete file sapstart.sem.

5 .If problems still occur, search for error notes in the following files: sapstart.log, sapstart<no>.trc, strerr<no>, stdout<no>, dev_disp,dev_w<no>, dev_ms.

6.If nothing works.Stop sap /oracle properly and then restart windows.Then try to start oracle first and then sap.

hope it help

Regards

Amit