• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1368
  • Last Modified:

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.
0
crishna1
Asked:
crishna1
  • 3
  • 2
1 Solution
 
crishna1Author Commented:
i am using 9.2.0.5.
0
 
seazodiacCommented:
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
 
seazodiacCommented:
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
 
crishna1Author Commented:
i could'nt find tha parameter MAX_ENABLED_ROLES  in the init.ora file, do i have to add it?
0
 
seazodiacCommented:
Yes, just add it.

If parameters are not specified, they take default.
0
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.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now