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

Create an Oracle Data Source on Windows

To create an Oracle data source on Windows

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 machine name where the Oracle database is installed in the Host Name field.
6. Enter the port number where the Oracle database is listening on the machine in the Port Number field.
7. Enter the name of the Oracle instance to which you want to connect in the SID field.

   Note: The service name is specified 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.

   Example: if the tnsnames.ora file contains the following entry for an Oracle instance, you enter instance1 in the SID field:

   instance1 =
   

   (Description=
   (Address = (PROTOCOL = TCP)(Host = myhost)(Port=1521))
   (Connect_DATA_ = (SID = SIDofinstance1))
   )
   

8. Click Test Connection.

   The connection settings are tested and a prompt appears specifying that the connection is successful.

9. Click OK.

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