NetBackup IT Analytics Installation and Upgrade Guide for Windows

Last Published:
Product(s): NetBackup IT Analytics (11.4)
  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 (Windows)
    6.  
      Supported third-party and open source products
  2. Install NetBackup IT Analytics on a Windows server
    1.  
      Step-1: Get the NetBackup IT Analytics license key file
    2.  
      Step-2: Portal and database deployment strategies
    3.  
      Step-3: Pre-installation configuration
    4. Step-4: Installing Oracle application binaries
      1.  
        Troubleshoot the Oracle installation
    5.  
      Step-5: Installing Portal application binaries
    6.  
      Step-6: Log into the Portal
    7.  
      Step-7: Install the license key file
    8. Verify the current license configuration
      1.  
        Run the License Summary report
      2.  
        About NetBackup IT Analytics version and license
      3.  
        View License Details
    9. Next steps
      1.  
        Performing a cold backup of the database
      2.  
        Recommended database backup process
  3. Upgrade NetBackup IT Analytics Portal on Windows
    1.  
      Overview
    2.  
      Upgrade path
    3.  
      Before upgrading
    4. Upgrade NetBackup 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.  
      Data Collector upgrades
    6.  
      Troubleshooting - manual Data Collector upgrades
    7.  
      Troubleshoot Data Collector upgrade manager upgrade failure and collector bundle download failure on Windows
    8.  
      Collector updates from the NetBackup IT Analytics Portal
    9.  
      Upgrade methods to incorporate enterprise objects
  4. Oracle patches for the database server
    1.  
      Install Oracle 19c Windows October 2024 patch
  5. Upgrade and migrate to a new server
    1.  
      Upgrade and migrate to a new Windows server

Install Oracle 19c Windows October 2024 patch

This section includes the following patches:

  • 36878821 - Windows Database Oct2024 Bundle Patch 19.25.0.0.241015.

  • 36878697 - Oracle JavaVM Component Release Update 19.25.0.0.241015.

  • 36866578 - UPDATE 19.0.0.0.0 DATABASE CLIENT JDK IN ORACLE HOME TO JDK8u431.

Note:

Verify that the Oracle OPatch utility version is latest.

We include 4 files and the following are the steps to install and verify the patches which needs to be executed in the order they are specified.

  1. Download the patch files and follow the pre-install setup.

  2. Upgrade OPatch.

  3. Install the patches.

  4. Verify the database and OJVM patch.

  5. Verify the JDK version updates.

Pre-install setup

  1. Make a note of the latest Oracle OJVM patch installed from the System Health Check report in the section Oracle Patch History.

    Note:

    If you have applied any of the OJVM patches before, then you will have to roll back the previous OJVM patch. Example the last applied OJVM patch was OJVM RELEASE UPDATE: 19.22.0.0.240116 (35926646), then it needs to be rolled back and the instruction to rollback is provided later under section Installing the Oracle patches step -7. If no prior OJVM patch found or if it is not 35648110 patch, then no rollback is needed.

  2. Log in to the virtual machine or Server where NetBackup IT Analytics is installed.
  3. Download the following files from the product download area of the website and save to C:\temp folder.

    • p6880880_190000_MSWIN-x86-64.zip

    • p36878821_190000_MSWIN-x86-64.zip (Database Bundle Patch)

    • p36878697_190000_MSWIN-x86-64.zip (OJVM Patch)

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

  4. Access the command prompt as an Administrator.
  5. Verify %ORACLE_HOME%\perl\bin is displayed in your PATH setting.

    Note:

    If not displayed in your PATH setting, enter the following:

    set PATH=%ORACLE_HOME%\perl\bin;%PATH%

  6. Set the Perl library path to empty.

    set perl5lib=

OPatch installation

  1. Change directory to the Oracle home directory.
  2. Execute command cd C:\opt\oracle.
  3. Rename the existing OPatch directory using the following command.

    rename Opatch Opatch_old

  4. Unzip the file p6880880_190000_MSWIN-x86-64.zip in C:\opt\oracle.
  5. Execute the following command to verify the opatch version.

    C:\opt\oracle\OPatch>opatch version.

    OPatch Version: 12.2.0.1.43

    Note:

    OPatch succeeded message is displayed.

Installing the patches

  1. Shut down NetBackup IT Analytics services by executing the following .bat file.

    C:\opt\aptare\utils\stopallservices.bat

    Note:

    Verify that all the NetBackup IT Analytics services are stopped by checking in services. If services are still running, the patch installation will not be successful and will cause issues.

  2. Explicitly stop the Distributed Transaction Coordinator service (which is not an Oracle service) if it is running using the following command.

    net stop msdtc.

  3. Unzip p36878821_190000_MSWIN-x86-64.zip at C:\opt\oracle.
  4. Unzip p36878697_190000_MSWIN-x86-64.zip at C:\opt\oracle.
  5. Unzip p36866578_190000_MSWIN-x86-64.zip at C:\opt\oracle.
  6. Set PATH using the following command.

    set PATH=%ORACLE_HOME%\opatch;%PATH%

  7. If the last OJVM patch, for example, was 19.24.0.0.240716 (36414915), then rollback by executing the

    opatch rollback -id 36414915 command and follow the steps to rollback.

  8. Navigate to the database bundle patch folder using the following command:

    cd C:\opt\oracle\36878821

  9. Check for any OPatch conflicts using the following command for the Database Bundle patch.

    opatch prereq CheckConflictAgainstOHWithDetail -ph ./

  10. If no conflict is detected, execute the following command from the folder C:\opt\oracle\36878821..

    C:\opt\oracle\36878821\opatch apply

  11. Follow the prompts to apply the database bundle patch.

    Note:

    After unzipping the patch on the server, the readme file is located at: C:\opt\oracle\36878821

  12. Navigate to the OJVM patch folder using the following command:

    cd C:\opt\oracle\36878697

  13. Verify any OPatch conflicts for the OJVM patch using the following command:

    opatch prereq CheckConflictAgainstOHWithDetail -ph ./

  14. If no conflict is detected, from the folder C:\opt\oracle\36878697, execute the following command:

    C:\opt\oracle\36878697\opatch apply

  15. Follow the prompts to apply the OJVM patch.

    Note:

    After unzipping the patch on the server, the readme file is located at: C:\opt\oracle\36878697

  16. Navigate to the JDK patch folder using the following command

    cd C:\opt\oracle\36866578.

  17. Verify the OPatch conflicts using the following command for the JDK bundle patch.

    opatch prereq CheckConflictAgainstOHWithDetail -ph ./

  18. If no conflicts are detected, execute the following command from the folder C:\opt\oracle\36866578..

    C:\opt\oracle\36866578\opatch apply

  19. Follow the prompts to apply the JDK Bundle patch.

    Note:

    After unzipping the patch on the server, the readme file is located at: C:\opt\oracle\36866578.

  20. Verify OPatch succeeded using the following commands which will show the OPatch application results of database, OJVM and JDK patches:

    C:\opt\oracle\OPatch\opatch lsinventory -detail

  21. Start NetBackup IT Analytics Oracle service by executing the following:

    C:\opt\aptare\utils\startoracle.bat

  22. Re-start the Distributed Transaction Coordinator service, which is not an Oracle service, using the following command.

    net start msdtc

  23. Note:

    This step requires the database to be running including the pluggable database.

    Connect to SQL Plus using the following command:

    sqlplus / as sysdba

    alter pluggable database all open;

    quit

  24. Execute the following command to complete the post-install SQL deployment for the patch being installed. This data patch command applies the patch to the pluggable database.

    C:\opt\Oracle\Opatch\datapatch -verbose

  25. Check the following log files in C:\opt\oracle\cfgtoollogs\opatch for errors. The log file name includes the current timestamp.

    For example: opatch202411-04_19-07-05PM_1.log.

  26. Start all the NetBackup IT Analytics services, including Oracle, by executing the following.

    C:\opt\aptare\utils\startallservices.bat

Validating the database and OJVM Patches

  1. Connect to SQL Plus using the 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 : 34411846
Action : APPLY
Action Time : 16-NOV-2022 14:08:03
Description : OJVM RELEASE UPDATE: 19.17.0.0.221018 (34411846)
Logfile :
C:\opt\cfgtoollogs\sqlpatch\34411846\24997534/34411846_
apply_SCDBCNTR_CDBROOT_2022Nov16_14_02_11.log
Status : SUCCESS

Patch Id : 34468114
Action : APPLY
Action Time : 16-NOV-2022 14:08:03
Description : Windows Database Bundle Patch : 19.17.0.0.221018 (34468114)
Logfile :
C:\opt\cfgtoollogs\sqlpatch\34468114\24926261/34468114_
apply_SCDBCNTR_CDBROOT_2022Nov16_14_02_11.log
Status : SUCCESS

Patch Id : 34411846
Action : ROLLBACK
Action Time : 28-MAR-2023 18:15:08
Description : OJVM RELEASE UPDATE: 19.17.0.0.221018 (34411846)
Logfile :
C:\opt\cfgtoollogs\sqlpatch\34411846\24997534/34411846_
rollback_SCDBCNTR_CDBROOT_2023Mar28_18_13_58.log
Status : SUCCESS

Patch Id : 34786990
Action : APPLY
Action Time : 28-MAR-2023 18:15:09
Description : OJVM RELEASE UPDATE: 19.18.0.0.230117 (34786990)
Logfile :
C:\opt\cfgtoollogs\sqlpatch\34786990\25141362/34786990_
apply_SCDBCNTR_CDBROOT_2023Mar28_18_13_58.log
Status : SUCCESS

Patch Id : 34750795
Action : APPLY
Action Time : 28-MAR-2023 18:15:09
Description : Windows Database Bundle Patch : 19.18.0.0.230117 (34750795)
Logfile :
C:\opt\cfgtoollogs\sqlpatch\34750795\25040762/34750795_
apply_SCDBCNTR_CDBROOT_2023Mar28_18_13_58.log
Status : SUCCESS

Patch Id : 34786990
Action : ROLLBACK
Action Time : 18-OCT-2023 20:58:50
Description : OJVM RELEASE UPDATE: 19.18.0.0.230117 (34786990)
Logfile :
C:\opt\cfgtoollogs\sqlpatch\34786990\25141362/34786990_
rollback_SCDBCNTR_CDBROOT_2023Oct18_20_57_20.log
Status : SUCCESS

Patch Id : 35354406
Action : APPLY
Action Time : 18-OCT-2023 20:58:52
Description : OJVM RELEASE UPDATE: 19.20.0.0.230718 (35354406)
Logfile :
C:\opt\cfgtoollogs\sqlpatch\35354406\25338973/35354406_
apply_SCDBCNTR_CDBROOT_2023Oct18_20_57_20.log
Status : SUCCESS

Patch Id : 35348034
Action : APPLY
Action Time : 18-OCT-2023 20:58:52
Description : Windows Database Bundle Patch : 19.20.0.0.230718 (35348034)
Logfile :
C:\opt\cfgtoollogs\sqlpatch\35348034\25299325/35348034_
apply_SCDBCNTR_CDBROOT_2023Oct18_20_57_20.log
Status : SUCCESS

Patch Id : 35354406
Action : ROLLBACK
Action Time : 06-DEC-2023 17:55:22
Description : OJVM RELEASE UPDATE: 19.20.0.0.230718 (35354406)
Logfile :
C:\opt\cfgtoollogs\sqlpatch\35354406\25338973/35354406_
rollback_SCDBCNTR_CDBROOT_2023Dec06_17_54_23.log
Status : SUCCESS

Patch Id : 35681552
Action : APPLY
Action Time : 06-DEC-2023 17:55:23
Description : Windows Database Bundle Patch : 19.21.0.0.231017 (35681552)
Logfile :
C:\opt\cfgtoollogs\sqlpatch\35681552\25362844/35681552_
apply_SCDBCNTR_CDBROOT_2023Dec06_17_54_23.log
Status : SUCCESS

Patch Id : 35648110
Action : APPLY
Action Time : 06-DEC-2023 18:52:28
Description : OJVM RELEASE UPDATE: 19.21.0.0.231017 (35648110)
Logfile :
C:\opt\cfgtoollogs\sqlpatch\35648110\25431514/35648110_
apply_SCDBCNTR_CDBROOT_2023Dec06_18_52_25.log
Status : SUCCESS

Patch Id : 35648110
Action : ROLLBACK
Action Time : 17-FEB-2024 00:47:47
Description : OJVM RELEASE UPDATE: 19.21.0.0.231017 (35648110)
Logfile :
C:\opt\cfgtoollogs\sqlpatch\35648110\25431514/35648110_
rollback_SCDBCNTR_CDBROOT_2024Feb17_00_46_45.log
Status : SUCCESS

Patch Id : 35926646
Action : APPLY
Action Time : 17-FEB-2024 00:47:48
Description : OJVM RELEASE UPDATE: 19.22.0.0.240116 (35926646)
Logfile :
C:\opt\cfgtoollogs\sqlpatch\35926646\25549578/35926646_
apply_SCDBCNTR_CDBROOT_2024Feb17_00_46_45.log
Status : SUCCESS

Patch Id : 35962832
Action : APPLY
Action Time : 17-FEB-2024 00:47:48
Description : Windows Database Bundle Patch : 19.22.0.0.240116 (35962832)
Logfile :
C:\opt\cfgtoollogs\sqlpatch\35962832\25463642/35962832_
apply_SCDBCNTR_CDBROOT_2024Feb17_00_46_45.log
Status : SUCCESS

Patch Id : 35926646
Action : ROLLBACK
Action Time : 21-MAY-2024 20:36:23
Description : OJVM RELEASE UPDATE: 19.22.0.0.240116 (35926646)
Logfile :
C:\opt\cfgtoollogs\sqlpatch\35926646\25549578/35926646_
rollback_SCDBCNTR_CDBROOT_2024May21_20_36_23.log
Status : SUCCESS

Patch Id : 36199232
Action : APPLY
Action Time : 21-MAY-2024 20:36:23
Description : OJVM RELEASE UPDATE: 19.23.0.0.240416 (36199232)
Logfile :
C:\opt\cfgtoollogs\sqlpatch\36199232\25655176/36199232_
apply_SCDBCNTR_CDBROOT_2024May21_20_36_23.log
Status : SUCCESS

Patch Id : 36219938
Action : APPLY
Action Time : 21-MAY-2024 20:36:49
Description : Windows Database Bundle Patch : 19.23.0.0.240416 (36219938)
Logfile :
C:\opt\cfgtoollogs\sqlpatch\36219938\25594398/36219938_
apply_SCDBCNTR_CDBROOT_2024May21_20_36_23.log
Status : SUCCESS

Patch Id : 36199232
Action : ROLLBACK
Action Time : 05-AUG-2024 19:23:23
Description : OJVM RELEASE UPDATE: 19.23.0.0.240416 (36199232)
Logfile :
C:\opt\cfgtoollogs\sqlpatch\36199232\25655176/36199232_
rollback_SCDBCNTR_CDBROOT_2024Aug05_19_23_23.log
Status : SUCCESS

Patch Id : 36414915
Action : APPLY
Action Time : 05-AUG-2024 19:23:23
Description : OJVM RELEASE UPDATE: 19.24.0.0.240716 (36414915)
Logfile :
C:\opt\cfgtoollogs\sqlpatch\36414915\25762332/36414915_
apply_SCDBCNTR_CDBROOT_2024Aug05_19_23_23.log
Status : SUCCESS

Patch Id : 36521936
Action : APPLY
Action Time : 05-AUG-2024 19:24:08
Description : Windows Database Bundle Patch : 19.24.0.0.240716 (36521936)
Logfile :
C:\opt\cfgtoollogs\sqlpatch\36521936\25687085/36521936_
apply_SCDBCNTR_CDBROOT_2024Aug05_19_23_23.log
Status : SUCCESS

Patch Id : 36414915
Action : ROLLBACK
Action Time : 04-NOV-2024 19:23:03
Description : OJVM RELEASE UPDATE: 19.24.0.0.240716 (36414915)
Logfile :
C:\opt\cfgtoollogs\sqlpatch\36414915\25762332/36414915_
rollback_SCDBCNTR_CDBROOT_2024Nov04_19_23_03.log
Status : SUCCESS

Patch Id : 36878697
Action : APPLY
Action Time : 04-NOV-2024 19:23:03
Description : OJVM RELEASE UPDATE: 19.25.0.0.241015 (36878697)
Logfile :
C:\opt\cfgtoollogs\sqlpatch\36878697\25899910/36878697_
apply_SCDBCNTR_CDBROOT_2024Nov04_19_23_03.log
Status : SUCCESS

Patch Id : 36878821
Action : APPLY
Action Time : 04-NOV-2024 19:23:20
Description : Windows Database Bundle Patch : 19.25.0.0.241015 (36878821)
Logfile :
C:\opt\cfgtoollogs\sqlpatch\36878821\25823470/36878821_
apply_SCDBCNTR_CDBROOT_2024Nov04_19_23_03.log
Status : SUCCESS


PL/SQL procedure successfully completed.

    Note:

    If any previous patches are applied, those patch id will be displayed here.

  5. Exit from SQL prompt:

    SQL>exit

Validating the JDK version updates

  1. C:\opt\oracle\jdk\bin\java -version

    java version "1.8.0_431"

    Java(TM) SE Runtime Environment (build 1.8.0_431-b10)

    Java HotSpot(TM) 64-Bit Server

    VM (build 25.431-b10, mixed mode)

  2. C:\opt\oracle\Opatch\jre\bin\java -version

    java version "1.8.0_431"

    Java(TM) SE Runtime Environment (build 1.8.0_431-b10)

    Java HotSpot(TM) 64-Bit Server

    VM (build 25.431-b10, mixed mode)