Upgrading the Portal with Additional Products

Upgrading a Portal and Data Collectors > Upgrading the Portal with Additional Products

Version 9.2.01

If you have purchased licenses for additional products, the following procedures provide the steps to create the necessary database tables.

Upgrade Scenarios

• Adding Storage Viewer for File Analytics, Storage Viewer for Capacity, Storage Viewer for SAN Fabrics, and Storage Viewer for Virtual Servers

• Adding Storage Viewer for Backup

• Adding new subsystems to existing Storage Viewer for Capacity

• Adding new subsystems to an existing Storage Viewer for Backup

Most Hitachi Storage Viewer products use the same set of instructions to upgrade the Portal with new HDS products, upgrade existing HDS products, and add subsystem support.

Storage Viewer for Backup requires an additional step to add specific subsystems, such as EMC Avamar. Storage Viewer for Capacity automatically adds new subsystem support through the standard upgrade process.

Database Table Creation Scripts

Table 2.1 Database Table Creation Script Names


Product and Subsystem	Name
Storage Viewer for Backup	base
Storage Viewer for Capacity	srm
CommVault Simpana	cmv
EMC Avamar	avm
EMC Networker	leg
Storage Viewer for SAN Fabrics	swi
Storage Viewer for File Analytics	afa
Generic Backup	gen
HP Data Protector	hpd
IBM Tivoli Storage Manager	tsm
Symantec Backup Exec	bue
Symantec NetBackup	nbu
Storage Viewer for Virtual Servers	vmm

Adding Database Tables

Once you upgrade the Storage Viewer platform, to add new products use the following procedures to set up the database tables.

These instructions apply to:

• Adding Storage Viewer for File Analytics, Storage Viewer for Capacity, Storage Viewer for SAN Fabrics, and Storage Viewer for Virtual Servers

• Adding new subsystems to an existing Storage Viewer for Backup

Please note these are generic instructions and you must replace the variable entries with those that correspond with your subsystem as listed in Table 2.1, “Database Table Creation Script Names”.

Prerequisites

• Hitachi Storage Viewer 9.x must be installed.

• Storage Viewer for Capacity must be installed prior to installing Storage Viewer for SAN Fabrics and File Analytics.

• Refer to Table 2.1, “Database Table Creation Script Names” for script naming specifics. The following steps use a variable.

To add database tables

Prepare the database for the new tables.

1. On C:

cd \opt\oracle\database\setup

2. Run the SQL scripts.

sqlplus portal/portal @setup_<name>.plb

EXAMPLE: sqlplus portal/portal @setup_avm.plb

3. On C: as sysdba:

cd \opt\oracle\database\ora_scripts

sqlplus / as sysdba @create_aptare_ro_user_<name>_views.sql

EXAMPLE: sqlplus / as sysdba @create_aptare_ro_user_avm_views.sql

Validate the database.

4. On C:

cd \opt\oracle\database\tools

sqlplus portal/portal @validate_sp.sql

NOTE: Run the validate_sp.sql script when the Portal and Data Collector Services are down. Performance is degraded when the services are running.

You must enable the features in the Portal web interface after you upgrade if the release introduces new features and reports. See Enabling New Features and Report Templates Using the Portal.