Wikia

How To Wiki

Oracle HOWTO: change Enterprise Manager Console Timezone

1,795pages on
this wiki
Talk0

Go to Michael Dvorkin's user page

Prerequisites Edit

Oracle Server 10.2

Steps to change Enterprise Manager Console Timezone Edit

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=<New 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=<New TZ>
  Example:
  agentTZRegion=+03:00

7. 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;  

8. Start EM console

  emctl start dbconsole

9. Check agent status

  emctl status agent

Known Issues Edit

Go to Michael Dvorkin's user page

Around Wikia's network

Random Wiki