ORA-28031 / ORA-01925: maximum of 148 enabled roles exceeded
(Doc ID 780749.1)
Last updated on FEBRUARY 23, 2023
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]
Oracle Net Services - Version 19.1.0.0.0 to 19.1.0.0.0 [Release 19.0]
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
...
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 |