Oracle Real Application Clusters (RAC) is an option for the Oracle Database for clustering and high availability in Oracle database environments. In Oracle RAC environment, some of the commands used in oracle.sql is considered inefficient (refer to Setting up with Oracle). Therefore WSO2 ESB BPS has a separate SQL script oracle_rac.sql for Oracle RAC. The Oracle RAC-friendly script is located in dbscripts folder together with other .sql scripts.
...
1. Edit the default database configuration defined in the master-datasources.xml file file located at $CARBON_HOME/repository/conf/datasources directory directory as follows. Both the database configurations in registry.xml and and user-mgt.xml refer refer this data source.
| Info |
|---|
Replace these settings with your own custom values. |
...
| Code Block |
|---|
SQL> @${CARBON_HOME}/dbscripts/oracle.sql |
Start the WSO2 ESBBPS.
| Code Block |
|---|
$ ./${CARBON_HOME}/bin/wso2server.sh |
...
To create the database tables when starting the WSO2 ESB BPS for the first time.
- For Linux Users
...
| Excerpt | ||
|---|---|---|
| ||
Instructions on how to set up WSO2 ESB BPS with Oracle RAC (Real Application Clusters) database. |