My Oracle Support Banner

Database hangs after adding more instances but not changing Huge Page configuration : Process W001 Died, Process J000 Died Instance Unreachable (Doc ID 1448833.1)

Last updated on AUGUST 22, 2023

Applies to:

Oracle Exadata Storage Server Software - Version 11.2.2.4.2 and later
Information in this document applies to any platform.

Symptoms

Users are unable to log into the database which had previously been reachable
CRS cannot communicate between instances
CRS shows as up
Instances show as up

Further review in the ALERT.LOG show processes dying
- no hard errors are seen in any logfiles


From the ALERT.LOG
------------------------------------------
Thu Apr 05 04:05:22 2012
Process W001 died, see its trace file
Process W001 died, see its trace file
Process W001 died, see its trace file
Thu Apr 05 04:10:27 2012
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /u01/app/oracle/diag/rdbms/prod/prod1/trace/proddb_cjq0_11131.trc:
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /u01/app/oracle/diag/rdbms/prod/prod1/trace/proddb_cjq0_11131.trc:
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /u01/app/oracle/diag/rdbms/prod/prod1/trace/proddb1_cjq0_11131.trc:



In our users problem two of their 4 instances are now unreachable:

Changes

Recently implemented Huge Pages
Recently added instances

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.