zl程序教程

您现在的位置是:首页 >  工具

当前栏目

Oracle10g的DBA无法登录解决方案

DBA解决方案 无法 登录 oracle10g
2023-06-13 09:14:09 时间
下面就是解决方案:
1-Fromthecommandprompt,stopisqlplus:
c:\>isqlplusctlstop
2-AssumingthatyouinstalloracleunderCdrive,runthefollowingcomands:
c:\>setoracle_home=c:\oracle\product\10.2.0\db_1
c:\>setjava_home=%ORACLE_HOME%\jdk

3-Changedirectoryto:
cd%ORACLE_HOME%\oc4j\j2ee\isqlplus\application-deployments\isqlplus

4-Supposeyouneedtocreateanewuserwithusername"yoyo"andpassword"ch51*****",runthefollowingcommand:
%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*PlusDBA/admin"-passwordwelcome-adduser"iSQL*PlusDBA"yoyoch51*****

5-Tocheckthataddingthisnewuserwassuccessful,runthefollowingcommand:
%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*PlusDBA/admin"-passwordwelcome-listusers"iSQL*PlusDBA"
结果:
admin
yoyo
6-TograntauseraccesstothewebDbarolefromthecommandline,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*PlusDBA/admin"-passwordwelcome-grantrolewebDba"iSQL*PlusDBA"yoyo
7-Now,runstartisqlplusagainandenjoyit:
isqlplusctlstart
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,就可以访问了。