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

最新推荐文章于 2023-03-08 11:47:38 发布

henrybai

最新推荐文章于 2023-03-08 11:47:38 发布

阅读量2.6k

点赞数

文章标签： oracle integer system initialization sql import

本文链接：https://blog.csdn.net/henrybai/article/details/4434382

版权

导入时有如下错误：

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