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 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.
| Info | ||
|---|---|---|
| ||
To test products on a Oracle RAC, please, rename |
...
Copy the Oracle JDBC libraries to $CARBON$PRODUCT_HOME/repository/components/lib . For example, - $ORACLE_HOME/jdbc/lib/ojdbc14.jar .
| Info |
|---|
Note: Remove old database driver from $CARBON$PRODUCT_HOME/repository/components/dropins ,when you upgrade the database driver. |
...
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 WSO2 BPS.
| 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 |
...