?
Solved

ORA-1925 maximum of 30 enabled roles exceeded

Posted on 2004-09-14
5
Medium Priority
?
1,322 Views
Last Modified: 2008-01-09
ORA-1925 maximum of <#> enabled roles exceeded

can someone please help me how to fix this error.

many thanks.
0
Comment
Question by:crishna1
  • 3
  • 2
5 Comments
 

Author Comment

by:crishna1
ID: 12059708
i am using 9.2.0.5.
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 12059783
Error:  ORA 1925  
Text:   maximum of <num> enabled roles exceeded  
-------------------------------------------------------------------------------
Cause:  The specified number of enabled roles exceeds the value specified in          
the initialization parameter MAX_ENABLED_ROLES.



Action: Increase MAX_ENABLED_ROLES and restart the instance.



This should do it for you. Just need to modify INIT<SID>.ORA file located under $ORACLE_HOME/network/admin folder.

and restart the database.
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 12059795
you might use SPFILE instead.

to make the modifiction in init<SID>.ora into effect, you have to regenerate SPFILE after editing the init<SID>.ora

SQL>create spfile='<SPFILE file path>' from pfile='<PFILE location>';

then start the database
0
 

Author Comment

by:crishna1
ID: 12059811
i could'nt find tha parameter MAX_ENABLED_ROLES  in the init.ora file, do i have to add it?
0
 
LVL 23

Accepted Solution

by:
seazodiac earned 2000 total points
ID: 12059952
Yes, just add it.

If parameters are not specified, they take default.
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Suggested Courses
Course of the Month15 days, 17 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question