DG4MQ DG4MQ Issues With Triggers When AUTHORIZATION_MODEL Is Not Set To COMMIT_CONFIRM
Last updated on JANUARY 18, 2017
Applies to:
Oracle Database Gateway for WebSphere MQ - Version 10.2.0.1 and laterInformation 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'
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