exec mgmt_target.set_agent_tzrgn
来源:互联网 发布:手机压缩视频软件 编辑:程序博客网 时间:2024/05/06 20:31
oem 报错“java.lang.Exception: IOException in send……”
oracle 10g R2 登陆EM管理控制台,题头报错如下:
“java.lang.Exception: IOException in sending Request :: Connection refused: connect”
处理方法如下:
1.停止emagent:
[oracle@rac1]$ export ORACLE_SID=rac1
[oracle@rac1]$ emctl stop agent
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
This will stop the Oracle Enterprise Manager 10g Database Control process. Continue [y/n] :y
Stopping Oracle Enterprise Manager 10g Database Control ...
... Stopped.
Agent is not running.
2.重新设置时区:
[oracle@rac1~]$ emctl resetTZ agent
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
Updating /u01/app/oracle/product/10.2.0/db_1/db1_zddb1/sysman/config/emd.properties...
Time zone set to PRC.
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('db1:3938','PRC')
-- 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('db1:3938','PRC')
3.以sysdba身份登陆,设置如下:
[oracle@rac1~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jun 5 15:18:16 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 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('db1:3938','PRC')
PL/SQL procedure successfully completed.
SQL>
4.启动emconsole
[oracle@rac1]$ emctl start agent
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
Starting agent ... started.
[oracle@rac1]$ emctl stop dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://db1:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Database Control ...
Cannot determine Oracle Enterprise Manager 10g Database Control process. /u01/app/oracle/product/10.2.0/db_1/db1_zddb1/emctl.pid does not exist.
[oracle@rac1]$ emctl start dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://db1: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 : /u01/app/oracle/product/10.2.0/db_1/db1_zddb1
Agent binaries : /u01/app/oracle/product/10.2.0/db_1
Agent Process ID : 16300
Parent Process ID : 16292
Agent URL : https://db1:3938/emd/main
Started at : 2009-06-05 15:12:49
Started by user : oracle
Last Reload : 2009-06-05 15:12:49
Last successful upload : (none)
Last attempted upload : (none)
Total Megabytes of XML files uploaded so far : 0.00
Number of XML files pending upload : 8
Size of XML files pending upload(MB) : 1.59
Available disk space on upload filesystem : 90.92%
Agent is already started. Will restart the agent
Stopping agent ... stopped.
Starting Oracle Enterprise Manager 10g Database Control ................................ started.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/db1_zddb1/sysman/log
[oracle@rac1]$
“java.lang.Exception: IOException in sending Request :: Connection refused: connect”
处理方法如下:
1.停止emagent:
[oracle@rac1]$ export ORACLE_SID=rac1
[oracle@rac1]$ emctl stop agent
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
This will stop the Oracle Enterprise Manager 10g Database Control process. Continue [y/n] :y
Stopping Oracle Enterprise Manager 10g Database Control ...
... Stopped.
Agent is not running.
2.重新设置时区:
[oracle@rac1~]$ emctl resetTZ agent
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
Updating /u01/app/oracle/product/10.2.0/db_1/db1_zddb1/sysman/config/emd.properties...
Time zone set to PRC.
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('db1:3938','PRC')
-- 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('db1:3938','PRC')
3.以sysdba身份登陆,设置如下:
[oracle@rac1~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jun 5 15:18:16 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 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('db1:3938','PRC')
PL/SQL procedure successfully completed.
SQL>
4.启动emconsole
[oracle@rac1]$ emctl start agent
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
Starting agent ... started.
[oracle@rac1]$ emctl stop dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://db1:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Database Control ...
Cannot determine Oracle Enterprise Manager 10g Database Control process. /u01/app/oracle/product/10.2.0/db_1/db1_zddb1/emctl.pid does not exist.
[oracle@rac1]$ emctl start dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://db1: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 : /u01/app/oracle/product/10.2.0/db_1/db1_zddb1
Agent binaries : /u01/app/oracle/product/10.2.0/db_1
Agent Process ID : 16300
Parent Process ID : 16292
Agent URL : https://db1:3938/emd/main
Started at : 2009-06-05 15:12:49
Started by user : oracle
Last Reload : 2009-06-05 15:12:49
Last successful upload : (none)
Last attempted upload : (none)
Total Megabytes of XML files uploaded so far : 0.00
Number of XML files pending upload : 8
Size of XML files pending upload(MB) : 1.59
Available disk space on upload filesystem : 90.92%
Agent is already started. Will restart the agent
Stopping agent ... stopped.
Starting Oracle Enterprise Manager 10g Database Control ................................ started.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/db1_zddb1/sysman/log
[oracle@rac1]$
- exec mgmt_target.set_agent_tzrgn
- Exec
- exec
- exec
- exec
- exec
- exec
- exec
- exec
- EXEC
- exec
- -exec
- exec
- wait&exec
- exec.exe
- EXEC Statement
- exec() method
- exec函数
- 做一棵永远成长的苹果树
- 微软.NET程序员系列
- 启动sendmail出错的解决办法
- struts2 common-fileupload上传文件大小限制 - hanxin830311 - JavaEye技术网站
- ASP.NET 模式窗口中调用后台代码
- exec mgmt_target.set_agent_tzrgn
- 求三角函数中的反正弦/余弦函数
- pam_tally.so模块详细介绍
- ACPI电源管理模式详解
- 靠近云计算:ubuntu上安装cassandra分布式数据库
- shell 2>&1 解释
- 我爱你
- 通过例子学习Jquery---超级链接提示
- 关于WD IFbA(Interactive Form by Adobe)的内存使用量问题