Skip to Content
avatar image
Former Member

stopsap and db_offline

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 25, 2009 at 05:01 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 25, 2009 at 08:58 AM

    Hi,

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

    Thanks

    Sunny

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 25, 2009 at 02:20 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 30, 2009 at 07:08 AM

    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

    Add comment
    10|10000 characters needed characters exceeded