stopsap and db_offline

[Former Member]

Dear All,

I'm running a database structure check right now.

Database is online but SAP instance was not started.

Question:

If I issue a stopsap command, will it also trigger

db_offline command for database?

This is because when our server is shutdown on

os level, it calls stopsap.

I need to be able to verify if stopsap can stop the

database properly even if SAP is not started.

Thank you very much!

Regards,

Rayel

[debasissahoo · Accepted solution]

Hi Rayel,

Yes, it should stop the database if the Central instance and SCS are already down.

http://help.sap.com/saphelp_nw04/helpdata/en/70/b38937809c8f71e10000009b38f842/frameset.htm

Regards,

Debasis.

[Former Member]

hi

stopsap all -> make sure that the R/3 Instance and Oracle Database stopped

startsap all -> make sure that the R/3 Instance and Oracle Database started

you can stop the individual instances using the following commands

stopsap r3<instance name>

stopsap j2ee<instance name>

If the Oracle Database is not started, tried using SAPDBA

startup/shitdown databse instance.

Regards

Bharathi.Ch

[Former Member]

hi,

it depends on the operating system that you are working. if you are in UNIX, stopsap cmd will stop sap instance and database also but in windows: stopsap name=<sid> nr=00 sapdiahost=<hostname> will stop only sap application server but not database.

regards,

niranjan

[sunny_pahuja2]

Hi,

Yes, stopsap stop database as well. If you don't want to stop the database then use stopsap r3

Thanks

Sunny