Tuesday, 9 December 2014

ORA-00445: PMON FAILED

connection to sqlplus is not working on one of the database.

alert log info is as follows.
ORA-00445: background process "J002" did not start after 120 seconds
Incident details in:
/u00/app/oracle/diag/rdbms/<sid>/<sid>/incident/incdir_31616/<sid>_cjq0_942322_i316
16.trc
Sat Dec 06 19:39:51 2014
PMON failed to acquire latch, see PMON dump
Mon Dec 08 18:36:34 2014
PMON failed to acquire latch, see PMON dump
Mon Dec 08 18:37:34 2014


Solutions:- 
       ipcs -m
       ipcs -r <id>

If PMON fails on startup, it’s almost always because of one of these conditions:

Leftover memory segments from a previous instance crash.

Incorrect environment parameter settings in SQL*Plus ($ORACLE_HOME, $ORACLE_SID).

Permission issues with the Oracle executables.

Not enough CPU/RAM resources for the startup to complete. 

No comments: