7 Replies Latest reply on Oct 14, 2008 3:48 PM by 341376

    Oracle 10g AQ <-> IBM WebSphere MQ

    545802
      Guys,

      I'm trying for the last 2 weeks to get the above setup done but no success. I need the overview picture as well as detail guideline how can I setup Oracle AQ to send and receive messages from IBM WebSphere MQ queues. I manage to get the MGW agent running but lacking on the AQ configuration and missing the whole point of setting up JMS. I mean which side is JMS. And how to create MQ JMS queue. Is Oracle JMS a separate product or is it embedded.
        • 1. Re: Oracle 10g AQ <-> IBM WebSphere MQ
          550147
          is this your first setup ? do you receive any errors ?
          • 2. Re: Oracle 10g AQ <-> IBM WebSphere MQ
            407338
            Hi there, please read Oracle® Streams Advanced Queuing User's Guide and Reference chapters 17 through 21. I am not sure about JMS, but it seems that you use that only if the IBM MQ side uses JMS. In your /OracleHome/mgw folder, you should find some samples. Once you get what you need from the IBM MQ side, it is pretty straightforward.

            Ben
            • 3. Re: Oracle 10g AQ <-> IBM WebSphere MQ
              552766
              Hi,
              did you get this to work?. if so, would you be able to provide some details?
              I am trying to do a poc to test Oracle (AQ/MGW) to MQ.

              --I have outlined the high level steps that I have identified.

              AQ Setup
              ----------------------------------------
              Init.ora parameter
              Create Oracle abstract Data Type
              Create Queue table
              Create Queue

              Install MQ client
              ---------------------------

              MGW Setup
              ----------------------------------------
              Loading MGW database objects
              Configure Listener for External Procedures
              TNS changes
              setup mgw.ora file
              Create MGW Admin user
              Create MGW Agent user
              Configuring MGW connection
              Setting up for WebSphere MQ (Java or JMS)
              Verifying MGW setup
              Configuring MGW Agent
              Configuring Messaging System Links
              Registering Websphere MQ (Java or JMS Queue)
              a. Creating Propagation Schedule
              b. enable MGW Propagation Schedule
              • 4. Re: Oracle 10g AQ <-> IBM WebSphere MQ
                KoenRoskams
                Hi all,

                I have this solution running in production at a customer for more then a year now. First setup was with 9i, now it is running on 10g. The MQ version we are using is 5.3. It is putting messages from MQ to OAQ and from OAQ to MQ as well. Only problem we have is that outbound messaging is not supporting messages over 30 Mb, meaning Messaging Gateway is not propagating messages out over 30 Mb, actually on 9i it crashed at that point, 10g is not doing that, but messaging stops as the big message is blocking the propagation.

                Koen
                • 5. Re: Oracle 10g AQ <-> IBM WebSphere MQ
                  552766
                  Hi Koen,
                  did you convert you messages to RAW?
                  would it be possible for you to email me (itsamyth41@gmail.com) some of your sample code?

                  Thanks
                  • 6. Re: Oracle 10g AQ <-> IBM WebSphere MQ
                    561310
                    I have a similar kind of problem, can any explore the all steps to configure Oracle 10g AQ <-> IBM WebSphere MQ

                    Thanks
                    vishal
                    • 7. Re: Oracle 10g AQ <-> IBM WebSphere MQ
                      341376
                      Friends, I made a trial of ORACLE<=>MQ. Configuration all seems ok but, the connection to MQ fails, "*Failed to access queue DESTQ@MQLINK; provider queue: TQ*
                      *oracle.mgw.common.GatewayException: [800] MQSeries queue manager, TESTQM, creation failed"*.

                      Here's full log and appreciate if anyone has similar experience to share with:
                      2008-10-14 22:55:42 MGW C-Bootstrap 0 LOG process-id=2888
                      Bootstrap program starting
                      2008-10-14 22:55:42 MGW C-Bootstrap 0 LOG process-id=2888
                      JVM created -- heapsize = 64
                      2008-10-14 22:55:43 MGW Engine 0 200 main
                      MGW Agent version: 10.2.0.3_20061010:0713
                      2008-10-14 22:55:43 MGW AdminMgr 0 LOG main
                      Connecting to database using connect string = jdbc:oracle:oci8:@ORANGE
                      2008-10-14 22:55:44 MGW Engine 0 200 main
                      MGW Component version: 10.2.0.3.0
                      2008-10-14 22:55:44 MGW Engine 0 200 main
                      MGW job number: 2, MGW job sid: 137, MGW database instance: 1
                      2008-10-14 22:55:44 MGW Engine 0 1 main
                      Agent is initializing.
                      2008-10-14 22:55:44 MGW Engine 0 23 main
                      The number of worker threads is set to 1.
                      2008-10-14 22:55:44 MGW Engine 0 22 main
                      The default polling interval is set to 5000ms.
                      2008-10-14 22:55:45 MGW Engine 0 2 main
                      Agent is up and running.
                      2008-10-14 22:56:33 MGW MQD 0 LOG ConfigNotifier
                      Creating MQSeries messaging link:
                      link : MQLINK
                      link type : Base Java interface
                      queue manager : TESTQM
                      channel : TQCONN
                      host : 10.90.90.101
                      port : 1414
                      user :
                      connections : 1
                      inbound logQ : LOG_IN
                      outbound logQ : LOG_OUT
                      2008-10-14 22:56:33 MGW Engine 0 4 ConfigNotifier
                      Link MQLINK has been added.
                      2008-10-14 22:56:48 MGW Notif Handler 0 7 ConfigNotifier
                      Queue DESTQ@MQLINK has been registered; provider queue: TQ.
                      2008-10-14 22:56:59 MGW AQN 0 LOG ConfigNotifier
                      Creating AQ messaging link:
                      link : oracleMgwAq
                      link type : native
                      database : ORANGE
                      user : MGWAGENT
                      connection type : JDBC OCI
                      connections : 1
                      inbound logQ : sys.mgw_recv_log
                      outbound logQ : sys.mgw_send_log
                      2008-10-14 22:56:59 MGW Notif Handler 0 14 ConfigNotifier
                      MGW subscriber SUB_AQ2MQ (MGWUSER.MGW_BASIC_SRC --> DESTQ@MQLINK) has been added.
                      2008-10-14 22:56:59 MGW Notif Handler 0 14 ConfigNotifier
                      MGW subscriber SUB_MQ2AQ (DESTQ@MQLINK --> MGWUSER.MGW_BASIC_DEST) has been added.
                      2008-10-14 22:56:59 MGW Notif Handler 0 9 ConfigNotifier
                      Propagation schedule SCH_AQ2MQ (MGWUSER.MGW_BASIC_SRC --> DESTQ@MQLINK) has been added.
                      2008-10-14 22:57:00 MGW Engine 0 19 ConfigNotifier
                      MGW subscriber SUB_AQ2MQ has been activated.
                      2008-10-14 22:57:03 MGW Engine 0 434 worker0
                      Failed to access queue DESTQ@MQLINK; provider queue: TQ
                      oracle.mgw.common.GatewayException: [800] MQSeries queue manager, TESTQM, creation failed
                           at oracle.mgw.common.MgwUtil.GatewayException(MgwUtil.java:739)
                           at oracle.mgw.drivers.mq.MQOPHandle.<init>(MQOPHandle.java:64)
                           at oracle.mgw.drivers.mq.MQOPHandleFactory.createOPHandle(MQOPHandleFactory.java:35)
                           at oracle.mgw.drivers.OPHandlePool.getHandle(OPHandlePool.java:133)
                           at oracle.mgw.drivers.mq.MQLink.registerDestination(MQLink.java:382)
                           at oracle.mgw.engine.DestMgr.getForeignDest(DestMgr.java:54)
                           at oracle.mgw.engine.JobData.init(JobData.java:233)
                           at oracle.mgw.engine.Worker.recoverJob(Worker.java:1086)
                           at oracle.mgw.engine.Worker.myRun(Worker.java:98)
                           at oracle.mgw.engine.ManagedThr.run(ManagedThr.java:58)

                      [Linked-exception]
                      com.ibm.mq.MQException: MQJE001: Completion Code '2', Reason '2059'.
                           at com.ibm.mq.MQManagedConnectionJ11.<init>(MQManagedConnectionJ11.java:229)
                           at com.ibm.mq.MQClientManagedConnectionFactoryJ11._createManagedConnection(MQClientManagedConnectionFactoryJ11.java:500)
                           at com.ibm.mq.MQClientManagedConnectionFactoryJ11.createManagedConnection(MQClientManagedConnectionFactoryJ11.java:541)
                           at com.ibm.mq.StoredManagedConnection.<init>(StoredManagedConnection.java:95)
                           at com.ibm.mq.MQSimpleConnectionManager.allocateConnection(MQSimpleConnectionManager.java:182)
                           at com.ibm.mq.MQQueueManagerFactory.obtainBaseMQQueueManager(MQQueueManagerFactory.java:870)
                           at com.ibm.mq.MQQueueManagerFactory.procure(MQQueueManagerFactory.java:756)
                           at com.ibm.mq.MQQueueManagerFactory.constructQueueManager(MQQueueManagerFactory.java:704)
                           at com.ibm.mq.MQQueueManagerFactory.createQueueManager(MQQueueManagerFactory.java:169)
                           at com.ibm.mq.MQQueueManager.<init>(MQQueueManager.java:677)
                           at oracle.mgw.drivers.mq.MQOPHandle.<init>(MQOPHandle.java:60)
                           at oracle.mgw.drivers.mq.MQOPHandleFactory.createOPHandle(MQOPHandleFactory.java:35)
                           at oracle.mgw.drivers.OPHandlePool.getHandle(OPHandlePool.java:133)
                           at oracle.mgw.drivers.mq.MQLink.registerDestination(MQLink.java:382)
                           at oracle.mgw.engine.DestMgr.getForeignDest(DestMgr.java:54)
                           at oracle.mgw.engine.JobData.init(JobData.java:233)
                           at oracle.mgw.engine.Worker.recoverJob(Worker.java:1086)
                           at oracle.mgw.engine.Worker.myRun(Worker.java:98)
                           at oracle.mgw.engine.ManagedThr.run(ManagedThr.java:58)
                      Caused by: com.ibm.mq.jmqi.JmqiException: CC=2;RC=2059;AMQ9213: A communications error for occurred. [1=java.net.ConnectException[Connection refused: connect],3=Istana]
                           at com.ibm.mq.jmqi.remote.internal.RemoteTCPConnection.connnectUsingLocalAddress(RemoteTCPConnection.java:632)
                           at com.ibm.mq.jmqi.remote.internal.RemoteTCPConnection.protocolConnect(RemoteTCPConnection.java:980)
                           at com.ibm.mq.jmqi.remote.internal.system.RemoteConnection.connect(RemoteConnection.java:989)
                           at com.ibm.mq.jmqi.remote.internal.system.RemoteConnectionPool.getConnection(RemoteConnectionPool.java:293)
                           at com.ibm.mq.jmqi.remote.internal.RemoteFAP.jmqiConnect(RemoteFAP.java:1371)
                           at com.ibm.mq.MQSESSION.MQCONNX_j(MQSESSION.java:924)
                           at com.ibm.mq.MQManagedConnectionJ11.<init>(MQManagedConnectionJ11.java:224)
                           ... 18 more
                      Caused by: java.net.ConnectException: Connection refused: connect
                           at java.net.PlainSocketImpl.socketConnect(Native Method)
                           at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305)
                           at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:171)
                           at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158)
                           at java.net.Socket.connect(Socket.java:464)
                           at java.net.Socket.connect(Socket.java:414)
                           at com.ibm.mq.jmqi.remote.internal.RemoteTCPConnection$2.run(RemoteTCPConnection.java:618)
                           at java.security.AccessController.doPrivileged(Native Method)
                           at com.ibm.mq.jmqi.remote.internal.RemoteTCPConnection.connnectUsingLocalAddress(RemoteTCPConnection.java:611)
                           ... 24 more
                      2008-10-14 22:57:03 MGW Engine 0 442 worker0
                      Unable to access queue DESTQ@MQLINK for subscriber SUB_AQ2MQ
                      2008-10-14 22:57:03 MGW Engine 0 LOG worker0
                      Initialization failures for SUB_AQ2MQ
                      2008-10-14 22:57:03 MGW Engine 0 422 worker0
                      Errors occurred during recovering subscriber SUB_AQ2MQ
                      oracle.mgw.common.GatewayException: [435] Initialization failures for SUB_AQ2MQ
                           at oracle.mgw.common.MgwUtil.GatewayException(MgwUtil.java:739)
                           at oracle.mgw.engine.Worker.recoverJob(Worker.java:1087)
                           at oracle.mgw.engine.Worker.myRun(Worker.java:98)
                           at oracle.mgw.engine.ManagedThr.run(ManagedThr.java:58)
                      2008-10-14 22:57:04 MGW Engine 0 434 worker0
                      Failed to access queue DESTQ@MQLINK; provider queue: TQ
                      oracle.mgw.common.GatewayException: [800] MQSeries queue manager, TESTQM, creation failed
                           at oracle.mgw.common.MgwUtil.GatewayException(MgwUtil.java:739)
                           at oracle.mgw.drivers.mq.MQOPHandle.<init>(MQOPHandle.java:64)
                           at oracle.mgw.drivers.mq.MQOPHandleFactory.createOPHandle(MQOPHandleFactory.java:35)
                           at oracle.mgw.drivers.OPHandlePool.getHandle(OPHandlePool.java:133)
                           at oracle.mgw.drivers.mq.MQLink.registerDestination(MQLink.java:382)
                           at oracle.mgw.engine.DestMgr.getForeignDest(DestMgr.java:54)
                           at oracle.mgw.engine.JobData.createAlterNativeSub(JobData.java:1248)
                           at oracle.mgw.engine.Worker.createDurableSub(Worker.java:2486)
                           at oracle.mgw.engine.Worker.myRun(Worker.java:94)
                           at oracle.mgw.engine.ManagedThr.run(ManagedThr.java:58)

                      [Linked-exception]
                      com.ibm.mq.MQException: MQJE001: Completion Code '2', Reason '2059'.
                           at com.ibm.mq.MQManagedConnectionJ11.<init>(MQManagedConnectionJ11.java:229)
                           at com.ibm.mq.MQClientManagedConnectionFactoryJ11._createManagedConnection(MQClientManagedConnectionFactoryJ11.java:500)
                           at com.ibm.mq.MQClientManagedConnectionFactoryJ11.createManagedConnection(MQClientManagedConnectionFactoryJ11.java:541)
                           at com.ibm.mq.StoredManagedConnection.<init>(StoredManagedConnection.java:95)
                           at com.ibm.mq.MQSimpleConnectionManager.allocateConnection(MQSimpleConnectionManager.java:182)
                           at com.ibm.mq.MQQueueManagerFactory.obtainBaseMQQueueManager(MQQueueManagerFactory.java:870)
                           at com.ibm.mq.MQQueueManagerFactory.procure(MQQueueManagerFactory.java:756)
                           at com.ibm.mq.MQQueueManagerFactory.constructQueueManager(MQQueueManagerFactory.java:704)
                           at com.ibm.mq.MQQueueManagerFactory.createQueueManager(MQQueueManagerFactory.java:169)
                           at com.ibm.mq.MQQueueManager.<init>(MQQueueManager.java:677)
                           at oracle.mgw.drivers.mq.MQOPHandle.<init>(MQOPHandle.java:60)
                           at oracle.mgw.drivers.mq.MQOPHandleFactory.createOPHandle(MQOPHandleFactory.java:35)
                           at oracle.mgw.drivers.OPHandlePool.getHandle(OPHandlePool.java:133)
                           at oracle.mgw.drivers.mq.MQLink.registerDestination(MQLink.java:382)
                           at oracle.mgw.engine.DestMgr.getForeignDest(DestMgr.java:54)
                           at oracle.mgw.engine.JobData.createAlterNativeSub(JobData.java:1248)
                           at oracle.mgw.engine.Worker.createDurableSub(Worker.java:2486)
                           at oracle.mgw.engine.Worker.myRun(Worker.java:94)
                           at oracle.mgw.engine.ManagedThr.run(ManagedThr.java:58)
                      Caused by: com.ibm.mq.jmqi.JmqiException: CC=2;RC=2059;AMQ9213: A communications error for occurred. [1=java.net.ConnectException[Connection refused: connect],3=Istana]
                           at com.ibm.mq.jmqi.remote.internal.RemoteTCPConnection.connnectUsingLocalAddress(RemoteTCPConnection.java:632)
                           at com.ibm.mq.jmqi.remote.internal.RemoteTCPConnection.protocolConnect(RemoteTCPConnection.java:980)
                           at com.ibm.mq.jmqi.remote.internal.system.RemoteConnection.connect(RemoteConnection.java:989)
                           at com.ibm.mq.jmqi.remote.internal.system.RemoteConnectionPool.getConnection(RemoteConnectionPool.java:293)
                           at com.ibm.mq.jmqi.remote.internal.RemoteFAP.jmqiConnect(RemoteFAP.java:1371)
                           at com.ibm.mq.MQSESSION.MQCONNX_j(MQSESSION.java:924)
                           at com.ibm.mq.MQManagedConnectionJ11.<init>(MQManagedConnectionJ11.java:224)
                           ... 18 more
                      Caused by: java.net.ConnectException: Connection refused: connect
                           at java.net.PlainSocketImpl.socketConnect(Native Method)
                           at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305)
                           at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:171)
                           at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158)
                           at java.net.Socket.connect(Socket.java:464)
                           at java.net.Socket.connect(Socket.java:414)
                           at com.ibm.mq.jmqi.remote.internal.RemoteTCPConnection$2.run(RemoteTCPConnection.java:618)
                           at java.security.AccessController.doPrivileged(Native Method)
                           at com.ibm.mq.jmqi.remote.internal.RemoteTCPConnection.connnectUsingLocalAddress(RemoteTCPConnection.java:611)
                           ... 24 more
                      2008-10-14 22:57:04 MGW Engine 0 442 worker0
                      Unable to access queue DESTQ@MQLINK for subscriber SUB_MQ2AQ
                      2008-10-14 22:57:05 MGW Notif Handler 0 9 ConfigNotifier
                      Propagation schedule SCH_MQ2AQ (DESTQ@MQLINK --> MGWUSER.MGW_BASIC_DEST) has been added.
                      2008-10-14 22:57:05 MGW Engine 0 19 ConfigNotifier
                      MGW subscriber SUB_MQ2AQ has been activated.
                      2008-10-14 22:57:05 MGW Engine 0 434 worker0
                      Failed to access queue DESTQ@MQLINK; provider queue: TQ
                      oracle.mgw.common.GatewayException: [800] MQSeries queue manager, TESTQM, creation failed
                           at oracle.mgw.common.MgwUtil.GatewayException(MgwUtil.java:739)
                           at oracle.mgw.drivers.mq.MQOPHandle.<init>(MQOPHandle.java:64)
                           at oracle.mgw.drivers.mq.MQOPHandleFactory.createOPHandle(MQOPHandleFactory.java:35)
                           at oracle.mgw.drivers.OPHandlePool.getHandle(OPHandlePool.java:133)
                           at oracle.mgw.drivers.mq.MQLink.registerDestination(MQLink.java:382)
                           at oracle.mgw.engine.DestMgr.getForeignDest(DestMgr.java:54)
                           at oracle.mgw.engine.JobData.init(JobData.java:233)
                           at oracle.mgw.engine.Worker.recoverJob(Worker.java:1086)
                           at oracle.mgw.engine.Worker.myRun(Worker.java:98)
                           at oracle.mgw.engine.ManagedThr.run(ManagedThr.java:58)

                      [Linked-exception]
                      com.ibm.mq.MQException: MQJE001: Completion Code '2', Reason '2059'.
                           at com.ibm.mq.MQManagedConnectionJ11.<init>(MQManagedConnectionJ11.java:229)
                           at com.ibm.mq.MQClientManagedConnectionFactoryJ11._createManagedConnection(MQClientManagedConnectionFactoryJ11.java:500)
                           at com.ibm.mq.MQClientManagedConnectionFactoryJ11.createManagedConnection(MQClientManagedConnectionFactoryJ11.java:541)
                           at com.ibm.mq.StoredManagedConnection.<init>(StoredManagedConnection.java:95)
                           at com.ibm.mq.MQSimpleConnectionManager.allocateConnection(MQSimpleConnectionManager.java:182)
                           at com.ibm.mq.MQQueueManagerFactory.obtainBaseMQQueueManager(MQQueueManagerFactory.java:870)
                           at com.ibm.mq.MQQueueManagerFactory.procure(MQQueueManagerFactory.java:756)
                           at com.ibm.mq.MQQueueManagerFactory.constructQueueManager(MQQueueManagerFactory.java:704)
                           at com.ibm.mq.MQQueueManagerFactory.createQueueManager(MQQueueManagerFactory.java:169)
                           at com.ibm.mq.MQQueueManager.<init>(MQQueueManager.java:677)
                           at oracle.mgw.drivers.mq.MQOPHandle.<init>(MQOPHandle.java:60)
                           at oracle.mgw.drivers.mq.MQOPHandleFactory.createOPHandle(MQOPHandleFactory.java:35)
                           at oracle.mgw.drivers.OPHandlePool.getHandle(OPHandlePool.java:133)
                           at oracle.mgw.drivers.mq.MQLink.registerDestination(MQLink.java:382)
                           at oracle.mgw.engine.DestMgr.getForeignDest(DestMgr.java:54)
                           at oracle.mgw.engine.JobData.init(JobData.java:233)
                           at oracle.mgw.engine.Worker.recoverJob(Worker.java:1086)
                           at oracle.mgw.engine.Worker.myRun(Worker.java:98)
                           at oracle.mgw.engine.ManagedThr.run(ManagedThr.java:58)
                      Caused by: com.ibm.mq.jmqi.JmqiException: CC=2;RC=2059;AMQ9213: A communications error for occurred. [1=java.net.ConnectException[Connection refused: connect],3=Istana]
                           at com.ibm.mq.jmqi.remote.internal.RemoteTCPConnection.connnectUsingLocalAddress(RemoteTCPConnection.java:632)
                           at com.ibm.mq.jmqi.remote.internal.RemoteTCPConnection.protocolConnect(RemoteTCPConnection.java:980)
                           at com.ibm.mq.jmqi.remote.internal.system.RemoteConnection.connect(RemoteConnection.java:989)
                           at com.ibm.mq.jmqi.remote.internal.system.RemoteConnectionPool.getConnection(RemoteConnectionPool.java:293)
                           at com.ibm.mq.jmqi.remote.internal.RemoteFAP.jmqiConnect(RemoteFAP.java:1371)
                           at com.ibm.mq.MQSESSION.MQCONNX_j(MQSESSION.java:924)
                           at com.ibm.mq.MQManagedConnectionJ11.<init>(MQManagedConnectionJ11.java:224)
                           ... 18 more
                      Caused by: java.net.ConnectException: Connection refused: connect
                           at java.net.PlainSocketImpl.socketConnect(Native Method)
                           at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305)
                           at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:171)
                           at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158)
                           at java.net.Socket.connect(Socket.java:464)
                           at java.net.Socket.connect(Socket.java:414)
                           at com.ibm.mq.jmqi.remote.internal.RemoteTCPConnection$2.run(RemoteTCPConnection.java:618)
                           at java.security.AccessController.doPrivileged(Native Method)
                           at com.ibm.mq.jmqi.remote.internal.RemoteTCPConnection.connnectUsingLocalAddress(RemoteTCPConnection.java:611)
                           ... 24 more
                      2008-10-14 22:57:05 MGW Engine 0 442 worker0
                      Unable to access queue DESTQ@MQLINK for subscriber SUB_AQ2MQ
                      2008-10-14 22:57:05 MGW Engine 0 LOG worker0
                      Initialization failures for SUB_AQ2MQ
                      2008-10-14 22:57:05 MGW Engine 0 422 worker0
                      Errors occurred during recovering subscriber SUB_AQ2MQ
                      oracle.mgw.common.GatewayException: [435] Initialization failures for SUB_AQ2MQ
                           at oracle.mgw.common.MgwUtil.GatewayException(MgwUtil.java:739)
                           at oracle.mgw.engine.Worker.recoverJob(Worker.java:1087)
                           at oracle.mgw.engine.Worker.myRun(Worker.java:98)
                           at oracle.mgw.engine.ManagedThr.run(ManagedThr.java:58)
                      2008-10-14 22:57:13 MGW Engine 0 434 worker0
                      Failed to access queue DESTQ@MQLINK; provider queue: TQ
                      oracle.mgw.common.GatewayException: [800] MQSeries queue manager, TESTQM, creation failed
                           at oracle.mgw.common.MgwUtil.GatewayException(MgwUtil.java:739)
                           at oracle.mgw.drivers.mq.MQOPHandle.<init>(MQOPHandle.java:64)
                           at oracle.mgw.drivers.mq.MQOPHandleFactory.createOPHandle(MQOPHandleFactory.java:35)
                           at oracle.mgw.drivers.OPHandlePool.getHandle(OPHandlePool.java:133)
                           at oracle.mgw.drivers.mq.MQLink.registerDestination(MQLink.java:382)
                           at oracle.mgw.engine.DestMgr.getForeignDest(DestMgr.java:54)
                           at oracle.mgw.engine.JobData.init(JobData.java:233)
                           at oracle.mgw.engine.Worker.recoverJob(Worker.java:1086)
                           at oracle.mgw.engine.Worker.myRun(Worker.java:98)
                           at oracle.mgw.engine.ManagedThr.run(ManagedThr.java:58)

                      [Linked-exception]
                      com.ibm.mq.MQException: MQJE001: Completion Code '2', Reason '2059'.
                           at com.ibm.mq.MQManagedConnectionJ11.<init>(MQManagedConnectionJ11.java:229)
                           at com.ibm.mq.MQClientManagedConnectionFactoryJ11._createManagedConnection(MQClientManagedConnectionFactoryJ11.java:500)
                           at com.ibm.mq.MQClientManagedConnectionFactoryJ11.createManagedConnection(MQClientManagedConnectionFactoryJ11.java:541)
                           at com.ibm.mq.StoredManagedConnection.<init>(StoredManagedConnection.java:95)
                           at com.ibm.mq.MQSimpleConnectionManager.allocateConnection(MQSimpleConnectionManager.java:182)
                           at com.ibm.mq.MQQueueManagerFactory.obtainBaseMQQueueManager(MQQueueManagerFactory.java:870)
                           at com.ibm.mq.MQQueueManagerFactory.procure(MQQueueManagerFactory.java:756)
                           at com.ibm.mq.MQQueueManagerFactory.constructQueueManager(MQQueueManagerFactory.java:704)
                           at com.ibm.mq.MQQueueManagerFactory.createQueueManager(MQQueueManagerFactory.java:169)
                           at com.ibm.mq.MQQueueManager.<init>(MQQueueManager.java:677)
                           at oracle.mgw.drivers.mq.MQOPHandle.<init>(MQOPHandle.java:60)
                           at oracle.mgw.drivers.mq.MQOPHandleFactory.createOPHandle(MQOPHandleFactory.java:35)
                           at oracle.mgw.drivers.OPHandlePool.getHandle(OPHandlePool.java:133)
                           at oracle.mgw.drivers.mq.MQLink.registerDestination(MQLink.java:382)
                           at oracle.mgw.engine.DestMgr.getForeignDest(DestMgr.java:54)
                           at oracle.mgw.engine.JobData.init(JobData.java:233)
                           at oracle.mgw.engine.Worker.recoverJob(Worker.java:1086)
                           at oracle.mgw.engine.Worker.myRun(Worker.java:98)
                           at oracle.mgw.engine.ManagedThr.run(ManagedThr.java:58)
                      Caused by: com.ibm.mq.jmqi.JmqiException: CC=2;RC=2059;AMQ9213: A communications error for occurred. [1=java.net.ConnectException[Connection refused: connect],3=Istana]
                           at com.ibm.mq.jmqi.remote.internal.RemoteTCPConnection.connnectUsingLocalAddress(RemoteTCPConnection.java:632)
                           at com.ibm.mq.jmqi.remote.internal.RemoteTCPConnection.protocolConnect(RemoteTCPConnection.java:980)
                           at com.ibm.mq.jmqi.remote.internal.system.RemoteConnection.connect(RemoteConnection.java:989)
                           at com.ibm.mq.jmqi.remote.internal.system.RemoteConnectionPool.getConnection(RemoteConnectionPool.java:293)
                           at com.ibm.mq.jmqi.remote.internal.RemoteFAP.jmqiConnect(RemoteFAP.java:1371)
                           at com.ibm.mq.MQSESSION.MQCONNX_j(MQSESSION.java:924)
                           at com.ibm.mq.MQManagedConnectionJ11.<init>(MQManagedConnectionJ11.java:224)
                           ... 18 more
                      Caused by: java.net.ConnectException: Connection refused: connect
                           at java.net.PlainSocketImpl.socketConnect(Native Method)
                           at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305)
                           at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:171)
                           at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158)
                           at java.net.Socket.connect(Socket.java:464)
                           at java.net.Socket.connect(Socket.java:414)
                           at com.ibm.mq.jmqi.remote.internal.RemoteTCPConnection$2.run(RemoteTCPConnection.java:618)
                           at java.security.AccessController.doPrivileged(Native Method)
                           at com.ibm.mq.jmqi.remote.internal.RemoteTCPConnection.connnectUsingLocalAddress(RemoteTCPConnection.java:611)
                           ... 24 more
                      2008-10-14 22:57:13 MGW Engine 0 442 worker0
                      Unable to access queue DESTQ@MQLINK for subscriber SUB_AQ2MQ
                      2008-10-14 22:57:13 MGW Engine 0 LOG worker0
                      Initialization failures for SUB_AQ2MQ
                      2008-10-14 22:57:13 MGW Engine 0 422 worker0
                      Errors occurred during recovering subscriber SUB_AQ2MQ
                      oracle.mgw.common.GatewayException: [435] Initialization failures for SUB_AQ2MQ
                           at oracle.mgw.common.MgwUtil.GatewayException(MgwUtil.java:739)
                           at oracle.mgw.engine.Worker.recoverJob(Worker.java:1087)
                           at oracle.mgw.engine.Worker.myRun(Worker.java:98)
                           at oracle.mgw.engine.ManagedThr.run(ManagedThr.java:58)


                      Thanks&Regards
                      Joe