Before You Upgrade an 5.x Oracle Policy Store

Consider the following before you upgrade an Oracle policy store:

Determine if SiteMinder r6.0 SP6 supports the version of Oracle that is functioning as the 5.x policy store.
Note: For more information, go to the Technical Support site and search for the SiteMinder Platform Matrix for 6.0.
If SiteMinder r6.0 SP6 supports the current version, you can upgrade the existing policy store. For more information, see Upgrade a 5.x Oracle Policy Store.
Note: In 5.x, Oracle policy and user stores could connect to the Policy Server using an ODBC or Oracle Call Interface (OCI) connection. SiteMinder r6.0 SP6 no longer supports OCI, so these stores can only connect to the Policy Server using an ODBC data source with the Oracle wire protocol driver.

However, an r6.0 SP6 Policy Server can communicate with a user directory defined in the 5.x policy store by transparently mapping the OCI namespace to ODBC. To establish this communication, create an ODBC data source on the r6.0 SP6 Policy Server host system. To create this data source, locate the Oracle service name for the OCI namespace user directory, which is listed in the 5.x Policy Server User Interface. You can access this name by selecting the user directory’s properties.
If SiteMinder r6.0 SP6 does not support the current version, see Migrate a 5.x Oracle Policy Store.

More information: