No question at this time
DBA Top 10
1 M. Cadot 20300
2 A. Kavsek 13300
3 M. Hidayathullah ... 11400
4 B. Vroman 8500
5 P. Wisse 5900
6 T. Boles 5400
7 J. Schnackenberg 4500
8 A. Hudspith 2300
9 P. Knibbs 2200
9 K. Pagadala 2200
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users47975
Total active users1857
Act. users last 24h3
Act. users last hour0
Registered user hits last week384
Registered user hits last month1277
Go up

insufficient privileges
Next thread: Elapsed time of queries daywise.
Prev thread: Confusion about auxiliary channels for active duplicate

Message Score Author Date
Hi Guys I am getting the below error during the...... Tso P May 29, 2017, 22:50
Dear Tso, we have found similar error solution,...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Mirza Hidayathullah Baig May 30, 2017, 06:04

Follow up by mail Click here


Subject: insufficient privileges
Author: Tso P, South Africa
Date: May 29, 2017, 22:50, 26 days ago
Os info: rhel5
Oracle info: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
Error info: Internal Exception: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_AQADM", line 464
ORA-06512: at "USER.TASK_QUEUE_PKG", line 107
ORA-06512: at line 2

Error Code: 1031
Call: BEGIN
task_queue_pkg.stop_dequeue();
END;
Message: Hi Guys

I am getting the below error during the application startup, I tried grant execute on SYS.DBMS_AQADM to USER; but it does not seem to help...

What might be the problem here?

Please help!!!

Thanks in advance...
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: insufficient privileges
Author: Mirza Hidayathullah Baig, United Kingdom
Date: May 30, 2017, 06:04, 26 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Dear Tso,

we have found similar error solution, please go through this it may give you some hints.

please check the package status as well. Package may have errors

https://community.oracle.com/thread/2238829?db=5

for DBMS_AQADM

https://stackoverflow.com/questions/27390779/invalid-package-body-status-for-dbms-aqadm-sys

https://docs.oracle.com/database/121/ARPLS/d_aqadm.htm#ARPLS005

Regards
Mirza
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here