Database ORA-600 / ORA-7445 Analysis , Diagnostic Repository (ADR) & Packaging (MOSC)

MOSC Banner

ORA-7445 on dbms_aqadm.remove_subscriber

Hi,

i am trying to remove a AQ subscriber, which gives me a "end of file communication channel".

The alert log shows me this: ORA-07445: exception encountered: core dump [kwqaChkpTxxcb()+38] [SIGSEGV] [ADDR:0xB0] [PC:0x118AE96] [Address not mapped to object] []

Anybody ever experienced this?

-- The statement

declare

procedure remove_subscriber(p_queue_name   varchar2, p_subscriber    varchar2)

is

   aSubscriber sys.aq$_agent;

   expected_error exception;

   pragma exception_init(expected_error,-24035);

begin

   aSubscriber := sys.aq$_agent(null,

                                p_subscriber,

                                0);

   dbms_aqadm.remove_subscriber

        ( queue_name     => 'AQ_ADMIN.'||p_queue_name

         ,subscriber     => aSubscriber

        );

end;

begin

    remove_subscriber('IM_MUTATIONS_TO_MODEL','"AQ_ADMIN"."IM_CALC_DELTA_MODEL"');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center