ORA-00443: background process "CJQ0" did not start

[benoit-schmid]

Hello,

On one insrtance, after an offline backup, when it is started I sometime have the following error:

---

Trace file /oracle/TST/saptrace/diag/rdbms/tst/TST/trace/TST_pmon_29640.trc

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORACLE_HOME = /oracle/TST/112_64

System name: SunOS

Node name: xxx

Release: 5.10

Version: Generic_144488-06

Machine: sun4u

Instance name: TST

Redo thread mounted by this instance: 1

Oracle process number: 2

Unix process pid: 29640, image: oracle@xxx (PMON)

• 2011-11-06 00:04:59.137

• SESSION ID:(27.1) 2011-11-06 00:04:59.137

• CLIENT ID:() 2011-11-06 00:04:59.137

• SERVICE NAME:(SYS$BACKGROUND) 2011-11-06 00:04:59.137

• MODULE NAME:() 2011-11-06 00:04:59.137

• ACTION NAME:() 2011-11-06 00:04:59.137

-

---

Trace Bucket Dump Begin: default bucket for process 2 (osid: 29640, PMON)

TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA

-

---

2011-11-06 00:04:59.135620 :80000CE8:db_trace:ksb.c@2305:ksbs1p_real(): [10254:2:27] KSBS1P: process PMON trying to start background CJQ0

2011-11-06 00:04:59.135624 :80000CE9:db_trace:ksb.c@2369:ksbs1p_real(): [10254:2:27] KSBS1P: process PMON obtained PR enqueue to start background CJQ0

2011-11-06 00:04:59.136336 :80000CF2:db_trace:ksb.c@2503:ksbs1p_real(): [10254:2:27] KSBS1P: creation error posted OER(1089)

2011-11-06 00:04:59.136355 :80000CF4:db_trace:ksb.c@2572:ksbs1p_real(): [10254:2:27] KSBS1P: out of loop: process did not start

-

---

Trace Bucket Dump End: default bucket for process 2 (osid: 29640, PMON)

ORA-00443: background process "CJQ0" did not start

ORA-00450: background process 'CJQ0' did not start

ORA-00443: background process "CJQ0" did not start

---

The error is not systematic.

When I saw it the first time, I restarted the DB and got no error.

1. Would you why I got this error?

2. Would you know how to avoid having this problem?

Thanks in advance for your answer.

[former_member188883]

Hi,

ora_cjq0 : The Job Queue process is used for batch processing u2013 running user jobs within a scheduler service. Able to run a large number of concurrent jobs, the coordinator process (cjq0) will spawn job queue slaves (jnnn) to actually run the jobs.

Reasons for this process not being starting could Os bug or some database bugs. Can you check whether you have applied latest oracle bug fixes on your database .

Also look at reducing the parameter value pga_aggregate_target and check the results.

Regards,

Deepak Kori

[benoit-schmid]

Hello,

> Reasons for this process not being starting could Os bug or some database bugs. Can you check whether you have applied latest oracle bug fixes on your database .
> 
> Also look at reducing the parameter value pga_aggregate_target  and check the results.
> 
> Regards,
> Deepak Kori

It is a recent 11.2.0.2 install.

We have 5 Oracle DB running with this version.

I only have this on a specific instance.

There fore patch level should be ok.

Why are you suggesting to reducue pga_aggregate_target?

By the way, I have the same PGA size on my DEV system.

On my DEV I have never had this error.

// grep -i pga /oracle/DEV/112_64/dbs/initDEV.ora

*.pga_aggregate_target=1G

// grep -i pga /oracle/TST/112_64/dbs/initTST.ora

*.pga_aggregate_target=1G

Thanks in advance for your answer.

[benoit-schmid]

Hello,

I have also noticed that the job_queue_process is set to 1000 by default on Oracle 11.2.

It used to be set to 1 in my 10.2 dbs.

Would you think it could be linked to my error messages?

Thanks in advance for your answer.

[former_member188883]

Hi,

You seem to be in the right direction. Please check by reducing the value of job_queue_process = 1.

Regards,

Deepak Kori

[benoit-schmid]

Hello,

Why were you suggesting to reduce the pga size?

Thanks in advance for your answer.

[former_member188883]

Hi,

I came across some oracle forums with similar issues. In one of the forums such a solution was suggested and problem was resolved .

Hope your problem is resolved.

Regards,

Deepak Kori

[benoit-schmid]

Hello,

And why do you think that job_queue_process = 1 should help?

Thanks in advance for your answer.

[former_member188883]

Hi,

This again I got hooked to a oracle forum with similar issue. Such a information was published over there.

Regards,

Deepak Kori

[benoit-schmid]

Hello,

Unfortunately the error still occurs after this change.

Regards,

[Former Member]

Hello Benoît Schmid , do you find the root cause of this error ?

[benoit-schmid]

Hello,

I have not found the cause of this error that regularly occurs at startup.

Regards,