Announcement: You can find the guides for Commerce 7.5 and later on the new Elastic Path Documentation site. The Developer Center continues to support Commerce 6.13.0 through 7.4.1.Visit new site

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.4.1, 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