How to change the Timezone for any specific OEM Agent

In this post I am going to share how to change the timezone of an OEM Agent.

Steps:

1) Check Current Timezone of the agent from the OEM repository database

select target_name, timezone_region

from sysman.mgmt_targets

where target_name='funoracleapps.lab'

order by 1,2;

2) Stop the Agent having wrong timezone

emctl stop agent

3) Reset Timezone for agent

emctl resetTZ agent

It will give command to run on OEM repository like below

Oracle Enterprise Manager Cloud Control 12c Release 5

Updating /oem/oracle/agent12c/agent_inst/sysman/config/emd.properties...

Successfully updated /oem/oracle/agent12c/agent_inst/sysman/config/emd.properties.

exec mgmt_target.set_agent_tzrgn('funoracleapps.lab:3872','Asia/Singapore')

and commit the changes

This can be done for example by logging into sqlplus and doing

SQL> exec mgmt_target.set_agent_tzrgn('funoracleapps.lab:3872','Asia/Singapore')

SQL> commit

4) Execute command on the OEM respository database

SQL> exec mgmt_target.set_agent_tzrgn('funoracleapps.lab:3872','Asia/Singapore')

SQL> commit

Commit complete.

5) Check the OEM Repository again

select target_name, timezone_region

from sysman.mgmt_targets

where target_name='funoracleapps.lab'

order by 1,2;

6) Start agent again

emctl start agent