oracle杀掉pmon进程的影响,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各进程会有相互通讯的机制