Installation and Upgrade Guides › Policy Server Installation Guide › Configuring SiteMinder Data Stores in a Relational Database › How to Configure a SiteMinder Data Store in an Oracle Database › Create an Oracle Database With SiteMinder Schema › Create the Oracle Database For the Policy, Key, Logging, or Session Data Stores

Create the Oracle Database For the Policy, Key, Logging, or Session Data Stores

If you are using an Oracle database, run the sm_oracle_ps.sql, sm_oracle_logs.sql, and sm_oracle_ss.sql scripts to create the following SiteMinder data in a single Oracle database:

• policy store
• key store
• logging database
• session store

To run the scripts

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 in to Oracle with sqlplus (or some other Oracle utility) as the user who administers the Policy Server database information.
   2. Import the scripts to create the SiteMinder schema:

      $NETE_PS_ROOT/db/sql/sm_oracle_ps.sql

      $NETE_PS_ROOT/db/sql/sm_oracle_logs.sql

      $NETE_PS_ROOT/db/sql/sm_oracle_ss.sql

      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.

You can also store SiteMinder data in a separate Oracle database by running each script separately to create:

• a policy store
• a key store
• a logging database
• a session store
• a sample users database

For example, you can run the sm_oracle_logs.sql script to create a separate logging database.

More Information:

Configure an Oracle Data Source for SiteMinder