Upgrade Guide › Upgrading Databases › Upgrading a Partitioned Oracle Database › Native Script Upgrades from 14.6

Native Script Upgrades from 14.6

These instructions upgrade your CA Data Protection database from 14.6 to 15.0.

Follow these steps::

1. Go to the \UpgradeV14_6ToV15_0 subfolder in your CA Data Protection distribution image.
2. Copy this subfolder to your database host server.

   This subfolder includes Native_UpgradeToVer3_110.sql and Native_Wrapper.sql.

3. 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.

4. Upgrade the CMS by running setup.exe.
5. Find setup.exe in the root of your CA Data Protection distribution image. For details about installing a CMS, see the Platform Deployment Guide.
6. (Only required when upgrading from 14.5 or earlier) Run this command as the schema owner, using the SQL*Plus utility:

   SQL> EXEC Wgn_Partition_Util.wgn_partition_new_table( 
   new_table_name => 'WGN3RELATEDEVENT', 
   template_name => 'WGN3EVENT', 
   pdebug => True, 
   db_type => Wgn_Partition_Util.wgn_db_type_CMS, 
   Tablespace_Name => Wgn_Partition_Util.wgn_get_tablespace_name('WGN3RELATEDEVENT') 
   ); 
   

   This command partitions the new WGN3RELATEDEVENT table with partition dates that match the Wgn3Event.