Oracle 12.1.0.2.x – JSON Database Patch Bundle(s)

It has been a while I patched a local development database, but nowadays stuff gets implemented or fixed in the latest patch bundle (so on 12.n.n.n.x).

So when I today downloaded the current Windows patch bundle (12.1.0.2.7) and applied the patch via OPatch, I had to figure out why I got the following message via the datapatch tool…

C:\app\product\12.1.0\dbhome_1\OPatch> datapatch -verbose
 
SQL Patching tool version 12.1.0.2.0 ON Tue Aug 18 10:59:18 2015
Copyright (c) 2015, Oracle.  ALL rights reserved.
 
Log file FOR this invocation: C:\app\cfgtoollogs\sqlpatch\sqlpatch_11144_2015_08_18_10_59_18\sqlpatch_invocation.log
 
Connecting TO DATABASE...OK
Bootstrapping registry AND package TO CURRENT versions...done
Determining CURRENT state...done
 
CURRENT state OF SQL patches:
Patch 20080249 ():
  NOT installed IN BINARY OR the SQL registry
Bundle series PSU:
  ID 7 IN the BINARY registry AND NOT installed IN the SQL registry
 
Adding patches TO installation queue AND performing prereq checks...
Installation queue:
  The following patches will be rolled back:
    20080249 ()
  The following patches will be applied:
    21126814 (WINDOWS DB BUNDLE PATCH 12.1.0.2.7(64bit):21126814)
 
Error: prereq checks failed!
  patch 20080249: ROLLBACK script C:\app\product\12.1.0\dbhome_1\sqlpatch\20080249\18321548\20080249_rollback.sql does NOT exist
Prereq CHECK failed, exiting WITHOUT installing any patches.
 
Please refer TO MOS Note 1609718.1 AND/OR the invocation log
C:\app\cfgtoollogs\sqlpatch\sqlpatch_11144_2015_08_18_10_59_18\sqlpatch_invocation.log
FOR information ON how TO resolve the above errors.
 
SQL Patching tool complete ON Tue Aug 18 10:59:53 2015

Hmmm…

Error: prereq checks failed!
  patch 20080249: 
  ROLLBACK script ..\20080249_rollback.sql does NOT exist

Time to to lookup the reverenced patch 20080249. The interesting bit that came along while searching, looking up the patch number on the My Oracle Support site (http://support.oracle.com) was:

In the “details” section it mentions:

This article is intended to provide the latest information about the Oracle JSON Merge Patch Bundles. This note will be constantly updated to reflect the latest patch bundle as they become available.

Current status regarding available JSON batch bundles:

Database Version JSON Patch Bundle # JSON Merge Patch
12.1.0.2.0 JSON Patch Bundle 1 <Bug:20080249>
12.1.0.2.8 JSON Patch Bundle 2 <Bug:20885778>

So if your interested in the progress and fixes for this latest feature in the Oracle 12.1.0.2 database, native JSON database support, the mentioned MOS note here is one to keep track of and apply when needed…

HTH/M.

Marco Gralike Written by: