APTARE IT Analytics Installation and Upgrade Guide for Linux

Last Published:
Product(s): APTARE IT Analytics (10.6)
  1. Install the APTARE IT Analytics Portal on a Linux server
    1.  
      Introduction
    2.  
      Portal installation memory requirements
    3.  
      Multi-language support and locale considerations (Linux)
    4.  
      OVA-based deployment on VMware ESXi
    5. 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
    6.  
      Supported third-party and open source products
    7.  
      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
    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
    2. Apply Oracle 19c July 2022 patch application on Linux
      1.  
        Pre-Install setup
      2.  
        OPatch installation steps
      3.  
        Installing the Oracle patch
      4.  
        Validate the Patch
      5.  
        Validating JDK version update
  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. Appendix A. X Virtual Frame Buffer
    1.  
      Configure X Virtual Frame Buffer (Xvfb)

Validate the Patch

  1. As Aptare user connect to SQL Plus using following command: 
    sqlplus / as sysdba
  2. Query to check registry for patch history.
    SQL> select * from sys.registry$history;
  3. Query to check registry for installed patch.
    SQL> select * from sys.registry$sqlpatch;
  4. Report output with patch details.
    SQL> set serveroutput on
SQL> exec dbms_qopatch.get_sqlpatch_status;
  5. Exit SQL prompt.
    SQL> exit
Patch Id : 32545013
Action : APPLY
Action Time : 29-JUN-2021 14:55:04
Description : Database Release Update : 19.11.0.0.210420 (32545013)
Logfile :
/opt/aptare/cfgtoollogs/sqlpatch/32545013/24175065/
32545013_apply_SCDBCNTR_CDBROOT_2021Jun29_14_49_09.log
Status : SUCCESS

Patch Id : 32904851
Action : APPLY
Action Time : 13-OCT-2021 19:58:17
Description : Database Release Update : 19.12.0.0.210720 (32904851)
Logfile :
/opt/aptare/cfgtoollogs/sqlpatch/32904851/24343243/
32904851_apply_SCDBCNTR_CDBROOT_2021Oct13_19_56_19.log
Status : SUCCESS

Patch Id : 33192793
Action : APPLY
Action Time : 01-DEC-2021 18:02:31
Description : Database Release Update : 19.13.0.0.211019 (33192793)
Logfile :
/opt/aptare/cfgtoollogs/sqlpatch/33192793/24462514/
33192793_apply_SCDBCNTR_CDBROOT_2021Dec01_17_59_27.log
Status : SUCCESS

Patch Id : 33515361
Action : APPLY
Action Time : 21-JAN-2022 17:13:39
Description : Database Release Update : 19.14.0.0.220118 (33515361)
Logfile :
/opt/aptare/cfgtoollogs/sqlpatch/33515361/24589353/
33515361_apply_SCDBCNTR_CDBROOT_2022Jan21_17_12_30.log
Status : SUCCESS

Patch Id : 33806152
Action : APPLY
Action Time : 28-APR-2022 17:12:27
Description : Database Release Update : 19.15.0.0.220419 (33806152)
Logfile :
/opt/aptare/cfgtoollogs/sqlpatch/33806152/24713297/
33806152_apply_SCDBCNTR_CDBROOT_2022Apr28_17_10_48.log
Status : SUCCESS

Patch Id : 34133642
Action : APPLY
Action Time : 20-JUL-2022 21:00:06
Description : Database Release Update : 19.16.0.0.220719 (34133642)
Logfile : /opt/aptare/cfgtoollogs/sqlpatch/34133642/24865470/
34133642_apply_SCDBCNTR_CDBROOT_2022Jul20_20_58_00.log
Status : SUCCESS

    Note:

    If Previous patches are applied, then those patch id will be displayed here.