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)

Task 3: Install Oracle database application binaries (Linux)

This section covers the installation of the Oracle Database application binaries. Typically, the Oracle Database application binaries are installed on the same server as the Portal binaries, although in some cases, a separate server may be designated.

See Task 1: Portal and database deployment strategies (Linux).

Note:

The APTARE IT Analytics server cannot have any other Oracle database instances installed.

Note the instructions provided with the confirmation of your purchase agreement and consult Veritas Support, if you require additional assistance.

To Install the Oracle database binaries

  1. Verify that you have the current version of the Oracle 19c Installer binaries.
  2. Login as root on the server where the APTARE IT Analytics Database will be installed. Typically, this is also the Portal server.
  3. Place the ISO image into the /mnt directory.
  4. Mount the ISO image that you downloaded.
    mkdir /mnt/diskd
    mount -o loop <sc_dbinstaller_XXXXX_XXX_linux.iso> /mnt/diskd

    where you substitute the relevant name of the ISO file that you downloaded.

  5. Enter the following commands to start the installer:
    cd /
    /mnt/diskd/install_oracle.sh
    

    The command copies the ORACLE binaries into /opt/aptare/oracle19.

  6. Press Enter to read the entire EULA license agreement and the pre- acceptance process will begin.

    This takes 3-5 minutes to complete, as it installs files into /opt/aptare/oracle19c.

    A complete log of this session is in this file /opt/aptare/logs/install/install_oracle_xxxxxxxxxxxxxxxxxxxxx.log
    **************************************************************************
    *  APTARE IT Analytics ORACLE Installer Version 19.3.0.0.0 (xxxxxxxxxxxxx)
    **************************************************************************
    To use this software you must agree to the following terms and
     conditions. Press ENTER to continue:
    Enter "accept" to accept these Terms and Conditions: accept
    Creating group aptare ...groupadd: group 'aptare' already exists
    Done.
    Creating group dba ...groupadd: group 'dba' already exists
    Done.
    Adding user aptare to group dba ...Done.
    Adding user aptare to group dba ...Done.
    
    
    The Database upgrade process will install the Oracle security 
    patches if they are available in this system. aptare user must 
    have write access to the directory where these patches are 
    downloaded. Enter the absolute directory path where these 
    patches are downloaded:/tmp/ora_patches 
    Creating ORACLE_HOME directory in /opt/aptare/oracle ... Done.
    Creating ORACLE_HOME/logs directory ...
    Setting up IT Analytics database directories 
    /data01 /data02 /data03 /data04 /data05 /data06 ...Done.
    
    
    Installing Oracle binaries in /opt/aptare/oracle ...
    Extracting files ... 
    This process may take 3-5 minutes to complete ... Done.
    .
    .
       creating: 31281355/etc/config/
      inflating: 31281355/etc/config/actions.xml
      inflating: 31281355/etc/config/inventory.xml
      inflating: 31281355/README.html
      inflating: PatchSearch.xml
    Oracle Interim Patch Installer version 12.2.0.1.21
    Copyright (c) 2020, Oracle Corporation.  All rights reserved.
    
    
    Oracle Home       : /opt/aptare/oracle
    Central Inventory : /opt/oraInventory
       from           : /opt/aptare/oracle/oraInst.loc
    OPatch version    : 12.2.0.1.21
    OUI version       : 12.2.0.7.0
    Log file location : /opt/aptare/oracle/cfgtoollogs
                        /opatch/opatchxxxxxxxxxxxxxxx.log
    
    Verifying environment and performing prerequisite checks...
    OPatch continues with these patches:   31281355
    
    Do you want to proceed? [y|n]
    Y (auto-answered by -silent)
    User Responded with: Y
    All checks passed.
    
    
    Please shutdown Oracle instances running out of this 
    ORACLE_HOME on the local system.
    (Oracle Home = '/opt/aptare/oracle')
    
    
    Is the local system ready for patching? [y|n]
    Y (auto-answered by -silent)
    User Responded with: Y
    Backing up files...
    Applying interim patch '31281355' to OH '/opt/aptare/oracle'
    
    
    Done.
    
    A complete log of this session can be found at
     /opt/aptare/logs/install/install_oracle_xxxxxxxxxxxxxxxxx.log