ORA-01925: maximum of 20 enabled roles exceeded

2001-03-05 Thread Charlie Mengler
Oracle V8.1.6.3 on Solaris 8 oracle@callisto:/u01/app/oracle/admin/CCC/pfile:362 oerr ora 1925 01925, 0, "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,

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

2001-03-05 Thread Robin Li
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. HTH Robin Charlie Mengler wrote: Oracle V8.1.6.3 on Solaris 8 oracle@callisto:/u01/app/oracle/admin/CCC/pfile:362 oerr ora 1925 01925, 0, "maximum of