Timezone mismatch error
560052Mar 6 2007 — edited Mar 25 2007hi i have a 10g R2 running on a RHEL AS 4 32bit machine.
i tried to setup database control but enterprise manager breaks with the following error when started
Timezone mismatch: The agentTZRegion value (US/Eastern) in
/u01/app/oracle/oracle/product/10.2.0/db_1/<HOST>_<SID>/sysman/config/emd.properties
does not match the current environment TZ setting(US/Eastern).
The dbconsole cannot run with this mismatch.
If US/Eastern is the correct timezone, set your timezone environment variable to US/Eastern and repeat the 'emctl start dbconsole' operation.
If US/Eastern is not the correct timezone, make sure that the timezone in your environment is correct, and then run the following command in your local Oracle Home: 'emctl resetTZ agent'
The output of this command will include detailed instructions to follow, to correct the mismatch.
my locale is set to US/Eastern,and in the $ORACLE_HOME/<HOST>_<SID>/sysman/config/emd.properties file i have the following entry
agentTZregion=US/Eastern
note that i did not touch this file after it was automatically created.
i tried emctl resetTZ agent ad also ddnt work
$emctl resetTZ agent
TZ set to US/Eastern
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
Updating /u01/app/oracle/oracle/product/10.2.0/db_1/<HOST>_<SID>/sysman/config/emd.properties...
resetTZ failed.
The agentTZRegion in:
/u01/app/oracle/oracle/product/10.2.0/db_1/<HOST>_<SID>/sysman/config/emd.properties
is not in agreement with what the agent thinks it should be.
Fix your environment.
Pick a TZ value that corresponds to time zone settings listed in:
/u01/app/oracle/oracle/product/10.2.0/db_1/sysman/admin/supportedtzs.lst
so i set a TZ env variable to US/Eastern but ddnt work.
so i dropped the repository and recreated it and reconfigured everything but nothing changed !
after checking the emca log file and here's what i found
CONFIG: Starting execution: /u01/app/oracle/oracle/product/10.2.0/db_1/bin/emctl start dbconsole
Mar 6, 2007 11:35:32 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Exit value of 1
Mar 6, 2007 11:35:32 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: TZ set to US/Eastern
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://<HOST>:5500/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ............................................................................................. failed.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/oracle/product/10.2.0/db_1/<HOST>_<SID>/sysman/log
Mar 6, 2007 11:35:32 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
WARNING: Error executing /u01/app/oracle/oracle/product/10.2.0/db_1/bin/emctl start dbconsole
Mar 6, 2007 11:35:32 AM oracle.sysman.emcp.EMConfig perform
SEVERE: Error starting Database Control
Refer to the log file at /u01/app/oracle/oracle/product/10.2.0/db_1/cfgtoollogs/emca/<SID>/emca_2007-03-6_11-22-07-AM.log for more details.
Mar 6, 2007 11:35:32 AM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Error starting Database Control
at oracle.sysman.emcp.EMDBPostConfig.performConfiguration(EMDBPostConfig.java:565)
at oracle.sysman.emcp.EMDBPostConfig.invoke(EMDBPostConfig.java:177)
at oracle.sysman.emcp.EMDBPostConfig.invoke(EMDBPostConfig.java:146)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:155)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:479)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1123)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:463)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:412)
any help is appreciated
regards
Message was edited by:
user557049