Dispatcher not started with startsap.exe

[Former Member]

HI

We are editing 2 scripts to work on starting & stopping SAP service for daily backup without OS reboot (on a 2003 windows server).

The sequence we tried in the starting sap script is :

STOP SQL*Plus ->STOP Oracle Listener ->OracleService->SAPOSCOL ->startsap

We thought startsap can intrigue the start of Oracle DB & Oscol but obviously we have to first start these 2 servcies 1st (then only starting instances from MMC works)

However, with the command "startsap", the instance could be started but the Disp+Work wp ends in STOPPED status after trying running for a while. The Msg_server & igsdw could be staretd without problem.

Upon checking from the MMC, the instance is shown in yellow color.

(Does it have anything to do with the sapstartsrv.exe running as we can't kill this service)

Please advice for solutions.

Thanks in advance

[lakshminarayanan_m · Accepted solution]

Hi,

U cane check with this script to take offilne backup

____________________________________________________________

stopsap name=SID nr=** SAPDIAHOST=HOSTNAME

sqlplus.exe /nolog <shutdown.sql

brbackup -u / -t offline_force -c -v TAPE-ID -p Backupprofileid(initsid.sap)

startsap name=SID nr=** SAPDIAHOST=HOSTNAME

_____________________________________________________________

copies this script in the notepad and save it batch file. If u need , u can schedule.

Try it and reply.

Regards

MLN

[Former Member]

Hi,

dispatcher is in yellow colour becuase oracle is not up.

so after oracle DB start, you go ahead with the startsap pf=<instance profile> .

Check and let us know.

Thanks

R.

[Former Member]

I thought Net Start OracleServicexxx was for starting the oracle?

Also, by specifying the pf, do you mean sapstart pf=... ?

we ahven't got to try sapstart coz we thought startsap could do the trick.

1 mroe question : we have 1 central instance 00 and one more 10, does the starting sequence matter?

Thanks

[Former Member]

Hi,

Yes, Of course starting sequence matters. You need to start DB, CI and then try to start DI.

Thanks!

Sundaresh Suryanarayan

[Former Member]

Sorry for this simple question

How do I confirm DB is up ?

I mean, by bringing OracleService<SID> up, does it mean DB is started?

Or I have to check with sqlplus as usual?

[Former Member]

Run R3trans -d

If the connection to database is established, then server is up , or trans.log will give you complete status.