<div>
Error: &nbsp;ORA 1925 &nbsp;<br />
Text: &nbsp; maximum of &lt;num&gt; enabled roles exceeded &nbsp;<br />
--------------------------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />--- <br />
Cause: &nbsp;The specified number of enabled roles exceeds the value specified in &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
the initialization parameter MAX_ENABLED_ROLES. <br />
<br />
<br />
<br />
Action: Increase MAX_ENABLED_ROLES and restart the instance. <br />
<br />
<br />
<br />
This should do it for you. Just need to modify INIT&lt;SID&gt;.ORA file located under $ORACLE_HOME/network/admin<wbr /> folder.<br />
<br />
and restart the database. 
</div>


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.

<div>
you might use SPFILE instead.<br />
<br />
to make the modifiction in init&lt;SID&gt;.ora into effect, you have to regenerate SPFILE after editing the init&lt;SID&gt;.ora<br />
<br />
SQL&gt;create spfile='&lt;SPFILE file path&gt;' from pfile='&lt;PFILE location&gt;';<br />
<br />
then start the database
</div>


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

<div>
i could'nt find tha parameter MAX_ENABLED_ROLES &nbsp;in the init.ora file, do i have to add it?
</div>


i could'nt find tha parameter MAX_ENABLED_ROLES  in the init.ora file, do i have to add it?

<div>
<div class="content wysiwyg-content">
ORA-1925 maximum of &lt;#&gt; enabled roles exceeded <br />
<br />
can someone please help me how to fix this error.<br />
<br />
many thanks.<br />

</div>
</div>


ORA-1925 maximum of <#> enabled roles exceeded 

can someone please help me how to fix this error.

many thanks.


ORA-1925 maximum of 30 enabled roles exceeded

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.