APTARE IT Analytics Installation and Upgrade Guide for Windows

Pre-Install setup

1. Log in to the virtual machine or Server where APTARE 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 APTARE IT Analytics services by executing

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

   Note:

   Verify that all the APTARE 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 the 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 following command from the folder C:\opt\oracle\p34110685_190000_MSWIN-x86-64\p34110685.

   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 succeeds using the following command.

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

10. Start all APTARE 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 serverout on

   SQL> exec dbms_qopatch.get_sqlpatch_status;