UTF-8 error when Configuring Hyperion using the EPM System Configurator:

 

Error:

EPMDFG-10399: EPM System Configurator has detected use of a non-UTF-8 Oracle database; UTF-8 encoding needs to be used

Solution:

The Pre-reqs from the documentation is clear that the database must be in UTF-8 character. It's imposisble to change this to UTF-8 if UTF-8 is not a subset of your existing character set. However, the below command will save you from recreating the database in UTF-8 :

Change the character set using the below sql command, exit the Configurator, and restart the configurator

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

SQL> startup restrict;
ORACLE instance started.
Total System Global Area  764121088 bytes
Fixed Size                 2217264 bytes
Variable Size             557845200 bytes
Database Buffers          197132288 bytes
Redo Buffers             6926336 bytes
Database mounted.
Database opened.

SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8;

Database altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.
Total System Global Area  764121088 bytes
Fixed Size                 2217264 bytes
Variable Size             557845200 bytes
Database Buffers          197132288 bytes
Redo Buffers             6926336 bytes

Database mounted.
Database opened.
SQL>