EPM 11.1.2 - Issues during configuration when using Oracle DB if not using UTF8

Posted by Ahmed A on Oracle Blogs See other posts from Oracle Blogs or by Ahmed A
Published on Thu, 30 Jun 2011 15:14:05 -0700 Indexed on 2011/07/01 0:26 UTC
Read the original article Hit count: 307

Filed under:

/EPM/Installs and Config

If you see issues during configuration when using Oracle DB if not using UTF8:

Workaround:

a. During configuration of EPM products, a warning message is displayed if the Oracle DB is not UTF8 enabled. If you continue with the configuration, certain products will not work as they will not be able to read the contents in the tables as the format is wrong.

b. The Oracle DB must be setup to use AL32UTF8 or a superset that contains AL32UTF8.

c. The only difference between AL32UTF8 and UTF8 character sets is that AL32UTF8 stores characters beyond U+FFFF as four bytes (exactly as Unicode defines UTF-8). Oracle’s “UTF8” stores these characters as a sequence of two UTF-16 surrogate characters encoded using UTF-8 (or six bytes per character). Besides this storage difference, another difference is better support for supplementary characters in AL32UTF8 character set.

Related posts about /EPM/Installs and Config

Cannot import resource > "app/config/security.yml" from "/app/config/config.yml"

as seen on Stack Overflow - Search for 'Stack Overflow'
Im getting this error: FileLoaderLoadException: Cannot import resource "app/config/security.yml" from "/app/config/config.yml". The file security.yml is on the right path. This is my security.yml file: jms_sapp/confiapp/config/security.yml secure_all_services: false exprapp/confiapp/config/security… >>> More
Difference between Web.Config and Machine.Config File

as seen on Samir ASP.NET with C# Technology - Search for 'Samir ASP.NET with C# Technology'
Two types of configuration files supported by ASP.Net. Configuration files are used to control and manage the behavior of a web application. i) Machine.config ii)Web.config Difference between Machine.Config and Web.Config Machine.Config: i) This is automatically installed when you install… >>> More
Help getting frame rate (fps) up in Python + Pygame

as seen on Stack Overflow - Search for 'Stack Overflow'
I am working on a little card-swapping world-travel game that I sort of envision as a cross between Bejeweled and the 10 Days geography board games. So far the coding has been going okay, but the frame rate is pretty bad... currently I'm getting low 20's on my Core 2 Duo. This is a problem since I'm… >>> More
Lost all privileges since upgrading to 13.10

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Since upgrading to 13.10, I no longer have the 'privileges' to do the following things: Mount USB/CDROM drives Run software centre or software updater Press the GUI shut down or restart buttons Unlock my account in the 'settings - user accounts' section (padlock is greyed out) Also, when logging… >>> More
GhettoVCB.sh log is wrong

as seen on Server Fault - Search for 'Server Fault'
2010-02-25 16:03:02 -- info: CONFIG - VM_BACKUP_ROTATION_COUNT = 2 2010-02-25 16:03:02 -- info: CONFIG - DISK_BACKUP_FORMAT = thin 2010-02-25 16:03:02 -- info: ============================== ghettoVCB LOG START ============================== 2010-02-25 16:03:02 -- info: CONFIG - ADAPTER_FORMAT =… >>> More

Developer IT