Preparing and Upgrading on a Linux Server > Upgrading the Portal with Additional Products
   
Version 9.1
Upgrading the Portal with Additional Products
If you have purchased licenses for additional products, 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 products use the same set of instructions to upgrade the Portal with new APTARE products, upgrade existing APTARE products, and add subsystem support.
Backup Manager requires an additional step when adding it to the Portal. Capacity Manager 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
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
Symantec Backup Exec
bue
Symantec NetBackup
nbu
Virtualization Manager
vmm
Adding Database Tables
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 2.1, “Database Table Creation Script Names”. Instructions for APTARE StorageConsole Backup Manager follow, see Adding Database Tables for APTARE StorageConsole Backup Manager.
Prerequisites
• StorageConsole 9.x must be installed.
• APTARE StorageConsole Capacity Manager must be installed prior to installing Fabric Manager 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
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.
Adding Database Tables for APTARE StorageConsole Backup Manager
Once you upgrade the StorageConsole platform, to add Backup Manager, use the following Windows or Linux procedures to set up the database tables.
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
• APTARE StorageConsole 9.x must be installed.
• Refer to Table 2.1, “Database Table Creation Script Names” for script naming specifics.
To add database tables for Backup Manager
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.