Installation Guides › Policy Server Installation Guide › Configuring SOA Security Manager Data in a Relational Database › Configure an Oracle Policy Store › How to Configure the Policy Store

How to Configure the Policy Store

To configure a single Oracle database as policy store, key store, token store, session store, and logging database, complete the following procedures:

Note: Ensure you have gathered the required database information before beginning. Some of the following procedures require this information.

1. Ensure that the Oracle database instance that is to contain the SOA Security Manager data is accessible from the Policy Server machine. Test the communication using tnsping or sqlplus.
2. Create the SOA Security Manager Schema.
3. Configure an Oracle Data Source for SOA Security Manager:
   • (Windows) Create an Oracle Data Source on Windows Systems.
   • (Windows) Create an Oracle RAC Data Source on Windows Systems.
   • (UNIX) Create an Oracle Data Source on UNIX.
   • (UNIX) Configure the Wire Protocol Driver.
   • (UNIX) Configure the Oracle Wire Protocol Driver.
   • (UNIX) Configure the Oracle RAC Wire Protocol Driver.
4. Point the Policy Server to the Database.
5. Set the SiteMinder Super User Password.
6. Import the Default SOA Security Manager Objects.
7. Import the Policy Store Data Definitions.
8. Restart the Policy Server.