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

wapysun

浏览: 21440485 次
性别:
来自: 杭州

最近访客更多访客>>

devcang

hunankeda110

辽东小小

apex53

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

2012-06 ( 77)
2012-05 ( 587)
2012-04 ( 177)
更多存档...

导入时有如下错误：

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

分享到：