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 12c

Creating the Database in Oracle 12c

Note: Before You Begin

Make sure you have Oracle 12c installed to your production server.

Creating a Pluggable Database

New in Oracle 12c is the concept of pluggable databases. We will create one along with a user account for the Elastic Path system.

  1. Open the DBCA Utility:
    cd $ORACLE_HOME/bin && ./dbca
  2. Delete the default 'orcl' database:
    • Select "Delete Database" and click "Next".
    • Select "orcl" database (if not already selected) and click "Next".
    • Skip "Management Options" by clicking "Next", and then finally, click "Finish".
  3. Re-create the database 'orcl' and specify a pluggable database name of 'eppdb':
    • Rerun the DBCA Utility.
    • Select "Create Database" and click "Next".
    • Fill in the following fields and use the default values for other fields not specified:
      Property Value
      Global Database Name orcl
      Administrative Password <password>
      Create as Container Database
      Pluggable Database Name eppdb
    • Click "Next" and then "Finish".
  4. You can connect to the pluggable db, eppdb, by it's service name 'eppdb' and using a slash in the URL like:
    jdbc:oracle:thin:@<ip>:1521/eppdb