Upgrading the Portal with Additional Licensed Modules
If you have purchased licenses for additional modules, the following procedures provide the steps to create the necessary database tables.
Upgrade Scenarios
• Adding File Analytics, Capacity Manager, Fabric Manager, and Virtualization Manager
• Adding Backup Manager
• Adding new subsystems to existing Capacity Manager
• Adding new subsystems to an existing Backup Manager
Most APTARE StorageConsole licensed modules use the same set of instructions to upgrade the Portal with new APTARE licensed modules, upgrade existing APTARE licensed modules, and add subsystem support.
Database Table Creation Scripts
Table 1 Database Table Creation Script Names
Product and Subsystem | Name |
Backup Manager | base |
Capacity Manager | srm |
Commvault Simpana | cmv |
EMC Avamar | avm |
EMC Networker | leg |
Fabric Manager | swi |
File Analytics | afa |
Generic Backup | gen |
HP Data Protector | hpd |
IBM Tivoli Storage Manager | tsm |
Veritas Backup Exec | bue |
Veritas NetBackup | nbu |
Virtualization Manager | vmm |
Adding Additional Products
Once you upgrade the StorageConsole platform, to add new products use the following procedures to set up the database tables.
These instructions apply to:
• Adding File Analytics, Capacity Manager, Fabric Manager, and Virtualization Manager
• Adding new subsystems to an existing Backup Manager
Please note these are generic instructions and you must replace the variable entries with those that correspond with your subsystem as listed in
Table 1, “Database Table Creation Script Names”. .
Prerequisites
• APTARE StorageConsole Capacity Manager must be installed prior to installing Fabric Manager and File Analytics.
To add database tables
1. Log in as aptare to your APTARE StorageConsole Database server.
You must be logged in as a database user. If you already are logged in as root: su - aptare
2. Prepare the database for the new tables.
cd /opt/aptare/database/setup
3. Run the SQL scripts.
sqlplus portal/portal @setup_<name>.plb
EXAMPLE: sqlplus portal/portal @setup_avm.plb
cd /opt/aptare/database/ora_scripts
sqlplus / as sysdba @create_aptare_ro_user_<name>_views.sql
EXAMPLE: sqlplus / as sysdba @create_aptare_ro_user_avm_views.sql
4. Validate the database.
cd /opt/aptare/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.
If the release introduces new features and reports, you must enable them in the Portal after you upgrade. See
Enabling New Features and Report Templates Using the Portal.