Versions Compared

Old Version 1

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.
Comment: Migrated to Confluence 5.3

Follow the instructions below to set up the Oracle database.

...

1. Edit the default database configuration defined in the  master-datasources.xml  file located at  $CARBON$PRODUCT_HOME/repository/conf/datasources  directory as follows. Both the database configurations in  registry.xml  and  user-mgt.xml  refer this data source.

...

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

...