ORA-28031 / ORA-01925: maximum of 148 enabled roles exceeded (Doc ID 780749.1)

Last updated on MAY 22, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.4 to 11.1.0.7 [Release 8.1.7 to 11.1]
Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.
Checked for relevance on 23-Aug-2011


Symptoms

1) The alert.log is full with the following errors:

...
Tue Dec 30 18:15:42 2008
Errors in file d:\app\administrator\diag\rdbms\prod\prod\trace\prod_j000_3444.trc:
ORA-12012: error on auto execute of job 4002
ORA-28031: maximum of 148 enabled roles exceeded
Tue Dec 30 18:15:47 2008
Thread 1 cannot allocate new log, sequence 64
Checkpoint not complete
Current log# 3 seq# 63 mem# 0: D:\APP\ADMINISTRATOR\ORADATA\PROD\REDO03.LOG
Thread 1 advanced to log sequence 64 (LGWR switch)
Tue Dec 30 18:17:43 2008
Errors in file d:\app\administrator\diag\rdbms\prod\prod\trace\prod_j001_744.trc:
ORA-12012: error on auto execute of job 4005
ORA-28031: maximum of 148 enabled roles exceeded
...

Because of the ORA-28031 error no job is running. The user owning the job is able to connect to the database and furthermore has no errors while running the code executed via the job.

 

2) An user gets the following error while connecting to the database:

SQL> conn testrole2/testrole2
ERROR:
ORA-28031: maximum of 148 enabled roles exceeded

 

 

3) While creating a queue table the following error occurs: 

 

EXECUTE DBMS_AQADM.CREATE_QUEUE_TABLE (queue_table =>'QTEST', queue_payload_type => 'TTEST', multiple_consumers=> TRUE,compatible=>'10.2');

*
ERROR at line 1:
ORA-24166: evaluation context SCOTT.AQ$_QTEST_V has errors
ORA-01925: maximum of 30 enabled roles exceeded
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 2220
ORA-06512: at "SYS.DBMS_AQADM", line 58
ORA-06512: at line 1

 

 

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms