Oracle crash; "Instance terminated by PMON"
- Article Type: General
- Product: Aleph
- Product Version: 20
Problem Symptoms:
Oracle crashes. The Oracle alert.log shows:
1. "DBWR process terminated with error"
2. "Instance terminated by PMON"
Cause:
1. swap does not address Oracle requirements - it should be equal to the size of the RAM (in case RAM is between 2 and 16 GB).
2. kernel.shmmax is set to 2147483648 which is too small. Oracle requirements say:
Minimum of the following values:
-Half the size of the physical memory
-4GB - 1 byte
Resolution:
Have Oracle DBA set kernel.shmmax to 4G
Additional Information
Excerpt from Oracle alert log showing specific instance of crash:
Tue Jun 04 19:33:03 2013
Errors in file /exlibris/app/oracle/diag/rdbms/aleph20/aleph20/trace/aleph20_pmon_8120.trc:
ORA-00471: DBWR process terminated with error
Tue Jun 04 19:33:04 2013
Errors in file /exlibris/app/oracle/diag/rdbms/aleph20/aleph20/trace/aleph20_q001_20573.trc:
ORA-00471: DBWR process terminated with error
Tue Jun 04 19:33:06 2013
Errors in file /exlibris/app/oracle/diag/rdbms/aleph20/aleph20/trace/aleph20_j001_655.trc:
ORA-00471: DBWR process terminated with error
PMON (ospid: 8120): terminating the instance due to error 471
Instance terminated by PMON, pid = 8120 <------------
Tue Jun 04 19:33:11 2013
ORA-1092 : opitsk aborting process
Tue Jun 04 19:41:56 2013
Starting ORACLE instance (normal)
Category: System Management (500)
Subject: Oracle (500)
- Article last edited: 10/8/2013