OpenPages database schema creation for Oracle

Applies to: On premises

Before you install IBM OpenPages®, decide how you want to create the OpenPages database.

You have the following options:
  1. You can use the OpenPages installation program to create the database schema. If you choose this option, you need to provide the credentials of a DBA user when you install OpenPages.
    When you use this option, the installation app verifies that the DBA user has the DBA role. If the database administrator accounts in your environment have a subset of the standard DBA role, you need to do one of the following options:
    • Temporarily grant the DBA role to the DBA user.
    • Use option 2 instead. With option 2, you can use a DBA that does not have the standard DBA role.
  2. You can ask a database administrator to do the steps that require DBA privileges, and then use the OpenPages installation program to complete the database setup. Use this option in the following cases:
    • Your organization's security policies require the separation of DBA and non-DBA tasks.
    • The database administrator accounts in your environment have a subset of the standard DBA role.
    • Your database administrator wants to customize the tablespace names, the schema name, or make other customizations.
  3. You can create all of the objects that are required for the database manually by using scripts. Use this option if you want to do any of the following configurations:
    • Customize the tablespace names or the schema name
    • Customize the tablespace data file locations
    • Use Oracle Transparent Data Encryption (TDE)
    • Run custom scripts

The initial install of an Oracle database always assumes LFS for the OpenPages storage type. If you want to use UNC, you must first install with LFS and then use the update storage script to change to UNC.

For a demonstration of how to create the database schema by using scripts, see the following video. The video shows 7.4 but the steps are similar for 9.1.x.