Announcement: You can find the guides for Commerce 7.5 and later on the new Elastic Path Documentation site. This Developer Center 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

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:
    sqlplus /nolog
  2. Connect to the database as the SYSuser:
    conn / as sysdba
  3. In SQL*Plus, create a database user account.
    create user COMMERCEDB identified by ep;
    
    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.
    grant connect, resource, dba to COMMERCEDB;
    
  5. Exit SQL*Plus.
    exit