What’s new with Oracle database 12.1.0.2.200714 versus 12.1.0.2.201020
This blogpost takes a look at the technical differences between Oracle database 12.1.0.2 PSU 200714 (july 2020) and PSU 201020 (october 2020). This gives technical specialists an idea of the differences, and gives them the ability to assess if the PSU impacts anything.
Functions
code symbol names unique in version 12.1.0.2.200714 versus 12.1.0.2.201020 NAME RESOLVE ANNOTATION ARCHIVE_OBJECT ------------------------------------------------------------ -------------------------------------------------- ------------------------------------------------------------------------------------------ ------------------------------------------------------------ defCtx_GetRngCtx defCtx_GetRngCtx ?? libnnzst12.a:ext_ztrsaadapter.o,libnnz12.a:ztrsaadapter.o kgiflpop (kgi)flpop kernel generic instantiation manager ?? libgeneric12.a:kgi.o kkfdGetQueReason (kkfd)GetQueReason kernel compile fast dataflow (PQ DFO) ?? libserver12.a:kkfd.o kkodpCheckPrefetch (kkodp)CheckPrefetch kernel compile optimizer AQP ?? libserver12.a:kkodp.o kkodpHJLegal (kkodp)HJLegal kernel compile optimizer AQP ?? libserver12.a:kkodp.o kkogimpCheckIMCValidity (kko)gimpCheckIMCValidity kernel compile optimizer ?? libserver12.a:kkoop.o knasnblp2 (knas)nblp2 kernel replication apply server ?? libserver12.a:knasn.o krvxuc (krvx)uc kernel redo recovery extract ?? libserver12.a:krvx.o ksfd_estimate_fobpools (ksfd)_estimate_fobpools kernel service functions disk IO ?? libserver12.a:ksfd.o ktcnq_get_typesize (ktc)nq_get_typesize kernel transaction control component ?? libserver12.a:ktcnq.o ktuTempAddExtent_swcbk (ktu)TempAddExtent_swcbk kernel transaction undo ?? libserver12.a:ktu.o ztchmd5m (zt)chmd5m security encryption ?? libnnzst12.a:ext_ztchmd5.o,libnnz12.a:ztchmd5.o ztcriv (zt)criv security encryption ?? libnnzst12.a:ext_ztcr.o,libnnz12.a:ztcr.o ztcrsg (zt)crsg security encryption ?? libnnzst12.a:ext_ztcr.o,libnnz12.a:ztcr.o code symbol names unique in version 12.1.0.2.201020 versus 12.1.0.2.200714 NAME RESOLVE ANNOTATION ARCHIVE_OBJECT ------------------------------------------------------------ -------------------------------------------------- ------------------------------------------------------------------------------------------ ------------------------------------------------------------ kcbo_exam_buf (kcbo)_exam_buf kernel cache buffers object queue ?? libserver12.a:kcbo.o kgnfs_isstaterenewal (kgnfs)_isstaterenewal kernel generic network file system ?? libgeneric12.a:kgnfs.o kjbrnd2dummy (kjbr)nd2dummy kernel lock management global cache service resource table ?? libserver12.a:kjbr.o kkfd_par_all (kkfd)_par_all kernel compile fast dataflow (PQ DFO) ?? libserver12.a:kkfd.o kkqjpdClearFroCtx (kkqjpd)ClearFroCtx kernel compile query join analysis predicate push down ?? libserver12.a:kkqjpd.o kksResetPMONSessionState (kks)ResetPMONSessionState kernel compile shared objects (cursor) ?? libserver12.a:kks1.o knasnblp2l (knas)nblp2l kernel replication apply server ?? libserver12.a:knasn.o knasnblp2lr (knas)nblp2lr kernel replication apply server ?? libserver12.a:knasn.o kokaugi_iobs (koka)ugi_iobs kernel objects kernel side access ?? libserver12.a:koka.o krvxpcls (krvx)pcls kernel redo recovery extract ?? libserver12.a:krvx.o ktuAddTrsp (ktu)AddTrsp kernel transaction undo ?? libserver12.a:ktu.o ktuFindTrsp (ktu)FindTrsp kernel transaction undo ?? libserver12.a:ktu.o ktuGetTseg (ktu)GetTseg kernel transaction undo ?? libserver12.a:ktu.o ktuTempsoClnUp_pdcbk (ktu)TempsoClnUp_pdcbk kernel transaction undo ?? libserver12.a:ktu.o ktuTempsoClnUp_single (ktu)TempsoClnUp_single kernel transaction undo ?? libserver12.a:ktu.o nzosGetCipherDetails (nz)osGetCipherDetails network security ?? libnnz12.a:ext_nzos.o,libnnzst12.a:ext_nzos.o nzosGetCipherDetails2 (nz)osGetCipherDetails2 network security ?? libnnz12.a:ext_nzos.o,libnnzst12.a:ext_nzos.o nzosGetCipherList (nz)osGetCipherList network security ?? libnnz12.a:ext_nzos.o,libnnzst12.a:ext_nzos.o nzosGetDefaultCipherlist (nz)osGetDefaultCipherlist network security ?? libnnz12.a:ext_nzos.o,libnnzst12.a:ext_nzos.o qksceCEContainerMismatch (qksce)CEContainerMismatch query kernel sql cursor evaluation ?? libserver12.a:qksce.o slrac_end_lock (slrac)_end_lock operating system (dependent) library verify (memory) read access ?? libgeneric12.a:slrac.o
This is a poor, yet one of the only ways, to understand what is going on inside the oracle executable.
There aren’t that many things removed or added. Of course this is version 12.1, which is not what I believe to be the 12.2 releases of 12.2.0.1, 18 and 19, so a truly different version/release.
Also quite striking is the absence of all the changed libjava related functions, for which I don’t know if these function additions have anything to do with security. However, please mind I am not implying that this is not secure, I simply can’t tell.
Also, the functions that are removed and added do not seem to have any relationship with the added and removed functions in 12.2 and up. That might indicate that the PSU purely focussed on security updates to existing functions and issues that were logged against this version.
In the data dictionary there weren’t any changes spotted. Of course this overview focusses on availability of parameters and metadata (tables and their columns), for a look into the data dictionary you should look at the work of my colleague Rodrigo Jorge (dissecting the 201020 patches)
Frits Hoogland Weblog 