Creating an Oracle Database for the Order User

    Procedure
  1. Open $OM_HOME/db/dbscripts/oracle/order/oracle_order_db.properties file in a suitable editor and update the following values:
    Property Update the Value for
    ORCL_HOST Oracle database host
    ORCL_PORT Oracle port
    ORCL_USERNAME Oracle superuser name
    ORCL_PASSWORD Oracle superuser password
    ORCL_SERVICENAME Service name of the database
    ORCL_ORDER_USER New Order user
    ORCL_ORDER_PASSWORD Password for the Order user
    ORCL_ORDER_TABLESPACE Order tablespace
    ORCL_TABLESPACE_SIZE Size of the tablespace
    ORCL_MINSIZE Minimum tablespace size
    ORCL_MAXSIZE Maximum tablespace size
    ORCL_DATAFILE_PATH Data file path of Oracle
    IS_CLOUD_PLATFORM The default value is false. Set it to true if creating a database on a cloud platform.
    DEFAULT_TENANT TIBCO
    EXECUTE_DDL_DML_ONLY The default value is false. Set it to true if you run only DDL/DML.
    BASE_INSTALLATION_SCRIPTS OMS_DDL.sql,OMS_Seed_OrderLock.sql:true,

    order_ds_dml.sql:true,blobConvertorFunction.sql:true,

    insertPartitionDateProcedure.sql:true,

    OMS_Create_Future_Partitions_SQL_Weekly.sql:true,

    OMS_Future_Partitions_Weekly_JOB.sql:true
  2. Save and close the file.
  3. Run the $OM_HOME/db/dbscripts/oracle/order/db-setup.sh script.