Solved

ORA-1925 maximum of 30 enabled roles exceeded

Posted on 2004-09-14
5
1,259 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
Comment Utility
i am using 9.2.0.5.
0
 
LVL 23

Expert Comment

by:seazodiac
Comment Utility
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
Comment Utility
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
Comment Utility
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 500 total points
Comment Utility
Yes, just add it.

If parameters are not specified, they take default.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Stay Alert! 13 62
PL/SQL Two statements 6 49
Pfile and SPfile - Oracle 2 33
Pl/SQL Query 31 61
Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

763 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now