Announcement: You can find the guides for Commerce 7.5 and later on the new Elastic Path Documentation site. This site contains the guides for Commerce 6.13.0 through 7.4.1.Visit new site

This version of Elastic Path Commerce is no longer supported or maintained. To upgrade to the latest version, contact your Elastic Path representative.

Creating the Database in Oracle 11g

In this document

Creating the Database in Oracle 11g

Creating a Database User Account

In Oracle databases, a database schema is mapped to a user account, so we only need to create a user account for the Elastic Path system.

  1. Start the SQL*Plus database client by entering the following command:
    1. sqlplus /nolog
    Copy
  2. Connect to the database as the SYSuser:
    1. conn / as sysdba
    Copy
  3. In SQL*Plus, create a database user account.
    1. create user COMMERCEDB identified by ep;
    Copy
    Note:

    When starting fresh with Elastic Path 7.1.0, it is recommended you use the name/password combination of COMMERCEDB/ep. This will make configuring Liquibase simpler, as this has been set as the default.

  4. Grant the user appropriate permissions.
    1. grant connect, resource, dba to COMMERCEDB;
    Copy
  5. Exit SQL*Plus.
    1. exit
    Copy