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 SiteMinderAudit Log Database

Upgrade a SiteMinderAudit Log Database

Consider the following:

• SiteMinder r6.0 SP6 does not support the versions of SQL Server that SiteMinder 5.x supported. You cannot upgrade a 5.x SiteMinder audit store. Configure a new audit store.

  Note: For more information about configuring an audit store, see the Policy Server Installation Guide.

• The version of Oracle that is functioning as the 5.x SiteMinder audit store determines if you can upgrade it. If SiteMinder r6.0 SP6 supports the version, use the following procedure to upgrade the audit store. Otherwise, configure a new audit store.

  Note: For a list of supported Oracle databases, go to the Technical Support site and search for the SiteMinder Platform Matrix for 6.0.

To upgrade an Oracle audit store

1. Be sure that the 5.x Oracle audit log database instance is accessible from the Policy Server host system. Test the communication using tnsping or sqlplus.
2. Log in to Oracle with sqlplus or another Oracle utility as the user who administers the audit log database.
3. Import the following script:

   $NETE_PS_ROOT/db/sql/sm_oracle_logs_upgrade_55_to_60.sql

   Consider the following:

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

     Example: @$NETE_PS_ROOT/db/sql/sm_oracle_logs_upgrade_55_to_60.sql

   • Environment variables may not function in the SQL utility for Oracle. If you have problems when using the utility, specify an explicit path for $NETE_PS_ROOT, instead of specifying the environment variable.