DB shutdown

[anvardheen_jabarullah]

Hi All,

In our HA server We want to bring down the full appliactions for the Maintenance activity. First I will bring down the applications and then cluster nodes.

How to stop DB?  Can We bring down by the following command "shutdown database" or any other method?

Also let me know how to check whether DB is up or not?

[Reagan · Accepted solution]

Hello

You need to provide more details regarding the OS and the database.

If this is Oracle database then from the SQL prompt you can issue :

shutdown immediate

As this is a cluster you can take the cluster resources offline.

Regards

RB

[anvardheen_jabarullah · Accepted solution]

Thanks for your prompt reply Benjamin.
Our server is Windows+Oracle PLATFORM

[Reagan · Accepted solution]

The cluster resources can be taken offline with the help of the cluster administrator.

If you only want to only stop SAP and Oracle manually then use SAP MMC to stop SAP and then connect to the database and stop the database as suggested.

Regards

RB

[anvardheen_jabarullah · Accepted solution]

Thanks.. is there any way to check whether DB is up or not?

[Reagan · Accepted solution]

1 - select name, open_mode from v$database;

2 - check for oracle processes at the OS level

3 - check the alert log whether the database has been shutdown or not.

Regards

RB

[anvardheen_jabarullah · Accepted solution]

As per your comments, in Oracle system I can bring down the DB by using the commant " sql*plus "/as sysdba" --> shutdown immediate"

What about in SQL db?

[Reagan · Accepted solution]

To the best of my knowledge when you stop SAP from SAP MMC the MSSQL database will also be stopped.

Regards

RB

[former_member45419]

HI Dheen,

pls refer this links for start/stop of msql in window platform,

https://websmp102.sap-ag.de/~form/sapnet?_SCENARIO=01100035870000000202&_SHORTKEY=011000358700007550...

Starting and Stopping the SQL Server (SAP Library - BC R/3 Database Guide: MS SQL Server)

Starting and Stopping the SQL Server - SAP/ MS SQL Server DBA in CCMS - SAP Library

Regards

Nayeem

[Former Member]

Hi,

For start/stop in windows and MSSQL follow the below link.

http://scn.sap.com/community/netweaver-administrator/blog/2012/05/14/start-and-stop-an-sap-central-i...

For the sequence you can follow below blog.

http://scn.sap.com/thread/1832882

You can also check the installation guide as the sequence is always given in there also.

Thanks

Rishi Abrol

[anvardheen_jabarullah]

Thanks Rishi...