In our project, we have used Oracle AQ Buffered message. It seems to be working fine in local with everything in one machine. But this fails in the cluster environment when trying to work with a buffered queue, we received a message: ORA-25306 CANNOT CONNECT TO BUFFERED QUEUE'S OWNER INSTANCE. The issue is intermittent and sometimes seems to work. Can please someone help in resolving the issue.
Below is the snapshot
Caused by: oracle.jms.AQjmsException: ORA-25306: Cannot connect to buffered queue’s owner instance at oracle.jms.AQjmsProducer.jdbcEnqueue(AQjmsProducer.java:1104)
at oracle.jms.AQjmsProducer.publish(AQjmsProducer.java:2065)
at oracle.jms.AQjmsProducer.bufferPublish(AQjmsProducer.java:1981)
at oracle.vb.internal.messaging.publisher.impl.MessagePublisherImpl.publishMessage(MessagePublisherImpl.java:88)
... 10 more
[2:40 PM] Caused by: java.sql.SQLException: ORA-25306: Cannot connect to buffered queue’s owner instance at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:397)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:744)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:536)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:236)
at oracle.jdbc.driver.T4Caqe.doOAQEQ(T4Caqe.java:365)
at oracle.jdbc.driver.T4CConnection.doEnqueue(T4CConnection.java:4694)
at oracle.jdbc.driver.PhysicalConnection.enqueue(PhysicalConnection.java:17882)
at weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection.enqueue(Unknown Source)
at oracle.jms.AQjmsProducer.jdbcEnqueue(AQjmsProducer.java:1042)
... 13 more