Setting up your Oracle database manually for Application Center

You can set up your Oracle database for Application Center manually.

1. Ensure that you have at least one Oracle database.

   In many Oracle installations, the default database has the SID (name) ORCL. For best results, specify Unicode (AL32UTF8) as the character set of the database.

   If the Oracle installation is on a UNIX or Linux computer, make sure that the database is started next time the Oracle installation is restarted. To this effect, make sure that the line in /etc/oratab that corresponds to the database ends with a Y, not with an N.

2. Create the user APPCENTER, either by using Oracle Database Control, or by using the Oracle SQLPlus command-line interpreter.
   • To create the user for the Application Center database/schema, by using Oracle Database Control, proceed as follows:
     1. Connect as SYSDBA.
     2. Go to the Users page.
     3. Click Server, then Users in the Security section.
     4. Create a user, named APPCENTER with the following attributes:

        Profile: DEFAULT
        Authentication: password
        Default tablespace: USERS
        Temporary tablespace: TEMP
        Status: Unlocked
        Add system privilege: CREATE SESSION
        Add system privilege: CREATE SEQUENCE
        Add system privilege: CREATE TABLE
        Add quota: Unlimited for tablespace USERS

   • To create the user by using Oracle SQLPlus, enter the following commands:

     CONNECT SYSTEM/<SYSTEM_password>@ORCL
     CREATE USER APPCENTER IDENTIFIED BY password DEFAULT TABLESPACE USERS QUOTA UNLIMITED ON USERS;
     GRANT CREATE SESSION, CREATE SEQUENCE, CREATE TABLE TO APPCENTER;
     DISCONNECT;

3. Create the tables for the Application Center database:
   1. Using the Oracle SQLPlus command-line interpreter, create the tables for the Application Center database by running the create-appcenter-oracle.sql file:

      CONNECT APPCENTER/APPCENTER_password@ORCL
      @product_install_dir/ApplicationCenter/databases/create-appcenter-oracle.sql
      DISCONNECT;

4. Download and configure the Oracle JDBC driver:
   1. Download the JDBC driver from the Oracle website at Oracle: JDBC, SQLJ, Oracle JPublisher and Universal Connection Pool (UCP):
   2. Ensure that the Oracle JDBC driver is in the system path. The driver file is ojdbc6.jar.