11g_測試kill殺死 background process後臺程式與alert
----oracle後臺程式
-bash-3.2$ ps -ef|grep ora_
oracle 4079 1 0 04:30 ? 00:00:05 ora_pmon_zxy
oracle 4081 1 0 04:30 ? 00:00:03 ora_vktm_zxy
oracle 4085 1 0 04:30 ? 00:00:01 ora_gen0_zxy
oracle 4087 1 0 04:30 ? 00:00:02 ora_diag_zxy
oracle 4089 1 0 04:30 ? 00:00:01 ora_dbrm_zxy
oracle 4091 1 0 04:30 ? 00:00:01 ora_psp0_zxy
oracle 4093 1 0 04:30 ? 00:00:06 ora_dia0_zxy
oracle 4095 1 0 04:30 ? 00:00:01 ora_mman_zxy
oracle 4097 1 0 04:30 ? 00:00:03 ora_dbw0_zxy
oracle 4099 1 0 04:30 ? 00:00:02 ora_lgwr_zxy
oracle 4101 1 0 04:30 ? 00:00:06 ora_ckpt_zxy
oracle 4103 1 0 04:30 ? 00:00:01 ora_smon_zxy
oracle 4105 1 0 04:30 ? 00:00:00 ora_reco_zxy
oracle 4107 1 0 04:30 ? 00:00:05 ora_mmon_zxy
oracle 4109 1 0 04:30 ? 00:00:12 ora_mmnl_zxy
oracle 4111 1 0 04:30 ? 00:00:00 ora_d000_zxy
oracle 4113 1 0 04:30 ? 00:00:00 ora_s000_zxy
oracle 4121 1 0 04:30 ? 00:00:00 ora_arc0_zxy
oracle 4123 1 0 04:30 ? 00:00:00 ora_arc1_zxy
oracle 4125 1 0 04:30 ? 00:00:00 ora_arc2_zxy
oracle 4127 1 0 04:30 ? 00:00:00 ora_arc3_zxy
oracle 4129 1 0 04:30 ? 00:00:00 ora_qmnc_zxy
oracle 4141 1 0 04:30 ? 00:00:00 ora_q000_zxy
oracle 4143 1 0 04:30 ? 00:00:00 ora_q001_zxy
oracle 4153 1 0 04:35 ? 00:00:01 ora_smco_zxy
oracle 4520 1 0 07:05 ? 00:00:00 ora_w000_zxy
oracle 4537 2586 0 07:11 pts/0 00:00:00 grep ora_
---手工殺掉pmon程式
-bash-3.2$ kill -9 4079
---實時檢視alert
Fri Jun 21 07:11:24 2013
MMON (ospid: 4107): terminating the instance due to error 472
Instance terminated by MMON, pid = 4107
--由上可知手工kill pmon後,mmon程式強制關閉了db instance
---mmon程式是什麼呢?
MMON
Manageability Monitor Process --用於管理性任務的一個程式
Performs or schedules many manageability tasks
主要收集awr快照和addm任務的
MMON performs many tasks related to manageability, including taking Automatic Workload Repository snapshots and performing Automatic Database Diagnostic Monitor analysis.
--參考:
oracle後臺程式介紹可以參考:
小結:1,pmon程式異常資料庫直接會強制關閉
2,pmon異常後,由mmon強制把資料庫例項關閉
--如果先殺掉mmon,然後kill pmon情況如何呢
----查詢後臺程式列表
-bash-3.2$ ps -ef|grep ora_
oracle 4563 1 0 07:21 ? 00:00:00 ora_pmon_zxy
oracle 4565 1 0 07:21 ? 00:00:00 ora_vktm_zxy
oracle 4569 1 0 07:21 ? 00:00:00 ora_gen0_zxy
oracle 4571 1 0 07:21 ? 00:00:00 ora_diag_zxy
oracle 4573 1 0 07:21 ? 00:00:00 ora_dbrm_zxy
oracle 4575 1 0 07:21 ? 00:00:00 ora_psp0_zxy
oracle 4577 1 0 07:21 ? 00:00:00 ora_dia0_zxy
oracle 4579 1 0 07:21 ? 00:00:00 ora_mman_zxy
oracle 4581 1 0 07:21 ? 00:00:00 ora_dbw0_zxy
oracle 4583 1 0 07:21 ? 00:00:00 ora_lgwr_zxy
oracle 4585 1 0 07:21 ? 00:00:00 ora_ckpt_zxy
oracle 4587 1 0 07:21 ? 00:00:00 ora_smon_zxy
oracle 4589 1 0 07:21 ? 00:00:00 ora_reco_zxy
oracle 4591 1 1 07:21 ? 00:00:00 ora_mmon_zxy
oracle 4593 1 0 07:21 ? 00:00:00 ora_mmnl_zxy
oracle 4595 1 0 07:21 ? 00:00:00 ora_d000_zxy
oracle 4597 1 0 07:21 ? 00:00:00 ora_s000_zxy
oracle 4605 1 0 07:21 ? 00:00:00 ora_arc0_zxy
oracle 4607 1 0 07:21 ? 00:00:00 ora_arc1_zxy
oracle 4609 1 3 07:21 ? 00:00:01 ora_arc2_zxy
oracle 4611 1 0 07:21 ? 00:00:00 ora_arc3_zxy
oracle 4613 1 0 07:21 ? 00:00:00 ora_qmnc_zxy
oracle 4625 1 0 07:21 ? 00:00:00 ora_q000_zxy
---手工殺掉mmon
-bash-3.2$ kill -9 4591
---檢視alert,oracle會自動重啟mmon
Fri Jun 21 07:23:20 2013
Restarting dead background process MMON
Fri Jun 21 07:23:20 2013
MMON started with pid=15, OS id=4635
---第二次殺掉mmon
-bash-3.2$ kill -9 4635
---檢視alert,oracle會自動重啟mmon,但同時啟動了smco程式
Fri Jun 21 07:26:20 2013
Restarting dead background process MMON
Fri Jun 21 07:26:20 2013
MMON started with pid=15, OS id=4652
Fri Jun 21 07:26:21 2013
Starting background process SMCO
Fri Jun 21 07:26:21 2013
SMCO started with pid=26, OS id=4654
---smco程式是什麼呢?
SMCO
--一言而蔽之,負責空間分配與回收。它會動態按需生成子程式wnnn實施真正的工作
Space Management Coordinator Process
Coordinates the execution of various space management tasks
This background process coordinates the execution of various space management tasks,
including proactive space allocation and space reclamation. SMCO dynamically spawns
slave processes (Wnnn) to implement these tasks.
---我們殺掉smco會發生什麼
---查詢smco程式
-bash-3.2$ ps -ef|grep ora_smco
oracle 4654 1 0 07:26 ? 00:00:00 ora_smco_zxy
oracle 4696 2586 0 07:41 pts/0 00:00:00 grep ora_smco
---殺掉smco
-bash-3.2$ kill -9 4654
--oracle自動重啟smco
Fri Jun 21 07:42:23 2013
Restarting dead background process SMCO
Fri Jun 21 07:42:23 2013
SMCO started with pid=26, OS id=4700
----查詢oracle後臺程式列表
-bash-3.2$ ps -ef|grep ora_
oracle 4563 1 0 07:21 ? 00:00:00 ora_pmon_zxy
oracle 4565 1 0 07:21 ? 00:00:00 ora_vktm_zxy
oracle 4569 1 0 07:21 ? 00:00:00 ora_gen0_zxy
oracle 4571 1 0 07:21 ? 00:00:00 ora_diag_zxy
oracle 4573 1 0 07:21 ? 00:00:00 ora_dbrm_zxy
oracle 4575 1 0 07:21 ? 00:00:00 ora_psp0_zxy
oracle 4577 1 0 07:21 ? 00:00:01 ora_dia0_zxy
oracle 4579 1 0 07:21 ? 00:00:00 ora_mman_zxy
oracle 4581 1 0 07:21 ? 00:00:00 ora_dbw0_zxy
oracle 4583 1 0 07:21 ? 00:00:00 ora_lgwr_zxy
oracle 4585 1 0 07:21 ? 00:00:01 ora_ckpt_zxy
oracle 4587 1 0 07:21 ? 00:00:00 ora_smon_zxy
oracle 4589 1 0 07:21 ? 00:00:00 ora_reco_zxy
oracle 4593 1 0 07:21 ? 00:00:01 ora_mmnl_zxy
oracle 4595 1 0 07:21 ? 00:00:00 ora_d000_zxy
oracle 4597 1 0 07:21 ? 00:00:00 ora_s000_zxy
oracle 4605 1 0 07:21 ? 00:00:00 ora_arc0_zxy
oracle 4607 1 0 07:21 ? 00:00:00 ora_arc1_zxy
oracle 4609 1 0 07:21 ? 00:00:01 ora_arc2_zxy
oracle 4611 1 0 07:21 ? 00:00:00 ora_arc3_zxy
oracle 4613 1 0 07:21 ? 00:00:00 ora_qmnc_zxy
oracle 4625 1 0 07:21 ? 00:00:00 ora_q000_zxy
oracle 4632 1 0 07:22 ? 00:00:00 ora_q001_zxy
oracle 4652 1 0 07:26 ? 00:00:00 ora_mmon_zxy
oracle 4706 1 0 07:44 ? 00:00:00 ora_smco_zxy
oracle 4715 2586 0 07:45 pts/0 00:00:00 grep ora_
---手工殺掉dbwr
-bash-3.2$ kill -9 4581
---殺掉dbwr後,pmon強制關閉了資料庫例項
Fri Jun 21 07:45:52 2013
PMON (ospid: 4563): terminating the instance due to error 471
Instance terminated by PMON, pid = 4563
---檢視oracle後臺程式列表
-bash-3.2$ ps -ef|grep ora_
oracle 4729 1 0 07:47 ? 00:00:00 ora_pmon_zxy
oracle 4731 1 0 07:47 ? 00:00:00 ora_vktm_zxy
oracle 4735 1 0 07:47 ? 00:00:00 ora_gen0_zxy
oracle 4737 1 0 07:47 ? 00:00:00 ora_diag_zxy
oracle 4739 1 0 07:47 ? 00:00:00 ora_dbrm_zxy
oracle 4741 1 0 07:47 ? 00:00:00 ora_psp0_zxy
oracle 4743 1 0 07:47 ? 00:00:00 ora_dia0_zxy
oracle 4745 1 0 07:47 ? 00:00:00 ora_mman_zxy
oracle 4747 1 0 07:47 ? 00:00:00 ora_dbw0_zxy
oracle 4749 1 0 07:47 ? 00:00:00 ora_lgwr_zxy
oracle 4751 1 0 07:47 ? 00:00:00 ora_ckpt_zxy
oracle 4753 1 0 07:47 ? 00:00:00 ora_smon_zxy
oracle 4755 1 0 07:47 ? 00:00:00 ora_reco_zxy
oracle 4757 1 0 07:47 ? 00:00:00 ora_mmon_zxy
oracle 4759 1 0 07:47 ? 00:00:00 ora_mmnl_zxy
oracle 4761 1 0 07:47 ? 00:00:00 ora_d000_zxy
oracle 4763 1 0 07:47 ? 00:00:00 ora_s000_zxy
oracle 4771 1 0 07:47 ? 00:00:00 ora_arc0_zxy
oracle 4773 1 0 07:48 ? 00:00:00 ora_arc1_zxy
oracle 4775 1 0 07:48 ? 00:00:00 ora_arc2_zxy
oracle 4777 1 0 07:48 ? 00:00:00 ora_arc3_zxy
oracle 4779 1 0 07:48 ? 00:00:00 ora_qmnc_zxy
oracle 4792 1 0 07:48 ? 00:00:00 ora_q000_zxy
oracle 4794 1 0 07:48 ? 00:00:00 ora_q001_zxy
oracle 4796 1 0 07:48 ? 00:00:00 ora_q002_zxy
oracle 4808 2586 0 07:49 pts/0 00:00:00 grep ora_
---殺掉lgwr
-bash-3.2$ kill -9 4749
---lgwr死掉後,由pmon強制關閉了資料庫例項
Fri Jun 21 07:45:52 2013
PMON (ospid: 4563): terminating the instance due to error 471
Instance terminated by PMON, pid = 4563
---檢視並確認pmon
-bash-3.2$ ps -ef|grep ora_pmon
oracle 4985 1 0 07:56 ? 00:00:00 ora_pmon_zxy
oracle 5090 2586 0 08:03 pts/0 00:00:00 grep ora_pmon
-bash-3.2$ kill -9 4985
-bash-3.2$ ps -ef|grep ora_pmon
oracle 5093 2586 0 08:03 pts/0 00:00:00 grep ora_pmon
--殺掉pmon由gen0強制關閉資料庫例項
Fri Jun 21 08:03:57 2013
GEN0 (ospid: 4991): terminating the instance due to error 472
Instance terminated by GEN0, pid = 4991
---檢視gen0
-bash-3.2$ ps -ef|grep ora_|grep -v grep|grep gen
oracle 5113 1 0 08:08 ? 00:00:00 ora_gen0_zxy
-bash-3.2$ kill -9 5113
--殺掉gen0後由pmon強制關閉資料庫例項
Fri Jun 21 08:09:30 2013
PMON (ospid: 5107): terminating the instance due to error 495
Instance terminated by PMON, pid = 5107
小結:1,oracle除了pmon程式異常中斷後,由pmon強制關閉資料庫例項
2,arc相關的一些非關鍵程式,即使中斷不會導致例項關閉
3,如果異常中斷某些oracle程式,oracle有機制會自動重啟中斷的程式
4,oracle各程式會有相互通訊的機制
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9240380/viewspace-764547/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle11g_background process後臺程式詳解Oracle
- Mac檢視和殺死後臺程式Mac
- Android後臺殺死系列之三:後臺殺死原理LowMemoryKiller(4.3-6.0)Android
- Android後臺殺死系列之一:FragmentActivity及PhoneWindow後臺殺死處理機制AndroidFragment
- rhel5上面awk及xargs快速殺死kill程式
- 批量kill殺死某些會話session的plsql會話SessionSQL
- 【Kill】兩條Linux命令徹底殺死OracleLinuxOracle
- 殺死Oracle死鎖程式Oracle
- alert檔案中出現:Auto-tuning: Shutting down background process GTXd
- kill session的測試Session
- 殺死殭屍程式
- Android後臺殺死系列之四:Binder訃告原理Android
- Android後臺殺死系列之二:ActivityManagerService與App現場恢復機制AndroidAPP
- 將程式在後臺執行和殺掉後臺的程式
- 從OS中kill ORACLE死鎖程式Oracle
- Bug 3248886 - Continous 'restarting dead background process qmn0' message in alert.logREST
- oracle死鎖測試與解決Oracle
- 殺掉鎖死的程式
- 被後臺殺死後,Android應用如何重新走閃屏邏輯Android
- oracle 817 ora_snp background processOracle
- 利用pgrep批量kill殺死多個mysqld程式MySql
- 「跳一跳」兩年後,廣告“殺死”遊戲小程式?遊戲
- Ksvcreate:Process(xx) Creation Failed/ORA-00445:Background Process "xx"AI
- oracle殺死鎖表的程式Oracle
- 【sqlserver】殺掉所有死鎖程式SQLServer
- linux kill -9 的記錄,批量殺程式Linux
- Standby資料庫alert log報很多這樣的錯誤: Restarting dead background process QMN0資料庫REST
- 殺死Haskell的人也可能殺死Rust · GitHubHaskellRustGithub
- 網站後門查殺檢測與清除網站
- Java Process 阻塞測試總結Java
- 檢視並殺死殭屍程式
- SAP Basis: 從SAP GUI殺死程式GUI
- ORACLE中殺死鎖程式的方法Oracle
- oracle database Background Processes所有後臺程式 詳解資料/官方文件OracleDatabase
- Kill session 和orakill 殺會話及程式總結Session會話
- 初探免殺之路——免殺方法測試
- 測試平臺後端優化後端優化
- shell指令碼按照程式名稱殺死程式指令碼