Installation Guides › Upgrade Guide › Upgrading from r12 › How to Migrate from r12.0 › Upgrade an r12.0 Policy Server › Before You Upgrade the Policy Server › Keep Track of Oracle/SQL Data Sources Then Recreate Them

Keep Track of Oracle/SQL Data Sources Then Recreate Them

This section only applies if the policy store you are upgrading resides in an Oracle or SQL Server database.

Windows Systems

The r12.1 Policy Server upgrade program deletes existing SOA Security Manager SQL Server/Oracle drivers and install new ones, which means you need to keep track of your existing SOA Security Manager data source connection settings before deleting the old data sources.

After upgrading, manually create new r12.1 SOA Security Manager data sources with these settings using the ODBC Data Source Administrator dialog box.

Note: For more information on creating new SOA Security Manager r12.1 data sources, see the Policy Server Installation Guide.

Important! If you do not delete the existing data sources prior to installing the r12.1 Policy Server, you cannot remove them after you upgrade because the upgrade program deletes the existing drivers. Thus, the Policy Server will then not be able to find the data sources.

To keep track of the older data source settings and then delete the data sources

1. Open the ODBC Data Source Administrator dialog box by selecting Programs, Administrative Tools, Data Sources (ODBC).
2. Click the System DN tab.
3. Make a note of the data source connection settings for all the SOA Security Manager data sources by doing the following:
   1. Select a data source, for example, SOA Security Manager Data Source.
   2. Click Configure.
   3. Write down all the data source connection settings as you will need them to create a new r12.1 data source after upgrading.
   4. Click Cancel.
   5. Repeat these steps for every SOA Security Manager data source. For example, you may have the following data sources:
      • SOA Security Manager Data Source
      • SOA Security Manager Logs Data Source
      • SOA Security Manager Reports Data Source
      • SOA Security Manager Tokens Data Source
      • SOA Security Manager Key Data Source
      • SOA Security Manager Session Server Data Source
4. Delete all the SOA Security Manager data sources by selecting the source and clicking Remove.

After you delete the data source, install the r12.1 Policy Server and create a new data source.

Note: For instructions on creating a new data source, see the Policy Server Installation Guide.

UNIX Systems

The system_odbc.ini file contains ODBC data source information for SOA Security Manager data stores in Oracle or SQL Server. When upgrading the Policy Server to r12.1, the upgrade program backs up your existing system_odbc.ini file by renaming it to system_odbc.ini<PID_of_
Upgrade>.

• PID_of_Upgrade

  Defines the upgrade program's process ID.

  Example: system_odbc.ini8957

After installing the Policy Server, you need to configure a new ODBC data source.

To configure a new UNIX data source

1. Go to NETE_PS_ROOT/db.
   • NETE_PS_ROOT

     Defines the SOA Security Manager installation directory.

     Example: /export/smuser/siteminder

2. Create a new system_odbc.ini file by renaming oraclewire.ini or sqlserverwire.ini to system_odbc.ini.
3. Replace all occurrences of the string "nete_ps_root" with the explicit path of the SOA Security Manager installation directory.
4. For SQL Server, change the following values. These values need to be changed for all the data source names (SOA Security Manager Tokens Data Source, SOA Security Manager Logs Data Source, SOA Security Manager Session Data Source, etc.)

   [SiteMinder Data Source]
   Driver=nete_ps_root/odbc/lib/NSmsss19.so
   Description=DataDirect 4.2 SQL Server Wire Protocol
   Database=Siteminder Data
   Address=myhost, 1433
   QuotedId=No
   AnsiNPW=No
   

5. Save the file.

Note: For more information on creating a data source, see the Policy Server Installation Guide.