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 APRIL 12, 2022
Applies to:
Oracle Exadata Storage Server Software - Version 11.2.2.4.2 and laterInformation 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 |