BRM Cannot Install On Oracle Database That Has AL32UTF8 As Its Character Set
Last updated on SEPTEMBER 13, 2016
Applies to:Oracle Communications Billing and Revenue Management - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 7.3.0 to 7.4.0]
Information in this document applies to any platform.
Add ***Checked for relevance on 01-Mar-2010***
*** Checked for relevance on 24-April-2013 ***
Checked for relevance on 13-Sep-2016.
Attempting to install BRM using pin_setup.bat, those tables were able to be installed into the database (Oracle XE 10g); but when trying to start up DM, it failed due to incompatibility with the character set. It expected exactly the name "UTF8"; whereas, by default, the character set goes to AL32UTF8.
The documentation says to use UTF8, so the user tried to find a way to change an Oracle 10g or Oracle 126.96.36.199 DB to be UTF8. But the sys.props$ says it is AL32UTF8. What is the difference and/or how to change it? AL32UTF8 should be the standard, but it looked like the software was expecting and hardcoded UTF8 in BRM.
Env variable NLS_LANG=American_America.UTF8 was all the documentation stated as being required for setup.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms