下面就是解决方案:
1- from the command prompt, stop isqlplus:
c:\>isqlplusctl stop
2- assuming that you install oracle under c drive, run the following comands:
c:\>set oracle_home=c:\oracle\product\10.2.0\db_1
c:\>set java_home=%oracle_home%\jdk
3- change directory to:
cd %oracle_home%\oc4j\j2ee\isqlplus\application-deployments\isqlplus
4- suppose you need to create a new user with user name ‘yoyo’ and password ‘ch51*****’, run the following command:
%java_home%\bin\java -djava.security.properties=%oracle_home%\oc4j\j2ee\home\config\jazn.security.props -jar %oracle_home%\oc4j\j2ee\home\jazn.jar -user “isql*plus dba/admin” -password welcome -adduser “isql*plus dba” yoyo ch51*****
5- to check that adding this new user was successful, run the following command:
%java_home%\bin\java -djava.security.properties=%oracle_home%\oc4j\j2ee\home\config\jazn.security.props -jar %oracle_home%\oc4j\j2ee\home\jazn.jar -user “isql*plus dba/admin” -password welcome -listusers “isql*plus dba”
结果:
admin
yoyo
6- to grant a user access to the webdba role from the command line, enter:
%java_home%\bin\java -djava.security.properties=%oracle_home%\oc4j\j2ee\home\config\jazn.security.props -jar %oracle_home%\oc4j\j2ee\home\jazn.jar -user “isql*plus dba/admin” -password welcome -grantrole webdba “isql*plus dba” yoyo
7- now, run start isqlplus again and enjoy it:
isqlplusctl start
8. 再次访问: http://hostname:5560/isqlplus/dba, 给出用户名和密码: yoyo 和 ch51***** (全小写),就可看到isqlplus的登入界面,
然后再提供用户名:system,口令:ch51*****, 连接标识:(description=(address_list=(address=(protocol=tcp)(host=kcsqlbi)(port=1521)))(connect_data=(service_name=orcl))),权限sysdba, 就可以访问了。