Oracle9i用户角色数超过默认限制

baobao

在X3中，默认的Oracle9i角色数为30，当导入的folder数超过5个时将出现角色超过默认限制导致无法导入新folder的错误。
修改方法如下：
1. open a windows command session: cmd
2. login into Oracle sqlplus : sqlplus /nolog
3. connect to the instance you want to modify using sys as sysdba role:
   conn [email=sys/change_on_install@adx_v5]sys/change_on_install@adx_v5[/email] as sysdba;
4. alter oracle max_enabled_roles:
   alter system set max_enabled_roles=148 scope=spfile;
5. shutdown Oracle database:shutdown immediate
6. start oracle db:startup