init.ora 里面可以调整
Index > ORACLE Server Parameters > max_enabled_roles max_enabled_roles--------------------------------------------------------------------------------Oracle 9.0.1:
Paramter Name: max_enabled_roles
Description: max number of roles a user can have enabled
Can ALTER SESSION: FALSE
Can ALTER SYSTEM: FALSE
Obsoleted: FALSE Oracle 8.1.7:
Paramter Name: max_enabled_roles
Description: max number of roles a user can have enabled
Can ALTER SESSION: FALSE
Can ALTER SYSTEM: FALSE
Obsoleted: FALSE Oracle 8.0.6:
Paramter Name: max_enabled_roles
Description: max number of roles a user can have enabled
Can ALTER SESSION: FALSE
Can ALTER SYSTEM: FALSE
Obsoleted: FALSE Oracle 7.3.4:
Paramter Name: max_enabled_roles
Description: max number of roles a user can have enabled
Can ALTER SESSION: FALSE
Can ALTER SYSTEM: FALSE
Obsoleted: FALSE Related Error Messages:
ORA-01925: maximum of %s enabled roles exceeded
Cause: The INIT.ORA parameter "max_enabled_roles" has been exceeded.
Action: Increase max_enabled_roles and warm start the database.
Index > ORACLE Server Parameters > max_enabled_roles max_enabled_roles--------------------------------------------------------------------------------Oracle 9.0.1:
Paramter Name: max_enabled_roles
Description: max number of roles a user can have enabled
Can ALTER SESSION: FALSE
Can ALTER SYSTEM: FALSE
Obsoleted: FALSE Oracle 8.1.7:
Paramter Name: max_enabled_roles
Description: max number of roles a user can have enabled
Can ALTER SESSION: FALSE
Can ALTER SYSTEM: FALSE
Obsoleted: FALSE Oracle 8.0.6:
Paramter Name: max_enabled_roles
Description: max number of roles a user can have enabled
Can ALTER SESSION: FALSE
Can ALTER SYSTEM: FALSE
Obsoleted: FALSE Oracle 7.3.4:
Paramter Name: max_enabled_roles
Description: max number of roles a user can have enabled
Can ALTER SESSION: FALSE
Can ALTER SYSTEM: FALSE
Obsoleted: FALSE Related Error Messages:
ORA-01925: maximum of %s enabled roles exceeded
Cause: The INIT.ORA parameter "max_enabled_roles" has been exceeded.
Action: Increase max_enabled_roles and warm start the database.
max_enabled_roles=148 #148是最大值
重新启动数据库