This content has been marked as final. Show 7 replies
Try looking in the timezone values table for valid locations in GMT ...
A location reveals much better information about a local time zone, i.e. could be northern or southern hemisphere, also affecting the daylight savings window. For now, looks like Iceland is one place that doesn't use DST, and they are in timezone UTC+0 so maybe that could work. Or locations close to the equator tend to not utilize DST, quite a few locations on the west coast of Africa might do as well.
select * from v$timezone_names where tzabbrev = 'GMT';
Hmmm interesting. What is the locale setup on the host? Windows slams the system clock at DST change, there are better ways to handle timezone "issues".
emctl config agent getTZ ... America/Rio_Branco
The way to handle all timezone issues is to set the server OS timezone to "UTC", as I did on the Windows box.
UTC is the single universal time which never chagnes, and just work sin all situations on all servers. All our servers have been set to UTC for the last 15 years running any number of databases including oracle with no DST issues, and perfect syncronization.
This has all been blown away with oracle depricating the world server standard, and replacing it with the horrible old local timezone, which we dont one running on the server host. The clients have the the local timezones, and oracle correctly converst between UTC to the local timezone.
For oracle to depricate the working world standard for servers (i.e. UTC), with no replacement, is absolute madness. If it was April already, I would say it was an April fools prank.
The really mad thing is that Oracle SW is largely Java, and Java is built around UTC.
Its the same as oracle saying they no longer support UTF8, and you have to go back to using ASCII.
The key is that UTC never chagnes. If you use a local timezone, the definition changes from time to time. When the timezone rules chagne, oracle has to update EVERY ROW with that timezone. If you have 100 million rows, this update can kill your DB. Thats why you should use UTC. Depricated? are they mad?
Edited by: user555967 on 26-Mar-2012 15:05
user555967 wrote:I don't believe listener failing to start has anything to do with em console error. EM dc/gc has always been picky about timezones, something like os - java - oracle views of timezone needs to match.
Later I installed oracle without errors, but the console would not start, nor would the listener. The log failes basically said:
"The agentTZRegion value in C:\app\oracle\product\11.2.0\dbhome_1\wario_orcl/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."So what is that line from emd.properties?
Does TZ work on Windows platform? Try e.g.
emctl start dbconsole
So Oracle installation does not support severs using UTC. Thats aproblem because we have hundreds of servers all set to UTC.Just fix the separate app (e.g. Em db control). No need to change the host itself.
I do not believe spamming the forums in frustration will endear you to the community. See your other related posts (in addition to the one above)
"Connection Refused: connect" 11g r2 x64 on windows 2008 SP2 x64
What user should oracle be installed with in windows 2008?
oracle deinstall doesnt work. I guess you have to reinstall windows?
Posting as many objective details as possible (and refraining from cursing) along with the contents of installation log files will go a long way in eliciting responses.
I am in the exact same situation and it looks like I might have to use a local timezone such as GMT (Monrovia, Reykjavik). Which doesn't use DST.
I have tried changing the timezone to GMT (Universal Coordinated Time) both before and after an install. When issue a "emctl config agent getTZ", I get America/Rio_Branca (-04:00) with Oracle 18.104.22.168. Due to other reasons, I also tried upgrading to 22.214.171.124 and now recieve Asia/Karachi when I try to change the timezone.
Windows 2008 R2 64bit
I am curious about what you ended up doing?