Re: max role exceeded

From: Shreepad Vaidya <Shreepad.Vaidya_at_alltel.com>
Date: Wed, 13 Dec 2000 0:23 -0600
Message-Id: <10708.124417@fatcity.com>

--=_sb2000/12/13-06-21-29-352=_sb

Content-Type: text/plain; charset=us-ascii

Hi Ajay,

1) The value of 20 is the default value.
2) The parameter max_enabled_roles is a static parameter.
3) Checking from v$parameter
     select * from v$parameter where name like 'max%enabled%'
  NUM NAME                TYPE VALUE ISDEFAULT ISSES ISSYS_MOD
ISMODIFIED ISADJ
  268 max_enabled_roles   3   20   TRUE      FALSE FALSE     FALSE

FALSE DESCRIPTION
max number of roles a user can have enabled

3) The value for the parameters ISSES ISSYS_MOD (false) indicates that it cannot be modified in a session(alter session) nor is it system (alter system) modifiable.

4) You will have to increase the max_enabled_roles value in init.ora . 5) Use svrmgrl and restart the database.

HTH
               shreepad.

From: ORACLE-L_at_fatcity.com AT INTERNET on 12/12/2000 16:20

To: ORACLE-L_at_fatcity.com AT INTERNET_at_CCMAIL cc: (bcc: Shreepad Vaidya/EMEA/ALLTELCORP)

Subject: max role exceeded

Hi Listers ,
While trying to connect as sys I got the following error

        ERROR:
        ORA-01925: maximum of 20 enabled roles exceeded

is it possible to bypass this and connect as sys , without restarting the instan
ce ( changing parameter max_enabled_roles) .

TIA
ajay
--=_sb2000/12/13-06-21-29-352=_sb

Content-Type: text/html; name="body.htm"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="body.htm"

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBUcmFuc2l0aW9uYWwv L0VOIj4NCjxIVE1MPjxIRUFEPg0KPE1FVEEgY29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PWlz by04ODU5LTEiIGh0dHAtZXF1aXY9Q29udGVudC1UeXBlPg0KPE1FVEEgY29udGVudD0iTVNIVE1M IDUuMDAuMzEwNS4xMDUiIG5hbWU9R0VORVJBVE9SPg0KPFNUWUxFPjwvU1RZTEU+DQo8L0hFQUQ+ DQo8Qk9EWSBiZ0NvbG9yPSNmZmZmZmY+DQo8RElWPjxGT05UIGZhY2U9QXJpYWwgc2l6ZT0yPkhp IExpc3RlcnMgLDwvRk9OVD48L0RJVj4NCjxESVY+PEZPTlQgZmFjZT1BcmlhbCBzaXplPTI+V2hp bGUgdHJ5aW5nIHRvIGNvbm5lY3QgYXMgc3lzIEkgZ290IHRoZSBmb2xsb3dpbmcgDQplcnJvcjwv Rk9OVD48L0RJVj4NCjxESVY+PEZPTlQgZmFjZT1BcmlhbCBzaXplPTI+Jm5ic3A7Jm5ic3A7Jm5i c3A7ICZuYnNwOyZuYnNwOyZuYnNwOyANCkVSUk9SOjxCUj4mbmJzcDsmbmJzcDsmbmJzcDsgJm5i c3A7Jm5ic3A7Jm5ic3A7IE9SQS0wMTkyNTogbWF4aW11bSBvZiAyMCBlbmFibGVkIA0Kcm9sZXMg ZXhjZWVkZWQ8L0ZPTlQ+PC9ESVY+DQo8RElWPiZuYnNwOzwvRElWPg0KPERJVj48Rk9OVCBmYWNl PUFyaWFsIHNpemU9Mj5pcyBpdCBwb3NzaWJsZSB0byBieXBhc3MgdGhpcyBhbmQgY29ubmVjdCBh cyBzeXMgLCANCndpdGhvdXQgcmVzdGFydGluZyB0aGUgaW5zdGFuY2UgKCBjaGFuZ2luZyBwYXJh bWV0ZXIgbWF4X2VuYWJsZWRfcm9sZXMpIC4gDQo8L0ZPTlQ+PC9ESVY+DQo8RElWPiZuYnNwOzwv RElWPg0KPERJVj48Rk9OVCBmYWNlPUFyaWFsIHNpemU9Mj5USUE8L0ZPTlQ+PC9ESVY+DQo8RElW PjxGT05UIGZhY2U9QXJpYWwgc2l6ZT0yPmFqYXk8L0ZPTlQ+PC9ESVY+DQo8RElWPiZuYnNwOzwv RElWPjwvQk9EWT48L0hUTUw+DQp= Received on Wed Dec 13 2000 - 00:23:14 CST