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

Oracle Enterprise Manager启动错误
操作系统版本为

引用
root@hisdb01:/#oslevel -r
5300-09


数据库版本为

引用
SQL> select * from v$version;

BANNER
----------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE    10.2.0.4.0      Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Productio
NLSRTL Version 10.2.0.4.0 - Production


由于操作系统从5305升级至5309,升级完成后启动Enterprise Manager时,后台报如下错误

引用
2010-03-15 16:16:03 Thread-1 WARN  http: snmehl_connect: connect failed to (hisdb01:3938): A remote host refused an attempted connect operation. (error = 79)
2010-03-15 16:17:11 Thread-1 WARN  http: snmehl_connect: connect failed to (hisdb01:3938): A remote host refused an attempted connect operation. (error = 79)
2010-03-15 16:17:11 Thread-1 WARN  http: snmehl_connect: connect failed to (hisdb01:3938): A remote host refused an attempted connect operation. (error = 79)
2010-03-16 08:19:42 Thread-1 WARN  http: snmehl_connect: connect failed to (hisdb01:3938): A remote host refused an attempted connect operation. (error = 79)


解决方法如下:
1、停止dbconsole

引用
oracle.orcl1@hisdb01:/home/oracle$emctl stop dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation.  All rights reserved.
https://hisdb01:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Database Control ...
...  Stopped.


2、重新设置时区
引用
oracle.orcl1@hisdb01:/home/oracle$export TZ=BEIST-8
oracle.orcl1@hisdb01:/home/oracle$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/products/rdbms/hisdb01_orcl1/sysman/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('hisdb01: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('hisdb01:3938','+08:00')


3、数据库中执行设置时区包

引用
oracle.orcl1@hisdb01:/home/oracle$sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Mar 16 08:22:50 2010

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> alter session set current_schema = SYSMAN;

Session altered.

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

PL/SQL procedure successfully completed.

SQL> exit



4、启动dbconsole

引用
oracle.orcl1@hisdb01:/home/oracle$emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996