日期:2014-05-16  浏览次数:20522 次

[转载]oracle 10g 修改IP地址导致系统无法启动oracleDBConsole的解决方法
更改了数据库服务器的ip地址,数据库重新启动后弹出windows不能在本地启动OracleDBConsole,错误代码2的错误。手动可以启动服务。
在命令行执行 emctl start dbconsole 命令,提示
C:\Documents and Settings\Administrator>emctl start dbconsole
Environment variable ORACLE_SID not defined. Please define it.
输入 set oracle_sid=orcl   orcl是数据库的SID。
C:\Documents and Settings\Administrator>set oracle_sid=orcl
再次执行 emctl start dbconsole 命令,提示
C:\Documents and Settings\Administrator>emctl start dbconsole
OC4J Configuration issue. C:\oracle\product\10.2.0\db_1/oc4j/j2ee/OC4J_DBConsole
_192.168.32.128_orcl not found.
进入C:\oracle\product\10.2.0\db_1/oc4j/j2ee目录,发现有OC4J_DBConsole_“计算机名"_orcl目录,复制该目录,将计算机名改为提示中出现的地址。
再次执行 emctl start dbconsole 命令,提示
C:\Documents and Settings\Administrator>emctl start dbconsole
EM Configuration issue. C:\oracle\product\10.2.0\db_1/192.168.32.128_orcl not fo
und.
操作同上一步,执行 emctl start dbconsole 命令,提示
C:\Documents and Settings\Administrator>emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://计算机名:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ...OracleDBConsoleorcl
服务正在启动 ...................................................................
..........
OracleDBConsoleorcl 服务已经启动成功。
后记:重启后OracleDBConsoleorcl服务可以开机启动,但登录sqlplus时却显示连接到空的例程,监听正常,执行 emctl start dbconsole 命令又提示没有定义SID,运行emca -config dbcontrol db -repos recreate 重新配置 em ,几次都在删除配置时卡住不动,无奈下只好重新启动,开机后发现一切正常了,数据库可以正常启动,远程可以连接,真是诡异。