AQ Failing With ORA-6544 [pevm_peruws_callback-1] [16224] (Doc ID 2443098.1)

郑全

        AQ Failing With ORA-6544 [pevm_peruws_callback-1] [16224] (Doc ID 2443098.1)        To BottomTo Bottom       

In this Document
        Symptoms
        Changes
        Cause
        Solution
        References


Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.
Symptoms

DBMS_AQADM.CREATE_AQ_AGENT fails with error ORA-6544 [pevm_peruws_callback-1] [16224].
Changes


Cause

DBMS_AQADM.CREATE_AQ_AGENT fails with error
BEGIN dbms_aqadm.create_aq_agent(:1 ); EXCEPTION WHEN OTHERS THEN IF SQLCODE = -24089 THEN NULL; ELSE RAISE; END IF; END;
[TOC00004]
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x709fa950 1847 package body SYS.DBMS_AQADM.CREATE_AQ_AGENT
0x70a01448 1 anonymous block
[TOC00004-END]
Solution

Since the CREATE_AQ_AGENT is failing, the SYS.ALERT_QUE can be dropped and re-created as below.

SQL> connect / as sysdba

SQL>alter system enable restricted session;

To drop the ALERT_QT queue_table execute:

exec dbms_aqadm.drop_queue_table('ALERT_QT',true)

To re-create tables, sequence, type and queue for server alert in version 11 and above:

SQL>@$ORACLE_HOME/rdbms/admin/dbmsslrt.sql
SQL>@$ORACLE_HOME/rdbms/admin/catalrt.sql
SQL>@$ORACLE_HOME/rdbms/admin/catmwin.sql
SQL>@$ORACLE_HOME/rdbms/admin/exechae.sql

To recompile the invalid objects

SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sql

SQL> alter system disable restricted session;

This strategy helped in resolving the issue.
References


NOTE:2288591.1 - SRDC - Providing Supporting Information for PL/SQL Runtime Issues
NOTE:430146.1 - How to recreate the SYS.ALERT_QUE
NOTE:1929376.1 - My Oracle Support - Automated Troubleshooting