Adding Database Tables for Hitachi Storage Viewer for Backup
Once you upgrade the Hitachi Storage Viewer platform, to add Storage Viewer for Backup, 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 1, “Database Table Creation Script Names”.
Prerequisites
To add database tables for Storage Viewer for Backup
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.