oracle10g m000,oracle僵死Process m000 died,J000 died

今天无意执行了一个脚本，后来发现kill了j000和m000的进程，oracle被僵死在那里，j000是job的守护进程，m000是MMON进程启动的从属平行进程，都是轻量级但不容忽视！[oracle@orazhang bdump]$ echo $ORACLE_SIDorcl[oracle@orazhang bdump]$ sqlplus / as sysdbaSQL*Plus: Releas..

初识CV

446人浏览 · 2021-04-03 15:40:49

初识CV · 2021-04-03 15:40:49 发布

今天无意执行了一个脚本，后来发现kill 了j000和m000的进程，oracle被僵死在那里，j000是job的守护进程，m000是MMON进程启动的从属平行进程，都是轻量级但不容忽视！

[oracle@orazhang bdump]$ echo $ORACLE_SID

orcl

[oracle@orazhang bdump]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on 星期三 6月 15 14:04:33 2011

Connected to an idle instance.

idle> exit

Disconnected

[oracle@orazhang bdump]$ ps -ef|grep ora_

oracle 3453 1 0 Jun13 ? 00:00:00 ora_pmon_orcl

oracle 3455 1 0 Jun13 ? 00:00:00 ora_psp0_orcl

oracle 3457 1 0 Jun13 ? 00:00:00 ora_mman_orcl

oracle 3459 1 0 Jun13 ? 00:00:01 ora_dbw0_orcl

oracle 3461 1 0 Jun13 ? 00:00:02 ora_lgwr_orcl

oracle 3463 1 0 Jun13 ? 00:00:00 ora_ckpt_orcl

oracle 3465 1 0 Jun13 ? 00:00:03 ora_smon_orcl

oracle 3467 1 0 Jun13 ? 00:00:00 ora_reco_orcl

oracle 3469 1 0 Jun13 ? 00:00:01 ora_cjq0_orcl

oracle 3471 1 0 Jun13 ? 00:00:00 ora_mmon_orcl

oracle 3473 1 0 Jun13 ? 00:00:00 ora_mmnl_orcl

oracle 3475 1 0 Jun13 ? 00:00:00 ora_d000_orcl

oracle 3477 1 0 Jun13 ? 00:00:00 ora_s000_orcl

oracle 3485 1 0 Jun13 ? 00:00:00 ora_arc0_orcl

oracle 3487 1 0 Jun13 ? 00:00:00 ora_arc1_orcl

oracle 3491 1 0 Jun13 ? 00:00:00 ora_qmnc_orcl

oracle 3673 1 0 Jun13 ? 00:00:00 ora_q000_orcl

oracle 3677 1 0 Jun13 ? 00:00:00 ora_q001_orcl

oracle 29600 29164 0 14:04 pts/0 00:00:00 grep ora_

[oracle@orazhang bdump]$ tail alert_orcl.log -n 100

Thread 1 advanced to log sequence 20

Thread 1 opened at log sequence 20

Current log# 5 seq# 20 mem# 0: /u01/app/oracle/oradata/ORCL/onlinelog/redo5.log

Current log# 5 seq# 20 mem# 1: /u01/app/oracle/flash_recovery_area/ORCL/onlinelog/redo5.log

.........省略......

Wed Jun 15 13:59:57 2011

Process J000 died, see its trace file

Wed Jun 15 13:59:57 2011

kkjcre1p: unable to spawn jobq slave process

Wed Jun 15 13:59:57 2011

Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_cjq0_3469.trc:

Process J000 died, see its trace file

Wed Jun 15 14:00:03 2011

kkjcre1p: unable to spawn jobq slave process

Wed Jun 15 14:00:03 2011

Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_cjq0_3469.trc:

Wed Jun 15 14:00:55 2011

Process m000 died, see its trace file

Wed Jun 15 14:00:55 2011

ksvcreate: Process(m000) creation failed

Wed Jun 15 14:01:39 2011

Process J000 died, see its trace file

Wed Jun 15 14:01:39 2011

kkjcre1p: unable to spawn jobq slave process

Wed Jun 15 14:01:39 2011

Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_cjq0_3469.trc:

Wed Jun 15 14:01:56 2011

Process m000 died, see its trace file

Wed Jun 15 14:01:56 2011

ksvcreate: Process(m000) creation failed

Wed Jun 15 14:02:57 2011

Process m000 died, see its trace file

Wed Jun 15 14:02:57 2011

ksvcreate: Process(m000) creation failed

Wed Jun 15 14:03:58 2011

Process m000 died, see its trace file

Wed Jun 15 14:03:58 2011

ksvcreate: Process(m000) creation failed

Wed Jun 15 14:04:59 2011

Process m000 died, see its trace file

Wed Jun 15 14:04:59 2011

ksvcreate: Process(m000) creation failed

[oracle@orazhang bdump]$

[oracle@orazhang bdump]$ cat /u01/app/oracle/admin/orcl/bdump/orcl_cjq0_3469.trc

/u01/app/oracle/admin/orcl/bdump/orcl_cjq0_3469.trc

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1

System name: Linux

Node name: orazhang

Release: 2.6.18-53.el5xen

Version: #1 SMP Wed Oct 10 17:06:12 EDT 2007

Machine: i686

Instance name: orcl

Redo thread mounted by this instance: 1

Oracle process number: 10

Unix process pid: 3469, image: oracle@orazhang (CJQ0)

*** SERVICE NAME:(SYS$BACKGROUND) 2011-06-15 13:59:57.946

*** SESSION ID:(162.1) 2011-06-15 13:59:57.946

*** 2011-06-15 13:59:57.946

Process J000 is dead (pid=29552, state=3):

*** 2011-06-15 14:00:03.954

Process J000 is dead (pid=29556, state=3):

*** 2011-06-15 14:01:39.960

Process J000 is dead (pid=29574, state=3):

[oracle@orazhang bdump]$ ipcs -sa

------ Shared Memory Segments --------

key shmid owner perms bytes nattch status

0x00000000 0 oracle 640 1258295296 18 dest

0x00000000 32769 oracle 600 393216 2 dest

0x00000000 65538 oracle 600 393216 2 dest

0x00000000 98307 oracle 600 393216 2 dest

0x00000000 131076 oracle 600 393216 2 dest

0x00000000 163845 oracle 600 393216 2 dest

0x00000000 196614 oracle 600 393216 2 dest

0x00000000 229383 oracle 600 393216 2 dest

0x00000000 262152 oracle 600 393216 2 dest

0x00000000 294921 oracle 600 393216 2 dest

0x00000000 393226 oracle 600 393216 2 dest

0x00000000 360459 oracle 600 393216 2 dest

------ Semaphore Arrays --------

key semid owner perms nsems

0xf5d4b884 98304 oracle 640 154

------ Message Queues --------

key msqid owner perms used-bytes messages

[root@orazhang ~]# killall -9 -r "ora_*"

[root@orazhang ~]# ps -ef|grep ora_

root 29973 29760 0 15:06 pts/0 00:00:00 grep ora_

[root@orazhang ~]# ipcs -as

------ Shared Memory Segments --------

key shmid owner perms bytes nattch status

0x00000000 32769 oracle 600 393216 2 dest

0x00000000 65538 oracle 600 393216 2 dest

0x00000000 98307 oracle 600 393216 2 dest

0x00000000 131076 oracle 600 393216 2 dest

0x00000000 163845 oracle 600 393216 2 dest

0x00000000 196614 oracle 600 393216 2 dest

0x00000000 229383 oracle 600 393216 2 dest

0x00000000 262152 oracle 600 393216 2 dest

0x00000000 294921 oracle 600 393216 2 dest

0x00000000 393226 oracle 600 393216 2 dest

0x00000000 360459 oracle 600 393216 2 dest

------ Semaphore Arrays --------

key semid owner perms nsems

0xf5d4b884 98304 oracle 640 154

------ Message Queues --------

key msqid owner perms used-bytes messages

sql > startup

ORACLE instance started.

Total System Global Area 1258291200 bytes

Fixed Size 1219184 bytes

Variable Size 385877392 bytes

Database Buffers 855638016 bytes

Redo Buffers 15556608 bytes

Database mounted.

Database opened.

打赏

微信扫一扫，打赏作者吧～

魔乐社区

魔乐社区（Modelers.cn) 是一个中立、公益的人工智能社区，提供人工智能工具、模型、数据的托管、展示与应用协同服务，为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作，由全产业链共同建设、共同运营、共同享有，推动国产AI生态繁荣发展。

更多推荐

全家桶集齐！Qwen3.5四款小模型上线魔乐社区，附昇腾全套实践教程

魔乐社区

Pont - 搭建前后端之桥：高效、灵活的接口管理工具

Pont 是一款强大的数据服务层解决方案，它能够帮助开发者快速搭建前后端之间的桥梁，实现接口的高效管理和代码自动生成。无论是新手还是有经验的开发者，都能通过 Pont 轻松处理接口文档、生成类型安全的 API 代码，从而显著提升开发效率。[![Pont 工具标志](https://raw.gitcode.com/gh_mirrors/po/pont/raw/3f1b7d4bbba3fd2dda