[重慶思莊每日技術分享]-AQ Failing With ORA-6544 [pevm_peruws_callback-1] [16224]

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