My Oracle Support Banner

DG4MQ DG4MQ Issues With Triggers When AUTHORIZATION_MODEL Is Not Set To COMMIT_CONFIRM (Doc ID 1114054.1)

Last updated on OCTOBER 17, 2019

Applies to:

Oracle Database Gateway for WebSphere MQ - Version 10.2.0.1 and later
Information in this document applies to any platform.

Symptoms

While executing a trigger or some auto-commit PL/SQL code that references MQSeries objects via Database Gateway for Websphere MQ (DG4MQ) the following error is returned:

ORA-20001: MQ$INTERFACE.enqueue(basic):ORA-20001: MQ$INTERFACE.qopen:ORA-28509: unable to establish a connection to non-Oracle system
ORA-06512: at "SH_PLSQL_OWNER.MQ$INTERFACE", line 1154
ORA-20001: MQ$INTERFACE.qopen:ORA-28509: unable to establish a connection to non-Oracle system
ORA-06512: at "SH_PLSQL_OWNER.RUN_ENQUEUE", line 7
ORA-06512: at "SYSTEM.TEST_OPG_TRG", line 8
ORA-04088: error during execution of trigger 'SYSTEM.TEST_OPG_TRG'





Changes

This is a new install of DG4MQ and the execution of trigger code that involves MQSeries via the gateway.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.