RE: ORA-01925: maximum of 20 enabled roles exceeded

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Mon, 05 Mar 2001 12:49:48 -0800
Message-ID: <F001.002C406E.20010305120533@fatcity.com>

(please see my answer below)

> -----Original Message-----
> From: Robin Li [mailto:rli_at_nyp.org]
> Sent: lundi, 5. mars 2001 11:25
>
> It is static. It happened to me on Version 8.0.6, I increased
> the number
> of max_enabled_roles in init.ora file and bounced the DB.
>
> Charlie Mengler wrote:
> >
> > Oracle V8.1.6.3 on Solaris 8
> >
> > <oracle_at_callisto:/u01/app/oracle/admin/CCC/pfile:362> oerr ora 1925
> > 01925, 00000, "maximum of %s enabled roles exceeded"
> > // *Cause:  The INIT.ORA parameter "max_enabled_roles" has
> been exceeded.
> > // *Action: Increase max_enabled_roles and warm start the database.
> >
> > OK, how exactly how do I "warm start the database"?
> > I don't recall ever coming across this term before today.

Of course another possibility is that a user has too many roles allocated, and it doesn't need all that roles. When you CREATE ROLE the role is granted by default to the creating user, but the creating user doesn't necessarily need to be granted the role. Perhaps you could just revoke some roles from the user that has more than the maximum?

select grantee, count (*)
from dba_role_privs
group by grantee
having count (*) > (your maximum) ;

---

any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer.

 
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com Received on Mon Mar 05 2001 - 14:49:48 CST