ORA-06553: PLS-553: character set name is not recognized, while starting Content Store

Technote (troubleshooting)


Problem(Abstract)

Fresh installation and configuration of Cognos 8 against Oracle 10G. Unable to 'test' Content Store settings and getting the following error message when starting Content Store.

..\<Cognos8>\configuration\schemas\content\oracle\dbInitTest_oracle.sql managed to execute without errors.

Symptom

CM-CFG-5029 Content Manager is unable to determine whether the content store is initialized.
ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-553: character set name is not recognized


Cause

Unicode was not defined correctly for the particular Database.

Environment

Oracle 10.2 as Content Store

Resolving the problem

Make sure you setup the Database with the following settings,

1. NLS_CHARACTERSET=AL32UTF8

2. NLS_NCHAR_CHARACTERSET=AL16UTF16

Steps:1. Select * from NLS_DATABASE_PARAMETERS

2. Check that NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET are both set to the above.

NOTE: In some cases, the database may have been created using a different character set, and was then manually modified to match the above character set. If this is the case, and you are still getting the above error, recreate the database with the correct character set from the outset.

Related information

See Java Garbage Management on http://support.cognos.com/supported/tti/public/docs/cognos_pp_performance_java_garbage_collection.pdf?lid=cognos_pp_performance_java_garbage_collection. Shows how to capture Oracle JDBC logs.

Historical Number

1030764

Rate this page:

(0 users)Average rating

Document information


More support for:

Cognos 8 Business Intelligence
Install and Config

Software version:

8.1

Operating system(s):

Windows

Reference #:

1370779

Modified date:

2011-05-16

Translate my page

Machine Translation

Content navigation