Installation and Upgrade Guides › Policy Server Installation Guide › Configuring SiteMinder Data in a Relational Database › Configure Oracle Data Stores › How to Store Audit Logs in Oracle › Configure an Oracle Data Source for SiteMinder › Create an Oracle RAC Data Source on Windows

Create an Oracle RAC Data Source on Windows

You can configure Oracle RAC 9.2.0.6 and 10.1.0.4 instances with the Policy Server as a single data source name similar to that of a single instance Oracle database. However, the data source name for Oracle RAC is different than a regular ODBC data source.

In an Oracle RAC system, in addition to the SID or ServiceName for each Oracle instance, there is also a ServiceName for the entire Oracle RAC system. When configuring a data source, configure the data source name to use this ServiceName when connecting to an Oracle RAC.

To configure an Oracle RAC data source

1. Select Start, Programs, Administrative Tools, Data Sources (ODBC).

   The ODBC Data Source Administrator appears.

2. Click the System DSN tab, and then click Add.
3. Select SiteMinder Oracle Wire Protocol, and click Finish.

   The ODBC Oracle Wire Protocol Driver Setup dialog appears. The General tab is pulled to the front.

4. Enter a name that identifies the data source in the Data Source Name field.

   Note: Record this name. You will need the data source name when pointing the Policy Server to the database.

5. Enter the IP Address of the first node in the Oracle RAC system in the Host field.

   Oracle RAC 10g: Enter the virtual IP Address.

6. Enter the service name for the entire Oracle RAC system in the Service Name field.

   Example: In the following tnsnames.ora file, the SMDB value is the service name for the entire Oracle RAC system, which contains 3 nodes:

   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)
   (SERVICE_NAME = SMDB)
   )
   

7. Click the Failover tab.

   Failover settings appear.

8. Specify the host name or virtual IP Address, port number, and service name for the remaining Oracle RAC nodes in the environment in the Alternate Servers field.

   Note: The ServiceName is the service name for the entire Oracle RAC system.

9. Specify the AlternateServers to provide connection failover to the other Oracle nodes if the primary server is not accepting connections. The entry should have the following format:

   (HostName=nete_servername2:PortNumber=1521:ServiceName=nete_servicename[,...])

10. Select LoadBalancing.
11. Click OK

    The Oracle RAC data source is configured for the wire protocol driver.