Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: log in database problem
PMON (Process Monitor) is a mandatory process. Something has caused it to
hang up its boots. There should be a trace file, + comments in the alert
log to identify why this happened. If PMON or any of the mandatory
processes die, you need to restart the database (as you've done) to fix the
problem. Stopping / restarting the listener will have no effect. Find out
why PMON died from the trace file, and address that problem.
Hope this helps.
Pete
chou wrote:
> In Oracle8 8.03 for WinNT, user tried to log in and got error message :
> ORA-00472:PMON process terminated with error.
>
> If I stopped the database and listner and then restarted the listner and
> database,
> It could work again. What problem will cause this error ?
--
Regards
Pete
Peter Sharman Email: psharman_at_us.oracle.com WISE Course Development Manager Phone: +1.650.607.0109 (int'l) Worldwide Internal Services Education (650)607 0109 (local)San Francisco
"Controlling application developers is like herding cats."
Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!"
Bruce Pihlamae, long term ORACLE DBA