Thursday, October 25, 2012

11.2.0.3.4 Patch Set Update for Oracle 11g R2 (11.2.0.3.0)



Database 11.2.0.3.4 PSU Patch 14275605
--------------------------------------------------------

To install the PSU 11.2.0.3.4 patch, the Oracle home must have the 11.2.0.3.0 Database installed. Subsequent PSU patches can be installed on Oracle Database 11.2.0.3.0

This patch is Oracle RAC Rolling Installable.

This patch is Data Guard Standby-First Installable.

You must use the OPatch utility version 11.2.0.3.0 or later to apply this patch. Oracle recommends that you use the latest released OPatch 11.2, which is available for download from My Oracle Support patch 6880880 by selecting the 11.2.0.0.0 release.

If you are installing the PSU to an environment that has a Grid Infrastructure home, note the following:

Patch 14275572: GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.3.4 (INCLUDES DB PSU 11.2.0.3.4)


Patch 14275605 - 11.2.0.3.4 Patch Set Update
--------------------------------------------------------------

Bugs Fixed by This Patch - This patch includes the following bug fixes.

1 CPU Molecules
------------------------


CPU molecules in PSU 11.2.0.3.4:

PSU 11.2.0.3.4 contains all molecules previously released in PSU 11.2.0.3.3 and the following new PSU 11.2.0.3.4 molecules:

14480674 - DB-11.2.0.3-MOLECULE-019-CPUOCT2012
14480675 - DB-11.2.0.3-MOLECULE-020-CPUOCT2012
14480676 - DB-11.2.0.3-MOLECULE-021-CPUOCT2012
14548763 - DB-11.2.0.3-MOLECULE-022-CPUOCT2012
14664355 - DB-11.2.0.3-MOLECULE-023-CPUOCT2012

2 Bug Fixes
----------------


See My Oracle Support Document 1449750.1 that documents all the non-security bugs fixed in each 11.2.0.4 Patch Set Update (PSU).
 

PSU 11.2.0.3.4 contains the following new fixes:
----------------------------------------------------------------- 
Advanced Queuing

13484963 - INVALID TTC BUFFER LENGTH IN CASE OF PROPAGATION MAY RAISE ORA-3146

Automatic Storage Management

13476583 - DROPPING OF A DISK CAN CAUSE DISMOUNT OF DISKGROUP IN OTHER ASM

Buffer Cache Management

13397104 - INSTANCE CRASH WITH ORA-600 [KJBLPKEYDRMQSCCHK:PKEY]
14409183 - SESSION HANGS ON GC BUFFER BUSY ACQUIRE

Generic

12693626 - HIGH CPU USAGE BY QUERY ON PARTITIONING KEY WITH INTERVAL PARTITIONING
12971775 - ORA-0600 WHILE RUNNING PARALLEL DML WHILE ONLINE INDEX IS CREATING
13059165 - EXEC OF UTLRP.SQL MAY RETURN INCORRECT COUNT FOR "OBJECTS WITH ERRORS" RESULT
13080778 - ORA-00942 RETURNED IN SQL ON MULTIPLE SCHEMAS DATABASE
13099577 - ORA-1460 WHEN PARALLEL QUERY SERVERS ARE USED
13250244 - ORA-4031 ERRORS SEEN WHEN PARAMETER _KGHDSIDX_COUNT IS SET TO >1 DUE TO MEM LEAK
13358781 - DBA_HIST_SQLSTAT SHOWS CCWAIT_DELTA ALWAYS = 0
13384182 - ORA-600 [DELROW:IOT1] RAISED FOR DELETE OR MERGE..DELETE SQL
13550185 - QUERIES ON V$SQLSTATS MAY CAUSE CRASH OR HANG
13566938 - DML WITH BINDS ON A REFERENCE PARTITIONED TABLE MAY RAISE ORA-600 [KCBGTCR_1]
13572659 - DBMS_REDEFINITION DISABLES FKS USED FOR REFERENCE PARTITIONING
13705338 - WRONG RESULTS ON IOT SECONDARY INDEX THROUGH JOIN
14076523 - ORA-600 [KGXRELEASE-BAD-HOLDER] FROM PROCESS WITH NO USER SESSION
14613900 - POSSIBLE CORE DUMP WHILE SCANNING FOR A CHILD FOR SHARABLE CURSOR

High Availability

12794305 - REDO SHIPMENT COULD FAIL AT THE STANDBY WITH ORA-600:[KRSR_PIC_COMPLETE.8]
13377816 - DON'T SEND IN DIA0 IF SOCKET CLOSED - HANDLE FAILURE APPROPRIATELY
13385346 - GCR0 TRACE FILES CONTINUOUSLY CREATED WITH KJGCR_DELETESO MESSAGES
13718279 - DB INSTANCE TERMINATED DUE TO ORA-29770 WHEN _GC_DEFER_TIME IS SET TO 1MS
13737746 - MRP0: BACKGROUND MEDIA RECOVERY TERMINATED

Oracle Security

11708510 - ORA-28267: INVALID NAMESPACE VALUE ERROR WHEN SQL USES DB LINK TO ACCESS 10G DB

Oracle Space Management

12583611 - EXCESSIVE ENQ:TX CONTENTION WITH HEAVY SECUREFILE INSERT WORKLOAD ON RAC
13464002 - PREFETCH INVOLVING TEMP OBJECTS MAY RAISE ORA-600[KCBCHG1_12]/[KDIFIND:KCBGET_24
13649031 - ORA-10637 OCCURS WHEN SHRINK ON PARTITIONED TABLE
13773133 - ORA-600 [KTSFLMERGE-CYCLE-1] DURING INSERTS INTO FREELIST MANAGED SEGMENT

Oracle Streams

12594032 - POSSIBLE MEMORY CORRUPTION WHEN USING CDC EXTEND_WINDOW OR EXTEND_WINDOW_LIST

Oracle Transaction Management

13430938 - ORA-4031 ERRORS WITH HIGH "KTC LATCH SUBH" MEMORY USAGE

Oracle Virtual Operating System Services

12585543 - RMAN BACKUP PERFORMANCE DROPS SIGNIFICANTLY AFTER UPGRADE TO 11.2

PL/SQL

13612575 - PROCEDURES RETURNING REFCURSOR BIND VARIABLES MAY HIT ORA-600 [15419]
13624984 - DATAPUMP HANGS ON PACKAGE BODY COMPILATION LIBRARY CACHE PIN
13804294 - INTERNAL ERRORS, CORRUPTIONS, USING PIPELINED FUNCTION WHOSE ROWS CAUSE ERRS

Server Manageability

13257247 - POPULATING WRH$_TEMPSTATXS MAY BE SLOW DUE TO INEFFICIENT QUERY EXECUTION PLAN
13699124 - AWR COMPARE PERIOD: SPINNING WHEN QUERYING DIFF OF KEY INSTANCE STATS