?
Solved

ORA-00472 disconnects from oracle database

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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

762 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