Preparing the Oracle database

Applies to: On premises

A user with SYSDBA privileges needs to do some steps to set up the database before you install IBM OpenPages®.

About this task

A DBA with SYSDBA privileges must run the op-database-sysdba-install.sql script before you install OpenPages. The script does the following tasks:
  • Sets up Oracle Text Search
  • Creates the OpenPages database schema user and sets the password of the user
  • Grants the privileges that the OpenPages database schema user requires

Procedure

  1. Log on to the database server as a user with administrative privileges.
  2. Go to the /OP_<version>_Main/OP_<version>_Configuration/Database/ORACLE/INSTALL_SCRIPTS directory.
  3. Verify that you have execute permission on the files in the INSTALL_SCRIPTS directory. If not, change the permissions by using the chmod command.
  4. In SQL*Plus, run the op-database-sysdba-install.sql script as a user with SYSDBA privileges. 
    sqlplus <sysdba_user>/<sysdba_password>@<oracle_tns_alias> as sysdba @op-database-sysdba-install.sql <op_user>
<op_password>
    Table 1. Parameters of the op-database-sysdba-install.sql script for Oracle databases
    Parameter Description
    <oracle_tns_alias> The TNS alias of the Oracle database instance, for example OP
    <sysdba_user> A user with SYSDBA privileges, for example sys
    <sysdba_password> The password of the SYSDBA user

    If the password contains special characters, use \" around the password. For more information, see Special characters in passwords.
    <op_user> The OpenPages schema owner, for example openpage
    <op_password> The password of the OpenPages schema owner
    For example:
    sqlplus sys/<sysdba_password>@OP as sysdba @op-database-sysdba-install.sql openpage '<op_password>'