ORA-01925: maximum of 30 enabled roles exceeded 解决办法！

最新推荐文章于 2024-08-07 15:16:54 发布

最新推荐文章于 2024-08-07 15:16:54 发布 · 139 阅读

文章标签：

#数据库

本文记录了解决Oracle数据库导入过程中遇到的角色数量超过30个的最大限制问题。通过调整参数max_enabled_roles并重新启动数据库服务，成功解决了该问题。

导入时有如下错误：

$ imp / file=cptst_full.dmp ignore=y full=y

Import: Release 9.2.0.7.0 - Production on Tue Aug 11 17:22:00 2009

IMP-00058: ORACLE error 1925 encountered
ORA-01925: maximum of 30 enabled roles exceededUsername:
Password:

IMP-00058: ORACLE error 1925 encountered
ORA-01925: maximum of 30 enabled roles exceeded
IMP-00005: all allowable logon attempts failed
IMP-00000: Import terminated unsuccessfully

$ sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.7.0 - Production on Tue Aug 11 17:23:06 2009

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production

SQL> show parameter MAX_ENABLED_ROLES

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_enabled_roles integer 30
SQL> ALTER SYSTEM SET MAX_ENABLED_ROLES = 100 SCOPE =both;
ALTER SYSTEM SET MAX_ENABLED_ROLES = 100 SCOPE =both
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

SQL> show parameter spfile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string ?/dbs/spfile@.ora
SQL> ALTER SYSTEM SET MAX_ENABLED_ROLES = 100 SCOPE =spfile;

System altered.

SQL> shutdown immediate

Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> SQL> startup
ORACLE instance started.

Total System Global Area 370234636 bytes
Fixed Size 455948 bytes
Variable Size 268435456 bytes
Database Buffers 100663296 bytes
Redo Buffers 679936 bytes
Database mounted.
Database opened.
SQL> show parameter MAX_ENABLED_ROLES

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_enabled_roles integer 100
SQL>