ORA-25306: Cannot connect to buffered queue"s owner instance

Rohit Gupta-Oracle

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

Mudasir Hakak

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)

Rohit Gupta-Oracle

I believe this issue would go away if we move from buffered messaging to persistent one?