Page Comparison

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

Changing the product-specific/identity/service-provider databases

The topics above show how to change the WSO2_CARBON_DB, which is used to store registry and user manager information. If you changed the product-specific database that comes by default or set up a separate database for identity/service-provider related data, the instructions are the same. In summary:

1. Add the datasource to the master-datasources.xml file. 

2. Create the database tables using the following scripts:  
   

   For the product-specific database	Use <PRODUCT_HOME>/dbscripts/apimgt/oracle.sql and <PRODUCT_HOME>/dbscripts/bps/oracle.sql
   For the identity database	Use <PRODUCT_HOME>/dbscripts/identity/oracle.sql
   For the service-provider database	Use <PRODUCT_HOME>/dbscripts/service-provider/oracle.sql