ORA-20000, ORU-10024

[DaveH]

Using the Alerter Component, I occasionally (but not always) receive the following on program startup:

ORA-20000 ORU-10024: There are no alerts registered
ORA-06512 SYS.DBMS_ALERT at line 272
ORA-06512 at line 1

Nothing seems to work trying to trap this error. Can you help?

FWIW I think the error is incorrect, because all alerts and pipes function normally despite the error at startup.

Dave

 

[Marco Kalter]

What is your Oracle Server version?

------------------
Marco Kalter
Allround Automations

 

[DaveH]

Using 8.1.6.3.1 (8.1.6 with patches)

Why would that make a difference?

 

[Marco Kalter]

It makes a difference if this problem is caused by an Oracle Server bug, which is most likely the case. The following 2 bugs seem to apply:

* 1099387
* 1534701

The first one should already be fixed in your 8.1.6.3 patch though.

Perhaps you can verify if one of these bugs applies?

------------------
Marco Kalter
Allround Automations

 

[DaveH]

But I'm not having any problem with the actual alerts... they are working fine even with the "error"... what I need to know is how to TRAP the error so the user doesn't see it.

Is there any way to do this... so far all attempts have failed.

 

[Marco Kalter]

When exactly does the error occur? When a TOracleEvent.Start is called? During event processing?

------------------
Marco Kalter
Allround Automations