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/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- linux殺死後臺程式Linux
- Mac檢視和殺死後臺程式Mac
- 將程式在後臺執行和殺掉後臺的程式
- 殺死Haskell的人也可能殺死Rust · GitHubHaskellRustGithub
- Linux基礎命令---殺死程式pkillLinux
- Linux基礎命令---殺死程式killallLinux
- Linux基礎命令—殺死程式pkillLinux
- 後臺獲取(Background Fetch) – HTTP 203 AdventHTTP
- 「跳一跳」兩年後，廣告“殺死”遊戲小程式？遊戲
- 網站後門查殺檢測與清除網站
- 這個殺手不太冷-kill家族
- 按照名字殺死程式的四種方法
- 殺死8080埠
- 初探免殺之路——免殺方法測試
- 【oracle 殺死繁忙程式 ORA-00054】實驗Oracle
- 最新的AI會“殺死”程式設計嗎？AI程式設計
- 測試平臺後端優化後端優化
- 【PWA學習與實踐】(8)使用Service Worker進行後臺同步 – Background Sync
- 【PWA學習與實踐】(8)使用Service Worker進行後臺同步 - Background Sync
- Mysql使用kill命令解決死鎖問題MySql
- 後端測試與 SDK 測試哪個前景更好？後端
- ORA-00445: background process "J000" did not start after 120 seconds
- Windows中殺死佔用某個埠的程式Windows
- dotnet core系列之Background tasks with hosted services (後臺任務)
- 簡述top命令與結束程式kill命令
- 測試已死，我看未必
- 036 Rust死靈書之Vec的完整程式碼測試Rust
- 《Android惡意程式碼分析與滲透測試》讀後感Android
- linux 檢視程式 kill程式Linux
- “我想殺死兩個孩子再自殺”產後抑鬱的媽媽有多可怕！
- 星海後臺測試平臺社群版正式釋出
- Java應用上雲後被kill問題分析與解決Java
- 程式命令ps/top/kill
- 網站安全檢測 對帝國CMS程式碼的後臺功能性安全測試網站
- 殺死那個遊戲公司遊戲
- 直播軟體開發，Android實現根據程式名殺死特定程式Android
- kill與pkill的區別
- 甭做啦，軟體測試已死……
- kill 已啟動的程式