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 > > ----------------------------------------------------------------- > > > > ---------------------------------------------------------------- > 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 > ----------------------------------------------------------------- > ---------------------------------------------------------------- > 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 > ----------------------------------------------------------------- > ---------------------------------------------------------------- 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 -----------------------------------------------------------------