Summary: error 52: Somebody had similar problem?

From: Xu, Ying X. (YXXu@dcss.com)
Date: Thu Feb 24 2000 - 13:09:50 CST


Many thanks to:

Joel.Lee@avnet.com
RSullivan@refco.com
LouisA@omnipoint-pcs.com for giving me very useful suggestions.
robsonk@ebrd.com
David.Birch@East.Sun.COM # He is the third person at Sun I talked to
regarding the problem. Although it is not the system problem, he tried his
best to find me the solution on Oracle website.

It is not a system issue. The error message is from Oracle. It means that
the database has run out of enqueue resources and we need to
increase the value of enqueue_resources in init.ora.

The meaning of the error messages:

ORA-00052 maximum number of enqueue resources num exceeded

Cause:
        An operation requested a resource that was unavailable. The maximum
number of enqueue resources is specified by the initialization parameter
ENQUEUE_RESOURCES. When this maximum is reached, no more requests are
processed.

Action:
         Try the operation again in a few minutes. If this message occurs
often, shut down Oracle, increase the ENQUEUE_RESOURCES parameter in the
initialization parameter file, and restart Oracle.

 
      :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
      ORA-01186 verification tests failed on file name

Cause:
        The datafile did not pass the checks to ensure it is part of the
database. See the accompanying messages for the reason the verification
failed.

Action:
         Make the correct file available to database. Then either open the
database or execute ALTER DATABASE CHECK.

---------------------
My original question:

Hi, sun-managers,

We just installed Oracle Rman. When we used it to backup, it gave lots of
error messages and then abort the backup. Below are the error messages:

------------
oltpprod_dbw0_2198.trc:ORA-01186: file 526 failed verification tests
oltpprod_dbw0_2198.trc:ORA-00052: maximum number of enqueue resources (520)
exceeded
oltpprod_dbw0_2198.trc:ORA-01186: file 527 failed verification tests
oltpprod_dbw0_2198.trc:ORA-00052: maximum number of enqueue resources (520)
exceeded
oltpprod_dbw0_2198.trc:ORA-01186: file 528 failed verification tests
oltpprod_dbw0_2198.trc:ORA-00052: maximum number of enqueue resources (520)
exceeded
oltpprod_dbw0_2198.trc:ORA-01186: file 529 failed verification tests
oltpprod_dbw0_2198.trc:ORA-00052: maximum number of enqueue resources (520)
exceeded
oltpprod_dbw0_2198.trc:ORA-00052: maximum number of enqueue resources (520)
exceeded
oltpprod_dbw0_2198.trc:ORA-00052: maximum number of enqueue resources (520)
exceeded
oltpprod_dbw0_2198.trc:ORA-00052: maximum number of enqueue resources (520)
exceeded
oltpprod_dbw0_2198.trc:ORA-00052: maximum number of enqueue resources (520)
exceeded
oltpprod_dbw0_2198.trc:ORA-00052: maximum number of enqueue resources (520)
exceeded
oltpprod_dbw0_2198.trc:ORA-00052: maximum number of enqueue resources (520)
exceeded
oltpprod_dbw0_2198.trc:ORA-00052: maximum number of enqueue resources (520)
exceeded
oltpprod_dbw0_2198.trc:ORA-00052: maximum number of enqueue resources (520)
exceeded
oltpprod_dbw0_2198.trc:ORA-00052: maximum number of enqueue resources (520)
exceeded
oltpprod_dbw0_2198.trc:ORA-00052: maximum number of enqueue resources (520)
exceeded
oltpprod_dbw0_2198.trc:ORA-00052: maximum number of enqueue resources (520)
exceeded
oltpprod_dbw0_2198.trc:ORA-00052: maximum number of enqueue resources (520)
exceeded
oltpprod_dbw0_2198.trc:ORA-00052: maximum number of enqueue resources (520)
exceeded
oltpprod_dbw0_2198.trc:ORA-00052: maximum number of enqueue resources (520)
exceeded
oltpprod_dbw0_2198.trc:ORA-00052: maximum number of enqueue resources (520)
exceeded
oltpprod_dbw0_5338.trc:error 52 detected in background process
-------------

The messages shows in Oracle's log file not in syslog file. However, DBAs
pointed out that error 52 is defined in /usr/include/sys/errno.h, so it's
system error. I called Sun support, they have no clue about the error
messages. Does anybody on the list have such problem before?

Any help is appreciated.

Thanks.

Ying Xu

  



This archive was generated by hypermail 2.1.2 : Fri Sep 28 2001 - 23:14:03 CDT