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:
- Choose the following from the list of available product
components:
- Oracle Server
- Oracle Net Services
- Oracle Development Kit
- Oracle Call Interface (OCI)
- Oracle Documentation (recommended)
- Transaction Processing (also known as OLTP) is the required
configuration type.
- Start the listener and the Oracle database service/processes
if they have not started automatically.
- 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
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.