Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
ORA-01925: maximum of 30 enabled roles exceeded

ORA-01925: maximum of 30 enabled roles exceeded

2004-02-25       - By Jared.Still@(protected)
Reply:     <<     11     12  

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 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 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 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. 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 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 ORA-01925.ora-code.com): maximum of 30 enabled roles exceeded
>
>
> > I get ORA-01925 (See 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)> </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 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 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 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.  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 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)> <br >
> To: <oracle-l@(protected)> <br >
> Sent: Wednesday, February 25, 2004 1:52 PM <br >
> Subject: ORA-01925 (See ORA-01925.ora-code.com): maximum of 30 enabled roles exceeded <br >
> <br >
> <br >
> > I get ORA-01925 (See 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 >