Creating an Oracle Database for the Shopping Cart User

    Procedure
  1. Open $OPE_HOME/database-scripts/oracle/shoppingCart/bin/oracle_shoppingcart_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_SHOPPINGCART_USER New shopping cart user
    ORCL_SHOPPINGCART_PASSWORD Password for the shopping cart user
    ORCL_SHOPPINGCART_TABLESPACE shopping cart tablespace
    ORCL_SHOPPINGCART_TABLESPACE_LOCATION shopping cart tablespace location
    ORCL_MINSIZE Minimum tablespace size
    ORCL_MAXSIZE Maximum tablespace size
    ORCL_DATAFILE_PATH data file path of Oracle
    IS_CLOUD_PLATFORM Default value is false. You need to set it to true if the database is on a cloud platform.
    EXECUTE_DDL_DML_ONLY Default value is false. You need to set it to true if you want to execute only DDL/DML.
    BASE_INSTALLATION_SCRIPTS SHOPPINGCART_DDL.sql
  2. Save and close the file.
  3. Run the $OPE_HOME/database-scripts/oracle/shoppingCart/bin/db-setup.sh script.