Forum Stats

  • 3,853,938 Users
  • 2,264,295 Discussions
  • 7,905,512 Comments

Discussions

Oracle 10g AQ <-> IBM WebSphere MQ

545802
545802 Member Posts: 1
edited Oct 14, 2008 11:48AM in Advanced Queueing
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.

Comments

  • 550147
    550147 Member Posts: 1
    is this your first setup ? do you receive any errors ?
  • 407338
    407338 Member Posts: 852
    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
  • 552766
    552766 Member Posts: 2
    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
  • 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
  • 552766
    552766 Member Posts: 2
    Hi Koen,
    did you convert you messages to RAW?
    would it be possible for you to email me ([email protected]) some of your sample code?

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

    Thanks
    vishal
  • 341376
    341376 Member Posts: 3
    Friends, I made a trial of ORACLE<=>MQ. Configuration all seems ok but, the connection to MQ fails, "*Failed to access queue [email protected]; 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 [email protected] 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 --> [email protected]) has been added.
    2008-10-14 22:56:59 MGW Notif Handler 0 14 ConfigNotifier
    MGW subscriber SUB_MQ2AQ ([email protected] --> 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 --> [email protected]) 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 [email protected]; 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 [email protected] 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 [email protected]; 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 [email protected] for subscriber SUB_MQ2AQ
    2008-10-14 22:57:05 MGW Notif Handler 0 9 ConfigNotifier
    Propagation schedule SCH_MQ2AQ ([email protected] --> 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 [email protected]; 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 [email protected] 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 [email protected]; 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 [email protected] 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
This discussion has been closed.