Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-28031 Maximum of 148 roles enabled roles exeeded

M.M.RSep 14 2010 — edited Sep 15 2010

Hi Experts,

I got the above error for a application schema..

How to resolve it..

SQL> show parameter max_enable

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_enabled_roles integer 150

Is it possible to have more than 150..we can increase..?

Thanks
Mano-DBA

Edited by: M.M.R on Sep 13, 2010 11:50 PM

Edited by: M.M.R on Sep 13, 2010 11:58 PM

This post has been answered by Herald ten Dam on Sep 14 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 13 2010

Added on Sep 14 2010

#general-database-discussions

19 comments

19,695 views