Installation and Upgrade Guides › Policy Server Installation Guide › Configuring SiteMinder Data Stores in a Relational Database › Configure Oracle Data Stores › How to Store Session Information in Oracle

How to Store Session Information in Oracle

To configure an Oracle database as a session store, complete the following procedures:

1. Gather Database Information.
2. Create the Session Store Schema.
3. Configure an Oracle Data Source for SiteMinder.
4. Point the Policy Server to the Database.
5. Restart the Policy Server.

Note: If you are trying to configure or upgrade a SiteMinder store listed in the SiteMinder Platform Support Matrix and cannot find the procedures in this guide, see the Directory Configuration Guide.

Gather Database Information

Configuring a single Oracle database to function as a policy store or any other type of SiteMinder data store requires specific database information.

Information prefixed with (U) indicates that the information is only required if the Policy Server is installed on a UNIX system. This information is required when configuring Oracle data source for UNIX.

Note: Policy and data store worksheets are provided to help you gather and record information before configuring or upgrading a SiteMinder data store. You can print the applicable worksheet and can use it to record required information before beginning.

More information:

Oracle Information Worksheet

Oracle RAC Information Worksheet

Required Information

Gather the following required information before configuring a supported Oracle or Oracle RAC database as a policy store or any other type of SiteMinder data store:

• (U) Policy Server installation path—Identify the explicit path to where the Policy Server is installed.
• Data source—Determine the name you will use to identify the Oracle data source.

  Example: SM Oracle Server Wire DS.

• Database administrative account—Determine the user name of an account with privileges to create, read, modify, and delete objects in the database.

  Note: Ensure the administrative account does not have the DB role. Audit-based reports will not return correct results if the administrative account has the DB role.

• Database administrative Password—Determine the password for the Administrative account.

Oracle Database Information

Gather the following information only if you are configuring a supported Oracle database as a policy store or any other type of SiteMinder data store:

• Oracle machine name—Determine the name of the machine on which the Oracle database is installed.
• Oracle instance service name—Determine the service name of the database instance to which you will connect. The tnsnames.ora file specifies service names.
• Oracle port number—Determine the port number on which the Oracle database is listening.

Oracle RAC Database Information

Gather the following information only if you are configuring a supported Oracle RAC database as a policy store or any other SiteMinder data store:

• Oracle RAC system service name—Determine the service name for the entire system.

  Example: In the following tnsnames.ora file, SMDB is the service name for the entire system:

  SMDB=
  (Description =
  (ADDRESS = PROTOCOL = TCP)(HOST = nete_servername1)(PORT=1521
  (ADDRESS = PROTOCOL = TCP)(HOST = nete_servername2)(PORT=1521)
  (ADDRESS = PROTOCOL = TCP)(HOST = nete_servername3)(PORT=1521))
  (LOAD_BALANCE = yes)
  (CONNECT_DATA=
  (SERVER = DEDICATED)
  (SERVER_NAME = SMDB))
  )
  

• Oracle RAC node service names—Determine the service names for each node in the system.
• Oracle RAC node IP addresses—Determine the IP Address of each node in the Oracle RAC system.

  Note: If you are using Oracle RAC 10g, determine the virtual IP address of each node in the system.

• Oracle RAC node port numbers—Determine the port number for each node in the Oracle RAC system.