12.1.0.2 Patch Set – Availability and Known Issues

Known Issues specific to the 12.1.0.2 Patch Set

  • See Note:1565065.1 for Support Status and Alerts affecting 12.1.0 releases.

This note lists known install / alert issues specific to the 12.1.0.2 Patch Set.
It should be read in conjunction with the platform specific release notes.This note includes details of:

  • Known install issues specific to 12.1.0.2, both generic and port specific
  • Bugs introduced in 12.1.0.2 (for features present in earlier releases)
  • Alerted issues which affect 12.1.0.2
  • Availability details for 12.1.0.2 by platform

This note does NOT list ALL issues which affect this release.
To get an indication of other issues known to affect this version you can search My Oracle Support for “Patches” which exist for your platform / release.

12.1.0.2 General Notes

  • 12.1.0.2 is only released as Enterprise Edition at this time
    See Note:1905806.1 “Oracle Database 12c Release 1 Patchset 1 (12.1.0.2) is being released only as Enterprise Edition at this time” for more details.
  • 12.1.0.2 New Features
    In addition to bug fixes and stability enhancements this Patch Set Release includes a number of new features – see Oracle Database 12c Release 1 (12.1.0.2) New Features .
  • Database Security Patching from 12.1.0.1 onwards
    Starting with Oracle Database version 12.1.0.1 , Oracle will only provide Patch Set Update (PSU) patches to meet the CPU program requirements for security patching. See Note:1581950.1 for full details.

Latest Critical Patch Update

For information about Critical Patch Updates see the Oracle Technology Network page “Critical Patch Updates and Security Alerts“. Note that for Database, Critical Patch Updates are a subset of each Patch Set Update. The latest Patch Set Update for this release is listed in the next section. For further information about Patch Set Updates see Note:854428.1.

Document Summary
Note:467881.1 Critical Patch Update Advisory (Jul 2015)
Note:2005667.1 Critical Patch Update Availability for Database Products (Jul 2015)

 

Current Recommended Patches

For information about Recommended Patches for the RDBMS see Note:756671.1 .

Patch Set Updates

Document Description Rolling RAC Patch Download
Note:21150768.8 Combo of 12.1.0.2.4 OJVM PSU and 12.1.0.2.4 DB PSU (Jul 2015) Part Patch:21150768
Note:21068507.8 Oracle JavaVM Component 12.1.0.2.4 Database PSU (Jul 2015) (OJVM PSU) No Patch:21068507
Note:20831110.8 12.1.0.2.4 (Jul 2015) Database Patch Set Update (DB PSU) Yes Patch:20831110

Grid Infrastructure

Document Description Rolling RAC Patch Download
Note:21150782.8 Combo of 12.1.0.2.4 OJVM PSU and 12.1.0.2.4 GI PSU (Jul 2015) Part Patch:21150782
Note:20996835.8 12.1.0.2.4 (Jul 2015) Grid Infrastructure Patch Set Update (GI PSU) Yes Patch:20996835

Oracle Engineered Systems

Document Description Rolling RAC Patch Download
Note:888828.1 Recommended Patch Information for Exadata Database Machine and Exadata Storage Server
Note:21188742.8 12.1.0.2 Bundle Patch 10 for Engineered Systems and DB In-Memory (Jul 2015) Yes Patch:21188742
Note:21150792.8 Combo of 12.1.0.2.4 OJVM PSU and 12.1.0.2.10 DBBP (Jul 2015) Part Patch:21150792

Database In-Memory (DBIM)

Document Description Rolling RAC Patch Download
Note:21188742.8 12.1.0.2 Bundle Patch 10 for Engineered Systems and DB In-Memory (Jul 2015) Yes Patch:21188742
Note:21150792.8 Combo of 12.1.0.2.4 OJVM PSU and 12.1.0.2.10 DBBP (Jul 2015) Part Patch:21150792

12.1.0.2 Alerts / Issues

This section lists alerts and important issues relevant to 12.1.0.2 .

General Alerts / Issues

Bug/Doc Description Updated
20881450+ Wrong results or Assorted dumps and errors querying HCC tables with OLTP blocks 20/Jul/2015
20144308+ ORA-27086 or ORA-1182 RMAN May Overwrite a SOURCE Database File during TTS, TSPITR, etc when OMF is used in SOURCE. ORA-1578 ORA-1122 in SOURCE afterwards 14/Jul/2015
20369110 ORA-600[9999] / Cannot enable more than 8 kernel options (such as uniaud , olap, lbac etc..) 14/Jul/2015
Note 1944645.1* ORA-600 [kdblkcheckerror]..[6266] corruption with self-referenced chained row. ORA-600 [kdsgrp1] / Wrong Results / ORA-8102 14/Jul/2015

Upgrade Issues

Bug/Doc Description Updated
19787643P Windows: SQLLDR.EXE – SQL Loader fails to start – oranfsodm12.dll is missing 19/Nov/2014
19141838 ORA-600 [qksanGetTextStr:1] from SQL Plan Management after Upgrade to 12.1 02/Jun/2015
20123899 Insert in to stat table fails with ORA-932 “inconsistent datatypes” after upgrade from 11g to 12c (part 2) 06/May/2015
15894842 Insert in to stat table fails with ORA-932 “inconsistent datatypes” after upgrade from 11g to 12c (part 1) 06/May/2015
19664340+ ORA-20000 “unable to gather statistics concurrently” during upgrade to 12.1 14/Jul/2015
19536415 DB upgrade to 12.1 fails with ORA-600 [kkaegso: PUBLIC] 14/Apr/2015
19291380 ORA-38802/ORA-38803/ORA-38804 from CREATE EDITION or SET EDITION during upgrade 14/Apr/2015

 

Notable fixes included in 12.1.0.2

This section lists fixes / enhancements in 12.1.0.2 which may cause a notable change in behaviour.

Note:1927261.1C OPS$ users identified with a password (OS_AUTHENT_PREFIX) can connect using OS authentication – correctly raise ORA-1017 in 12.1.0.2 onwards
14675058C A package procedure with zero arguments should not have a row in ALL_ARGUMENTS

 

Issues introduced in 12.1.0.2

This section lists bugs introduced in 12.1.0.2 (if any). Such issues may be either serious or trivial but the aim is to list them all to help customers assess the risk of applying the Patch Set on top of 12.1.0.1

Bug/Doc Description Updated
20881450+ Wrong results or Assorted dumps and errors querying HCC tables with OLTP blocks 20/Jul/2015
21030693 ORA-600 [qerpxMObjVI6] from parallel query on partitioned table 14/Jul/2015
20879889 Open cursor leak from DML on table with a materialized view log 16/Apr/2015
20634449 Wrong results from OUTER JOIN with a bind variable and a GROUP BY clause in 12.1.0.2 14/May/2015
20466322 ASSM Free block space not reused when expected 14/Jul/2015
20406840 Pro*C 12.1.0.2 throws ORA-600 [17998] when precompiling by ‘other’ user (not Oracle install user) 23/Jul/2015
19787643PI Windows: SQLLDR.EXE – SQL Loader fails to start – oranfsodm12.dll is missing 19/Nov/2014
19567916 Wrong results when GROUP BY uses nested queries in 12.1.0.2 24/Sep/2014
20794034 ORA-600 [rworupo.1] from SQL with window function and large columns 24/Jun/2015
18881811 Data pump import of wrapped PLSQL corrupts the body 12/Apr/2015
19703301 ORA-22275 “invalid lob locator specified” if fix for bug 14044260 present 13/Jul/2015
19687159 Excess memory use / ORA-4030 for SQL with many WINDOW operations and large sort keys – superseded 14/Apr/2015
19627012 ORA-7445 [kd9ir2tComputeTreeSErcs] inserting / loading to a compressed table 14/Apr/2015
19018447 ORA-7445 [ksxpmsgcncl] / ORA-600 [15810] from Parallel Query 14/Apr/2015
19134173 ORA-600 [kghfrf:nxt] writing diagnostics for ORA-4021 14/Apr/2015

12.1.0.2 Availability

The following 12.1.0.2 releases are currently available.
Platform specific install / upgrade issues are listed under each heading but also see above for GENERIC issues.For unlisted platforms check Note:742060.1 for the Release Schedule.

In the table clicking on the hyperlinks beginning with “Patch” should take you directly to the relevant patch download page, clicking on the “ReadMe” link should take you directly to the latest version of the ReadMe for the Patch Set, and clicking on “Certification” shows certification information for the platform.

HPUX Itanium 32-bit Client Certification
12.1.0.2 Patch 17694377 released 14-NOV-2014 ReadMe
HPUX Itanium 64-bit Certification
12.1.0.2 Patch 17694377 released 14-NOV-2014 ReadMe
IBM AIX Based Systems 32-bit Client Certification
12.1.0.2 Patch 17694377 released 14-NOV-2014 ReadMe
IBM AIX Based Systems (64-bit) Certification
12.1.0.2 Patch 17694377 released 14-NOV-2014 ReadMe
IBM Linux on System z (32-bit client)
12.1.0.2 Patch 17694377 released 14-NOV-2014 ReadMe
IBM Linux on System z (64-bit) Certification
12.1.0.2 Patch 17694377 released 14-NOV-2014 ReadMe
Linux 32-bit Client Certification
12.1.0.2 Patch 17694377 released 22-JUL-2014 ReadMe
Linux x86-64 Certification
12.1.0.2 Patch 17694377 released 22-JUL-2014 ReadMe
Note:888828.1MP Recommended Patch Information for Exadata Database Machine and Exadata Storage Server
Oracle Solaris on x86 32-bit Client
12.1.0.2 Patch 17694377 released 22-JUL-2014 ReadMe
Oracle Solaris on x86-64 Certification
12.1.0.2 Patch 17694377 released 22-JUL-2014 ReadMe
Oracle Solaris on Sparc 32-bit Client Certification
12.1.0.2 Patch 17694377 released 22-JUL-2014 ReadMe
Oracle Solaris on Sparc 64-bit Certification
12.1.0.2 Patch 17694377 released 22-JUL-2014 ReadMe
Windows 32-bit Certification
12.1.0.2 Patch 17694377 released 26-SEP-2014 ReadMe
19787643P Windows: SQLLDR.EXE – SQL Loader fails to start – oranfsodm12.dll is missing
Windows 64-bit (x86-64) Certification
12.1.0.2 Patch 17694377 released 26-SEP-2014 ReadMe
19787643P Windows: SQLLDR.EXE – SQL Loader fails to start – oranfsodm12.dll is missing

Symbols used in this document

In the lists above

  • ‘*’ indicates that an alert exists for that issue.
  • ‘+’ indicates a particularly notable issue / bug.
  • See Note:1944526.1 for details of other symbols used

 


Posted

in

by

Tags:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *