1 Reply Latest reply: Nov 15, 2012 4:19 AM by 974404 RSS

    How to change time zone of OEM 12c Cloud Control

    Roshni Shankar
      Hi All,

      I installed OEM 12c Cloud Control. While deploying agent on the destination host I am getting a warning "time zone did not match" . So instead of changing time zone of the destination host I want to change time zone for my OEM 12c Cloud Control.

      I have read an article where steps for changing time zone for oms is mentioned as,

      1.Reset agent time zone
      $ORACLE_HOME/bin/emctl resetTZ agent

      2. Check new time zone in the configuration file:
      $ORACLE_HOME/pkgdb_PROD/sysman/config/emd.properties
      agentTZRegion=<New TZ>
      Example:
      agentTZRegion=+03:00

      3. Update target time zone in the database
      sqlplus sysman
      exec mgmt_target.set_agent_tzrgn('<target name>','<new TZ>')

      select timezone_region from mgmt_targets where target_name = '<target name>';
      commit;

      Example:
      sqlplus sysman
      exec mgmt_target.set_agent_tzrgn('localhost:3961','+03:00')
      select timezone_region from mgmt_targets where target_name = 'localhost:3961';
      commit;

      But here I am not understanding one thing, in this command exec mgmt_target.set_agent_tzrgn('<target name>','<new TZ>') what is the <target name>?

      Is is agent, oms or repository. And from where I can get the listen address and port of this <target_name>

      Or, please suggest me a way to change time zone of my OEM.

      Thanks in Advance!!
        • 1. Re: How to change time zone of OEM 12c Cloud Control
          974404
          Roshni Shankar wrote:

          1.Reset agent time zone
          $ORACLE_HOME/bin/emctl resetTZ agent

          2. Check new time zone in the configuration file:
          $ORACLE_HOME/pkgdb_PROD/sysman/config/emd.properties
          agentTZRegion=<New TZ>
          Example:
          agentTZRegion=+03:00

          3. Update target time zone in the database
          sqlplus sysman
          exec mgmt_target.set_agent_tzrgn('<target name>','<new TZ>')

          select timezone_region from mgmt_targets where target_name = '<target name>';
          commit;

          Example:
          sqlplus sysman
          exec mgmt_target.set_agent_tzrgn('localhost:3961','+03:00')
          select timezone_region from mgmt_targets where target_name = 'localhost:3961';
          commit;

          But here I am not understanding one thing, in this command exec mgmt_target.set_agent_tzrgn('<target name>','<new TZ>') what is the <target name>?

          Is is agent, oms or repository. And from where I can get the listen address and port of this <target_name>

          Or, please suggest me a way to change time zone of my OEM.

          Thanks in Advance!!
          you re describing way to change tz on agent, not oms.