The following sections describe how to set up Oracle RAC to replace the default H2 database in your WSO2 product:
Oracle Real Application Clusters (RAC) is an option that facilitates clustering and high availability in Oracle database environments. In the Oracle RAC environment, some of the commands used in
oracle.sql are considered inefficient. Therefore, the product has a separate SQL script (
oracle_rac.sql) for Oracle RAC. The Oracle RAC-friendly script is located in the
dbscripts folder together with other
To test products on Oracle RAC, rename
oracle.sql before running
Setting up the database and users
Follow the steps below to set up an Oracle RAC database.
- Set environment variables <
ORACLE_SIDwith the corresponding values (
orcl1) as follows:
- Connect to Oracle using SQL*Plus as SYSDBA.
Create a database user and grant privileges to the user as shown below:
- Exit from the SQL*Plus session by executing the
Setting up the JDBC driver
Copy the Oracle JDBC libraries (for example, the
<ORACLE_HOME>/jdbc/lib/ojdbc14.jar file) to the
Remove the old database driver from the
<PRODUCT_HOME>/repository/components/dropins directory when you upgrade the database driver.
By default, all WSO2 products are configured to use the embedded H2 database. To configure your product with Oracle RAC, see Changing to Oracle RAC.