[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

ORA-00472 disconnects from oracle database

Posted on 1998-06-18
3
Medium Priority
?
828 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

656 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