tzOffset for America/Caracas is -270(min), but agent is running with tzOffset -240(min)

Posted by Vasudev Seeram on September 6, 2012 Leave a comment (0) Go to comments

Problem:

While configuring Enterprise Manager Database Control for an R12.1 instance on Windows 2008, the following error is encountered:

tzOffset for America/Caracas is -270(min), but agent is runnning with tzOffset 
-240(min)

Solution:

Change time zone in emd.properties and operating system.

Log file showed the following message:

C:oracleUAT2dbtech_st11.1.0ittl-hrmstest.domainname_UAT2sysmanlogemdb.nohup

----- Thu Sep  6 13:38:39 2012::tzOffset for America/Caracas is -270(min), but 
agent is runnning with tzOffset -240(min)
 -----
----- Thu Sep  6 13:38:39 2012::trying again after waiting for 1 sec to account 
for daylight transition
 -----
----- Thu Sep  6 13:38:39 2012::tzOffset for America/Caracas is -270(min), but 
agent is runnning with tzOffset -240(min)
 -----
----- Thu Sep  6 13:38:39 2012::Mismatch detected between timezone in env 
(America/Caracas) and in 
C:oracleUAT2dbtech_st11.1.0ittl-hrmstest.domainname_UAT2/sysman/config/emd.properties 
(America/Caracas). Forcing value to latter.. -----
----- Thu Sep  6 13:38:39 2012::The agentTZRegion value in 
C:oracleUAT2dbtech_st11.1.0ittl-hrmstest.domainname_UAT2/sysman/config/emd.properties 
is not in agreement with what agent thinks it should be.Please verify your environment to 
make sure that TZ setting has not changed since the last start of the agent.
If you modified the timezone setting in the environment, please stop the agent and 
exectute 'emctl resetTZ agent' and also execute the script 
mgmt_target.set_agent_tzrgn(<agent_name>, <new_tz_rgn>) to get the value propagated to 
repository -----
12/09/06 13:38:39 Error starting ORMI server ITTL-HRMSTEST port 5,520: Address 
already in use: JVM_Bind
12/09/06 13:38:39 Shutting down OC4J...

Edit C:oracleUAT2dbtech_st11.1.0ittl-hrmstest.domainname_UAT2sysmanconfigemd.properties

Since I am not in Caracas, I changed:

agentTZRegion=America/Caracas

To:

agentTZRegion=America/Santiago

Check C:oracleUAT2dbtech_st11.1.0/sysman/admin/supportedtzs.lst for list of supported timezones.

C:oracleUAT2dbtech_st11.1.0ittl-hrmstest.domainname_UAT2sysmanconfig>emctl 
config agent getTZ

Oracle Enterprise Manager 11g Database Control Release 11.1.0.7.0
Copyright (c) 1996, 2008 Oracle Corporation.  All rights reserved.
America/Caracas

Changed time zone at OS level.

C:oracleUAT2dbtech_st11.1.0ittl-hrmstest.domainname_UAT2sysmanconfig>emctl 
config agent getTZ
Oracle Enterprise Manager 11g Database Control Release 11.1.0.7.0
Copyright (c) 1996, 2008 Oracle Corporation.  All rights reserved.
America/Santiago

Clean up and restart:

drop role mgmt_user;
drop user MGMT_VIEW;
drop user sysman cascade;
set ORACLE_HOSTNAME=ittl-hrmstest.domainname
emca -deconfig all db
emca -config dbcontrol db  -repos recreate -SID UAT2 -PORT 1536 -ORACLE_HOME %ORACLE_HOME% 
-DBCONTROL_HTTP_PORT 1158

Then ran emca to deconfigure (this step may not be necessary):

C:oracleUAT2dbtech_st11.1.0cfgtoollogsemcaUAT2>set ORACLE_HOSTNAME=ittl-hrmstest.domainname
C:oracleUAT2dbtech_st11.1.0cfgtoollogsemcaUAT2>emca -deconfig all db
 STARTED EMCA at Sep 6, 2012 5:59:12 PM
EM Configuration Assistant, Version 11.1.0.7.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: UAT2

Do you wish to continue? [yes(Y)/no(N)]: Y
Sep 6, 2012 5:59:17 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at C:oracleUAT2dbtech_st11.1.0cfgtoollogs
emcaUAT2emca_2012_09_06_17_59_12.log.
Sep 6, 2012 5:59:18 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be performed.
Enterprise Manager configuration completed successfully
FINISHED EMCA at Sep 6, 2012 5:59:18 PM

Then run emca and recreate the repository.

C:oracleUAT2dbtech_st11.1.0cfgtoollogsemcaUAT2>emca -config dbcontrol db
  -repos recreate -SID UAT2 -PORT 1536 -ORACLE_HOME %ORACLE_HOME% -DBCONTROL_HTTP_PORT 1158

STARTED EMCA at Sep 6, 2012 5:59:34 PM
EM Configuration Assistant, Version 11.1.0.7.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Password for SYSMAN user: Email address for notifications (optional): vasudev.seeram@domainname.com
Outgoing Mail (SMTP) server for notifications (optional): mail.domainname.com
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ C:oracleUAT2dbtech_st11.1.0

Local hostname ................ ittl-hrmstest.domainname
Listener port number ................ 1536
Database SID ................ UAT2
Email address for notifications ............... vasudev.seeram@domainname.com
Outgoing Mail (SMTP) server for notifications ............... mail.domainname.com

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Sep 6, 2012 6:00:00 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at C:oracleUAT2dbtech_st11.1.0cfgtoollogs
emcaUAT2emca_2012_09_06_17_59_34.log.
Sep 6, 2012 6:00:04 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Sep 6, 2012 6:00:12 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Sep 6, 2012 6:00:12 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Sep 6, 2012 6:05:46 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Sep 6, 2012 6:05:51 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Sep 6, 2012 6:06:57 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Sep 6, 2012 6:07:20 PM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Sep 6, 2012 6:07:20 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Sep 6, 2012 6:07:27 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Sep 6, 2012 6:07:27 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Sep 6, 2012 6:07:40 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Sep 6, 2012 6:07:40 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Sep 6, 2012 6:08:20 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Sep 6, 2012 6:08:20 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> 
The Database Control URL is https://ittl-hrmstest.domainname:1158/em <<<<<<<<<<<
Sep 6, 2012 6:08:23 PM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************  WARNING  ************************

Management Repository has been placed in secure mode wherein Enterprise Manager
data will be encrypted.  The encryption key has been placed in the file: 
C:oracleUAT2dbtech_st11.1.0ittl-hrmstest.domainname_UAT2sysmanconfigemkey.ora.   
Please ensure this file is backed up as the encrypted data will become
 unusable if this file is lost.

***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Sep 6, 2012 6:08:23 PM

C:oracleUAT2dbtech_st11.1.0cfgtoollogsemcaUAT2>

[amazon asin=1849684782&template=iframe image&chan=default] [amazon asin=0071763228&template=iframe image&chan=default] [amazon asin=0071790578&template=iframe image&chan=default]