Installation Guides › Policy Server Installation Guide › Configuring SOA Security Manager Data Stores 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, and logging database, complete the following procedures:

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

1. Be sure that the Oracle database instance that is to contain the SOA Security Manager data is accessible from the Policy Server system. 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 SOA Security Manager super user password.
6. Import the default policy store objects.
7. Import the policy store data definitions.
8. Restart the Policy Server.
9. Prepare for the Administrative UI registration.