{"id":1218,"date":"2014-07-16T10:25:38","date_gmt":"2014-07-16T08:25:38","guid":{"rendered":"http:\/\/www.ora-solutions.net\/web\/?p=1218"},"modified":"2014-07-16T10:25:38","modified_gmt":"2014-07-16T08:25:38","slug":"11-2-0-4-dbua-silently-changing-nls_territory-init-ora-parameter-during-upgrade","status":"publish","type":"post","link":"https:\/\/www.ora-solutions.net\/web\/2014\/07\/16\/11-2-0-4-dbua-silently-changing-nls_territory-init-ora-parameter-during-upgrade\/","title":{"rendered":"11.2.0.4 DBUA silently changing NLS_TERRITORY init.ora Parameter during upgrade"},"content":{"rendered":"<p>In case you are planning to perform any upgrades with DBUA, double-check that the init.ora parameters after the upgrade. In a production upgrade at a client site, dbua silently changed init.ora parameter NLS_TERRITORY from GERMANY to AMERICA. It was only noticed when after the upgrade, decimal and grouping number characters were swapped, leading to application problem. <\/p>\n<p>Support had to admit that it is unpublished bug 16538186 and that there is NO documentation of it anywhere at the moment.<\/p>\n<p>We learned from this to double-check init.ora parameters after dbua with before upgrade parameters.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In case you are planning to perform any upgrades with DBUA, double-check that the init.ora parameters after the upgrade. In a production upgrade at a client site, dbua silently changed init.ora parameter NLS_TERRITORY from GERMANY to AMERICA. It was only noticed when after the upgrade, decimal and grouping number characters were swapped, leading to application [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[57,47],"tags":[],"class_list":["post-1218","post","type-post","status-publish","format-standard","hentry","category-11gr2","category-bugs"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/1218","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/comments?post=1218"}],"version-history":[{"count":1,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/1218\/revisions"}],"predecessor-version":[{"id":1219,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/1218\/revisions\/1219"}],"wp:attachment":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/media?parent=1218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/categories?post=1218"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/tags?post=1218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}