Search

Top 60 Oracle Blogs

Recent comments

How to upgrade to Oracle 19.8 on Windows

As always, you should follow the instructions in the README.html that comes with the Release Update, but because I know many people like to see what the experience of others is like, here’s my run of the patch application.

As always don’t forget to run your CMD prompt as Administrator, otherwise OPatch will typically have trouble accessing and locking the software inventory

Prerequisites

Get your environment setup as per the patch notes.


C:\WINDOWS\system32>set ORACLE_SID=db19

C:\WINDOWS\system32>set ORACLE_HOME=C:\oracle\product\19

C:\WINDOWS\system32>set PATH=C:\oracle\product\19\bin;%PATH%

C:\WINDOWS\system32>set PATH=%ORACLE_HOME%\perl\bin;%PATH%

C:\WINDOWS\system32>set PERL5LIB=

C:\WINDOWS\system32>net stop msdtc
The Distributed Transaction Coordinator service is stopping.
The Distributed Transaction Coordinator service was stopped successfully.

Check your OPatch version

For this patch, it needs to be 12.2.0.1.17 or higher. Mine was OK but my general recommendation is to always download the latest OPatch any time you need to use it. Of course, I was lazy here and did not Smile


C:\WINDOWS\system32>set PATH=%ORACLE_HOME%\Opatch;%PATH%

C:\WINDOWS\system32>opatch version
OPatch Version: 12.2.0.1.19

OPatch succeeded.

Apply the patch

Shutdown everything that might be using the Oracle executables in the ORACLE_HOME you are about to patch. Note that on Windows this is more than just running a “shutdown” on the database. You need to go into the Windows Services and ensure any of the Oracle services are also shutdown to ensure nothing is running.

Now when you apply the patch, there is a good chance it is going to fail Smile



D:\>cd D:\oracle\stage\win198\31247621

D:\oracle\stage\win198\31247621>opatch apply
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation.  All rights reserved.


Oracle Home       : C:\oracle\product\19
Central Inventory : C:\Program Files\Oracle\Inventory
   from           :
OPatch version    : 12.2.0.1.19
OUI version       : 12.2.0.7.0
Log file location : C:\oracle\product\19\cfgtoollogs\opatch\opatch2020-08-18_14-41-35PM_1.log

Verifying environment and performing prerequisite checks...

Conflicts/Supersets for each patch are:

Patch : 31247621

        Bug Superset of 30901317
        Super set bugs are:
        29947145, 29968085, 29293072, 29516727, 28774416, 29766679, 30147473, 29631749, 29434301, 29443250, 29643721, 30114534, ....

        Conflict with 30805684
        Conflict details:
        C:\oracle\product\19\rdbms\admin\oracle.sym
        C:\oracle\product\19\bin\oracle.exe


Following patches have conflicts: [   30805684   31247621 ]
Use the MOS Patch Conflict Checker "https://support.oracle.com/epmos/faces/PatchConflictCheck" to resolve.
See MOS documents 1941934.1 and 1299688.1 for additional information and resolution methods.


UtilSession failed: Please rebuild the superset patch [31247621] to make sure it supersedes all the relevant patch(es) [30901317,30805684].
The rebuild patch should contain bug fix [29994370, 29947145, 30834110, 29968085, 29293072, 29516727, 28774416, 29766679, 30147473, 29631749, ...

Log file location: C:\oracle\product\19\cfgtoollogs\opatch\opatch2020-08-18_14-41-35PM_1.log

OPatch failed with error code = 73

It failed because of a conflict with patch 30805684, and it is at this point I found the following line that I should have paid attention to in the patch README:

If Opatch reports conflicts with an earlier version of OJVM Bundle Patch, perform a rollback of the OJVM patch before following below steps.

And yes indeed, 30805684 is my 19.7 OJVM patch. So you’ll need to head off the My Oracle Support and download the 19.8 OJVM as well (patch 31219897).

Rollback the old JVM


D:\oracle\stage\win198\31247621>opatch rollback -id 30805684
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation.  All rights reserved.


Oracle Home       : C:\oracle\product\19
Central Inventory : C:\Program Files\Oracle\Inventory
   from           :
OPatch version    : 12.2.0.1.19
OUI version       : 12.2.0.7.0
Log file location : C:\oracle\product\19\cfgtoollogs\opatch\opatch2020-08-18_14-46-25PM_1.log


Patches will be rolled back in the following order:
   30805684
The following patch(es) will be rolled back: 30805684

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = 'C:\oracle\product\19')


Is the local system ready for patching? [y|n]
y
User Responded with: Y

Rolling back patch 30805684...

RollbackSession rolling back interim patch '30805684' from OH 'C:\oracle\product\19'

Patching component oracle.rdbms, 19.0.0.0.0...

Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...

Patching component oracle.javavm.server, 19.0.0.0.0...

Patching component oracle.javavm.client, 19.0.0.0.0...
RollbackSession removing interim patch '30805684' from inventory
Log file location: C:\oracle\product\19\cfgtoollogs\opatch\opatch2020-08-18_14-46-25PM_1.log

OPatch succeeded.

Now we can try again to apply the patch </p />
</p></div>

    	  	<div class=