Cannot stop SAP database

[Former Member]

Hi,

after the failed attempt to make a client copy I cannot stop my SAP database (MaxDB):

stopsap hangs at the beginning on the first step

"Checking ADA db Database

-

---

"

stopdb ends with

"There are still active users connected to the database.

On order to shutdown the database with stopdb you first have to stop

database applications. This includes MCOD instances and database utilities."

So I have modified the stopdb as described in SAP Note 1148232.

stopdb finish now with

"There are still active users connected to the database.

On order to shutdown the database with stopdb you first have to stop

database applications. This includes MCOD instances and database utilities.

/usr/sap/<sid>/SYS/exe/run/stopdb: Terminating with error code 3"

--> error code 3 means "DB was running, could not be stopped"

What can I do in order to stop the database?

Thank you for help

Wilhelm

[markus_doehr2 · Accepted solution]

dbmcli -U c db_offline

Check note 1148232 - stopdb does not shut down database under Unix

Markus

[Former Member · Accepted solution]

Hi Markus,

the SAP note didn't help, but your command was the hit.

Thank you

Wilhelm

[markus_doehr2 · Accepted solution]

> the SAP note didn't help, but your command was the hit.

Did you apply the attached patches?

Markus

[Former Member · Accepted solution]

Did you apply the attached patches?

I have copied and pasted the attached version of stopdb. Result as written in my question

Wilhelm