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

Native Script Upgrades from 14.5

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

To upgrade from 14.5 using the native upgrade scripts

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

   This subfolder includes Native_UpgradeToVer3_100.sql and Native_Wrapper.sql.

3. Edit Native_UpgradeToVer3_100.sql on your database host server. In particular, you may want to specify the tablespace and storage parameters for this partitioned table, WGN3RELATEDEVENT.

   For installations with customizations, the tablespace is defined by the WGN_PARTITION_CUST.wgn_get_tablespace_name function. Typically this returns "WGN3RELATEDEVENT_DATA", but may return other tablespace values.

   Ensure that the required tablespace is created and resource is assigned to the schema owner. Failure to create this tablespace returns this error:

   ORA-00959: tablespace 'WGN3RELATEDEVENT_DATA' does not exist
   

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. You now need to upgrade from 14.6. See the next section.