Versions Compared

Old Version 5

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Follow the instructions below to set up the Oracle database.

...

Info

When using the ojdbc6.jar with WSO2 servers there is a possibility of throwing an timezone region not found error. To overcome this issue it is necessary to set the java property as export JAVA_OPTS="-Duser.timezone='+05:30'". The value of this property should be the GMT difference of the country.  

if it is necessary to set this property permanently, then it should be defined inside the wso2server.sh as a new JAVA_OPT property.

Create Database Tables

Database tables can be created either manually by running scripts or automatically by using start-up parameters.

Using Scripts

Warning

Important: As there is an issue in the oracle.sql script that comes with the API Manager 1.6.0 distribution, please download the correct file from here and replace the {CARBON_HOME}/dbscripts/oracle.sql file with it.

Then, the database tables can be created manually by logging in to the created database and running the following scripts in SQL*Plus:

Code Block
SQL> @${CARBON_HOME}/dbscripts/oracle.sql

Start the Carbon instance.

Code Block
$ ./${CARBON_HOME}/bin/wso2server.sh

Using start-up Parameters

...