Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

How to disable oracle's MAX_ENABLED_ROLES limit or expand the value of limitation. [oracle 10g (win32)]

share|improve this question
What are you set to now, what are you trying to set it to, and what problem are you trying to solve? –  mrdenny Jun 15 '13 at 21:03
add comment

migrated from stackoverflow.com Apr 16 '13 at 20:06

This question came from our site for professional and enthusiast programmers.

1 Answer

You can change the setting up to 148 apparently, http://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams117.htm

If you can upgrade to 11g this parameter is deprecated and there is no limit any more (apparently): http://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams130.htm

share|improve this answer
This is not the answer :( –  MJ.Ahmadi Apr 16 '13 at 7:51
What's the problem? –  Colin 't Hart Apr 16 '13 at 8:00
on 11g I read "Range of values 0 to 148" :) –  Florin Ghita Apr 16 '13 at 8:31
I also read: "The MAX_ENABLED_ROLES parameter is deprecated. It is retained for backward compatibility only." –  Colin 't Hart Apr 16 '13 at 8:39
The 10gR2 docs you linked to say it is deprecated too. But the 11g docs also have this, which suggests it isn't really deprecated, as OS_ROLES isn't. Maybe the answer is to set OS_ROLES=FALSE? –  Alex Poole Apr 16 '13 at 9:27
show 1 more comment

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.