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.
- 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.
- On the Management Options page, follow the best practicesset by your company for configuring Enterprise Manager and Automatic Maintenance Tasks.
- On the Database Credentials page, follow the best practices set by your company.
-
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.
- On the Recovery Configuration page, choose the appropriate recovery options. For production environments, we recommend enabling flashback recovery and archive mode.
-
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.
-
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. -
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.
- On the Initialization Parameters page, click All Initialization Parameters.
-
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 - Click Close, and click Next.
- Click Next, and continue to the Creation Options page.
- Select the Create Database, and the Save as a Database Template options.
-
Click Finish.
A summary of the database parameters appears.
-
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.
- Click OK.