Search <book_title>...

APTARE IT Analytics Release Notes

Last Published: 2022-01-07

Product(s): APTARE IT Analytics (10.5)

Oracle 19c patch application for Windows

To ensure the Oracle 19c upgrade on Windows contains all the current security updates, a patch must be installed once your system has been upgraded to APTARE IT Analytics version 10.5.

Pre-install Setup

Log into the virtual machine or Server where APTARE IT Analytics is installed.
Download the Oracle patch from the product download area of the website, and unzip the patch into the C:\opt\oracle directory, creating a new patch directory - for example C:\opt\oracle\ p31247621_190000_MSWIN-x86-64.
Open the command prompt as an Administrator.
Verify %ORACLE_HOME%\perl\bin displays in your PATH setting. If this does not display in your PATH setting, enter the following:
```
 Set PATH=%ORACLE_HOME%\perl\bin;%PATH%
Set PERL5LIB=
```

Installing the Oracle patch (OPatch)

Shut down Aptare services.
```
C:\opt\aptare\utils\stopallservices.bat
```
Explicitly stop the Distributed Transaction Coordinator service (which is not an Oracle service) if it is running.
```
net stop msdtc
```

Navigate to the patch folder:

cd C:\opt\oracle\p31247621_190000_MSWIN-x86-64
\31247621

Set the PATH:
```
set PATH=%ORACLE_HOME%\opatch;%PATH%
```
Check for any OPatch conflicts.
```
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
```
If a conflict is detected, contact Support with the following log files from the folder C:\opt\oracle\cfgtoollogs\opatch:
```
opatch*.log
```
If no conflict is detected, run the following command from the folder C:\opt\oracle\Opatch:
```
 opatch apply
```
Follow the prompts to apply the patch.
After unzipping the patch on the server, the readme file is located at: C:\opt\oracle\p31247621_190000_MSWIN-x86-64\31247621
Verify OPatch succeeded with the following command:
```
C:\opt\oracle\OPatch\opatch lsinventory -detail
```
Start all Aptare Services including Oracle. Next steps require the database to be running including the pluggable database.
```
C:\opt\aptare\utils\startallservices.bat
```
Run following command to apply the patch to the pluggable database:
```
C:\opt\Oracle\Opatch\datapatch -verbose
```

Note:

Use the Windows Services, right-click Distributed Transaction Coordinator, and click Start if the netstart msdtc service does not start automatically.

Validating the patch

Connect to SQL Plus using following command:
```
C:\opt\oracle\OPatch>sqlplus / as sysdba
```

Run following queries to show the patch installed:

SQL>select * from sys.registry$history;

SQL>select * from sys.registry$sqlpatch ;

SQL> set serverout on
SQL> exec dbms_qopatch.get_sqlpatch_status;