Jeff Taylor's Weblog
-
Database
November 4, 2014
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
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 )