BRM Cannot Install On Oracle Database That Has AL32UTF8 As Its Character Set (Doc ID 737499.1)

Last updated on SEPTEMBER 13, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 to 7.4.0.0.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.

Goal

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 9.2.0.6 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.

Solution

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