Changing the database script when you use Oracle ASM

Applies to: On premises

If you use Oracle Automatic Storage Management (ASM), you must modify some scripted values. You must update the create-opx-tablespaces.sql script before you run the op-database-dba-install.sh|.bat script.

Procedure

  1. Log on to the Oracle database server as the user who installed Oracle.
  2. Go to the /OP_<version>_Main/OP_<version>_Configuration/Database/ORACLE/INSTALL_SCRIPTS directory.
  3. Open the create-opx-tablespaces.sql script in a text editor.
  4. As appropriate for your environment, replace the '&&3/&v_lcase_name..dbf' parameter with the name of a disk group.
    For example, if you want to use a disk group called DATA to store the opx_dflt_data_ts table space, use the following syntax:
    create tablespace &&opx_dflt_data_ts datafile ‘+DATA’ size 512 M reuse autoextend on next 128 M maxsize 1024 M &&encrypt_var;
  5. Save and close the file.