My Oracle Support Banner

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

Last updated on SEPTEMBER 23, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Oracle Database - Enterprise Edition - Version 8.1.7.4 to 11.1.0.7 [Release 8.1.7 to 11.1]
Information in this document applies to any platform.

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:

 

 

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.