Siteminder upgrade - help on database schema

Products

• CA Single Sign On Secure Proxy Server (SiteMinder)
• AXIOMATICS POLICY SERVER
• CA Single Sign On Agents (SiteMinder)
• CA Single Sign On Federation (SiteMinder)
• CA Single Sign On SOA Security Manager (SiteMinder)
• SITEMINDER

Issue/Introduction

 

We'd like to know how to upgrade the Policy Store data to 12.8SP3 from
Policy Server and Store 12.52 ?

 

Environment

Release : 12.8.03

Component : SITEMINDER -POLICY SERVER

Resolution

 

Here are the high level tasks to lead. Review carefully the 12.8SP3
documentation about upgrade to get more details :

  Upgrading
  https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/layer7-identity-and-access-management/single-sign-on/12-8-03/upgrading.html

1. Insure that the Policy Store on 12.52 is fully healthy :

   Correct Integrity Errors of Policy Store
   https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/layer7-identity-and-access-management/single-sign-on/12-8-03/upgrading/correct-integrity-errors-of-policy-store.html

   Correct all errors that are detected if any;

2. Export the data using XPSExport;

3. Install a supported ODBC Policy Store;

4. Initialize the ODBC Policy Store :

   How to Configure an Oracle Policy Store
   https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/layer7-identity-and-access-management/single-sign-on/12-8-03/installing/install-a-policy-server/configure-odbc-databases-as-policy-session-key-and-audit-stores/configure-an-odbc-database-as-a-policy-store/how-to-configure-an-oracle-policy-store.html

5. Insure that the Policy Server 12.8SP3 can start properly with the
   new Policy Store 12.8SP3 with default objects;

6. Import data from 2. to the Policy Store 12.8SP3 using XPSImport;

Note that you should run XPSExport command with the -xp switch, to
export all Domains and their related objects.

  Where is the smobjexport command gone ?
  https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=14397

  XPSExport for Policy Backup
  https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=44799

  XPSExport -xb and Host-specific configuration data
  https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=37281