Installation and Upgrade Guides › SiteMinder Upgrade Guide › Upgrade Procedures from 5.x › Step 1: Upgrade the 5.x Policy Server to 6.x › Upgrade a 5.x Policy Store › Upgrade an Oracle Policy Store › Configure a Policy Server to Use a 5.x OCI NameSpace User Directory › Create a UNIX Oracle Data Source For a 5.x OCI Namespace

Create a UNIX Oracle Data Source For a 5.x OCI Namespace

To create a UNIX Oracle data source for a 5.x OCI namespace

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. The SID is the system identifier for the database instance. If no system_odbc.ini file exists, copy and rename oraclewire.ini to system_odbc.ini.

The modified text for the user directory’s data source should appear as follows:

     [OCI_User_Directory_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

OCI_User_Directory_Data_Source

Defines the Oracle service name of the OCI namespace user directory.

nete_ps_root

Defines an explicit path rather than one with an environment variable.

uid

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

pwd

Defines the password for the user.

nete_servername

Defines the name of the Oracle database host system.

nete_serverid

Defines the SID or, in this example, instance1.