1. Ensure that you can log into the Oracle server as a member of the ORA_DBA user group on Windows or the dba group on UNIX.
2. Set the NLS_LANG (National Language Support) environment variable to the UTF-8 character set on the metric store computer by typing the following command:
NLS_LANG = language_territory.character_set
Examples are:
* NLS_LANG = AMERICAN_AMERICA.UTF8
The value of the variable determines the locale-dependent behavior of IBM Cognos 8. Error messages, sort order, date, time, monetary, numeric, and calendar conventions automatically adapt to the native language and locale.
3. Create an user account which IBM Cognos 8 Metrics Manager will use to access the Metric store database. You must use an Oracle database username with the following permissions granted:
* CREATE TABLE, CREATE VIEW, CREATE PROCEDURE, CREATE TRIGGER, CREATE TYPE, CREATE SEQUENCE, and CREATE SESSION
* EXECUTE on DBMS_LOCK and DBMS_UTILITY packages.
The CREATE TABLE and CREATE TRIGGER permissions must be granted directly to the user account rather than to a role.
You must exactly grant these permissions only! The metric store will not initialize correctly if you grant more or less privileges than specified above.
4. Determine if the database is using Unicode character set.
select * from NLS_DATABASE_PARAMETERS
If the result set NLS_CHARACTERSET is not Unicode! and the metric store can not be created. Therefore create a new database and specify AL32UTF8 for the database character set parameters.