java.lang.Exception: IOException in sending Request :: Connection refused 解決方法一

java.lang.Exception: IOException in sending Request :: Connection refused 解決方法一

 

1.進入$ORACLE_HOME/ORACLE_SID/sysman/log

查看emagent.trc

 

2.發現WARN  collector: the column name DiskActivityavwait in this condition does not exist

3.使用emctl resetTZ agent，要據提示執行相關命令；

我這邊的提示信息如下：

Updating /u1/app/oracle/product/10.2.0/db_1/nbbdtmis01.tsmt.com.tw_nbbdtmis/sysm
an/config/emd.properties...
Time zone set to +08:00.

To complete this process, you must either:

connect to the database served by this DBConsole as user 'sysman', and execute:

SQL> exec mgmt_target.set_agent_tzrgn('nbbdtmis01.tsmt.com.tw:3938','+08:00')

                        -- or --

connect to the database served by this DBConsole as user 'sys', and execute:

SQL> alter session set current_schema = SYSMAN;
SQL> exec mgmt_target.set_agent_tzrgn('nbbdtmis01.tsmt.com.tw:3938','+08:00')

 

4.使用SYSMAN登錄，然後執行

exec mgmt_target.set_agent_tzrgn('nbbdtmis01.tsmt.com.tw:3938','+08:00')

5.再執行emctl start dbconsole,OEM啟動OK。