X

Jeff Taylor's Weblog

Enterprise Manager agentTZRegion

EM didn't like the switch from daylight savings to standard time - it was locked into Pacific daylight savings:


In $ORACLE_HOME/node1_sid/sysman/log/emdb.nohup
----- Mon Nov  3 19:36:01 2014::tzOffset for -07:00 is -420(min), but agent is runnning with tzOffset -480(min)


$ grep TZ
$ORACLE_HOME/node1_sid/sysman/config/emd.properties


agentTZRegion=-07:00


$ grep US/Pacific
$ORACLE_HOME/sysman/admin/supportedtzs.lst


US/Pacific

US/Pacific-New


$ export TZ=US/Pacific


$ $ORACLE_HOME/bin/emctl resetTZ agent

Oracle Enterprise Manager 11g Database Control Release
11.2.0.4.0

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

Updating
/u01/app/oracle/product/11.2.0/dbhome_1/node1_sid/sysman/config/emd.properties...

Successfully updated
/u01/app/oracle/product/11.2.0/dbhome_1/node1_sid/sysman/config/emd.properties.

Login as the em repository user and run the  script:

exec
mgmt_target.set_agent_tzrgn('node1:3938','US/Pacific')

and commit the changes

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

SQL> exec
mgmt_target.set_agent_tzrgn('node1:3938','US/Pacific')

SQL> commit


[also ran "emctl resetTZ agent"
on other RAC node]

$ grep TZ
$ORACLE_HOME/node1_sid/sysman/config/emd.properties


agentTZRegion=US/Pacific


$ sqlplus
/ as sysdba



SQL*Plus: Release 11.2.0.4.0 Production on Tue Nov 4 07:28:57
2014


Copyright (c) 1982, 2013, Oracle.  All rights reserved.



Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 -
64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data
Mining

and Real Application Testing options


SQL>

SQL> alter session set
current_schema = SYSMAN;



Session altered.


SQL> exec
mgmt_target.set_agent_tzrgn('node1:3938','US/Pacific')



PL/SQL procedure successfully completed.


SQL> exec
mgmt_target.set_agent_tzrgn('node2:3938','US/Pacific')



PL/SQL procedure successfully completed.


$ emctl stop dbconsole

$ emctl start dbconsole

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.