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

Running the script to configure your Oracle database for IBM Content Navigator

You must configure your Oracle database to create a table where you can store IBM® Content Navigator configuration data and preferences.

Before you begin

This task assumes that you:

Ran the IBM Content Navigator Configuration and Deployment Tool to update the table creation script for your environment.
Remember: You must run this script on the database where you created the database user that you specified when you ran the IBM Content Navigator Configuration and Deployment Tool.
Copied the updated script to your database server or made the script available to your database server from a shared network drive. For more information, see Running the script to configure your database for IBM Content Navigator.

You can run the script by using SQL Plus or Oracle SQL Developer.

You must connect to the database instance as a user with administrative authority to run the script.

To configure your Oracle database for IBM Content Navigator:

Log in to the server where Oracle is located.
Open one of the following tools:
- SQL Plus
- Oracle SQL Developer
Open the ORACLE_ONE_SCRIPT.sql file in a text editor and remove the comment characters (--) from the beginning of the COMMIT statement. Save the file.
Connect to the database instance where you plan to store IBM Content Navigator configuration data as a user with administrative authority:

Interface Command

SQL Plus Enter SQL_Plus_user_name/password@database_name

Oracle SQL Developer Connect to the database instance by entering your user name and password.

Interface	Command
SQL Plus	Enter `SQL_Plus_user_name/password@database_name`
Oracle SQL Developer	Connect to the database instance by entering your user name and password.

Run the script to create and populate the IBM Content Navigator configuration table:

Interface	Command
SQL Plus	Enter one of the following commands: `@ORACLE_ONE_SCRIPT.sql` `start ORACLE_ONE_SCRIPT.sql`
Oracle SQL Developer	Select the database. Select File > Openy and then click Browse. Select the ORACLE_ONE_SCRIPT.sql. Click Run Script.

Confirm that the task ran successfully.

After you run the script, the IBM Content Navigator table should be created and populated on your database.

After you configure your database for IBM Content Navigator, you must: