Preparing the files for your database administrator

Applies to: On premises

Your database administrator needs a set of scripts to create the database schema. You need to prepare the files and send them to your DBA with instructions on how to run the scripts.

Do this procedure if your organization's security policies require the separation of DBA and non-DBA tasks.

About this task

The sql-wrapper.sql file contains information that is used by the database scripts. You need to enter the values for your environment, such as the name of the database instance for OpenPages®.

When you install OpenPages, use the same values that you set in the sql-wrapper.sql file.

Procedure

  1. Log on to the Oracle database server computer 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 write permission on the sql-wrapper.sql file. If not, change the permission on the file by using the chmod command.
  4. Edit the sql-wrapper.sql file.
    Restriction: Change only the parameters that are described in this step.

    These parameters are used by the scripts that your DBA will run.

    Table 1. Parameters in the sql-wrapper.sql file for Oracle databases
    Property Description
    opx_datafile_storage_dir Defines the physical locations of the datafiles that are associated with the tablespaces that are created. This should be set to a value that is appropriate for your environment
    opx_dflt_sid The TNS alias of the Oracle database for OpenPages.
    opx_db_owner The database owner, also the name of the schema
    opx_op_admin_name The OpenPages administrator user name
    opx_op_admin_pwd The OpenPages administrator password
    opx_dflt_stor_srv_root The path to the OpenPages storage directory.

    Example:

    define opx_dflt_stor_srv_root='/home/opuser/
OP/OpenPages/openpages-storage'
  5. If your database administrator is going to run the scripts that require DBA privileges, prepare the files for your database administrator.
    1. Go to the /OP_<version>_Main/OP_<version>_Configuration/Database/ORACLE/INSTALL_SCRIPTS directory.
    2. Open the op-dba-install-file-list.txt file.
    3. Send your DBA the sql-wrapper.sql file that you updated along with the files listed in the op-dba-install-file-list.txt file.
    4. Send your DBA the instructions to run the DBA scripts: Running the steps that require DBA privileges