Versions Compared

Old Version 1

changes.mady.by.user Former user

Saved on

compared with

New Version 2

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.

...

Copy the Oracle JDBC libraries to $CARBON$PRODUCT_HOME/repository/components/lib. For example, - $ORACLE_HOME/jdbc/lib/ojdbc14.jar.

Info

Remove old database driver from $CARBON$PRODUCT_HOME/repository/components/dropins , when you upgrade the database driver.

Info

When using the ojdbc6.jar with WSO2 servers there is a possibility of throwing an a 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.

...

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

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

Start the Carbon instance.

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

Using start-up Parameters

  • For Windows users:
Code Block
$CARBON$PRODUCT_HOME/bin/wso2server.bat -Dsetup

...

  • For Linux Users
Code Block
$ ./${CARBONPRODUCT_HOME}/bin/wso2server.sh -Dsetup

...