Error Ora 01925
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
ORA-01925: maximum of string enabled roles exceeded tips Oracle Error Tips by Burleson Consulting (S. Karam) The Oracle docs note this on the ora-01925 error: ORA-01925: maximum of string enabled roles exceeded Cause: The INIT.ORA parameter "max_enabled_roles" has been exceeded. Action: Increase max_enabled_roles and warm start the database. An example of increasing max_enable_roles is on the Oracle MOSC Forums, a user is confronted with ORA-01925 on SQL*PLUS Version 9.0.1.0.1 . An Oracle advisor replies that the next action should be: Go to $ORACLE_HOME/dbs and rename your spfile to another name (.bak). Change the parameter in the init file, set to 148. Restart your database. Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications. Errata? Oracle technology is changing and we strive to update our BC Oracle support information. If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just e-mail: and include the URL for the page. Burleson Consulting The Oracle of Database Support Oracle Performance Tuning Remote DBA Services Copyright © 1996 - 2016 All rights reserved by Burleson Oracle is the registered trademark of Oracle Corporation. ��first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 6 of 6 Thread: ORA-01925: maximum of 30 enabled roles exceeded Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 10-21-03,13:19 #1 Waqas_lodhi2000 View Profile View Forum Posts Registered http://www.dba-oracle.com/t_ora_01925_maximum_of_string_enabled_roles_exceeded.htm User Join Date Oct 2003 Location Dammam Posts 4 Unanswered: ORA-01925: maximum of 30 enabled roles exceeded While importing database tables I found this message: ORA-01925: maximum of 30 enabled roles exceeded I don't know why this message is coming. As we cannot change this parameter in parameter file. Reply With Quote 10-21-03,13:35 #2 gbrabham View Profile View Forum Posts Registered User Join Date Apr 2003 http://www.dbforums.com/showthread.php?953115-ORA-01925-maximum-of-30-enabled-roles-exceeded Location Greenville, SC (USA) Posts 1,155 This is a parameter in your INITxxxx.ORA initialization file... MAX_ENABLED_ROLES = xxxx HTH Gregg Reply With Quote 10-21-03,13:39 #3 Waqas_lodhi2000 View Profile View Forum Posts Registered User Join Date Oct 2003 Location Dammam Posts 4 In my initsidxxx.ora file the value is MAX_ENABLED_ROLES = 30 Thanks Reply With Quote 10-21-03,14:01 #4 gbrabham View Profile View Forum Posts Registered User Join Date Apr 2003 Location Greenville, SC (USA) Posts 1,155 Change the value from 30 to a higher value and "bump" the database. Gregg Reply With Quote 10-22-03,01:33 #5 Waqas_lodhi2000 View Profile View Forum Posts Registered User Join Date Oct 2003 Location Dammam Posts 4 cannot edit that parameter When I am going to change the value through alter session it gives me error that this parameter is not editable. Ok. Thanks Reply With Quote 10-22-03,08:56 #6 gbrabham View Profile View Forum Posts Registered User Join Date Apr 2003 Location Greenville, SC (USA) Posts 1,155 This is not a dynamic parameter... You have to put it in the INITxxx.ora initialization file and restart the database Gregg Reply With Quote Quick Navigation Oracle Top Site Areas Settings Private Messages Subscriptions Who's
-0800 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 http://www.freelists.org/post/oracle-l/ORA01925-maximum-of-30-enabled-roles-exceeded,10 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"
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 6 of 6 Thread: Max_enabled_roles Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 10-02-2008,07:01 AM #1 JMac View Profile View Forum Posts Red Boy of Differdange Join Date Jan 2000 Location Chester, England. Posts 818 Max_enabled_roles I've had a 9.2.0.6 database running for 7 years. Within the last 2 days when I try and connect as SYSTEM I get an error : ORA-01925: MAXIMUM OF 30 ENABLED ROLES EXCEEDED So, I connected as SYS and looked this user's roles: > desc dba_role_privs Name Null? Type ----------------------------------------- -------- ---------------------------- GRANTEE VARCHAR2(30) GRANTED_ROLE NOT NULL VARCHAR2(30) ADMIN_OPTION VARCHAR2(3) DEFAULT_ROLE VARCHAR2(3) > > Select count(*) from dba_role_privs 2 where grantee = 'SYSTEM'; COUNT(*) ---------- 20 > SELECT granted_role, default_role FROM dba_role_privs 2 WHERE grantee = 'SYSTEM'; GRANTED_ROLE DEF ------------------------------ --- DBA YES QA_ROLE YES AC_OWNER YES RG_0_ROLE YES RG_1_ROLE YES RG_2_ROLE YES RG_R_ROLE YES ADMIN_ROLE YES LOGIN_ROLE YES FUSION_ROLE YES INITIAL_ROLE YES GRANTED_ROLE DEF ------------------------------ --- DISTRIB_0_ROLE YES DISTRIB_1_ROLE YES DISTRIB_2_ROLE YES DISTRIB_E_ROLE YES DISTRIB_R_ROLE YES INST_ADMIN_ROLE YES SBS_LOADER_ROLE YES SHIP_QUERY_ROLE YES AQ_ADMINISTRATOR_ROLE YES 20 rows selected. > SHOW parameter MAX_ENABLED NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ max_enabled_roles integer 30 > > > > connect system Enter password: ERROR: ORA-01925: maximum of 30 enabled roles exceeded Warning: You are no longer connected to ORACLE. > > > show user USER is "" > I know I can set the init.ora param as high as 148, but that's not my issue with this. (1) Why has it just started to happen now? (2) Why, if the user only has 20 roles, is SYSTEM exceeding 30 enabled roles? Edit: There are 45 roles actually defined in the system. If this is what is causing the issue, all well and good - though the user in question SYSTEM is shown as only having 20 roles in DBA_ROLE_PRIVS. However, why has it only now just started to happen? No new roles have been added for several years. Last edited by JMac; 10-02-2008 at 07:18 AM. Reply With Quote 10-02-2008,07:33 A