I'm getting the same issue when setting up and testing a Database Connection in Service Center that I want to integrate via Integration Studio.
What was the cause in this case?
Stuart Towers wrote:
I did not find the original case, but Google shows me the following:- http://stackoverflow.com/questions/9156379/ora-01882-timezone-region-not-found
The platform does not explicitly set the timezone in a new connection, so the value from the driver is inherited. At Java level, either it is specifically set in the run parameters, or is inherited from the operating system. I suspect your case is the latter.
The error is actually self-explanatory: the timezone region defined is not known to Oracle.
According to the post above, timezone is read from /etc/sysconfig/clock. In my case, it reads:# cat /etc/sysconfig/clock# The time zone of the system is defined by the contents of /etc/localtime.# This file is only for evaluation by system-config-date, do not rely on its# contents elsewhere.ZONE="Europe/Lisbon"Which is one that exists in Oracle:select * from v$timezone_nameswhere (tzname) like 'Europe/Lisbon'TZNAME TZABBREV------------------ ---------Europe/Lisbon LMT Europe/Lisbon WET Europe/Lisbon WEST Europe/Lisbon WEMT Europe/Lisbon CET Europe/Lisbon CEST
I would suggest you consult with the sysadmin that gave you the machine; you probably need to change the timezone of the server. If you have other machines already installed, try using the same timezone as others use. Note that a full reboot should be needed to change the timezone.
Hope this helps!Acácio