时不我待。
分类: Oracle
2009-06-05 15:40:48
[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. |
[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') |
[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> |
[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. 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. 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 : 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]$ |
chinaunix网友2009-08-07 11:17:28
风云,你好! 昨天我登录oeM后报错:java.lang.Exception: IOException in sending Request :: Connection timed out: 今天搜索到你帖子,测试中,我不很明白这句话的含义:SQL> exec mgmt_target.set_agent_tzrgn('db1:3938','PRC') 在命令窗操作后报错: 第 1 行出现错误: SQL> exec mgmt_target.set_agent_tzrgn('db1:3938','PRC') BEGIN mgmt_target.set_agent_tzrgn('db1:3938','PRC'); END; * 第 1 行出现错误: SQL> exec mgmt_target.set_agent_tzrgn('db1:3683','PRC') BEGIN mgmt_target.set_agent_tzrgn('db1:3683','PRC'); END; ORA-20233: Invalid agent name db1:3938 ORA