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?