Re: ORA-01925: maximum of 30 enabled roles exceeded
- From: Jared.Still@xxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 25 Feb 2004 12:06:28 -0800
This is 8i, correct?
Just log in with srvmgrl and remove the roles from the account that has
too many.
It's likely that you have created many roles as the sys user. If so, they
are automatically
granted to SYS as a default role.
Logging in with 'sqlplus "/ as sysdba"' will also work.
Jared
"M Rafiq" <rafiq9857@xxxxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
02/25/2004 11:42 AM
Please respond to oracle-l
To: oracle-l@xxxxxxxxxxxxx
cc:
Subject: Re: ORA-01925: maximum of 30 enabled roles exceeded
Roger,
your option of shutdown is
svrmgrl
connect internal
shutdown abort
change the param in initSID.ora and
start your database...
Regards
Rafiq
From: "Juan Cachito Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
Reply-To: oracle-l@xxxxxxxxxxxxx
To: <oracle-l@xxxxxxxxxxxxx>
Subject: Re: ORA-01925: maximum of 30 enabled roles exceeded
Date: Wed, 25 Feb 2004 15:02:32 -0400
can't you change the init.ora and restart the database?
----- Original Message -----
From: "Levesque, Roger I. , CTR , WHS/PSD" <levesr@xxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, February 25, 2004 2:24 PM
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
> > -----------------------------------------------------------------
> >
>
Other related posts:
