{"id":1130,"date":"2015-08-26T17:32:15","date_gmt":"2015-08-26T15:32:15","guid":{"rendered":"http:\/\/www.ludovicocaldara.net\/dba\/?p=1130"},"modified":"2020-08-18T16:32:09","modified_gmt":"2020-08-18T14:32:09","slug":"ora-01882-timezone-region-not-found-while-connecting-to-an-em12c-target","status":"publish","type":"post","link":"https:\/\/www.ludovicocaldara.net\/dba\/ora-01882-timezone-region-not-found-while-connecting-to-an-em12c-target\/","title":{"rendered":"ORA-01882: timezone region not found while connecting to an EM12c target"},"content":{"rendered":"

After a recent upgrade to Enterprise Manager 12c 12.1.0.5, we noticed that the few Oracle Databases in release 10g were no more connectable:<\/p>\n

\"ORA-01882\"<\/a>On MOS there are a few notes about the error: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found, the most relevant being Doc ID 1513536.1<\/span> and Doc ID 1934470.1<\/span>.<\/p>\n

The problem is due to the time zone table on the target database that doesn’t contain the timezone requested by the client. But who’s the client? In our case, all the target agents were correctly set to Europe\/Zurich, but the timezone table of the target database contained it:<\/p>\n

SQL> select version from v$timezone_file;\r\n\r\n   VERSION\r\n----------\r\n         4\r\n\r\nSQL> SELECT TZname, TzAbbrev FROM V$TIMEZONE_NAMES where TZname like 'Europe\/Zurich';\r\n\r\nTZNAME             TZABBREV\r\n------------------ ---------------------\r\nEurope\/Zurich      LMT\r\nEurope\/Zurich      BMT\r\nEurope\/Zurich      CET\r\nEurope\/Zurich      CEST<\/pre>\n
So what was causing the problem?<\/p>\n
The upgrade process of the OMSes from 12.1.0.3 to 12.1.0.5, without the presence of a specific TZ environment variable, set the OMS timezone to Europe\/Vaduz. I figured it out after searching deep and large,\u00a0 inside the WLS product properties:<\/p>\n
$ pwd\r\n\/u01\/app\/oracle\/Middleware_12105\/wlserver_10.3\r\n$ cat .product.properties\r\n...\r\nUSER_TIMEZONE=Europe\/Vaduz\r\n...<\/pre>\n
Indeed, that timezone was not present in the timezone table version 4:<\/p>\n
SQL> sELECT TZname, TzAbbrev FROM V$TIMEZONE_NAMES where TZname like 'Europe\/Vaduz';\r\n\r\nno rows selected\r\n\r\nSQL> alter session set time_zone='Europe\/Zurich';\r\n\r\nSession altered.\r\n\r\nSQL> alter session set time_zone='Europe\/Vaduz';\r\nERROR:\r\nORA-01882: timezone region\u00a0 not found\r\n<\/pre>\n
After setting explicitly the TZ to Europe\/Zurich on the OMS servers and restarting the OMSes, everything was fine again.<\/p>\n
HTH<\/p>\n
—<\/p>\n
Ludo<\/p>\n","protected":false},"excerpt":{"rendered":"
After a recent upgrade to Enterprise Manager 12c 12.1.0.5, we noticed that the few Oracle Databases in release 10g were no more connectable: On MOS there are a few notes about the error: ORA-00604: error occurred at recursive SQL level … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[326,3,52,330,132],"tags":[90],"class_list":["post-1130","post","type-post","status-publish","format-standard","hentry","category-oracle","category-oracledb","category-12c","category-oracle-inst-upg","category-triblog","tag-em12c"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/1130","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/comments?post=1130"}],"version-history":[{"count":3,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/1130\/revisions"}],"predecessor-version":[{"id":1134,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/1130\/revisions\/1134"}],"wp:attachment":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/media?parent=1130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/categories?post=1130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/tags?post=1130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}