Creating the Process Federation Server database for Oracle (deprecated)

Edit online
Process Federation Server includes scripts for creating an Oracle database for storing saved searches. Customize and then run the scripts.

Before you begin

Ensure that Oracle was installed using the UTF-8 Universal character set (AL32UTF8) instead of the default database character set (WE8ISO8859P1 - ISO 8859-1 West European). This character set ensures that Process Federation Server metadata that contains language-specific characters can be saved in the database.
Attention:  25.0.1.0 

Storing saved search definitions that are used by Process Portal in a relational database is deprecated with this version. To help ensure compatibility and future support, use the Federated Data Repository index as the data store for the Process Federation Server.

For more information on how to configure the Process Federation Server data store, see Configuring properties for the data store.

To migrate existing saved search definitions, see Migrating saved search definitions to a Federated Data Repository index.

About this task

The scripts for creating the Process Federation Server database for Oracle are in the pfs_install_root/ibmProcessFederationServer/wlp-ext/dbscripts/oracle.
  • createTablespace_PFS.sql
  • createSchema_PFS.sql
  • createTable_PFS.sql

Procedure

  1. Replace the variables in the script files with the values for your federated environment:
    @SCHEMA@
    The name of the user who owns the Process Federation Server database tables.
    @DB_PASSWORD@
    The password for the user that is identified by the @SCHEMA@ variable.
    @TAB_TS@
    The table space that is used for storing data.
    @IDX_TS@
    The table space that is used for storing indexes.
    @TSDIR@
    The directory path for the table space or a prefix for the table space name, for example, PFSTS, that is added to all table spaces.
    @DB_USER@
    The user name that you want to use to create the database. During database creation, this user is granted RESOURCE privileges. To secure the database, you can remove the privileges for RESOURCE in the createSchema_PFS.sql script and enable them in the createTable_PFS.sql script. The database scripts contain more information about these changes.
  2. From a command prompt, run the scripts to create the table spaces, schema, and tables.
    The following variables are used in the script calls:
    dbadmin
    The Oracle user with administrative authority.
    database_name
    The Oracle service name, for example, orcl.
    1. Create the table spaces. 
      sqlplus dbadmin/password@database_name @createTablespace.sql
    2. Create the schema. 
      sqlplus dbadmin/password@database_name @createSchema.sql
    3. Create the tables. 
      sqlplus dbadmin/password@database_name @createTable.sql
    The Oracle database is created.

What to do next

Create a process federation server. See Creating a process federation server.