IBM Content Navigator, Version 2.0.3 Supports: Content Manager, FileNet P8, OnDemand, OASIS CMIS

Worksheet for creating the data source and updating the database script for your Oracle RAC database

Work with your Oracle Real Application Cluster (RAC) database server administrator to gather the information that you need to create a data source for your IBM® Content Navigator database on the web application server and create a table for IBM Content Navigator on your Oracle RAC database. The data source enables the web client to connect to the IBM Content Navigator database. The IBM Content Navigator Configuration and Deployment Tool requires that you enter values that are prepared in advance. The worksheet is a useful place to put these values.

Print this worksheet and enter values as you prepare for your installation.

Use this worksheet when you do the following configuration and deployment tasks in the IBM Content Navigator Configuration and Deployment Tool:

Update and Run the Database Script for Your Environment
Creating a Data Source for Your Database

Restriction: The IBM Content Navigator Configuration and Deployment Tool does not allow you tp specify the following information:

The location of the datafile table space
The location of the tempfile table space

If these table spaces need to be created in a specific location on the database server, work with your Oracle RAC database server administrator to modify and manually run the script on the database server. Do not run the script from the IBM Content Navigator Configuration and Deployment Tool.

If you are using Oracle RAC with Automatic Storage Manager (ASM), you must specify the location of the datafile table space and the tempfile table space.

Table 1. Parameters required by the IBM Content Navigator Configuration and Deployment Tool to create a data source for your Oracle RAC database
Parameter	Description	Value
JDBC driver	The JDBC driver that corresponds to the type of database where you will store IBM Content Navigator configuration data. IBM Content Navigator supports the following JDBC drivers: DB2® Universal JDBC Driver DB2 for z/OS® Universal JDBC Driver (available on WebSphere® Application Server only) DB2 Universal JDBC Driver (pureScale or HADR) (available on WebSphere Application Server only) Microsoft JDBC Driver Oracle JDBC Driver Oracle JDBC Driver (RAC Support) Remember: You must copy the JDBC driver for your database to the IBM Content Navigator server. In addition, if you are deploying on Oracle WebLogic Server, you must add the JDBC driver class path to the Oracle WebLogic Server startup script. For more information, see Preparing Oracle WebLogic Server for IBM Content Navigator.	Oracle JDBC Driver (RAC Suport)
JDBC data source name	The name of the non-XA JDBC data source that you want to create to communicate with the IBM Content Navigator database. The name must be unique and cannot contain spaces. The default name is ECMClientDS. You cannot run this task if the data source name exists on your web application server. It is recommended that you remove the existing data source by using your application server administration tools before you run this task.
Oracle JDBC RAC data	The list of database host names and port numbers in your Oracle Real Application Cluster (RAC). Separate the host name and port number with a colon (:). Separate each server entry with a comma (,). For example, enter: host_name1:port_1,host_name2:port_2.
Database service name	The name of the database that you created to store the IBM Content Navigator configuration data and user preferences. This is the database where you want to create the IBM Content Navigator configuration table. You must specify an existing database.
Oracle RAC retries	The number of attempts for the Oracle Real Application Clusters (RAC). This value determines the number of times that communication with the list of servers in the Oracle cluster is attempted before the connection to the database fails. The default number of attempts is 32.
Oracle RAC delay	The amount of delay, in seconds, between attempts to connect to the list of servers in the Oracle Real Application Clusters (RAC). The default delay is 4 seconds.
Database user name	The name of the database users that the IBM Content Navigator data source will use to connect to the database. The user must be a table space owner.
Database user password	The password of the specified database user.
IBM Content Navigator administrator	The name of the user that you want to use as the IBM Content Navigator administrator. Important: This user must be an existing web application server user name or LDAP user name. This parameter is the ECMClient_ADMINID parameter in the database script, ORACLE_ONE_SCRIPT.sql.
Table space name	The name of the table space that you want to create on the IBM Content Navigator configuration database. This parameter is the ECMClient_TBLSPACE parameter in the database script, ORACLE_ONE_SCRIPT.sql. The table space name is also used for the following parameters: The name of the datafile is ECMClient_TBLSPACE The name of the tempfile is ECMClient_TBLSPACE@TEMP If you need to create the datafile table space or the tempfile table space in a specific location on the database server, work with your Oracle database server administrator to modify and manually run the script on the database server.
JDBC directory	The directory where you installed the JDBC driver files on your IBM Content Navigator server. If you plan to deploy IBM Content Navigator in a highly available cluster, you must copy the driver files to the same directory on each node in the cluster.
JDBC configuration script	The fully qualified path of the JDBC data source configuration script. The name of the script depends on the web application server you are using: On Oracle WebLogic Server, the script is configureWLJDBC.py. On WebSphere Application Server, the script is configureWSJDBC.tcl. On AIX®, the default directory is /opt/IBM/ECMClient/configure/scripts/`script_name`. On Linux, the default directory is /opt/IBM/ECMClient/configure/scripts/`script_name`. On Linux for System z®, the default directory is /opt/IBM/ECMClient/configure/scripts/`script_name`. On Windows, the default directory is C:\Program Files (x86)\IBM\ECMClient\configure\scripts\`script_name`.
Current database configuration	Specify whether your database has already been configured for IBM Content Navigator or not.
Run the script to build and populate the database	You can use the IBM Content Navigator Configuration and Deployment Tool to run the script that is generated by this task on your database server. When you run this script, it creates the objects that you identified in this task on the database and populates the database with the default configuration. If you do not select this option, you must manually run the updated script on your database server to create the IBM Content Navigator configuration table on your database instance. You must complete this step after you deploy the web application but before you administer the web client. Specify whether this option applies to your environment.
Enable database connection validation	You can enable connection validation (WebSphere Application Server) or automatic connection testing (Oracle WebLogic Server) on the data source to decrease the likelihood of the web client encountering a connection failure to the database. For more information on connection validation and automatic connection testing, see your web application server documentation. Specify whether this option applies to your environment. Note: This description is different from the description in the IBM Content Navigator Configuration and Deployment Tool. Refer to this description when completing the task.