PROCESS J000 And …

反映前台操作缓慢，部分用户无法登陆系统

Alertlog:

 

Thread 1 advanced to log sequence 26559
  Current log# 2 seq# 26559 mem# 0: /u01/oracle/oradata/koaprod/redo02.log
  Current log# 2 seq# 26559 mem# 1: /ekp/oradata/koaprod/redo02a.log
Tue Apr 15 10:58:45 2014
Process J000 died, see its trace file
Tue Apr 15 10:58:45 2014
kkjcre1p: unable to spawn jobq slave process
Tue Apr 15 10:58:45 2014
Errors in file /u01/oracle/admin/koaprod/bdump/koaprod_cjq0_3693.trc:

Tue Apr 15 10:58:56 2014
Process J000 died, see its trace file
Tue Apr 15 10:58:56 2014
kkjcre1p: unable to spawn jobq slave process
Tue Apr 15 10:58:56 2014
Errors in file /u01/oracle/admin/koaprod/bdump/koaprod_cjq0_3693.trc:

Tue Apr 15 11:00:08 2014
Process m000 died, see its trace file
Tue Apr 15 11:00:08 2014
ksvcreate: Process(m000) creation failed
Tue Apr 15 11:01:10 2014
Process m000 died, see its trace file
Tue Apr 15 11:01:10 2014
ksvcreate: Process(m000) creation failed
Tue Apr 15 11:02:11 2014
Process m000 died, see its trace file
Tue Apr 15 11:02:11 2014
ksvcreate: Process(m000) creation failed
Tue Apr 15 11:02:14 2014
Thread 1 advanced to log sequence 26560
  Current log# 3 seq# 26560 mem# 0: /u01/oracle/oradata/koaprod/redo03.log
  Current log# 3 seq# 26560 mem# 1: /ekp/oradata/koaprod/redo03a.log
Tue Apr 15 11:03:12 2014
Process m000 died, see its trace file
Tue Apr 15 11:03:12 2014
ksvcreate: Process(m000) creation failed
Tue Apr 15 11:04:13 2014
Process m000 died, see its trace file
Tue Apr 15 11:04:13 2014
ksvcreate: Process(m000) creation failed
Tue Apr 15 11:05:14 2014
Process m000 died, see its trace file
Tue Apr 15 11:05:14 2014
ksvcreate: Process(m000) creation failed
Tue Apr 15 11:06:15 2014
Process m000 died, see its trace file
Tue Apr 15 11:06:15 2014
ksvcreate: Process(m000) creation failed
Tue Apr 15 11:07:17 2014
Process m000 died, see its trace file
Tue Apr 15 11:07:17 2014
ksvcreate: Process(m000) creation failed
Tue Apr 15 11:08:18 2014
Process m000 died, see its trace file
Tue Apr 15 11:08:18 2014

 

------------------------------------------------------------------------------------

查看process和session未超出最大值

------------------------------------------------------------------------------------

 

 

参考以下文档处理：

PROCESS J000 And M000 Die (Îĵµ ID 790397.1) תµ½µ×²¿ 

--------------------------------------------------------------------------------

ÐÞ¸Äʱ¼ä:2013-3-2ÀàÐÍ:PROBLEM    
 

In this Document

 Symptoms
 Cause
 Solution
 References

--------------------------------------------------------------------------------

Applies to:
Oracle Server - Enterprise Edition - Version 10.2.0.1 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 29-Sep-2010***

Oracle Server Enterprise Edition - Version: 10.2.0.1 to 10.2.0.5

 

Symptoms
On 10.2 , similar error messages are reported in the alert.log:

Process J000 died, see its trace file
Wed Feb 25 14:24:40 2009
kkjcre1p: unable to spawn jobq slave process
Wed Feb 25 14:24:40 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_cjq0_9516.trc:
Wed Feb 25 15:00:22 2009
Process m000 died, see its trace file
Wed Feb 25 15:00:22 2009
ksvcreate: Process(m000) creation failed
Investigating the generated trace file, we find no more information reported rather than the following:

*** SERVICE NAME:(SYS$BACKGROUND) 2009-02-25 14:24:40.162
*** SESSION ID:(162.1) 2009-02-25 14:24:40.162
*** 2009-02-25 14:24:40.162
Process J000 is dead (pid=11564, state=3):Also, found that :

- pga_aggregate_target is set to a numeric value

and

- pre_page_sga is set to false

Cause
This is caused by lack of OS resources or incorrect configuration, where more memory is required and Operating system reaches the limits set.

Solution
* For Unix Platforms:

- run the HCVE script found in NOTE.250262.1 which is responsible to check for the OS resources and perform the suggested changes.

* For Windows platforms, 32 bit architecture:

- enable the /3GB switch in the boot.ini file, following the steps mentioned in Note 225349.1 - Address Windowing Extensions (AWE) or VLM on Windows Platforms