The following information will help you with the installation of an Oracle Critical Patch Update (CPU) for Symantec Data Loss Prevention (DLP).
Users of Enterprise Oracle must obtain the CPU from Oracle and work with Oracle if any issues are encountered.
Users of Standard Oracle will need to download the CPU from the Broadcom support portal.
Once Oracle releases a new CPU, we will post it to the support portal after testing and validating the CPU.
Oracle 19c
Vulnerability Patching
Confirm the ORACLE_HOME environment variable is pointing to your Database Home, for example: D:\oracle\product\19.3.0.0\db_1\
Windows: echo %ORACLE_HOME%
Linux: echo $ORACLE_HOME
The Oracle CPU includes both the opatch application and the patch itself. These come in two different zip files. You need to unzip these both under the oracle_Home directory. When you go to unzip the opatch application you will update the files under the original %oracle_home%\opatch directory.
Ref opatch application (example OPatch_64bit_12.2.0.1.29). And the patch number zip file such as p6880880_190000_MSWIN-x86-64.zip.
When you go to run the command to install the cpu be sure to change directories into the patch number directory and reference the opatch application,
%oracle_home%\opatch\opatch apply.
Also, the command will fail unless you Shutdown all sqlplus sessions, regardless of whether they are connected to the database or not.
Some system services can also hold Oracle files open and cause this error. Stop the following services during Opatch execution:
Note: In some cases, the Windows system can automatically restart these services after they are manually stopped. It may be necessary to temporarily disable the services while Opatch is executing, and re-enable them after the CPU installation has completed.
Also, When searching for which processes might be tying up the Oracle dlls you can use the tasklist command from the command prompt:
Tasklist /m
This displays all of the dlls being used by processes on the system. However, if the CPU patch is erroring out and specifically mentions a dll, you can search for it with:
Example DLL lookup:
Tasklist /m oci.dll
This will return a list of all processes using the specified dll file.
If you receive a 73 or 74 error, you can try using the -force argument, or uninstall the conflicting package per the following article
Article Id: 159395 - Oracle Critical Patch Update on Windows fails with error 74