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
• Storage Viewer for Capacity must be installed prior to installing Storage Viewer for SAN Fabrics and File Analytics.
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.