Page Comparison

...

...

Setup User

1. Set environment variables ORACLE_HOME, PATH, ORACLE_SID with the corresponding values /oracle/app/oracle/product/11.2.0/dbhome_1, $PATH:$ORACLE_HOME/bin, orcl1.

...

4. Exit from the SQL*Plus session by typing the "quit" command.

SQL> quit

Setup Configuration File

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

...

<datasource>
     <name>WSO2_CARBON_DB</name>
     <description>The datasource used for registry and user manager</description>
     <jndiConfig>
          <name>jdbc/WSO2CarbonDB</name>
     </jndiConfig>
     <definition type="RDBMS">
          <configuration>
            <url>jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)
   			       (ADDRESS=(PROTOCOL=TCP)(HOST=racnode1) (PORT=1521))
   			       (ADDRESS=(PROTOCOL=TCP)(HOST=racnode2) (PORT=1521))
   			       (CONNECT_DATA=(SERVICE_NAME=service_name)))</url>
            <username>regadmin</userName>
            <password>regadmin</password>
            <driverClassName>oracle.jdbc.driver.OracleDriver</driverClassName>
            <maxActive>80</maxActive>
            <maxWait>60000</maxWait>
            <minIdle>5</minIdle>
            <testOnBorrow>true</testOnBorrow>
            <validationQuery>SELECT 1</validationQuery>
            <validationInterval>30000</validationInterval>
          </configuration>
     </definition>
</datasource>

The database configuration options

• url - The URL of the database.
• username - The name of the database user.
• password - The password of the database user.
• driverClassName  - The class name of the database driver.
• maxActive - The maximum number of active connections that can be allocated from this pool at the same time or negative for no limit.
• maxWait - The maximum number of milliseconds that the pool will wait (when there are no available connections) for a connection to be returned before throwing an exception or <= 0 to wait indefinitely.
• minIdle - The minimum number of active connections that can remain idle in the pool without extra ones being created or 0 to create none.

Copy JDBC Driver

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

Create Database Tables

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

Using Scripts

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

...

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

Using Start-up Parameters

• For Windows users:

$CARBON_HOME/bin/wso2server.bat -Dsetup

...