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)