Content Platform Engine, Version 5.2.1   Database:  Oracle          

Creating an Oracle table space for the Content Platform Engine GCD

Create a table space for the Content Platform Engine global configuration database on Oracle.

Before you begin

At least two Oracle table spaces must be created for the Content Platform Engine. One table space is needed for the global configuration database user and one for a single object store user. Do not share the database user for the GCD with the object store database user or with the IBM® Content Navigator.

Procedure

  1. Create a user (cpe_db_user), password, and default table space in the Oracle database for the global configuration database (GCD). See Creating Content Platform Engine database accounts for information about the user and required permissions.
  2. Table space names must contain only alphanumeric and underscore characters. Names must start with an alphabetic character and must be at most 30 characters long. For performance reasons, specify locally managed, instead of dictionary managed, table spaces. (The table spaces you create with Oracle Enterprise Manager are locally managed by default.)

    The following table shows the recommended minimum sizes of the permanent and temporary table spaces for the GCD. (The table space names shown in the table are arbitrary.)

    Table 1. Recommended table sizes for the GCD table spaces
    Table space Name Table space Type Minimum Size Description
    gcd Permanent 100 MB Permanent table space for the GCD
    tempgcd Temporary 2 GB Temporary table space for the GCD
  3. Icon representing the worksheet
    Record the values for the Database user name, the Database password, and the table space names in your customized Installation and Upgrade Worksheet. To find these properties, set the Autofilter for Column E Installation or Configuration Program for CM: Configure GCD JDBC Data Sources. Then set the Autofilter for Column D ISV Component Vendor to "Oracle".


Last updated: March 2016
p8ppi119.htm

© Copyright IBM Corporation 2013, 2016.