Skip to Main Content

ODP.NET

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!

AQ subscription on autonomous database

thgrothMar 24 2025

I get the following exception when trying to register a subscription to a AQ queue on an autonomous database (works with an on-prem database):

Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01031: insufficient privileges
https://docs.oracle.com/error-help/db/ora-01031/
at OracleInternal.ServiceObjects.OracleConnectionImpl.CheckForAnyErrorFromDB(TTCError ttcOER, Object traceObj)
at OracleInternal.ServiceObjects.OracleNotificationManager.SendAQRegistrationInfo(OracleConnectionImpl connectionImpl, OracleDependencyImpl orclDependencyImpl, String[] subscriptionName, String listenerClientId, OracleNotificationRequest ntfnReq)
at OracleInternal.ServiceObjects.OracleNotificationManager.RegisterForAQNotification(OracleConnectionImpl connectionImpl, OracleDependencyImpl orclDependencyImpl, String queueName, String[] notificationConsumers, OracleNotificationRequest ntfnReq, OracleAQQueue oracleAQQueue)
at Oracle.ManagedDataAccess.Client.OracleAQQueue.SubscriptionRegister()
at Oracle.ManagedDataAccess.Client.OracleAQQueue.add_MessageAvailable(OracleAQMessageAvailableEventHandler value).

I am using Oracle.ManagedDataAccess 23.7.0

Anyone experienced the same, and found a solution?

Comments
Post Details
Added on Mar 24 2025
1 comment
144 views