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 › Configure an Oracle Data Source for SiteMinder › Create an Oracle Data Source on Windows Systems

Previous Topic: Configure an Oracle Data Source for SiteMinder

Next Topic: Create an Oracle RAC Data Source on Windows Systems
Create an Oracle Data Source on Windows Systems

To create an Oracle data source on a Windows system

  1. Select Programs, Administrative Tools, Data Sources (ODBC) to access the ODBC Data Source Administrator.
  2. Click the System DSN tab and click Add.

    The Create New Data Source dialog appears.

  3. Scroll down and select SiteMinder Oracle Wire Protocol and click Finish.

    The ODBC Oracle Wire Protocol Driver Setup dialog appears.

  4. Under the General tab, do the following:
    1. In the Data Source Name field, enter any name you want.

      Example: SM Oracle Wire DS

      Note: Take note of the data source name. The data source name is required when configuring your ODBC database as a policy store.

    2. (Optional) In the Description field, enter a description of the Oracle wire protocol data source.
    3. In the Host field, enter the name of the Oracle database host system.
    4. In the Port Number field, enter the port number on which the Oracle database is listening.
    5. In the SID field, enter the service name of the Oracle instance to which you want to connect. You specified this name in the tnsnames.ora file. The SID is the system identifier for the database instance.

      The tnsnames.ora file contains service names and details that Oracle uses to identify and connect to Oracle instances. For example, if the tnsnames.ora file contains the following entry for an Oracle instance, enter instance1 in the SID field.

      instance1 =
        (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(Host = myhost)(Port =1521))
        (CONNECT_DATA = (SID = SIDofinstance1))
       )

    6. Test the connection with the database by clicking Test Connect.
  5. Click OK to save the selections and exit the ODBC Oracle Wire Protocol Driver Setup.

    The configuration is complete. Configure SiteMinder to use the data source you created.

More Information:

Configure an ODBC Database as a Policy Store