Re: MAX_ROLES_ENABLED =

A copy of this was sent to "Canmor" <canmor_at_micron.net> (if that email address didn't require changing) On Sun, 19 Sep 1999 00:33:21 -0600, you wrote:

>Hi Folks,
>
>I have oracle 8i installed on D:\Ora8iHome. I have a clean bootup.
>When I login as sys/change_on_install, I get the follwoing message.
>"Maximum of 20 enabled roles exceeded".
>
>Once I added MAX_ROLES_ENABLED = 25 to
>init.ora, I couldn't login at all. I get "Oracle not availabe".
>I check the services. Everything seems started.
>When I removed the line and rebooted, I was able to login
>again except as sys/change_on_install user.
>
>Any tips as to where to add this line or how to get around it,
>would be appreciated.
>

all non default roles are granted to sys by default.

you must have >20 default roles.

sys fails upon logging in due to this. To increase add:

max_enabled_roles = 100

or some number (NOT max_roles_enabled).

the database failed to start with this invalid parameter (hence Oracle not available). removing it fixed the startup error but not the sys error.

>Thanks
>
>Lahcen
>

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sun Sep 19 1999 - 08:22:14 CDT