{"id":120,"date":"2018-10-30T16:09:50","date_gmt":"2018-10-30T16:09:50","guid":{"rendered":"http:\/\/www.matez.de\/?p=120"},"modified":"2018-10-30T16:09:50","modified_gmt":"2018-10-30T16:09:50","slug":"timezones-known-by-java-are-not-known-by-oracle-database","status":"publish","type":"post","link":"https:\/\/www.matez.de\/index.php\/2018\/10\/30\/timezones-known-by-java-are-not-known-by-oracle-database\/","title":{"rendered":"timezones known by java are not known by Oracle Database"},"content":{"rendered":"<p>Recently we had an issue with database connection, which led to the following eror:<\/p>\n<blockquote><p>ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found<\/p><\/blockquote>\n<p>Finally we found out, that the timezone coming from the operating system was known to Java JDK, but not to the Oracle Database we were using.<\/p>\n<blockquote><p>Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 &#8211; 64bit Production<br \/>\nPL\/SQL Release 12.2.0.1.0 &#8211; Production<br \/>\nCORE 12.2.0.1.0 Production<br \/>\nTNS for Linux: Version 12.2.0.1.0 &#8211; Production<br \/>\nNLSRTL Version 12.2.0.1.0 &#8211; Production<\/p><\/blockquote>\n<p>These are the timezones which will lead to the issue:<\/p>\n<table width=\"304\">\n<tbody>\n<tr>\n<td width=\"304\">Africa\/Juba<\/td>\n<\/tr>\n<tr>\n<td>America\/Creston<\/td>\n<\/tr>\n<tr>\n<td>America\/Kralendijk<\/td>\n<\/tr>\n<tr>\n<td>America\/Lower_Princes<\/td>\n<\/tr>\n<tr>\n<td>America\/Metlakatla<\/td>\n<\/tr>\n<tr>\n<td>America\/North_Dakota\/Beulah<\/td>\n<\/tr>\n<tr>\n<td>America\/Santarem<\/td>\n<\/tr>\n<tr>\n<td>America\/Sitka<\/td>\n<\/tr>\n<tr>\n<td>Antarctica\/Rothera<\/td>\n<\/tr>\n<tr>\n<td>Antarctica\/Vostok<\/td>\n<\/tr>\n<tr>\n<td>Asia\/Hebron<\/td>\n<\/tr>\n<tr>\n<td>Asia\/Novokuznetsk<\/td>\n<\/tr>\n<tr>\n<td>Etc\/UCT<\/td>\n<\/tr>\n<tr>\n<td>Etc\/UTC<\/td>\n<\/tr>\n<tr>\n<td>Etc\/Universal<\/td>\n<\/tr>\n<tr>\n<td>Etc\/Zulu<\/td>\n<\/tr>\n<tr>\n<td>Europe\/Busingen<\/td>\n<\/tr>\n<tr>\n<td>Pacific\/Chuuk<\/td>\n<\/tr>\n<tr>\n<td>Pacific\/Pohnpei<\/td>\n<\/tr>\n<tr>\n<td>UCT<\/td>\n<\/tr>\n<tr>\n<td>Universal<\/td>\n<\/tr>\n<tr>\n<td>Zulu<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>How to solve it:<\/p>\n<ul>\n<li>choose a timezone id known by Oracle database<\/li>\n<li>set environment variable i.e. export TZ=UTC or<\/li>\n<li>set java property -Duser.timezone=UTC<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Recently we had an issue with database connection, which led to the following eror: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found Finally we found out, that the timezone coming from the operating system was known to Java JDK, but not to the Oracle Database we were using. Oracle Database &hellip; <a href=\"https:\/\/www.matez.de\/index.php\/2018\/10\/30\/timezones-known-by-java-are-not-known-by-oracle-database\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;timezones known by java are not known by Oracle Database&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/www.matez.de\/index.php\/wp-json\/wp\/v2\/posts\/120"}],"collection":[{"href":"https:\/\/www.matez.de\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.matez.de\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.matez.de\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.matez.de\/index.php\/wp-json\/wp\/v2\/comments?post=120"}],"version-history":[{"count":1,"href":"https:\/\/www.matez.de\/index.php\/wp-json\/wp\/v2\/posts\/120\/revisions"}],"predecessor-version":[{"id":121,"href":"https:\/\/www.matez.de\/index.php\/wp-json\/wp\/v2\/posts\/120\/revisions\/121"}],"wp:attachment":[{"href":"https:\/\/www.matez.de\/index.php\/wp-json\/wp\/v2\/media?parent=120"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.matez.de\/index.php\/wp-json\/wp\/v2\/categories?post=120"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.matez.de\/index.php\/wp-json\/wp\/v2\/tags?post=120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}