2014-02-12
今天在用EM进行数据库备份时时发现oracle 10g R2下EM得一个报错,错误如下 :“java.lang.Exception:IOException in sending Request :: Connection refused: connect”,遂通过查阅资料得到如下解决方案。困惑了许久原以为是操作系统用户oracle没有权限造成的,经过多次检查oracle用户权限和密码都没错误。
查了许多资料发现是时区设置的问题。
oracle修改时区的方法:
停止emagent:[oracle@localhost ~]$ emctl stop agent[oracle@localhost ~]$ emctl stop dbconsole [oracle@localhost ~]$ export TZ=PRC[oracle@localhost ~]$ emctl config agent getTZ[oracle@localhost ~]$ emctl config agent updateTZ[oracle@localhost ~]$ emctl start agent[oracle@localhost ~]$ emctl start dbconsole如果数据库dbconsole不能停止,提示Failed to shutdown DBConsole Gracefully
就要杀死 oc4j 进程
[oracle@localhost ~]$ ps -ef|grep oc4j
oracle 8844 8819 1 18:41 pts/2 00:00:15 /u01/app/oracle/product/10.2.0/db_1/jdk/bin/java -server -Xmx256M -XX:MaxPermSize=96m -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -DORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1 -Doracle.home=/u01/app/oracle/product/10.2.0/db_1/oc4j -Doracle.oc4j.localhome=/u01/app/oracle/product/10.2.0/db_1/localhost_orcl/sysman -DEMSTATE=/u01/app/oracle/product/10.2.0/db_1/localhost_orcl -Doracle.j2ee.dont.use.memory.archive=true -Djava.protocol.handler.pkgs=HTTPClient -Doracle.security.jazn.config=/u01/app/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_localhost_orcl/config/jazn.xml -Djava.security.policy=/u01/app/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_localhost_orcl/config/java2.policy -Djava.security.properties=/u01/app/oracle/product/10.2.0/db_1/oc4j/j2ee/home/config/jazn.security.props -DEMDROOT=/u01/app/oracle/product/10.2.0/db_1/localhost_orcl -Dsysman.md5password=true -Drepapi.oracle.home=/u01/app/oracle/product/10.2.0/db_1 -Ddisable.checkForUpdate=true -Djava.awt.headless=true -jar /u01/app/oracle/product/10.2.0/db_1/oc4j/j2ee/home/oc4j.jar -config /u01/app/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_localhost_orcl/config/server.xmloracle 11946 11915 0 18:57 pts/3 00:00:00 grep oc4j[oracle@localhost ~]$ kill 8844进程杀死后执行停止dbconsole命令
[oracle@localhost ~]$emctl stop dbconsole