[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

ORA-1925 maximum of 30 enabled roles exceeded

Posted on 2004-09-14
5
Medium Priority
?
1,305 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to recover a database from a user managed backup

650 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