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 › Upgrade a 5.x Oracle Policy Store

Previous Topic: Modify the 5.x .smdif File With an OCI Namespace User Directory

Next Topic: Configure a Policy Server to Use a 5.x OCI NameSpace User Directory

Upgrade a 5.x Oracle Policy Store

To upgrade a 5.x Oracle Policy Store

  1. Be sure that the Oracle database instance that is to function as the r6.0 SP6 policy store is accessible from the Policy Server host system. Test the communication using tnsping or sqlplus.
  2. Logging in to Oracle with sqlplus or another Oracle utility as the user who administers the Policy Server database information.
  3. Importing the following upgrade script: 
    $NETE_PS_ROOT/db/sm_oracle_ps_upgrade_55_to_60.sql

    Note: If you are using sqlplus, run the schema using an @ sign.

    Example: @$NETE_PS_ROOT/db/sm_oracle_ps_upgrade_55_to_60.sql

  4. From a command prompt on the Policy Server host system, navigate to siteminder_home\bin.
  5. Run the following command: 
    smobjimport -isiteminder_home\db\smdif\sm_upgrade_55_to_60sp5.smdif 
-dsm_admin -wadmin_pswd -v -f

    Important! Before running a SiteMinder utility or executable on Windows Server 2008, open the command line window with Administrator permissions. Open the command line window this way, even if your account has Administrator privileges. For more information, see the release notes for your SiteMinder component.

    -v

    Outputs error, warning, and comment messages in verbose format. Verbose format lets you monitor the status of the import.

    -f

    Overwrites duplicate policy store objects with objects from 6.x.

    Important! The upgrade file adds 6.x features to the 5.x policy store. Once you import this file, a 5.x Policy Server can no longer read the policy store.

    This step creates default objects required by SiteMinder. The objects are automatically saved in their appropriate locations in the policy store and key store.

    If you do not complete this step, required SiteMinder objects are not added to your policy and key store. As a result, you cannot use the Policy Server User Interface to configure policies.

Important! After upgrading the 5.x policy store to 6.x, be aware that an OCI namespace user directory is listed as LDAP in the NameSpace field of the SiteMinder User Directory dialog. This is a software limitation. Do not modify the existing settings for this user directory in any way, as it could break the Policy Server connection to this directory. The directory is listed for reference purposes only.