Versions Compared

Old Version 6

changes.mady.by.user Former user

Saved on

compared with

New Version 7

changes.mady.by.user Former user

Saved on

Key

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

Include Page
shared:Setting up Oracle (V1)
shared:Setting up Oracle (V1)

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