Adding Database Tables
Once you upgrade the Hitachi 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 1, “Database Table Creation Script Names”. Instructions for Hitachi Storage Viewer for Backup follow, see
Adding Database Tables for Hitachi Storage Viewer for Backup.
Prerequisites
• Hitachi Storage Viewer for Capacity must be installed prior to installing Storage Viewer for SAN Fabrics and Storage Viewer for File Analytics.
To add database tables
1. Log in as aptare to your Hitachi Storage Viewer 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.