Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

anyone seen this oracle error ORA-00472

Steven E. Protter
Exalted Contributor

anyone seen this oracle error ORA-00472

ORA-00472: PMON process terminated with error

I know,check metalink, but Oracle support has struck out on two tries and 6 business days here.

Database will not shut down on HP-UX 11.11(11i)

We thought it was triggered by a java patch from HP but the problem is coming up on servers that were not patched.

Oracle 8.1.7.3 64 bit. HP-UX 11.11 December or July Patch set(as in both)

Steve

Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
4 REPLIES
Volker Borowski
Honored Contributor

Re: anyone seen this oracle error ORA-00472

Hi Steve,

I searched SAP-NET:

ORA 47* usually is a followup error.
Check the alertlog, if an additional (other) error occurs right before the 0047*. (Note 541695)

An other one says Veritas Cluster is fireing "kill -9" in error (Note 308880)

I have two Notes suggesting nfiles and ninode Kernelparameter beinig too small (which sounds most likely to mee) (Note 9748 and 37347).

To check, do a
sar -v 1 10
and if the used/max ratio is high, go for higher values.

Check if you have trace-files, which give you further information.

Hope this helps
Volker

Sean OB_1
Honored Contributor

Re: anyone seen this oracle error ORA-00472

FYI:

root@openview:/root # oerr ora 00472
00472, 00000, "PMON process terminated with error"
// *Cause: The process cleanup process died
// *Action: Warm start instance
root@openview:/root #

I have no experience with this but thought I'd post the error detail.
Rita C Workman
Honored Contributor

Re: anyone seen this oracle error ORA-00472

Go and check the trace files for that process. It should give you some info on what is happening..remember..the trace file may also point you to another background process. You may need to follow the path until you get back to the original/root process that could have initiated the failure.

Just a thought,
Rita
Printaporn_1
Esteemed Contributor

Re: anyone seen this oracle error ORA-00472

Hi,

This is general error better check PMON alert log.
if still cannot find anyhing
add this:
event = "472 trace name context forever,level 2"
to init.ora then start instance.
next error will give you more information in alert and PMON log.
enjoy any little thing in my life