广

oracle数据库

  • MYSQL
  • MSSQL
  • Redis
  • MongoDB
  • oracle数据库
  • 数据管理

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

    2018-05-03 14:16:48 次阅读 稿源:互联网
    广告
    全网推广平台,软文发布
    下面就是解决方案:
    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, 就可以访问了。

    一起学吧部分文章转载自互联网,供读者交流和学习,若有涉及作者版权等问题请及时与我们联系,以便更正、删除或按规定办理。感谢所有提供资讯的网站,欢迎各类媒体与一起学吧进行文章共享合作。

    广告
    广告
    广告
    广告