?
Solved

ORA-00472 disconnects from oracle database

Posted on 1998-06-18
3
Medium Priority
?
833 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 100 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
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 videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

839 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