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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
60 views