本文记录了一次因操作系统升级导致的Oracle Enterprise Manager启动失败问题及其解决过程。文章详细描述了错误信息、具体步骤，包括停止dbconsole服务、调整时区设置、执行数据库设置命令等，最终使EM恢复正常运行。
操作系统版本为
[quote]root@hisdb01:/#oslevel -r
5300-09[/quote]
数据库版本为
[quote]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[/quote]
由于操作系统从5305升级至5309，升级完成后启动Enterprise Manager时，后台报如下错误
[quote]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)
[/quote]
解决方法如下：
1、停止dbconsole
[quote]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.[/quote]
2、重新设置时区
[quote]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')[/quote]
3、数据库中执行设置时区包
[quote]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[/quote]
4、启动dbconsole
[quote]oracle.orcl1@hisdb01:/home/oracle$emctl start 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
Agent Version : 10.1.0.6.0
OMS Version : 10.1.0.6.0
Protocol Version : 10.1.0.2.0
Agent Home : /oracle/products/rdbms/hisdb01_orcl1
Agent binaries : /oracle/products/rdbms
Agent Process ID : 590036
Parent Process ID : 1
Agent URL : https://hisdb01:3938/emd/main
Started at : 2010-03-16 08:21:51
Started by user : oracle
Last Reload : 2010-03-16 08:21:51
Last successful upload : (none)
Last attempted upload : (none)
Total Megabytes of XML files uploaded so far : 0.00
Number of XML files pending upload : 15
Size of XML files pending upload(MB) : 0.07
Available disk space on upload filesystem : 21.39%
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/products/rdbms/hisdb01_orcl1/sysman/log[/quote]
5、 查看dbconsole状态，可以看到已经成功启动，web访问也一切正常。
[quote]oracle.orcl1@hisdb01:/home/oracle$emctl status 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
Oracle Enterprise Manager 10g is running.
------------------------------------------------------------------
Logs are generated in directory /oracle/products/rdbms/hisdb01_orcl1/sysman/log
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.
oracle.orcl1@hisdb01:/home/oracle$https://172.16.1.99:3938/emd/main
oracle.orcl1@hisdb01:/home/oracle$emctl start 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
Starting Oracle Enterprise Manager 10g Database Control .................. started.
------------------------------------------------------------------
Logs are generated in directory /oracle/products/rdbms/hisdb01_orcl1/sysman/log
[/quote]
6、可奇怪的是，后台报错依旧
[quote]remote host refused an attempted connect operation. (error = 79)
2010-03-16 08:29:20 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:29:26 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:29:32 Thread-1 WARN http: snmehl_connect: connect failed to (hisdb01:3938): A remote host refused an attempted connect operation. (error = 79)[/quote]
[quote]root@hisdb01:/#oslevel -r
5300-09[/quote]
数据库版本为
[quote]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[/quote]
由于操作系统从5305升级至5309，升级完成后启动Enterprise Manager时，后台报如下错误
[quote]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)
[/quote]
解决方法如下：
1、停止dbconsole
[quote]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.[/quote]
2、重新设置时区
[quote]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')[/quote]
3、数据库中执行设置时区包
[quote]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[/quote]
4、启动dbconsole
[quote]oracle.orcl1@hisdb01:/home/oracle$emctl start 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
Agent Version : 10.1.0.6.0
OMS Version : 10.1.0.6.0
Protocol Version : 10.1.0.2.0
Agent Home : /oracle/products/rdbms/hisdb01_orcl1
Agent binaries : /oracle/products/rdbms
Agent Process ID : 590036
Parent Process ID : 1
Agent URL : https://hisdb01:3938/emd/main
Started at : 2010-03-16 08:21:51
Started by user : oracle
Last Reload : 2010-03-16 08:21:51
Last successful upload : (none)
Last attempted upload : (none)
Total Megabytes of XML files uploaded so far : 0.00
Number of XML files pending upload : 15
Size of XML files pending upload(MB) : 0.07
Available disk space on upload filesystem : 21.39%
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/products/rdbms/hisdb01_orcl1/sysman/log[/quote]
5、 查看dbconsole状态，可以看到已经成功启动，web访问也一切正常。
[quote]oracle.orcl1@hisdb01:/home/oracle$emctl status 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
Oracle Enterprise Manager 10g is running.
------------------------------------------------------------------
Logs are generated in directory /oracle/products/rdbms/hisdb01_orcl1/sysman/log
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.
oracle.orcl1@hisdb01:/home/oracle$https://172.16.1.99:3938/emd/main
oracle.orcl1@hisdb01:/home/oracle$emctl start 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
Starting Oracle Enterprise Manager 10g Database Control .................. started.
------------------------------------------------------------------
Logs are generated in directory /oracle/products/rdbms/hisdb01_orcl1/sysman/log
[/quote]
6、可奇怪的是，后台报错依旧
[quote]remote host refused an attempted connect operation. (error = 79)
2010-03-16 08:29:20 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:29:26 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:29:32 Thread-1 WARN http: snmehl_connect: connect failed to (hisdb01:3938): A remote host refused an attempted connect operation. (error = 79)[/quote]
扫一扫
5671
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
