Pre-installing the metadata repository database in an Oracle database system (Windows)

You can use an existing installation of an Oracle database to create a metadata repository for InfoSphere® Information Server on Windows.

Before you begin

Include the $ORACLE_HOME\bin\ directory in your Windows 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 an Oracle 12c database, 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

This script creates a tablespace within an existing database.
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_xmeta_db.sql file to not set this parameter.

Procedure

  1. Navigate to the following directory of the InfoSphere Information Server installation media, where IS_suite is the directory where you extracted the media.
    Database version Directory
    Oracle 11g R2 IS_suite\DatabaseSupport\Windows\MetadataRepository\Oracle11g
    Oracle 12c IS_suite\DatabaseSupport\Windows\MetadataRepository\Oracle12c
  2. Open a command prompt and run the create_xmeta_db script to set up the database for the metadata repository. All arguments are required and must be specified in the order that is shown in the following example. 
    create_xmeta_db.cmd OracleSystemUser OracleSystemPassword NetServiceName 
                    XmetaUserName XmetaUserPassword XmetaTableSpaceName
                    XmetaDatafilePath
    For example,
    create_xmeta_db.cmd SYS MANAGER DBNAME xmetauser xmetapwd xmetaspace
C:\oracle\product\11.2.0\oradata\dbname
    OracleSystemUser
    The Oracle system user name to log into SQL*Plus with to create the tablespace and user. This user must be assigned the database administrator role and must have the SYSDBA role.
    OracleSystemPassword
    The password for the Oracle system user.
    NetServiceName
    The name for the connect descriptor as specified in the tnsnames.ora file.
    XmetaUserName
    The name of the Oracle user that you are creating for the metadata repository tablespace.
    XmetaUserPassword
    The password for the metadata repository tablespace user.
    XmetaTableSpaceName
    The name of the metadata repository tablespace.
    XmetaDatafilePath
    The location where you want to create the data files for the tablespace. This location must reference an existing directory. For example, C:\oracle\product\11.2.0\oradata\dbname.
  3. From the same directory as step 1, run the same command but with staging area information to set up the database for the staging area. All arguments are required and must be specified in the order that is shown in the following example. 
    create_xmeta_db.cmd OracleSystemUser OracleSystemPassword NetServiceName
                    StagingUser StagingUserPassword StagingTableSpace
                    StagingDatafilePath
    For example, the following command runs as the user, SYS, using the password sys_pwd. The command connects to Oracle with the TNS name xmeta, and creates a tablespace named xmetasrsp under the C:\oracle\product\11.2.0\oradata\dbname directory. The Oracle account named xmetasr is created using the password xmetapwd, and is used to access the staging area schema.
    create_xmeta_db.cmd SYS sys_pwd xmeta xmetasr xmetasrpwd xmetasrsp
C:\oracle\product\11.2.0\oradata\dbname
    OracleSystemUser
    The Oracle system user name to log into SQL*Plus with to create the tablespace and user. This user must be assigned the database administrator role and must have the SYSDBA role.
    OracleSystemPassword
    The password for the Oracle system user.
    NetServiceName
    The name for the connect descriptor as specified in the tnsnames.ora file.
    StagingUser
    The name of the user that you are creating to access the staging area schema. This user must be different from the active repository user because the staging area schema must be a different schema within the metadata repository database.
    StagingUserPassword
    The password for the staging area schema user.
    StagingTableSpace
    The name of the tablespace that you are creating for the staging area schema.
    StagingDatafilePath
    The location where you want to create the data files for the staging area tablespace. This location must reference an existing directory. For example, C:\oracle\product\11.2.0\oradata\dbname.