ORA-1925 maximum of 30 enabled roles exceeded

ORA-1925 maximum of <#> enabled roles exceeded

can someone please help me how to fix this error.

many thanks.
Who is Participating?
seazodiacConnect With a Mentor Commented:
Yes, just add it.

If parameters are not specified, they take default.
crishna1Author Commented:
i am using
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.
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
crishna1Author Commented:
i could'nt find tha parameter MAX_ENABLED_ROLES  in the init.ora file, do i have to add it?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.