APTARE IT Analytics Installation and Upgrade Guide for Windows

Last Published:
Product(s): APTARE IT Analytics (10.5)
  1. Install APTARE IT Analytics Portal on a Windows server
    1.  
      Introduction
    2.  
      Portal installation memory requirements
    3.  
      Task 1: Portal and database deployment strategies (Windows)
    4.  
      Task 2: Pre-installation configuration (Windows)
    5. Task 3: Installing Oracle application binaries (Windows)
      1.  
        Troubleshoot the Oracle installation
    6.  
      Task 4: Installing Portal application binaries (Windows)
    7.  
      Task 5: Request the license key file (Windows)
    8.  
      Task 6: Log into the Portal (Windows)
    9.  
      Task 7: Install the license key file (Windows)
    10.  
      Task 8: Performing a cold backup (Windows)
    11.  
      Supported third-party and open source products
    12.  
      Uninstall Portal server software
  2. Upgrade APTARE IT Analytics Portal on Windows
    1.  
      Overview
    2.  
      Upgrade path
    3.  
      Before upgrading
    4. Upgrade the Oracle database application binaries to19c (Windows)
      1.  
        Upgrading the Oracle database application binaries (Windows)
    5. Upgrade APTARE IT Analytics Portal
      1.  
        Upgrading a shared services environment
      2.  
        Run the upgrade utility installer (Windows)
      3.  
        Running the upgrade utility
      4. Attribute merging during the Portal upgrade
        1.  
          Attribute management during the Portal upgrade
      5.  
        Upgrading the Portal with additional licensed modules
      6.  
        Database table creation scripts
      7.  
        Add additional products
      8.  
        Enable new features and report templates using the Portal
    6.  
      Data Collector upgrades
    7.  
      Troubleshooting - manual Data Collector upgrades
    8.  
      Collector updates from the APTARE IT Analytics Portal
    9.  
      Clustered NetBackup Upgrade Procedure
    10.  
      Upgrade methods to incorporate enterprise objects
  3. Oracle patches for the database server
    1.  
      Install Oracle 19c Windows July 2021 patch
  4. Upgrade and migrate to a new server
    1.  
      Upgrade and migrate to a new server
  5. Portal upgrades (Win): Tomcat and Apache
    1.  
      Overview
    2.  
      Upgrade from Tomcat 7 to Tomcat 8 (Win)
    3.  
      Upgrade the Apache Web Server to 2.4.xx to 2.4.yy (Windows)

Add additional products

Once you upgrade the APTARE IT Analytics platform, to add new licensed modules 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.

Prerequisites

  • Capacity Manager must be installed prior to installing Fabric Manager 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@//localhost:1521/scdb @setup_<name>.plb

    Example: sqlplus portal/portal@//localhost:1521/scdb @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@//localhost:1521/scdb @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.