IBM Worklight v5.0.5 > WL server administration > Troubleshooting

Set up the Oracle database manually


IBM Worklight V5.0.5. automatically configures the databases. However, if you are using an older version of IBM Worklight, or if you are experiencing problems with the automatic configuration process, manually set up and configure your Oracle database.

To set up the Oracle database.

  1. Create the database and users. Using the Oracle Database Configuration Assistant (DBCA), follow the steps in the wizard to create a new general-purpose database named WRKLGHT:

    1. Use global database name WRKLGHT_your_domain, and system identifier (SID) WRKLGHT.

    2. On the Custom Scripts tab of the step Database Content, do not run the SQL scripts, because first create a user account.

    3. On the Character Sets tab of the step Initialization Parameters, select Use Unicode (AL32UTF8) character set and UTF8 - Unicode 3.0 UTF-8 national character set.

    4. Complete the wizard, accepting the default values.

    Repeat the previous step to create the IBM Worklight report database.

    1. Use global database name WLREPORT_your_domain, and SID WLREPORT.

  2. Create the user worklight, either using Oracle Database Control, or using the Oracle SQLPlus command-line interpreter.

    Create the user for the WRKLGHT database, using Oracle Database Control:

    1. Connect as SYSDBA.

    2. Go to the Users page and in Oracle 10.2(g), click Administration, then Users.

    3. In Oracle 11.2(g), click Server, then Users in the Security section.

    4. Create a user named worklight with the following attributes:

      Profile DEFAULT
      Authentication password
      Default tablespace USERS
      Temporary tablespace TEMP
      Status UNLOCK
      Add role CONNECT
      Add role RESOURCE
      Add system privilege CREATE VIEW
      Add system privilege UNLIMITED TABLESPACE

      Repeat the previous step to create the user worklight for the IBM Worklight report database, WLREPORT.

    To create the user for both databases using Oracle SQLPlus...

      CONNECT system/<system_password>@WRKLGHT
      CREATE USER worklight IDENTIFIED BY worklight;
      GRANT CONNECT TO worklight;
      GRANT RESOURCE TO worklight;
      GRANT CREATE VIEW TO worklight;
      DISCONNECT;
      CONNECT system/<system_password>@WLREPORT
      CREATE USER worklight IDENTIFIED BY worklight;
      GRANT CONNECT TO worklight;
      GRANT RESOURCE TO worklight;
      GRANT CREATE VIEW TO worklight;
      DISCONNECT;

  3. Create the database tables for the IBM Worklight database and IBM Worklight reports database:

    1. Using the Oracle SQLPlus command-line interpreter, create the required tables for the IBM Worklight database (WRKLGHT) by executing the create-worklight-oracle.sql file:


        CONNECT system/<system_password>@WRKLGHT
        @<worklight_install_dir>/WorklightServer/databases/create-worklight-oracle.sql
        DISCONNECT;

    2. Using the Oracle SQLPlus command-line interpreter, create the required tables for the IBM Worklight report database (WLREPORT) by executing the create-worklightreports-oracle.sql file:

  4. Create a worklight.properties file. Give the file the following contents, depending on whether you are using JDBC or JNDI. For JDBC:
    wl.db.type=ORACLE
    wl.db.url=jdbc:oracle:thin:@<HOST IP>:1521/WRKLGHT
    wl.reports.db.type=ORACLE
    wl.reports.db.url=jdbc:oracle:thin:@<HOST IP>:1521/WLREPORT
    wl.db.username=worklight
    wl.db.password=worklight
    reports.exportRawData=true

    For JNDI:

    wl.db.jndi.name=jdbc/WorklightDS
    wl.reports.db.jndi.name=jdbc/WorklightDS
    wl.db.type=ORACLE

    If you choose to use worklight.properties supplied as part of worklight.war, remove all properties related to Apache Derby.

  5. Replace the WEB-INF/classes/conf.worklight.properties file in worklight.war with the file you created in the previous step.

  6. 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.


Parent Troubleshooting