Create the INOW database - Perceptive Content Database Install Guide - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external

Perceptive Content Database Install Guide

Platform
Perceptive Content
Product
Perceptive Content Database Install Guide
Release
Foundation 24.1
License

To create the INOW database, complete the following steps.

Note: Depending on the version of Oracle you are using, there may be additional configuration options not found in this guide. Please refer to the best practices for your organization.
  1. Using the Oracle Database Configuration Assistant (DBCA), create a new database by selecting the Custom Database template, click Next, and name it according to the naming conventions for your organization. For example, INOW.
  2. On the Management Options page, follow the best practicesset by your company for configuring Enterprise Manager and Automatic Maintenance Tasks.
  3. On the Database Credentials page, follow the best practices set by your company.
  4. On the Storage Options page, choose the appropriate storage type for your database files, and then click Next.
    Note: Ensure the storage is striped and mirrored. We recommend that you use Oracle ASM for managing database storage. Also, place datafiles, redo logs, and archived logs on separate disks to distribute I/O. For more information, refer to the I/O Configuration and Design section of the Oracle Database Performance Tuning Guide.
  5. On the Recovery Configuration page, choose the appropriate recovery options. For production environments, we recommend enabling flashback recovery and archive mode.
  6. On the Database Content page, clear each of the additional components.
    Note: The Enterprise Manager Repository option can remain selected if you intend to use it.
  7. On the Initialization Parameters page, on the Memory tab, use the following recommended settings as a starting point to configure the Perceptive Content Database memory.
    Note:
    • The settings should not exceed your server capacity, as paging may occur. If paging occurs, we recommend adding memory to the server or reducing Oracle memory settings.
    • Depending on the configuration of the operating system, you may receive a performance boost by using huge pages for Oracle memory allocation. For more information on this, refer to the appropriate version-specific operating system and Oracle documentation.
    • Use automatic shared memory management (ASMM), rather than automatic memory management (AMM).
      Parameter % of Recommended Memory Example Value
      SGA_MAX_SIZE 70% or less of total memory 20G
      SGA_TARGET *Same value asSGA_MAX_SIZE 20G
      PGA_AGGREGATE_TARGET   4G
    Note: The values above are simply a starting point. After load testing with a sufficient representation of data and peak activity, review the AWR reports to determine the various advisory recommendations for each individual component of memory and adjust as necessary.
  8. On the Initialization Parameters page, on the Character Sets tab,specify WE8MSWIN1252 as the default character set for the INOW database.
    Note:
    • The National Character Set (AL16UTF16) can remain as the default value.
    • Perceptive Content using an Oracle database does not currently support Unicode. If you require a Unicode implementation, we recommend that you consider using SQL Server or PostgreSQL.
    • Since Oracle does not currently support Unicode, ensure that you define the NLS_LANG environment variable correctly to reflect the actual code page/character of the client before connecting to the database.

      For example: NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252

      The application server will automatically set the NLS_LANG environment variable on startup as shown in the example above. On Linux, the system sets the code page as follows within the connection string: IANAAppCodePage=2252.
  9. On the Initialization Parameters page, click All Initialization Parameters.
  10. In the All Initialization Parameters dialog box, click Show Advanced Parameters.
    Note: The value for each of the parameters in the dialog box must match the values listed below.
    Parameter Value
    QUERY_REWRITE_ENABLE TRUE
    QUERY_REWRITE_INTETRITY TRUSTED
    CURSOR_SHARING EXACT
    NLS_DATE_FORMAT RRRR-MM-DD
    NLS_TIME_FORMAT HH24:MI:SS.FF
    NLS_TIMESTAMP_FORMAT RRRR-MM-DD HH24:MI:SS.FF
  11. Click Close, and click Next.
  12. Click Next, and continue to the Creation Options page.
  13. Select the Create Database, and the Save as a Database Template options.
  14. Click Finish.

    A summary of the database parameters appears.

  15. Click OK to create the database. This may take some time, depending on your system.

    When the database is complete, a summary appears with database log and connection information.

  16. Click OK.