DG4MQ DG4MQ Issues With Triggers When AUTHORIZATION_MODEL Is Not Set To COMMIT_CONFIRM

(Doc ID 1114054.1)

Last updated on JANUARY 18, 2017

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms