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

Configure the Oracle Wire Protocol Driver

To configure the Oracle wire protocol driver

1. Edit the $NETE_PS_ROOT/db/system_odbc.ini file by replacing the nete_serverid value for SID with the value that is appropriate for your Oracle instance. If no system_odbc.ini file exists, copy and rename oraclewire.ini to system_odbc.ini. The SID is the system identifier for the database instance. In the following tnsnames.ora file, the value instance1 is the SID.

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

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

   [SiteMinder Data Source]
   Driver=nete_ps_root/odbc/lib/NSora24.so
   Description=DataDirect 6 SP3 Oracle Wire Protocol
   LogonID=uid
   Password=pwd
   HostName=nete_servername
   PortNumber=1521
   SID=nete_serverid
   CatalogOptions=0
   ProcedureRetResults=0
   EnableDescribeParam=0
   EnableStaticCursorsForLongData=0
   ApplicationUsingThreads=1
   

   nete_ps_root

   Specifies an explicit path, rather than one with an environment variable.

   uid

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

   pwd

   Specifies the password for the user.

   nete_servername

   Specifies the name of the Oracle database host system.

   nete_serverid

   Specifies the SID.

   Note: Only enter ten characters or less for the SID value due to a limitation of the Oracle wire protocol driver.

   You can edit these sections in the same manner to configure data sources for separate logs, keys, session, and sample users databases:

   • [SiteMinder Logs Data Source]
   • [SiteMinder Keys Data Source]
   • [SiteMinder Session Data Source]
   • [SmSampleUsers Data Source]
2. Configure your policy, key, logging, or session data stores.

More Information:

Configure Policy, Key, Logging, or Session Stores