EPM Database UTF8 Issue

EPM Database UTF8 Issue

This is usually the error we find while installing a new EPM instance. This is the way I was able to change my Character set in the following manner.

UTF
UTF Character Set

1. Check Current Char set:

SELECT * FROM

V$NLS_PARAMETERS
WHERE PARAMETER = ‘NLS_CHARACTERSET’;

 

2. Update new one:

UPDATE PROPS$
SET VALUE$ = ‘UTF8’
WHERE NAME = ‘NLS_CHARACTERSET’;

COMMIT;

3. Restart:

SHUTDOWN IMMEDIATE;

STARTUP;

4. Verify Again:

SELECT * FROM
V$NLS_PARAMETERS
WHERE PARAMETER = ‘NLS_CHARACTERSET’;

There could be another reasons for this issue, based on my scenario I was able to resolve EPM UTF8 issue using these steps.

Comments are closed.