Oracle HOWTO: change Enterprise Manager Console Timezone

Go to Michael Dvorkin's user page

Prerequisites
Oracle Server 10.2

Steps to change Enterprise Manager Console Timezone
1. Stop EM console

emctl stop dbconsole

2. Check current time zone

echo $TZ

3. Check supported time zones in the following file:

$ORACLE_HOME/sysman/admin/nsupportedtzs.lst

4. Set new time zone

export TZ=

Example:

export TZ=Etc./GMT-3

5. Reset agent time zone

$ORACLE_HOME/bin/emctl resetTZ agent

6. Check new time zone in the configuration file:

$ORACLE_HOME/pkgdb_PROD/sysman/config/emd.properties agentTZRegion=

Example:

agentTZRegion=+03:00

7. Update target time zone in the database

sqlplus sysman exec mgmt_target.set_agent_tzrgn(' ','') select timezone_region from mgmt_targets where 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;

8. Start EM console

emctl start dbconsole

9. Check agent status

emctl status agent

Known Issues
Go to Michael Dvorkin's user page