NetBackup IT Analytics Installation and Upgrade Guide for Linux

Last Published:
Product(s): NetBackup IT Analytics (11.6)
  1. Installation overview
    1.  
      Introduction
    2.  
      NetBackup IT Analytics components
    3.  
      Standard or Shared Services licensing edition
    4.  
      Install options
    5.  
      Multi-language support and locale considerations (Linux)
    6.  
      Supported third-party and open source products
  2. Install NetBackup IT Analytics on a Linux server
    1.  
      Step-1: Get the NetBackup IT Analytics license key file
    2.  
      Step-2: Portal and database deployment strategies
    3.  
      Step-3: Portal and database prerequisites
    4. Step-4: Install Oracle database application binaries
      1.  
        Create database and users in existing Oracle farm in a Split Architecture deployment
    5.  
      Step-5: Install the Portal application binaries (Linux)
    6.  
      Step-6: Start the Portal services (Linux)
    7.  
      Step-7: Log into the Portal
    8.  
      Step-8: Install a license
    9. Verify the current license configuration
      1.  
        Run the License Summary report
      2.  
        About NetBackup IT Analytics version and license
      3.  
        View License Details
    10. Next steps
      1.  
        Perform a cold backup of the database
      2.  
        Recommended database backup process
  3. Upgrade NetBackup IT Analytics Portal on Linux
    1.  
      Overview
    2.  
      Upgrade path
    3.  
      Before upgrading
    4. Upgrade NetBackup 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
    5. Data Collector upgrades
      1.  
        Mandatory prerequisites
    6.  
      Troubleshoot - Downgrade of Data Collector is not supported
    7.  
      Troubleshoot - Manual Data Collector upgrades
    8.  
      Troubleshoot Data Collector upgrade manager upgrade failure and collector bundle download failure on Linux
    9.  
      Collector updates from the NetBackup IT Analytics Portal
  4. Upgrade and Migrate to a new server
    1. Upgrade and migrate to a new server
      1.  
        Install the latest release of NetBackup 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)
  6. Appendix B. Oracle patches for the database server
    1.  
      Install Oracle 19c Linux July 2025 patch
  7. Appendix C. Upgrade Oracle rpms
    1.  
      Upgrade Oracle rpms in a Split Architecture Deployment

Install Oracle 19c Linux July 2025 patch

Patches included:

  1. 37952354 - Combo Patch which Includes the DBRU and OJVM patches

  2. 37960098 - Database JULY 2025 Release Update 19.28.0.250715

  3. 37847857 - OJVM RELEASE UPDATE 19.28.0.250715

  4. 37860476 - JDK BUNDLE PATCH 19.0.0.0.250121

To ensure the Oracle 19c upgrade on Linux contains all the current security updates, a patch must be installed on your system.

As part of this Oracle patch application, you need to ensure that the version of Oracle's OPatch utility is up to date to be able to use it to install the Database patch. We include five files, and the following steps must be followed:

Pre-install Setup
  1. Log into the virtual machine as root or Server where NetBackup IT Analytics is installed.
  2. Download the following 5 files from the product download area of the website and save to /tmp folder.

    Note:

    If you have already applied any of the prior Oracle patches, then the first two files from the download are not required.

    • xdb6.jar

    • xmlparserv2-sans-jaxp-services.jar

    • p6880880_190000_Linux-x86-64.zip

    • p37952354_190000_Linux-x86-64.zip (OJVM and Database Bundle Patch)

    • p37860476_190000_Linux-x86-64.zip (JDK Bundle Patch)

  3. Go to cd /tmp.
  4. Log in to the server as root.
  5. Stop all services using the following command:

    /opt/aptare/bin/aptare stop

    Note:

    Ensure all NetBackup IT Analytics services are stopped. If services are still running, it may cause technical issues further during patch installation.

  6. Verify all the required rpms are installed before applying Oracle patches.

    Refer to the document for more details.

Install Opatch
  1. As a root user, copy the opatch file from /tmp to /opt/aptare/oracle folder.
    mv p6880880_190000_Linux-x86-64.zip /opt/aptare/oracle.
  2. Set the PATH

    export PATH=$PATH:/opt/aptare/oracle/OPatch.

  3. Rename the Opatch folder and unzip opatch file.
    cd /opt/aptare/oracle
    mv OPatch OPatch_old
    unzip p6880880_190000_Linux-x86-64.zip 
    

    The above command will create a folder with name opatch in /opt/aptare/oracle.

  4. Set Permission on the opatch folder.
    chown -R aptare:dba /opt/aptare/oracle/OPatch
  5. Run the following command to check the opatch version:
    OPatch/opatch version
    OPatch Version: 12.2.0.1.47
    OPatch succeeded.
Install the Patches
  1. As a root user, copy the Oracle database combo patch and JDK bundle patch files from /tmp to /opt/aptare/oracle folder using following commands:
    mv p37952354_190000_Linux-x86-64.zip /opt/aptare/oracle
    mv p37860476_190000_Linux-x86-64.zip /opt/aptare/oracle
  2. Navigate to /opt/aptare/oracle folder and unzip the file.
    cd /opt/aptare/oracle
    unzip p37952354_190000_Linux-x86-64.zip
    

    The above command will create a 37952354 folder in /opt/aptare/oracle folder.

    unzip p37860476_190000_Linux-x86-64.zip

    The above command will create a folder 37860476 in /opt/aptare/oracle folder.

    During the unzip if you see the below message, put 'y' as shown below.

    replace PatchSearch.xml? [y]es, [n]o, [A]ll, [N]one, [r]ename: y
  3. Set permission on patch folders 37952354 and 37860476
    chown -R aptare:dba 37952354
    chown -R aptare:dba 37860476
    

    Note:

    If it is not Cohesity-provided Oracle and if you have already installed an Oracle patch previously, skip the following steps 4 through 10.

  4. As root user copy the two jar files from /tmp to /opt/aptare/oracle/sqldeveloper/sqldeveloper/lib folder.
    mv xdb6.jar /opt/aptare/oracle/sqldeveloper/sqldeveloper/lib
        mv xmlparserv2-sans-jaxp-services.jar /opt/aptare/oracle/sqldeveloper/sqldeveloper/lib
    
  5. Change permissions on the jar files and perl
    cd /opt/aptare/oracle/sqldeveloper/sqldeveloper/lib
        chown  aptare:dba xdb6.jar
        chown  aptare:dba xmlparserv2-sans-jaxp-services.jar
        cd /opt/aptare/oracle
        chown -R aptare:dba perl
        chmod -R 775 perl
    
  6. Check if oraInventory folder is available under /opt/. If the folder is not available, then
    cd /opt/aptare/upgrade
    cp oraInventory.zip /opt/
    unzip oraInventory
    
  7. Check permission on /opt/oraInventory folder if it is aptare:dba else change the permission
    cd /opt/
    chown -R aptare:dba oraInventory
    
  8. Run su - aptare command.
  9. Run the following command to attach the Oracle home
    $ORACLE_HOME/oui/bin/runInstaller -silent -ignoreSysPrereqs -invPtrLoc "/opt/aptare/oracle/oraInst.loc" -attachHome ORACLE_HOME="/opt/aptare/oracle" ORACLE_HOME_NAME="OraDB19c_home" INVENTORY_LOCATION="/opt/oraInventory"

    Note:

    If the Oracle home is already attached, Oracle Home already exists at this location. Select another location message is displayed. Ignore this message.

  10. Follow the steps to make changes for fuser if you see the fuser error 'Missing command :fuser'.
    cd /opt/aptare/oracle/bin/
    touch fuser
    chmod 755 fuser
    
  11. Connect as aptare user, if continuing from step 3 by using the below command else proceed to next step.

    su - aptare

  12. Set PATH. Make sure you set all the paths else patch application might fail.
    export PATH=$PATH:/opt/aptare/oracle/OPatch
    export PATH=$PATH:/usr/ccs/bin
    PATH=$PATH:/opt/aptare/oracle/sqldeveloper/sqldeveloper/lib
    

    Note:

    You can verify the path with the command echo $PATH.

  13. Check for any OPatch conflicts.

    This will check for conflicts for both the database RU patch and OJVM patches.

    cd /opt/aptare/oracle/37952354
    /opt/aptare/oracle/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
    Oracle Interim Patch Installer version 12.2.0.1.47
    Copyright (c) 2025, Oracle Corporation.  All rights reserved.
    PREREQ session
    Oracle Home       : /opt/aptare/oracle
    Central Inventory : /opt/oraInventory
       from           : /opt/aptare/oracle/oraInst.loc
    OPatch version    : 12.2.0.1.47
    OUI version       : 12.2.0.7.0
    Log file location : /opt/aptare/oracle/cfgtoollogs/opatch/opatch2025-07-22_09-13-52AM_1.log
    Invoking prereq "checkconflictagainstohwithdetail"
    Prereq "checkConflictAgainstOHWithDetail" passed.
    OPatch succeeded.
    OPatch succeeded.
    
  14. If no conflicts are detected, run the following command to apply database RU patch from /opt/aptare/oracle/37952354/37960098 folder.
    cd /opt/aptare/oracle/37952354/37960098        
       
    /opt/aptare/oracle/OPatch/opatch apply
    
    Oracle Interim Patch Installer version 12.2.0.1.47
    Copyright (c) 2025, 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.47
    OUI version       : 12.2.0.7.0
    Log file location : /opt/aptare/oracle/cfgtoollogs/opatch/opatch2025-07-22_09-14-50AM_1.log
    Verifying environment and performing prerequisite checks...
    OPatch continues with these patches:   37960098
    Do you want to proceed? [y|n]y
    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
    User Responded with: Y
    Backing up files...
    Applying interim patch '37960098' to OH '/opt/aptare/oracle'
    ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.crypto.rsf, 19.0.0.0.0 ] , [ oracle.pg4appc, 19.0.0.0.0 ] , [ oracle.pg4mq, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.precomp.companion, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.sdo.companion, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.ldap.ztk, 19.0.0.0.0 ] , [ oracle.java.sqlj.sqljruntime, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ] , [ oracle.jdk, 1.8.0.391.11 ]  not present in the Oracle Home or a higher version is found.
    Patching component oracle.rdbms, 19.0.0.0.0...
    Patching component oracle.rdbms.util, 19.0.0.0.0...
    .
    .
    Patching component oracle.precomp.lang, 19.0.0.0.0...
    
    Patching component oracle.precomp.common, 19.0.0.0.0...
    
    Patching component oracle.jdk, 1.8.0.201.0...
    
    Patch 37960098 successfully applied.
    
    Sub-set patch [37642901] has become inactive due to the application of a super-set patch [37960098].
    
    Sub-set patch [37542054] has become inactive due to the application of a super-set patch [37960098].
    
    Please refer to Doc ID 2161861.1 for any possible further required actions.
    Log file location: /opt/aptare/oracle/cfgtoollogs/opatch/opatch2025-07-22_09-14-50AM_1.log
    OPatch succeeded.
    

    Note:

    Ignore any warnings related to rollback of patch. This message is displayed when no prior Oracle security patches were applied.

  15. Run the following commands to apply OJVM patch from /opt/aptare/oracle/37952354/37847857 folder.
    cd /opt/aptare/oracle/37952354/37847857
       
      /opt/aptare/oracle/OPatch/opatch apply
    Oracle Interim Patch Installer version 12.2.0.1.47
    Copyright (c) 2025, 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.47
    OUI version       : 12.2.0.7.0
    Log file location : /opt/aptare/oracle/cfgtoollogs/opatch/opatch2025-07-22_09-21-25AM_1.logVerifying environment and performing prerequisite checks...
    OPatch continues with these patches:   37847857
    Do you want to proceed? [y|n]
    y
    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
    User Responded with: Y
    Backing up files...
    Applying interim patch '37847857' to OH '/opt/aptare/oracle'
    Patching component oracle.javavm.server, 19.0.0.0.0...
    Patching component oracle.javavm.server.core, 19.0.0.0.0...
    Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...
    Patching component oracle.rdbms, 19.0.0.0.0...
    Patching component oracle.javavm.client, 19.0.0.0.0...
    
    Patch 37847857 successfully applied.
    
    Sub-set patch [37499406]] has become inactive due to the application of a super-set patch [37847857].
    
    Please refer to Doc ID 2161861.1 for any possible further required actions.
    
    Log file location: /opt/aptare/oracle/cfgtoollogs/opatch/opatch2025-07-22_09-21-25AM_1.log
    OPatch succeeded.
    

    Note:

    Ignore any warnings related to rollback of patch. This message shows up when no prior Oracle security patches were applied.

  16. Navigate to /opt/aptare/oracle/37860476 and check for any OPatch conflicts for the JDK bundle patch.
    cd /opt/aptare/oracle/37860476
    /opt/aptare/oracle/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
    Oracle Interim Patch Installer version 12.2.0.1.47
    Copyright (c) 2025, Oracle Corporation.  All rights reserved.
    
    PREREQ session
    
    Oracle Home       : /opt/aptare/oracle
    Central Inventory : /opt/oraInventory
       from           : /opt/aptare/oracle/oraInst.loc
    OPatch version    : 12.2.0.1.47
    OUI version       : 12.2.0.7.0
    Log file location : /opt/aptare/oracle/cfgtoollogs/opatch/opatch2025-07-22_09-24-18AM_1.log
    Invoking prereq "checkconflictagainstohwithdetail"
    
    Prereq "checkConflictAgainstOHWithDetail" passed.
    OPatch succeeded.
  17. If no conflicts are detected, execute the following commands to apply JDK patch from /opt/aptare/oracle/37860476 folder.
    cd /opt/aptare/oracle/37860476
       
    /opt/aptare/oracle/OPatch/opatch applyOracle Interim Patch Installer version 12.2.0.1.47
    Copyright (c) 2025, 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.47
    OUI version       : 12.2.0.7.0
    
    Log file location : /opt/aptare/oracle/cfgtoollogs/opatch/opatch2025-07-22_09-25-02AM_1.log
    
    Verifying environment and performing prerequisite checks...
    OPatch continues with these patches:   37860476
    Do you want to proceed? [y|n]
    y
    User Responded with: Y
    All checks passed.
    Backing up files...
    
    Applying interim patch '37860476' to OH '/opt/aptare/oracle'
    
    ApplySession: Optional component(s) [ oracle.jdk, 1.8.0.191.0 ] , [ oracle.jdk, 1.8.0.391.11 ]  not present in the Oracle Home or a higher version is found.
    Patching component oracle.jdk, 1.8.0.201.0...
    
    Patch 37860476 successfully applied.
    
    Log file location: /opt/aptare/oracle/cfgtoollogs/opatch/opatch2025-07-22_09-25-02AM_1.log
    
    OPatch succeeded.
    
    

    Ignore any messages about JDK not present or higher version present, "ApplySession: Optional component(s) [ oracle.jdk, 1.8.0.191.0 ] not present in the Oracle Home or a higher version is found."

  18. Verify OPatch succeeded with the following commands which will display the OPatch application results for the database, OJVM and JDK bundle patches:
    /opt/aptare/oracle/OPatch/opatch lsinventory -detail
        .
        .
        .
    OPatch succeeded.
    
  19. Connect to SQL Plus using following command:
    -bash-4.2$ sqlplus /nolog
    SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jul 22 09:29:19 2025 Version 19.28.0.0.0
    Copyright (c) 1982, 2024, Oracle.  All rights reserved.
    
  20. Connect as sysdba
    SQL> connect / as sysdba
    Connected to an idle instance.
    
  21. Start the database.
    SQL> startup
    ORACLE instance started.
    :
    :
    Database mounted.
    Database opened.
    
  22. Open all pluggable database.
    SQL> alter pluggable database all open;
    Pluggable database altered.
    
  23. Exit from SQL prompt.
    SQL> quit
  24. Datapatch is run to complete the post-install SQL deployment for the patch being installed.

    Run the following command to apply the patch to the pluggable database (This may take few minutes)

    /opt/aptare/oracle/OPatch/datapatch -verbose
    

    Note:

    If run utlrp.sql message is displayed, to re-validate, run it

    SQL Patching tool version 19.27.0.0.0 Production on Fri Apr 18 12:54:51 2025
    Copyright (c) 2012, 2025, Oracle.  All rights reserved.
    
    Log file for this invocation: /opt/aptare/cfgtoollogs/sqlpatch/sqlpatch_401849_2025_04_18_12_54_51/sqlpatch_invocation.log
    
    Connecting to database...OK
    Gathering database info...done
    
    Note:  Datapatch will only apply or rollback SQL fixes for PDBs
           that are in an open state, no patches will be applied to closed PDBs.
           Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
           (Doc ID 1585822.1)
    
    Bootstrapping registry and package to current versions...done
    Determining current state...done
    
    Current state of interim SQL patches:
    Interim patch 37102264 (OJVM RELEASE UPDATE: 19.26.0.0.250121 (37102264)):
      Binary registry: Not installed
      PDB CDB$ROOT: Applied successfully on 07-FEB-25 02.26.53.917213 PM
      PDB PDB$SEED: Applied successfully on 07-FEB-25 02.30.39.875590 PM
      PDB SCDB: Applied successfully on 07-FEB-25 02.30.39.902941 PM
    Interim patch 37847857 (OJVM RELEASE UPDATE: 19.28.0.2507155 (37847857)):
      Binary registry: Installed
      PDB CDB$ROOT: Not installed
      PDB PDB$SEED: Not installed
      PDB SCDB: Not installed
    
    Current state of release update SQL patches:
      Binary registry:
        19.27.0.0.0 Release_Update 250406131139: Installed
      PDB CDB$ROOT:
        Applied 19.26.0.0.0 Release_Update 250118124854 successfully on 07-FEB-25 02.30.16.794747 PM
      PDB PDB$SEED:
        Applied 19.26.0.0.0 Release_Update 250118124854 successfully on 07-FEB-25 02.32.28.155886 PM
      PDB SCDB:
        Applied 19.26.0.0.0 Release_Update 250118124854 successfully on 07-FEB-25 02.32.22.940241 PM
    
    Adding patches to installation queue and performing prereq checks...done
    Installation queue:
      For the following PDBs: CDB$ROOT PDB$SEED SCDB
        The following interim patches will be rolled back:
          37102264 (OJVM RELEASE UPDATE: 19.26.0.0.250121 (37102264))
        Patch 37960098 (Database Release Update : 19.28.0.2507155 (37960098)):
          Apply from 19.26.0.0.0 Release_Update 250118124854 to 19.27.0.0.0 Release_Update 250406131139
        The following interim patches will be applied:
          37847857 (OJVM RELEASE UPDATE: 19.28.0.2507155 (37847857))
    
    Installing patches...
    Patch installation complete.  Total patches installed: 9
    
    Validating logfiles...done
    Patch 37102264 rollback (pdb CDB$ROOT): SUCCESS
      logfile: /opt/aptare/cfgtoollogs/sqlpatch/37102264/25987410/37102264_rollback_SCDBCNTR_CDBROOT_2025Apr18_12_55_43.log (no errors)
    Patch 37960098 apply (pdb CDB$ROOT): SUCCESS
      logfile: /opt/aptare/cfgtoollogs/sqlpatch/37960098/27123174/37960098_apply_SCDBCNTR_CDBROOT_2025Apr18_12_55_43.log (no errors)
    Patch 37847857 apply (pdb CDB$ROOT): SUCCESS
      logfile: /opt/aptare/cfgtoollogs/sqlpatch/37847857/26115603/37847857_apply_SCDBCNTR_CDBROOT_2025Apr18_12_55_43.log (no errors)
    Patch 37102264 rollback (pdb PDB$SEED): SUCCESS
      logfile: /opt/aptare/cfgtoollogs/sqlpatch/37102264/25987410/37102264_rollback_SCDBCNTR_PDBSEED_2025Apr18_12_56_49.log (no errors)
    Patch 37960098 apply (pdb PDB$SEED): SUCCESS
      logfile: /opt/aptare/cfgtoollogs/sqlpatch/37960098/27123174/37960098_apply_SCDBCNTR_PDBSEED_2025Apr18_12_56_49.log (no errors)
    Patch 37847857 apply (pdb PDB$SEED): SUCCESS
      logfile: /opt/aptare/cfgtoollogs/sqlpatch/37847857/26115603/37847857_apply_SCDBCNTR_PDBSEED_2025Apr18_12_56_49.log (no errors)
    Patch 37102264 rollback (pdb SCDB): SUCCESS
      logfile: /opt/aptare/cfgtoollogs/sqlpatch/37102264/25987410/37102264_rollback_SCDBCNTR_SCDB_2025Apr18_12_56_49.log (no errors)
    Patch 37960098 apply (pdb SCDB): SUCCESS
      logfile: /opt/aptare/cfgtoollogs/sqlpatch/37960098/27123174/37960098_apply_SCDBCNTR_SCDB_2025Apr18_12_56_49.log (no errors)
    Patch 37847857 apply (pdb SCDB): SUCCESS
      logfile: /opt/aptare/cfgtoollogs/sqlpatch/37847857/26115603/37847857_apply_SCDBCNTR_SCDB_2025Apr18_12_56_49.log (no errors)
    SQL Patching tool complete on Fri Apr 18 12:59:36 2025
    

    Note:

    If you get the message asking you to run "utlrp.sql" to revalidate, run it.

    -bash-4.2$ sqlplus / as sysdba
    SQL*Plus: Release 19.0.0.0.0 - Production on Fri Apr 18 13:00:23 2025
    Version 19.27.0.0.0
    Copyright (c) 1982, 2024, Oracle.  All rights reserved.
    Connected to:
    Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
    Version 19.27.0.0.0
    
    
    SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
  25. Check the log files in /opt/aptare/cfgtoollogs/sqlpatch/ for errors. The log file name must include the current timestamp.

    Example:

    Log file for this invocation: 
    /opt/aptare/cfgtoollogs/sqlpatch/ sqlpatch_495171_2025_07_22_09_30_32/sqlpatch_invocation.log
    
  26. Start all the services as a root user.
    /opt/aptare/bin/aptare start
Validate the Database and OJVM Patches
  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;Patch Id : 37102264
            Action : APPLY
            Action Time : 07-FEB-2025 14:26:53
            Description : OJVM RELEASE UPDATE: 19.26.0.0.250121 (37102264)
            Logfile :
    /opt/aptare/cfgtoollogs/sqlpatch/37102264/25987410/37102264_apply_SCDBCNTR_CDBRO
    OT_2025Feb07_14_26_53.log
            Status : SUCCESS
    
    Patch Id : 37260974
            Action : APPLY
            Action Time : 07-FEB-2025 14:30:16
            Description : Database Release Update : 19.26.0.0.250121 (37260974)
            Logfile :
    /opt/aptare/cfgtoollogs/sqlpatch/37260974/26040769/37260974_apply_SCDBCNTR_CDBRO
    OT_2025Feb07_14_26_53.log
            Status : SUCCESS
    
    Patch Id : 37102264
            Action : ROLLBACK
            Action Time : 18-APR-2025 12:55:43
            Description : OJVM RELEASE UPDATE: 19.26.0.0.250121 (37102264)
            Logfile :
    /opt/aptare/cfgtoollogs/sqlpatch/37102264/25987410/37102264_rollback_SCDBCNTR_CD
    BROOT_2025Apr18_12_55_43.log
            Status : SUCCESS
    
    Patch Id : 37499406
            Action : APPLY
            Action Time : 18-APR-2025 12:55:43
            Description : OJVM RELEASE UPDATE: 19.27.0.0.250415 (37499406)
            Logfile :
    /opt/aptare/cfgtoollogs/sqlpatch/37499406/26115603/37499406_apply_SCDBCNTR_CDBRO
    OT_2025Apr18_12_55_43.log
            Status : SUCCESS
    
    Patch Id : 37642901
            Action : APPLY
            Action Time : 18-APR-2025 12:56:38
            Description : Database Release Update : 19.27.0.0.250415 (37642901)
            Logfile :
    /opt/aptare/cfgtoollogs/sqlpatch/37642901/27123174/37642901_apply_SCDBCNTR_CDBRO
    OT_2025Apr18_12_55_43.log
            Status : SUCCESS
    
    Patch Id : 37499406
            Action : ROLLBACK
            Action Time : 22-JUL-2025 09:31:29
            Description : OJVM RELEASE UPDATE: 19.27.0.0.250415 (37499406)
            Logfile :
    /opt/aptare/cfgtoollogs/sqlpatch/37499406/26115603/37499406_rollback_SCDBCNTR_CD
    BROOT_2025Jul22_09_31_29.log
            Status : SUCCESS
    
    Patch Id : 37847857
            Action : APPLY
            Action Time : 22-JUL-2025 09:31:29
            Description : OJVM RELEASE UPDATE: 19.28.0.0.250715 (37847857)
            Logfile :
    /opt/aptare/cfgtoollogs/sqlpatch/37847857/27534561/37847857_apply_SCDBCNTR_CDBRO
    OT_2025Jul22_09_31_29.log
            Status : SUCCESS
    
    Patch Id : 37960098
            Action : APPLY
            Action Time : 22-JUL-2025 09:31:52
            Description : Database Release Update : 19.28.0.0.250715 (37960098)
            Logfile :
    /opt/aptare/cfgtoollogs/sqlpatch/37960098/27635722/37960098_apply_SCDBCNTR_CDBRO
    OT_2025Jul22_09_31_29.log
            Status : SUCCESS
    
    PL/SQL procedure successfully completed.
    

    Note:

    If previous patches are applied then those patch IDs will be displayed here.

  5. Exit from SQL prompt:
    SQL>exit
    
Validate the JDK Version Update
  1. Run /opt/aptare/oracle/jdk/bin/java -version
    java version "1.8.0_461"
    Java(TM) SE Runtime Environment (build 1.8.0_461-b11)
    Java HotSpot(TM) 64-Bit Server VM (build 25.461-b11, mixed mode)
    
  2. Run /opt/aptare/oracle/OPatch/jre/bin/java -version
    java version "1.8.0_461"
    Java(TM) SE Runtime Environment (build 1.8.0_461-b11)
    Java HotSpot(TM) 64-Bit Server VM (build 25.461-b11, mixed mode)
    

Public privileges of Oracle users are revoked during the installation of Oracle patches and during the NetBackup IT Analytics Portal upgrade. You must reinstate the public privileges after you perform any of these procedures.