Oracle 10g的DBA无法登录解决方案
程序员文章站
2023-11-12 16:19:04
下面就是解决方案: 1- from the command prompt, stop isqlplus: c:\>isqlplusctl stop 2- assumi...
下面就是解决方案:
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, 就可以访问了。
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, 就可以访问了。
推荐阅读
-
Oracle 10g的DBA无法登录解决方案
-
Oracle导dmp出现文件ORA-12154: TNS: 无法解析指定的连接标识符问题的解决方案
-
用户为scott时,用pl/sql登录oracle,报错问题的解决方案
-
使用PLSQL客户端登录ORACLE时报ORA-12502和ORA-12545错误的解决方案
-
PL/SQL登录Oracle数据库报错ORA-12154:TNS:无法解析指定的连接标识符已解决(本地未安装Oracle需要连接服务器上的)
-
sql server连接不上怎么办 SQL Server2008R无法登录的解决方案(1814\18456)
-
sql server连接不上怎么办 SQL Server2008R无法登录的解决方案(181418456)
-
plsql登录oracle数据库时出现的‘适配器无法加载’问题的解决办法
-
sql server连接不上怎么办 SQL Server2008R无法登录的解决方案(1814\18456)
-
sql server连接不上怎么办 SQL Server2008R无法登录的解决方案(1814\18456)