2011-10-27

Time Zone DST patch for Oracle grid control agent 11g on AIX


Patch 6672979 has to be applied. Product: CORE (not agent!).
This patch installs TZ DST version 7, which includes Australian TZ changes in 2008.
Grid control agent 11.1.0.1.0 has Core Files 11.1.0.7.0

To see Core files for agent run:
opatch lsinventory -detail | grep "Oracle Core Required Support Files"

To see the current time zone info:
head $ORACLE_HOME/oracore/zoneinfo/readme.txt

Proper $TZ for AIX in NSW is:
echo $TZ
EET-10EETDT,M10.1.0/02:00,M4.1.0/03:00

To validate TZ:
echo $ORACLE_HOME
export EMDROOT=$ORACLE_HOME
export EMSTATE=$ORACLE_HOME
emdctl validateTZ agent Australia/Sydney

With TZ DST versions 10 and 14, I had the following errors:
emdctl validateTZ agent Australia/Sydney
tzOffset for Australia/Sydney is 0(min), but agent is runnning with tzOffset 660(min)
trying again after waiting for 1 sec to account for daylight transition
tzOffset for Australia/Sydney is 0(min), but agent is runnning with tzOffset 660(min)

Check the TZ settings in the Operating System environment:
emctl config agent getTZ

Reset time zone:
emctl resetTZ agent
grep TZ $ORACLE_HOME/sysman/config/emd.properties

sqlplus SYSMAN@OMS_repository
exec mgmt_target.set_agent_tzrgn('agenthost.gov.au:3872','Australia/Sydney');
commit;


Start agent
emctl start agent

Useful documents:
DST: Is your Grid Control ready for the next Daylight Saving Time - second half 2010? [ID 739116.1]
Grid Agent Configuration: How to Troubleshoot Timezone Issues in Enterprise Manager Grid Agent Setup? [ID 330737.1]

Recommended patches for agent 11.1.0.1.0 on AIX on 2011-10-26
1. 6880880 - OPatch version: 11.1.0.8.5
2. 6672979 - CORE: Patch DST CHANGES FOR SOME AUSTRALIAN REGIONS IN 2008 - NEED DATABASE FIX (this is TZ DST version 7)
3. 9345921 - ENTERPRISE MANAGER AGENT 11.1.0.1.5 PSU
4. 12424139 - PATCH BUNDLE REQUEST FOR MW MANAGEMENT CUMULATIVE MLR-APRIL 2011 - AGENT