Installation and Upgrade Guides › SiteMinder Upgrade Guide › Upgrading from r6.x › How to Migrate from r6.x › Upgrade an r6.x Policy Store › How to Upgrade an r6.x Policy Store › Extend the Oracle Policy Store Schema

Extend the Oracle Policy Store Schema

You extend the policy store schema to store objects introduced by r12.0 SP2. The existing r6.x policy store schema has not changed.

To extend the Oracle policy store schema

1. Log into Oracle with sqlplus or some other Oracle utility as the user who administers the Policy Server database information.

   Note: We recommend that you do not create the SiteMinder schema with the SYS or SYSTEM users. If necessary, create an Oracle user, such as SMOWNER, and create the schema with that user.

2. Import the following r12.0 SP2 script into the 6.x database instance:

   $NETE_PS_ROOT/xps/db/Oracle.sql

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

   Sqlplus example: <@NETE_PS_ROOT>/xps/db/Oracle.sql

   Non-sqlplus example: <$NETE_PS_ROOT>/xps/db/Oracle.sql

   The policy store schema is extended to store objects introduced by r12.0 SP2.