Home
All Oracle Error Codes
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

RE: ORA-01925: maximum of 30 enabled roles exceeded

Jamadagni, Rajendra

2004-02-25

Replies:
Hey, we are pushing 148 and some enquired can we push it higher ...

Raj
--------------------------------------------------------------------------------
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
select standard_disclaimer from company_requirements;
QOTD: Any clod can have facts, having an opinion is an art !


-----Original Message-----
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)
Sent: Wednesday, February 25, 2004 1:33 PM
To: 'oracle-l@(protected)'
Subject: RE: ORA-01925: maximum of 30 enabled roles exceeded


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@(protected)
[mailto:oracle-l-bounce@(protected). ,
CTR , WHS/PSD
Sent: Wednesday, February 25, 2004 1:25 PM
To: 'oracle-l@(protected)'
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@(protected)]
Sent: Wednesday, February 25, 2004 12:48 PM
To: oracle-l@(protected)
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@(protected)>
To: <oracle-l@(protected)>
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@(protected)
> '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
> -----------------------------------------------------------------
>

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
'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
-----------------------------------------------------------------
----------------------------------------------------------------
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
-----------------------------------------------------------------
----------------------------------------------------------------
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
-----------------------------------------------------------------
----------------------------------------------------------------
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
-----------------------------------------------------------------