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

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

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

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

1 Answer 1

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

Your Answer


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