EM 啟動失敗解決辦法

$ emctl start dbconsole

Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0

Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.

[url]http://p570:1158/em/console/aboutApplication[/url]

Agent Version : 10.1.0.4.1

OMS Version : Unknown

Protocol Version : 10.1.0.2.0

Agent Home : /oracle/oracle10G/p570_oradb

Agent binaries : /oracle/oracle10G

Agent Process ID : 577968

Parent Process ID : 774356

Agent URL : [url]http://p570:3938/emd/main[/url]

Started at : 2006-01-15 11:03:33

Started by user : oracle

Last Reload : 2006-01-15 11:03:33

Last successful upload : (none)

Last attempted upload : (none)

Total Megabytes of XML files uploaded so far : 0.00

Number of XML files pending upload : 1281

Size of XML files pending upload(MB) : 7.78

Available disk space on upload filesystem : 44.73%

Agent is already started. Will restart the agent

Stopping agent ... stopped.

Starting Oracle Enterprise Manager 10g Database Control .... started.

------------------------------------------------------------------

Logs are generated in directory /oracle/oracle10G/p570_oradb/sysman/log

$

emdctl.trc記錄如下：

2006-01-15 09:42:10 Thread-1 WARN http: snmehl_connect: connect failed to (p570:3938): A remote host refused an attempted connect operation. (error = 79)

2006-01-15 09:42:21 Thread-1 ERROR http: 6: snmehl_read: error on read: A connection with a remote socket was reset by that socket. (error = 73)

2006-01-15 09:42:40 Thread-1 WARN http: snmehl_connect: connect failed to (p570:3938): A remote host refused an attempted connect operation. (error = 79)

2006-01-15 09:44:16 Thread-1 WARN http: snmehl_connect: connect failed to (p570:1158): A remote host refused an attempted connect operation. (error = 79)

2006-01-15 09:46:46 Thread-1 WARN http: snmehl_connect: connect failed to (p570:1158): A remote host refused an attempted connect operation. (error = 79)

2006-01-15 09:49:17 Thread-1 WARN http: snmehl_connect: connect failed to (p570:1158): A remote host refused an attempted connect operation. (error = 79)

2006-01-15 09:51:47 Thread-1 WARN http: snmehl_connect: connect failed to (p570:1158): A remote host refused an attempted connect operation. (error = 79)

不能通路]http://p570:1158/em

是時區設定的問題,metalink上有解決方法:

$export TZ=RPC

$cd $ORACLE_HOME/bin

$./emctl resetTZ agent

根據提示用sys/sysman執行相關語句

$ emctl resetTZ agent

Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0 

Copyright (c) 1996, 2007 Oracle Corporation.  All rights reserved.

Updating /oracle/app/oracle/OraHome_1/p630_aixora/sysman/config/emd.properties...

Time zone set to +00: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('p630:3938','+00: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('p630:3938','+00:00')

$ sqlplus /nolog

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Oct 8 02:38:36 2012

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

SQL> conn sysman/123

Connected.

SQL> exec mgmt_target.set_agent_tzrgn('p630:3938','+00:00')

PL/SQL procedure successfully completed.

$emctl start dbconsole

解決！