DB-02 關閉流程

1. 停機前需確認如下事宜
1.1 Check ths status of updates using TX:SM13
1.2 Check which users are still logged on to ths system using TX:SM04
(可用sm02發停機訊息)
1.3 Check if background job are schedule or still running using TX:SM37
1.4 若SAP安裝在muti-instance上,要停central instance前需先停dailog instance

2. The Stopsap script is called as the <SID>adm user.

3. First the script stops the sapstat process. To do that, it calls the following command:
kill -2 <sapstartPID>
This command is stored in the kill.sap file, which is located in the following directory after the instance has been started:
/usr/sap/<SID>/<InstanceName>/work/kill.sap
Because all SAP process are child processes of sapstart, these processes are stopped as well. The -2 option ensures a "soft shutdown"; that is, it ensures that SAP process are stopped in a controlled manner. Of course, when the SAPWP are stoped, the associated Oracleshadow processws stop as well.  

4. Then, the stopsap script starts, which halts the DB.

5. For this perpose, an SQL file(stopdb.sql) is generated in the home directory of the <SID>adm user. This file contains all Oralce commands required to stop the DB; These commands are executed in the following two qlplus sessions.

6. In the first session, a long switch is forced in order to be able to archive all relevant changes that originate from the SAP system.

7. In the second session, the DB is shutdown using tge shutdown immediate command. First, this initiates the ALTER DATABASE CLOSE NORMAL process, which closes the online redo logs and data files. That process is follow by a ALTER DATABASE DISMOUNT process, which closes the control files and thus terminates all connections that exist between the processes and files.

8. The last step stops the Oracle background processes. Finally, the sqlplus session stops.

9. Oralce Listener 需手動停止, switch user to ora<SID> 然后執行 listener stop.

10. SAP OS Collector is n't stopped by the stopsap script. if necessary, the administrator must stop it manually. To do that, the <SID>adm user must enter the following command:
saposcol -l