Set up the Oracle databases manually

1. Ensure we have at least one Oracle database.

   The default database generally has the SID (name) ORCL. For best results, set the character set of the database to Unicode (AL32UTF8).

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

2. Create the user WORKLIGHT...

   • Using Oracle Database Control...

     1. Connect as SYSDBA and go to...
        Users | Server Security | Users

     2. Create a user, named WORKLIGHT 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

     3. Repeat the previous step to create the user WORKLIGHTREPORTS for the reports database/schema.

   • Using Oracle SQLPlus...

     CONNECT SYSTEM/SYSTEM_password@ORCL
     CREATE USER WORKLIGHT IDENTIFIED BY WORKLIGHT_password DEFAULT TABLESPACE USERS QUOTA UNLIMITED ON USERS;
     GRANT CREATE SESSION, CREATE SEQUENCE, CREATE TABLE TO WORKLIGHT;
     DISCONNECT;
     CONNECT SYSTEM/SYSTEM_password@ORCL
     CREATE USER WORKLIGHTREPORTS IDENTIFIED BY WORKLIGHTREPORTS_password DEFAULT TABLESPACE USERS QUOTA UNLIMITED ON USERS;
     GRANT CREATE SESSION, CREATE SEQUENCE, CREATE TABLE TO WORKLIGHTREPORTS;
     DISCONNECT;

3. Create the database tables for the runtime and reports databases:

   1. Create the tables for the runtime database...
      CONNECT WORKLIGHT/product_password@ORCL
      @MF_HOME/WorklightServer/databases/create-worklight-oracle.sql
      DISCONNECT;

   2. Create the tables for the reports database...
      CONNECT WORKLIGHTREPORTS/<WORKLIGHTREPORTS_password>@ORCL
      @MF_HOME/WorklightServer/databases/create-worklightreports-oracle.sql
      DISCONNECT;

4. Download and configure the Oracle JDBC driver:

   1. Download the JDBC driver from...
      Oracle: JDBC, SQLJ, Oracle JPublisher and Universal Connection Pool (UCP)

   2. Ensure that the Oracle JDBC driver, ojdbc6.jar, is in the system path.

Parent topic: Configure the Oracle databases manually