Oracle 10g的DBA无法登录解决方案

下面就是解决方案:


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, 就可以访问了。

(0)
上一篇 2022年3月22日
下一篇 2022年3月22日

相关推荐