Previous Topic: Create the Session Store SchemaNext Topic: Configure the Oracle RAC Wire Protocol Driver

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 › Create the Session Store Schema › Configure the Oracle Wire Protocol Driver

Configure the Oracle Wire Protocol Driver

You configure the wire protocol driver to specify the settings SiteMinder uses 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 one of the following files and rename it system_odbc.ini. The file you rename depends on the database vendor you are configuring as a SiteMinder data store.

These files are located in siteminder_home/db

The system_odbc.ini file contains the following sections. The data source that you are configuring determine the section or sections that you edit:

[SiteMinder Data Source]

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

[SiteMinder Logs Data Source]

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

[SiteMinder Keys Data Source]

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

[SiteMinder Session Data Source]

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

[SmSampleUsers Data Source]

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

Follow these steps:

  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: 
    Driver=nete_ps_root/odbc/lib/NSora24.so
Description=DataDirect 6 Oracle Wire Protocol
LoginID=uid
Password=pwd
HostName=nete_servername
PortNumber=1521
SID=nete_serverid
CatalogOptions=0
ProcedureResults=0
EnableDisableParam=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=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 the explicit path to where the 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_servername

    Specifies the machine name where the Oracle database is installed.

    nete_serverid

    Specifies the Oracle instance service name (SID). The SID is the system identifier for the database instance.

    Example: In the following sample tnsnames.ora file, the value instance1 is the SID.

    instance1 =

    (Description =

    (ADDRESS = (Protocol = TCP)(Host = myhost)(Port = 1521)

    (CONNECT_DATA = (SID = instance1))

    )
  3. Save the file.

    The Oracle wire protocol driver is configured.