No question at this time
DBA Top 10
1 M. Cadot 17000
2 A. Kavsek 14300
3 B. Vroman 10300
4 M. Hidayathullah ... 8400
5 T. Boles 4900
6 P. Wisse 4400
7 J. Schnackenberg 3500
8 K. Van Nieuwenhov... 2100
9 A. Hudspith 800
9 T. P 800
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 users48097
Total active users1702
Act. users last 24h1
Act. users last hour0
Registered user hits last week237
Registered user hits last month1339
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, 201 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, 201 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