Enter Your Email

Enter your email address:

Delivered by FeedBurner

Custom Search

Thursday, July 17, 2008

emctl resetTZ agentTZ

rac1-> emctl resetTZ agentTZ
set to US/EasternOracle Enterprise Manager 10g Database Control Release 10.2.0.4.0Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.Updating /u01/app/oracle/product/10.2.0/db_1/rac1_devdb1/sysman/config/emd.properties...Time zone set to US/Eastern.
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('rac1.mycorpdomain.com:3938','US/Eastern')
-- 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('rac1.mycorpdomain.com:3938','US/Eastern')


***************************************************************
rac1-> sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Fri May 9 17:27:37 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - ProductionWith the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> alter session set current_schema = SYSMAN;
Session altered.
SQL> exec mgmt_target.set_agent_tzrgn('rac1.mycorpdomain.com:3938','US/Eastern')
PL/SQL procedure successfully completed.
SQL>
rac1-> emctl start dbconsole devdb1TZ set to US/EasternOracle Enterprise Manager 10g Database Control Release 10.2.0.3.0Copyright (c) 1996, 2006 Oracle Corporation. All rights reserved.
http://rac1.mycorpdomain.com:1158/em/console/aboutApplicationStarting Oracle Enterprise Manager 10g Database Control ............................. started
Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/rac1_devdb1/sysman/log

1 comment:

  1. Hi All,
    Presently am working as senior software developer (vc++) as I am not much interesting to work on this technology, am very much interested in data base domain like DB/Oracle/Linux administration and related to this. So just I wanted to move in DB side.
    Can anyone help / suggest me to altering domain change?
    Post your comments: Vijay.rajput06@gmail.com , Vijay_i4@yahoo.com
    Thanks in Advance,
    Vijay R

    ReplyDelete

 
Copyright © 2005 - 2008 DBA-ONWeb Technical blog. All rights reserved