Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Messaging Gateway connectivity to IBM MQ

341376Oct 14 2008 — edited Mar 4 2009

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

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

2008-10-14 22:57:13 MGW Engine 0 434 worker0

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 1 2009

Added on Oct 14 2008

#database-and-application-migrations

1 comment

6,216 views