3 Upgrading Database

This chapter provides instructions on how to upgrade database.

3.1 Upgrading Database

To upgrade the database, perform the following:

1. Save and unzip the file on a local folder.

2. Enure you have access to sqlplus and to the database to be upgraded (tnsnames.ora is updated with database information).

3. Run the following upgrade install scripts:

   1. To upgrade from v1.0 to v2.0, run Install_HSM_upg_v1.0_to_v2.0_CDA.sql. For installations without CDA, run Install_HSM_upg_v1.0_to_v2.0.sql.

      For example, SQL> @Install_HSM_upg_v1.0_to_v2.0_CDA.sql.

   2. To upgrade from v1.2 to v2.0, run Install_HSM_upg_v1.2_to_v2.0_CDA.sql. For installations without CDA, run Install_HSM_upg_v1.2_to_v2.0.sql.

      For example, SQL> @Install_HSM_upg_v1.2_to_v2.0_CDA.sql.

   3. To upgrade from v1.3 to v2.0, run Install_HSM_upg_v1.3_to_v2.0_CDA.sql. For installations without CDA, run Install_HSM_upg_v1.3_to_v2.0.sql.

      For example, SQL> @Install_HSM_upg_v1.3_to_v2.0_CDA.sql.

      After running the preceding script, the admin user has to perform the steps mentioned in Appendix C to add the SDV section.

4. Upgrade the database as follows:

   1. Change to the server/database_upg folder.

   2. Start SQLPlus and connect to the database using SYS user or SYSTEM user.

   3. Run the upgrade install script.

      For example, Install_HSM_upg_v1.0_to_v2.0_CDA.sql.

   4. When prompted, enter user ID and password for each schema that has to be upgraded.

      Following is a sample screen showing various prompts and messages during the execution of the script:

      Figure 3-1 Database Upgrade

      
      Description of "Figure 3-1 Database Upgrade"
      
      

      Note:

      Monitor the screen for error reports, if any.