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

Creating the Database in Oracle 12c

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:
      Table 1.
      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