Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Oracle 10g AQ <-> IBM WebSphere MQ

545802
Member Posts: 1
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.
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.
Tagged:
Comments
-
is this your first setup ? do you receive any errors ?
-
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 -
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 -
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 -
I have a similar kind of problem, can any explore the all steps to configure Oracle 10g AQ <-> IBM WebSphere MQ
Thanks
vishal -
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:Bootstrap program starting2008-10-14 22:55:42 MGW C-Bootstrap 0 LOG process-id=2888JVM created -- heapsize = 642008-10-14 22:55:42 MGW C-Bootstrap 0 LOG process-id=2888MGW Agent version: 10.2.0.3_20061010:07132008-10-14 22:55:43 MGW Engine 0 200 mainConnecting to database using connect string = jdbc:oracle:oci8:@ORANGE2008-10-14 22:55:43 MGW AdminMgr 0 LOG mainMGW Component version: 10.2.0.3.02008-10-14 22:55:44 MGW Engine 0 200 mainMGW job number: 2, MGW job sid: 137, MGW database instance: 12008-10-14 22:55:44 MGW Engine 0 200 mainAgent is initializing.2008-10-14 22:55:44 MGW Engine 0 1 mainThe number of worker threads is set to 1.2008-10-14 22:55:44 MGW Engine 0 23 mainThe default polling interval is set to 5000ms.2008-10-14 22:55:44 MGW Engine 0 22 mainAgent is up and running.2008-10-14 22:55:45 MGW Engine 0 2 mainCreating MQSeries messaging link:2008-10-14 22:56:33 MGW MQD 0 LOG ConfigNotifier
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_OUTLink MQLINK has been added.2008-10-14 22:56:33 MGW Engine 0 4 ConfigNotifierQueue [email protected] has been registered; provider queue: TQ.2008-10-14 22:56:48 MGW Notif Handler 0 7 ConfigNotifierCreating AQ messaging link:2008-10-14 22:56:59 MGW AQN 0 LOG ConfigNotifier
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_logMGW subscriber SUB_AQ2MQ (MGWUSER.MGW_BASIC_SRC --> [email protected]) has been added.2008-10-14 22:56:59 MGW Notif Handler 0 14 ConfigNotifierMGW subscriber SUB_MQ2AQ ([email protected] --> MGWUSER.MGW_BASIC_DEST) has been added.2008-10-14 22:56:59 MGW Notif Handler 0 14 ConfigNotifierPropagation schedule SCH_AQ2MQ (MGWUSER.MGW_BASIC_SRC --> [email protected]) has been added.2008-10-14 22:56:59 MGW Notif Handler 0 9 ConfigNotifierMGW subscriber SUB_AQ2MQ has been activated.2008-10-14 22:57:00 MGW Engine 0 19 ConfigNotifierFailed to access queue [email protected]; provider queue: TQ2008-10-14 22:57:03 MGW Engine 0 434 worker0
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 moreUnable to access queue [email protected] for subscriber SUB_AQ2MQ2008-10-14 22:57:03 MGW Engine 0 442 worker0Initialization failures for SUB_AQ2MQ2008-10-14 22:57:03 MGW Engine 0 LOG worker0Errors occurred during recovering subscriber SUB_AQ2MQ2008-10-14 22:57:03 MGW Engine 0 422 worker0
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)Failed to access queue [email protected]; provider queue: TQ2008-10-14 22:57:04 MGW Engine 0 434 worker0
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 moreUnable to access queue [email protected] for subscriber SUB_MQ2AQ2008-10-14 22:57:04 MGW Engine 0 442 worker0Propagation schedule SCH_MQ2AQ ([email protected] --> MGWUSER.MGW_BASIC_DEST) has been added.2008-10-14 22:57:05 MGW Notif Handler 0 9 ConfigNotifierMGW subscriber SUB_MQ2AQ has been activated.2008-10-14 22:57:05 MGW Engine 0 19 ConfigNotifierFailed to access queue [email protected]; provider queue: TQ2008-10-14 22:57:05 MGW Engine 0 434 worker0
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 moreUnable to access queue [email protected] for subscriber SUB_AQ2MQ2008-10-14 22:57:05 MGW Engine 0 442 worker0Initialization failures for SUB_AQ2MQ2008-10-14 22:57:05 MGW Engine 0 LOG worker0Errors occurred during recovering subscriber SUB_AQ2MQ2008-10-14 22:57:05 MGW Engine 0 422 worker0
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)Failed to access queue [email protected]; provider queue: TQ2008-10-14 22:57:13 MGW Engine 0 434 worker0
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 moreUnable to access queue [email protected] for subscriber SUB_AQ2MQ2008-10-14 22:57:13 MGW Engine 0 442 worker0Initialization failures for SUB_AQ2MQ2008-10-14 22:57:13 MGW Engine 0 LOG worker0Errors occurred during recovering subscriber SUB_AQ2MQ2008-10-14 22:57:13 MGW Engine 0 422 worker0
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.