Solved

ORA-00472 disconnects from oracle database

Posted on 1998-06-18
3
774 Views
Last Modified: 2012-08-14

I am running Oracle7 version 7.3.4.0.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.
0
Comment
Question by:scalpy
3 Comments
 

Expert Comment

by:dougier
ID: 1083176
Oracle will provide help with this.  

They will ask for your dump files and the configuration information.  The dump files will be in a location specified in the  config.ora (background_dump_dest).  

I've had similar problems with PMON etc.  In our case it was occuring regularly for no obvious reason when the DB was being accessed by a Visual Basic program using ODBC or when Designer/2000 was performing a reconciliation.  I was advised to turn off any multi thread server options I was using (init.ora parameters beginning with the letters "mts").  

Hope this is of some use!
0
 
LVL 3

Accepted Solution

by:
poncejua earned 50 total points
ID: 1083177
Hi,

If you're runing an export backup in shared mode, probably the lock manager is failing, probably due to insufficient resources. Reference the readmedlm.doc under $ORACLE_HOME/pso/doc/readmedlm.doc. This document
gives a formula to correctly calculate the number of lock manager resources which need to be specified when starting the DLM on each node.


0
 

Author Comment

by:scalpy
ID: 1083178
Thanks guys.  I have purchased the Seagate Backup Exec Options Agent for Oracle Server for Windows NT.  The backup option seems to have solved the problem.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Parametric query in oracle 6 49
sql query 9 37
Oracle 10g - insert string with special characters 8 41
su - oracle could not open session 6 47
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now