 | | | ORA-01925: maximum of 30 enabled roles exceeded | ORA-01925: maximum of 30 enabled roles exceeded 2004-02-25 - By Jared.Still@(protected)
Back
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@(protected)>
Sent by: oracle-l-bounce@(protected)
02/25/2004 11:42 AM
Please respond to oracle-l
To: oracle-l@(protected)
cc:
Subject: Re: ORA-01925 (See http://ORA-01925.ora-code.com): 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@(protected)>
Reply-To: oracle-l@(protected)
To: <oracle-l@(protected)>
Subject: Re: ORA-01925 (See http://ORA-01925.ora-code.com): 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@(protected)>
To: <oracle-l@(protected)>
Sent: Wednesday, February 25, 2004 2:24 PM
Subject: RE: ORA-01925 (See http://ORA-01925.ora-code.com): 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 (See http://tch-22.ora-code.com). 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@(protected)]
> Sent: Wednesday, February 25, 2004 12:48 PM
> To: oracle-l@(protected)
> Subject: Re: ORA-01925 (See http://ORA-01925.ora-code.com): 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@(protected)>
> To: <oracle-l@(protected)>
> Sent: Wednesday, February 25, 2004 1:52 PM
> Subject: ORA-01925 (See http://ORA-01925.ora-code.com): maximum of 30 enabled roles exceeded
>
>
> > I get ORA-01925 (See http://ORA-01925.ora-code.com): 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@(protected) 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
> > -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
> >
>
<br><font size=2 face="sans-serif">This is 8i, correct?</font>
<br>
<br><font size=2 face="sans-serif">Just log in with srvmgrl and remove the
roles from the account that has too many.</font>
<br>
<br><font size=2 face="sans-serif">It's likely that you have created many roles
as the sys user. If so, they are automatically</font>
<br><font size=2 face="sans-serif">granted to SYS as a default role.</font>
<br>
<br><font size=2 face="sans-serif">Logging in with 'sqlplus "/ as sysdba
"' will also work.</font>
<br>
<br><font size=2 face="sans-serif">Jared</font>
<br><font size=2 face="sans-serif"><br>
</font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td>
<td><font size=1 face="sans-serif"><b>"M Rafiq" <rafiq9857@(protected)
.com></b></font>
<br><font size=1 face="sans-serif">Sent by: oracle-l-bounce@(protected)</font>
<p><font size=1 face="sans-serif"> 02/25/2004 11:42 AM</font>
<br><font size=2 face="sans-serif"> </font><font size=1 face="sans-serif"
>Please respond to oracle-l</font>
<br>
<td><font size=1 face="Arial"> </font>
<br><font size=1 face="sans-serif"> To:  
; oracle-l@(protected)</font>
<br><font size=1 face="sans-serif"> cc:  
; </font>
<br><font size=1 face="sans-serif"> Subject:
Re: ORA-01925 (See http://ORA-01925.ora-code.com): maximum of 30 enabled roles exceeded</font><
/table>
<br>
<br>
<br><font size=2 face="Courier New">Roger,<br>
<br>
your option of shutdown is<br>
<br>
svrmgrl<br>
connect internal<br>
shutdown abort<br>
<br>
change the param in initSID.ora and<br>
<br>
start your database...<br>
<br>
Regards<br>
Rafiq<br>
<br>
<br>
<br>
<br>
<br>
From: "Juan Cachito Reyes Pacheco" <jreyes@(protected)><br>
Reply-To: oracle-l@(protected)<br>
To: <oracle-l@(protected)><br>
Subject: Re: ORA-01925 (See http://ORA-01925.ora-code.com): maximum of 30 enabled roles exceeded<br>
Date: Wed, 25 Feb 2004 15:02:32 -0400<br>
<br>
can't you change the init.ora and restart the database?<br>
<br>
-- -- Original Message -- --<br>
From: "Levesque, Roger I. , CTR , WHS/PSD" <levesr@(protected)>
<br>
To: <oracle-l@(protected)><br>
Sent: Wednesday, February 25, 2004 2:24 PM<br>
Subject: RE: ORA-01925 (See http://ORA-01925.ora-code.com): maximum of 30 enabled roles exceeded<br>
<br>
<br>
> Yes. What happens is, because I cannot logon to sys, it won't let
me <br>
make<br>
> the change which is a kind of catch-22 (See http://tch-22.ora-code.com). I am looking for a way
around it<br>
so<br>
> I can logon. I am in Oracle 8.1.7.4.0.<br>
><br>
> Thanks<br>
><br>
> -- --Original Message-- --<br>
> From: Juan Cachito Reyes Pacheco [mailto:jreyes@(protected)]<br>
> Sent: Wednesday, February 25, 2004 12:48 PM<br>
> To: oracle-l@(protected)<br>
> Subject: Re: ORA-01925 (See http://ORA-01925.ora-code.com): maximum of 30 enabled roles exceeded<br>
><br>
><br>
> Did you tried to increase the parameter<br>
> MAX_ENABLED_ROLES = 70<br>
><br>
><br>
> -- -- Original Message -- --<br>
> From: "Levesque, Roger I. , CTR , WHS/PSD" <levesr@(protected)
.mil><br>
> To: <oracle-l@(protected)><br>
> Sent: Wednesday, February 25, 2004 1:52 PM<br>
> Subject: ORA-01925 (See http://ORA-01925.ora-code.com): maximum of 30 enabled roles exceeded<br>
><br>
><br>
> > I get ORA-01925 (See http://ORA-01925.ora-code.com): maximum of 30 enabled roles exceeded when I try to
<br>
> > logon with the sys id. Any ideas??<br>
> ><br>
> > Thanks<br>
> > -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------<br>
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com<br>
> > -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------<br>
> > To unsubscribe send email to: oracle-l-request@(protected)
put<br>
> > 'unsubscribe' in the subject line.<br>
> > --<br>
> > Archives are at http://www.freelists.org/archives/oracle-l/<br>
> > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html<br>
> > -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --<br>
> ><br>
><br>
</font>
<br>
<br>
|
|
|