I though I’ve set up everything needed to use JMS and read Oracle AQ message, but my receiver is crashing with below error:
Setup of JMS message listener invoker failed for destination ‘DB.MY_QUEUE’ – trying to recover. Cause: ORA-00904: “SYS”.”DBMS_AQADM_SYS”.”GET_CLIENT_SESSION_ID”: invalid identifier
ORA-01031: insufficient privileges
ORA-06512: at “SYS.DBMS_AQADM_SYS”, line 6916
ORA-06512: at line 1
ORA-01031: insufficient privileges
ORA-06512: at “SYS.DBMS_AQADM_SYS”, line 6916
ORA-06512: at line 1
ORA-06512: at “SYS.DBMS_AQJMS”, line 151
ORA-06512: at line 1
I’ve also assigned DBMS_AQJMS and DBMS_AQDM to my user, but same issue.
Any idea on what to do here?
I’ve used following guide:
https://oracle.github.io/microservices-datadriven/spring/starters/aqjms/