If the directory/file paths specified in this guide do not exist in your WSO2 product, see Directory Structure of WSO2 Products to locate the paths applicable to your product.
Administration Guide 4.4.x

Versions Compared

Old Version 5

changes.mady.by.user Nilmini Perera

Saved on

compared with

New Version Current

changes.mady.by.user Nilmini Perera

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The following sections describe how to set up Oracle RAC to replace the default H2 databases with Oracle RAC:database in your WSO2 product: 

Table of Contents
maxLevel3
minLevel3
locationtop
styleborder:1
separatorpipe

...

...

NOTE TO WRITERS : Add the intro and the TOC in the hosting page when you pull or copy the content.

The following sections describe how to replace the default H2 databases with Oracle RAC:

Table of Contents
maxLevel3
locationtop
styleborder:1
separatorpipe

Oracle Real Application Clusters (RAC) is an option for the Oracle Database for 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 .sql scripts.

...

  1. Set environment variables <ORACLE_HOME>, PATH,and ORACLE_SID with the corresponding values (/oracle/app/oracle/product/11.2.0/dbhome_1, $PATH:<ORACLE_HOME>/bin, and orcl1 ) as follows:
  2. Connect to Oracle using SQL*Plus as SYSDBA.

  3. Create a database user and grant privileges to the user as shown below:

    Code Block
    languagepowershell
    Create user <USER_NAME> identified by password account unlock;
grant connect to <USER_NAME>;
grant create session, create table, create sequence, create trigger to <USER_NAME>;
alter user <USER_NAME> quota <SPACE_QUOTA_SIZE_IN_MEGABYTES> on '<TABLE_SPACE_NAME>';
commit;
  4. Exit from the SQL*Plus session by executing the quit command.

...

Info

Remove the old database driver from the <PRODUCT_HOME>/repository/components/dropins/ directory when you upgrade the database driver.

...