----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
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
Restarting dead background process MMON
Fri Jun 21 07:23:20
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
Restarting dead background process MMON
Fri Jun 21 07:26:20
MMON started with pid=15, OS id=4652
Fri Jun 21 07:26:21
Starting background process SMCO
Fri Jun 21 07:26:21
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
Restarting dead background process SMCO
Fri Jun 21 07:42:23
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
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
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
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
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各进程会有相互通讯的机制
如果觉得《oracle杀掉pmon进程的影响 11g_测试kill杀死 background process后台进程与alert》对你有帮助，请点赞、收藏，并留下你的观点哦！
