APTARE IT Analytics Installation and Upgrade Guide for Linux

Last Published:
Product(s): APTARE IT Analytics (10.5)
  1. Install the APTARE IT Analytics Portal on a Linux server
    1.  
      Introduction
    2.  
      Portal installation memory requirements
    3.  
      OVA-based deployment on VMware ESXi
    4. Installer-based deployment
      1.  
        Task 1: Portal and database deployment strategies (Linux)
      2.  
        Task 2: Pre-installation configuration (Linux)
      3.  
        Task 3: Install Oracle database application binaries (Linux)
      4.  
        Task 4: Install the Portal application binaries (Linux)
      5.  
        Task 5: Installing the database schema (Linux)
      6.  
        Task 6: Start the Portal services (Linux)
      7.  
        Task 7: Request the license key file (Linux)
      8.  
        Task 8: Log into the Portal
      9.  
        Task 9: Install the license key file (Linux)
      10.  
        Task 10: Performing a cold backup of the database (Linux)
      11.  
        Recommended database backup process
    5.  
      Supported third-party and open source products
    6.  
      Uninstall the APTARE IT Analytics Portal
  2. Upgrade APTARE IT Analytics Portal on Linux
    1.  
      Overview
    2.  
      Upgrade path
    3.  
      Before upgrading
    4. Upgrade Oracle database application binaries to 19c (Linux)
      1.  
        Upgrade Oracle database application binaries (Linux)
    5. Upgrade APTARE IT Analytics Portal
      1.  
        Upgrade a shared services environment
      2.  
        Run the upgrade utility installer (Linux)
      3.  
        Known issues
      4.  
        Run the upgrade utility
      5.  
        After the upgrade
      6.  
        Upgrade methods to incorporate enterprise objects
      7. Attribute merging during the Portal upgrade
        1.  
          Attribute Management During the Portal Upgrade
        2.  
          Example of a Merge of Attribute Values
        3.  
          Steps to Rename Duplicate Attributes
        4.  
          Best Practice for Attributes in Multi-Tenancy Environments
      8.  
        Upgrade the Portal with additional licensed modules
      9.  
        Upgrade scenarios
      10.  
        Database table creation scripts
      11. Add additional products
        1.  
          Prerequisites
      12.  
        Enable new features and report templates using the Portal
    6. Data Collector upgrades
      1.  
        Mandatory prerequisites
    7.  
      Troubleshoot - Manual Data Collector upgrades
    8.  
      Collector updates from the APTARE IT Analytics Portal
  3. Oracle patches for the database server
    1.  
      Apply Oracle-recommended patches
  4. Upgrade and Migrate to a new server
    1. Upgrade and migrate to a new server
      1.  
        Install the latest release of APTARE IT Analytics on the new server
      2.  
        Perform an export of the database on the existing server
      3.  
        Stop Portal and agent services on the new server
      4.  
        Drop and re-create the existing portal user on the new server
      5.  
        Import the database onto the new server
      6.  
        Start Portal and agent services on the new server
      7.  
        Download, install, and execute to upgrade the database schema
    2.  
      Testing
    3.  
      Update Data Collector binaries (if necessary)
  5. Portal upgrades (Linux): Tomcat and Apache
    1.  
      Overview
    2.  
      Upgrade to Tomcat 8.5.56 from a previous Tomcat version
    3.  
      Upgrade the Apache Web Server to 2.4.xx (Linux)

Prerequisites

Capacity Manager must be installed prior to installing Fabric Manager and File Analytics.

To add database tables

  1. Log in as aptare to your APTARE IT Analytics 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@//localhost:1521/scdb @setup_<name>.plb

    EXAMPLE:

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

    If the release introduces new features and reports, you must enable them in the Portal after you upgrade.