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.

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More

WP2Social Auto Publish Powered By : XYZScripts.com