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

Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.

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

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

Login as the em repository user and run the  script:

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