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