ORA-00472 disconnects from oracle database
Posted on 1998-06-18
I am running Oracle7 version 188.8.131.52.0 ( Sqlnet v2.3) on a Compaq Proliant 6000 running Windows NT4 Server. Over the last three weeks I have had three occurances of sudden disconnects from the database by all clients. When you attempt to relog in you get a read failure. The error that is reported is ORA-00472 which the error documentation states as the following:
ORA-00472 PMON process terminated with error
Cause: The Process Monitor process terminated abnormally.
Action: Check the accompanying messages, if any, and the background process trace file. Correct the problem mentioned in the other messages. Then shut down and restart the instance. If the trace file mentions any other background process messages, check the trace file for the mentioned process until the root message is found.
Copyright (C) 1995, Oracle Corporation
The only thing I can do is cycle the server. Any ideas on what is causing it ??? On two of the three occasions a backup/verify was in progress (Backup Exec v7 - Oracle Addon forthcoming) but backups are run every day and this has only occurred three times.
When you look in the event log you see many lines like these:
6/17/98 2:06:21 AM ORACLE7.orcl Warning None 16 N/A NSCC Instance orcl has been terminated.
6/16/98 2:04:20 AM ORACLE7.orcl Error None 23 N/A NSCC ReadFile() failure.
I know virtually nothing about Oracle but I would like to correct/avoid this problem.
Any help would be appreciated.