11.2.0.4 DBUA silently changing NLS_TERRITORY init.ora Parameter during upgrade

By | July 16th, 2014 | Category: 11gR2, Bugs | 1 Comment »

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.

Support had to admit that it is unpublished bug 16538186 and that there is NO documentation of it anywhere at the moment.

We learned from this to double-check init.ora parameters after dbua with before upgrade parameters.

One comment
Leave a comment »

  1. Frank July 28th, 2014 08:15 :

    Best greetings to all application developers, please read Oracle® Database Globalization Support Guide. This brilliant book describes the globalization support of the Oracle Database.

Leave Comment