RE: ORA-01925: maximum of 30 enabled roles exceeded
- From: Thomas Day <tday6@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 25 Feb 2004 14:08:12 -0500
Go to your INIT{SID}.ora file, change the max_enabled_roles to something
rather bigish, start up the database.
"Powell, Mark D"
<mark.powell To:
"'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
@eds.com> cc:
Sent by: Subject: RE: ORA-01925: maximum
of 30 enabled roles exceeded
oracle-l-bounce
02/25/2004 01:33
PM
Please respond
to oracle-l
This may not be the best workaround but I believe you can log in with a DBA
ID and then drop and recreate a couple of the roles attached to SYS because
they were created under the SYS ID. This does require that you are able to
re-grant all privileges to the role or that a couple of old and obsolete
roles exist that you need to clean up anyway.
Problems like this are one reason the SYS ID should not be used to perform
DBA tasks like creating users, roles, or user objects.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Levesque, Roger I. ,
CTR , WHS/PSD
Sent: Wednesday, February 25, 2004 1:25 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: ORA-01925: maximum of 30 enabled roles exceeded
Yes. What happens is, because I cannot logon to sys, it won't let me make
the change which is a kind of catch-22. I am looking for a way around it
so
I can logon. I am in Oracle 8.1.7.4.0.
Thanks
-----Original Message-----
From: Juan Cachito Reyes Pacheco [mailto:jreyes@xxxxxxxxxxxxxxxx]
Sent: Wednesday, February 25, 2004 12:48 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: ORA-01925: maximum of 30 enabled roles exceeded
Did you tried to increase the parameter
MAX_ENABLED_ROLES = 70
----- Original Message -----
From: "Levesque, Roger I. , CTR , WHS/PSD" <levesr@xxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, February 25, 2004 1:52 PM
Subject: ORA-01925: maximum of 30 enabled roles exceeded
> I get ORA-01925: maximum of 30 enabled roles exceeded when I try to
> logon with the sys id. Any ideas??
>
> Thanks
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put
> 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
