Previous Topic: Native Upgrade ScriptsNext Topic: Native Script Upgrades from 14.0


Native Script Upgrades from r12.5

These instructions upgrade your CA DataMinder database from 12.5 to 14.0.

To upgrade from r12.5 using the native upgrade scripts

  1. Go to the \UpgradeV12_5ToV14 subfolder in your CA DataMinder distribution image.
  2. Copy this subfolder to your database host server.

    This subfolder includes Native_UpgradeToVer3_70.sql and Native_Wrapper.sql.

  3. Edit Native_UpgradeToVer3_70.sql on your database host server to make the changes you require.
  4. Run the following command as the schema owner, using the SQL*Plus utility:
    SQL> set serveroutput on size unlimited
    SQL> start Native_Wrapper.sql;
    

    Important! Always use a version of SQL*Plus that matches your version of Oracle. Errors can occur if you use an older version of SQL*Plus to run scripts against a newer version of Oracle.

  5. (Optional) Install the Data Warehouse. Run the CA DataMinder server installation wizard or, if you want to customize storage for the data warehouse, run the data warehouse native scripts.
  6. Upgrade the CMS by running setup.exe.

    Find setup.exe in the root of your CA DataMinder distribution image. For details about installing a CMS, see the Platform Deployment Guide.

  7. (Optional) Run the following command to create a partitioned Data Warehouse with partition dates that match the CMS.

    Run this command as the schema owner, using the SQL*Plus utility:

    SQL> EXEC Wgn_Partition_Util.wgn_partition_tables( 
      partition_dates => Wgn_Partition_Util.get_partition_dates(Wgn_Partition_Util.wgn_db_type_cms) 
      , db_type => Wgn_Partition_Util.wgn_db_type_DW 
      , Partition_Options => Wgn_Partition_Util.wgn_opt_Convert_to_Partitioned 
      , new_tablespace => 'WGNDATADW' 
      , new_indextablespace => 'WGNDATADWIDX' 
      , pdebug => True ); 
    
  8. You now need to upgrade from 14.0. See the next section.