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

    Forum Stats

  • 3,707,910 Users
  • 2,240,909 Discussions
  • 7,839,920 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

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

User_HXFRRUser_HXFRR Posts: 2 Employee

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

  • Mudasir HakakMudasir Hakak Posts: 135 Blue Ribbon

    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)

  • User_HXFRRUser_HXFRR Posts: 2 Employee

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

Sign In or Register to comment.