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 › Configure the Oracle RAC Wire Protocol Driver

Configure the Oracle RAC Wire Protocol Driver

You configure the wire protocol driver to specify the settings SiteMinder should use to connect to the database.

Note: This procedure only applies if the Policy Server is installed on a UNIX system. If you have not already done so, copy and rename oraclewire.ini to system_odbc.ini, which is located in <policy_server_installation>/db.

The system_odbc.ini file contains the following sections. The sections you edit are determined by the data source you are configuring:

• [SiteMinder Data Source]

  Specifies the settings SiteMinder should use to connect to the database functioning as the policy store.

• [SiteMinder Tokens Data Source]

  Specifies the settings SiteMinder should use to connect to the database functioning as the token store.

• [SiteMinder Logs Data Source]

  Specifies the settings SiteMinder should use to connect to the database functioning as the audit log database.

• [SiteMinder Keys Data Source]

  Specifies the settings SiteMinder should use to connect to the database functioning as the key store.

• [SiteMinder Session Data Source]

  Specifies the settings SiteMinder should use to connect to the database functioning as the session store.

• [SmSampleUsers Data Source]

  Specifies the settings SiteMinder should use to connect to the database functioning as the sample user data store.

To configure the wire protocol driver

1. Open the system_odbc.ini file.
2. Depending on the data source you are configuring, edit the applicable data source sections with the following information:
   • Add ServiceName=nete_servicename
   • Add AlternateServers=
   • Add Loadbalancing=1
   • Remove or comment SID=nete_serverid

   The modified text for the data source should appear as follows:

   Driver=nete_ps_root/odbc/lib/NSora23.so
   Description=DataDirect 5.3 Oracle Wire Protocol
   Logon=uid
   Password=pwd
   HostName=nete_servername1
   PortNumber=1521
   ServiceName=nete_servicename
   CatalogOptions=0
   ProcedureRetResults=0
   EnableDescribeParam=0
   EnableStaticCursorsForLongData=0
   ApplicationUsingThreads=1
   AlternateServers=
   LoadBalancing=1
   

   Note: When editing data source information, do not use the pound sign (#). Entering a pound sign comments the information, which truncates the value. The truncated value may cause ODBC connections to fail.

   • nete_ps_root

     Specifies an explicit path to the directory where Policy Server is installed.

   • uid

     Specifies the user name of the database account that has full access rights to the database.

   • pwd

     Specifies the password for the database account that has full access rights to the database.

   • nete_servicename1

     Specifies the IP Address of the first Oracle RAC node.

     (Oracle 10g) Specifies the virtual IP Address of the first Oracle RAC node.

   • nete_servicename

     Specifies the service name for the entire Oracle RAC system.

   • AlternateServers

     Specifies the connection failover to the other Oracle nodes, if the primary server is not accepting connections.

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

   • LoadBalancing=1

     Turns on client load balancing, which helps to distribute new connections to keep RAC nodes from being overwhelmed with connection requests. When enabled, the order in which primary and alternate database servers are accessed is random.

3. Save the file.

   The Oracle wire protocol driver is configured.