| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-01925: maximum of 30 enabled roles exceeded
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_at_hotmail.com>
Sent by: oracle-l-bounce_at_freelists.org
02/25/2004 11:42 AM
Please respond to oracle-l
To: oracle-l_at_freelists.org
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_at_dazasoftware.com>
Reply-To: oracle-l_at_freelists.org
To: <oracle-l_at_freelists.org>
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?
> 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_at_dazasoftware.com]
> Sent: Wednesday, February 25, 2004 12:48 PM
> To: oracle-l_at_freelists.org
> 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_at_psd.whs.mil>
> To: <oracle-l_at_freelists.org>
> 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_at_freelists.org put
> > 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
> >
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Wed Feb 25 2004 - 14:03:39 CST
 |
 |