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/201520144308+ 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/201520369110 ORA-600[9999] / Cannot enable more than 8 kernel options (such as uniaud , olap, lbac etc..) 14/Jul/2015Note 1944645.1* ORA-600 [kdblkcheckerror]..[6266] corruption with self-referenced chained row. ORA-600 [kdsgrp1] / Wrong Results / ORA-8102 14/Jul/2015Upgrade Issues
Bug/Doc Description Updated 19787643P Windows: SQLLDR.EXE – SQL Loader fails to start – oranfsodm12.dll is missing 19/Nov/201419141838 ORA-600 [qksanGetTextStr:1] from SQL Plan Management after Upgrade to 12.1 02/Jun/201520123899 Insert in to stat table fails with ORA-932 “inconsistent datatypes” after upgrade from 11g to 12c (part 2) 06/May/201515894842 Insert in to stat table fails with ORA-932 “inconsistent datatypes” after upgrade from 11g to 12c (part 1) 06/May/201519664340+ ORA-20000 “unable to gather statistics concurrently” during upgrade to 12.1 14/Jul/201519536415 DB upgrade to 12.1 fails with ORA-600 [kkaegso: PUBLIC] 14/Apr/201519291380 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/201521030693 ORA-600 [qerpxMObjVI6] from parallel query on partitioned table 14/Jul/201520879889 Open cursor leak from DML on table with a materialized view log 16/Apr/201520634449 Wrong results from OUTER JOIN with a bind variable and a GROUP BY clause in 12.1.0.2 14/May/201520466322 ASSM Free block space not reused when expected 14/Jul/201520406840 Pro*C 12.1.0.2 throws ORA-600 [17998] when precompiling by ‘other’ user (not Oracle install user) 23/Jul/201519787643PI Windows: SQLLDR.EXE – SQL Loader fails to start – oranfsodm12.dll is missing 19/Nov/201419567916 Wrong results when GROUP BY uses nested queries in 12.1.0.2 24/Sep/201420794034 ORA-600 [rworupo.1] from SQL with window function and large columns 24/Jun/201518881811 Data pump import of wrapped PLSQL corrupts the body 12/Apr/201519703301 ORA-22275 “invalid lob locator specified” if fix for bug 14044260 present 13/Jul/201519687159 Excess memory use / ORA-4030 for SQL with many WINDOW operations and large sort keys – superseded 14/Apr/201519627012 ORA-7445 [kd9ir2tComputeTreeSErcs] inserting / loading to a compressed table 14/Apr/201519018447 ORA-7445 [ksxpmsgcncl] / ORA-600 [15810] from Parallel Query 14/Apr/201519134173 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
Comment