Creating an Oracle Database for the Shopping Cart User
- Procedure
- 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 - Save and close the file.
- Run the
$OPE_HOME/database-scripts/oracle/shoppingCart/bin/db-setup.sh
script.