Pre-installing the IBM InfoSphere Information Analyzer analysis database in an Oracle database system (AIX Linux)
You can use an existing installation of an Oracle database to create an InfoSphere® Information Analyzer analysis database InfoSphere Information Server.
Before you begin
$ORACLE_HOME/bin
directory in
your system PATH to properly invoke the sqlplus command. Requirements:
- You must configure your Oracle database with
the following character sets. These character sets are the only ones
that are compatible with InfoSphere Information Server.
NLS_CHARACTERSET = AL32UTF8 NLS_NCHAR_CHARACTERSET = AL16UTF16
If the database is configured to use another character set, some characters will not be stored, processed, or displayed correctly. The preinstallation check in the InfoSphere Information Server installation program will report a failure for this condition, and if you force the installation it will fail.
- For Oracle 12c and 12cR2 databases, CDB is supported in InfoSphere Information Server release 11.5.0.2 and later versions. CDB is not supported in InfoSphere Information Server releases prior to 11.5.0.2.
About this task
Attention: This script also sets the OPEN_CURSORS initialization
parameter to the minimum required value of 1500. If this parameter
is already set to a higher value, modify the configure_ia_db.sql file
to not set this parameter.