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
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:
Post a Comment