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.

550147

is this your first setup ? do you receive any errors ?

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

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

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

552766

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

I have a similar kind of problem, can any explore the all steps to configure Oracle 10g AQ <-> IBM WebSphere MQ

Thanks
vishal

341376

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