Installing an Oracle database engine and creating databases

Install the Oracle software and configure the database server. Create one or more databases, depending on whether one or more FileNet® P8 components will share the database.

About this task

The following procedure shows the minimal choices (specific to the needs of Content Platform Engine) for installing a database engine. Consult Oracle installation documentation for complete preinstallation requirements and instructions.

Procedure

To install an Oracle database engine:

  1. Choose the following from the list of available product components:
    • Oracle Server
    • Oracle Net Services
      • Oracle Net Listener
    • Oracle Development Kit
      • Oracle Call Interface (OCI)
    • Oracle Documentation (recommended)
  2. Transaction Processing (also known as OLTP) is the required configuration type.
  3. Start the listener and the Oracle database service/processes if they have not started automatically.
  4. Create one or more databases, depending on whether one or more FileNet P8 components will share the database.
    FileNet P8 requires the following settings for Oracle databases:
    Database configuration type
    Transaction Processing (also known as OLTP) is the required configuration type.
    Server process type
    Dedicated Server Mode
    Database character set
    Set the regular character set to AL32UTF8. It is not required to set the national character set (NLS_NCHAR_CHARACTERSET) to a specific value. You can take the default. 
    Collating sequence for ORDER BY queries
    Set the collating sequence for ORDER BY queries (NLS_SORT) to BINARY.
    Collation behavior of the database session
    Set the collation behavior of the database session (NLS_COMP) to BINARY.
    Database authentication behavior at database connection time
    Set the protocol to the appropriate level for your environment.

    Note that for users on WebSphere Application Server V8.5.5 and Oracle 12C or Oracle 18c, the version for the following authentication protocol values must be set to 11:

    • SQLNET.ALLOWED_LOGON_VERSION_SERVER=11
    • SQLNET.ALLOWED_LOGON_VERSION_CLIENT=11
    Icon representing the worksheet
    Record the values for the Database server name, Database name, and the Database port number 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. In addition, set the Database server name, Database name, and the Database port number for the CM: Configure Object Store JDBC Data Sources.