NetBackup IT Analytics Installation and Upgrade Guide for Windows

Pre-Install setup

1. Log in to the virtual machine or server where NetBackup IT Analytics is installed.
2. Download the p6880880_190000_MSWIN-x86-64.zip and p34110685_190000_MSWIN-x86-64.zip from the product download area of the website and save to C:\temp folder.
3. Access the command prompt as an Administrator.
4. 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%

5. 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.

   Note:

   The above command creates a folder with name Opatch in C:\opt\oracle folder.

5. Execute the following command to verify the opatch version.

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

   OPatch Version 12.2.0.1.32

   Note:

   OPatch succeeded message is displayed.

Patching the database

1. Shut down NetBackup IT Analytics services by executing:

   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 p34110685_190000_MSWIN-x86-64.zip at C:\opt\oracle.
4. Navigate to patch folder using the following command.

   cd C:\opt\oracle\p34110685_190000_MSWIN-x86-64\34110685

5. Set PATH using the following command.

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

6. Check for any OPatch conflicts using following command.

   opatch prereq CheckConflictAgainstOHWithDetail -ph

7. If no conflict is detected, execute the command from the folder C:\opt\oracle\p34110685_190000_MSWIN-x86-64\p34110685 using the following command.

   C:\opt\oracle\p34110685_190000_MSWIN-x86-64\34110685\opatch apply

8. Follow the prompts to apply the patch.

   Note:

   After unzipping the patch on the server, the readme file is located at: C:\opt\oracle\p34110685_190000_MSWIN-x86-64\34110685

9. Verify if the OPatch has succeeded using the following command.

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

10. Start all NetBackup IT Analytics Services including Oracle by executing the following.

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

    Note:

    Next steps requires the database to be running including the pluggable database.

11. Connect to SQL Plus using the following commands.

    sqlplus / as sysdba

    alter pluggable database all open;

    quit

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

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

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

    For example: opatch2022-08-17_17-26-26PM_1.txt

Validating the patch

1. Connect to SQL Plus using the following command.

   sqlplus / as sysdba

2. Execute the following queries to view all the installed patches.

   SQL>select * from sys.registry$history;

   SQL>select * from sys.registry$sqlpatch ;

   SQL> set serveroutput on

   SQL> exec dbms_qopatch.get_sqlpatch_status;