Preparing to run the non-DBA database scripts

Applies to:

Edit the sql-wrapper.sql file to specify the values for your environment.

This procedure is optional. Instead of running scripts, you can complete the database setup when you install OpenPages®.

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

Log on to the Oracle database server computer as the Oracle database administrator (DBA).
Go to the /OP_<version>_Main/OP_<version>_Configuration/Database/ORACLE/INSTALL_SCRIPTS directory.
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.

Edit the sql-wrapper.sql file to ensure that the variables are set correctly for your environment.

Table 1. Parameters in the sql-wrapper.sql file for Oracle databases
Property	Description
`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_base_currency_iso_code`	The base currency For example, if you use Euros as your base currency, change the default ISO currency code from `USD` to `EUR`. `define opx_base_currency_iso_code='EUR'`
`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'`
`flag_install_oracle_text`	The value for `flag_install_oracle_text` must match the value that you used when you ran the `op-database-dba-install.bat\|.sh` script. See Running the steps that require DBA privileges.

If you want to load custom data during the database setup process, see Loading custom data (Db2 and Oracle).