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

---

+

Search Tips   |   Advanced Search