Installation and Upgrade Guides › Policy Server Installation Guide › Configuring SiteMinder Data Stores in a Relational Database › Configure Policy, Key, Logging, or Session Stores › Store Keys, Logging, and Session Data in the Policy Store › Store Key, Logging, and Session Information in an Oracle Database

Store Key, Logging, and Session Information in an Oracle Database

To store keys, logging, and session information in an Oracle database

1. Be sure that the Oracle database instance that is to store the SiteMinder data is accessible from the Policy Server host system. Test the communication using tnsping or sqlplus.
2. Create the SiteMinder schema in the Oracle database:
   1. Log into Oracle with sqlplus or another Oracle utility as the user who administers the Policy Server database information.
   2. Import one or more of the following scripts to create the respective SiteMinder schema:
      • $NETE_PS_ROOT/db/sql/sm_oracle_ps.sql
        Creates the SiteMinder policy store; or if you are storing keys in different database, creates a key store.
      • $NETE_PS_ROOT/db/sql/sm_oracle_logs.sql
        Creates the schema for SiteMinder audit logs in an Oracle database.
      • $NETE_PS_ROOT/db/sql/sm_oracle_ss.sql
        Creates the schema for the SiteMinder session server in an Oracle database.

      If you are using sqlplus, run the schema using an @ sign.

      Example: @$NETE_PS_ROOT/db/sql/sm_oracle_ps.sql

      Note: Environment variables may not function in the SQL utility for Oracle. If you encounter problems when using the utility, specify an explicit path for $NETE_PS_ROOT, rather than one with an environment variable.

3. In the Policy Server Management Console, click the Data tab to move it to the front.

   Important! If you are accessing this graphical user interface on Windows Server 2008, open the shortcut with Administrator permissions, even if you are logged into the system as an Administrator. For more information, see the release notes for your SiteMinder component.

4. Select Key Store from the Database list.
5. Select the Use the policy store database check box and click Apply.
6. Select Audit Logs from the Database list.
7. Select the Use the policy store database check box and click Apply.
8. Click Test Connection to verify connectivity to the database server.
   • If it returns a success message, click OK to save the settings and exit.
   • If it returns a failure message, go back and recheck your data source settings.