Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
ORA-25306: Cannot connect to buffered queue"s owner instance

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
Answers
-
It seems AQ operation jobs are runnig from non owning queue ownership instance, and buffered queues are being accessed from non-owning instance.
There is a matching MOS note for this, hope this helps
AQ Operations (Enqueue/Dequeue) via Job on Buffered Queue from Non-Owner Instance in RAC Environmnet Fails with Ora-25306 (Doc ID 1474602.1)
-
I believe this issue would go away if we move from buffered messaging to persistent one?