Streams Specific Patches

Streams Specific Patches [ID 437838.1]
		Modified 26-MAY-2010     Type BULLETIN     Status PUBLISHED

In this Document
  
  
  
     
     
     
     
     
     
     
     
     
     
     
  

---

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.4 to 11.1.0.7 - Release: 9.2 to 11.1
Information in this document applies to any platform.
Last updated on 21-Jan-2010

Purpose

Intended for customers who want to know what are the minimal patches that needs to be applied before configuring Streams. This is not a full list of patches for all the bugs/known issues for entire Streams product.

Note : Depending on exactly what Streams functionality you  are using, you do not necessarily need to apply all the Streams specific patches.
 

Scope and Application

This document complements and does not replace the recommendations done on document
- Oracle Recommended Patches -- Oracle Database

It is highly recommended to apply to apply the latest PSU available for your release prior installing Streams specific patches as more and more problems will be avoided.

Intro to Patch Set Updates (PSU)

For the moment there are not recommendations for patches on top of 11.1.0.6 nor 11.2.0.

For Windows platforms we do not provide specific patches and therefore the patch will be included on latest bundle patch set.

Note that not all of the patches can be available for all the platforms. If there is no patch available for your platform please contact Oracle Support to request it.
When requesting a patch do not forget to specify:

• Platform where the patch is required.
• Exact release, patchset and PSU level
• Provide list of patches installed and/or the ones that you pretend to install. This is required to verify potential clashes during installation. You can get the list of patches installed using command:

          opatch lsinvetory -details
 

Streams Specific Patches

On top of 11.1.0.7.3, 11.1.0.7.2 and 11.1.0.7.1

PSU 11.1.0.7.3 can be downloaded from and you can find documentation for it on .

PSU 11.1.0.7.2 can be downloaded from and you can find documentation for it on .

PSU 11.1.0.7.1 can be downloaded from and you can find documentation for it on .

Patch	Comments
	Patch for 11.1.0.7.0 should be used
	Patch for 11.1.0.7.0 should be used
	ORA-600 [KWQBMCRCPTS101] when removing streams
	Patch for 11.1.0.7.0 should be used

On top of 11.1.0.7

11.1.0.7 can be downloaded from .

Patch	Comments
	Merge patch that contains fixes for: ORA-26687: no instantiation scn provided when drop child table Streams capture aborts with ORA-26744 and ORA-26773 on lob columns ORA-26773 reported by streams capture process after split partition operation Logmnr ckptunsafecount is maintained incorrectly Streams capture slow processing direct path insert, high cpu for logmnr builder Incorrect data read in streams dml handler leading to performance degradation Logmnr checkpointing may cause capture performance problem Data corruption during rollback inline lob dml with mbu Intermittent ORA-16014 errors in streams environment Avoid control file contention from data guard processes ORA-26773 Malformed redo on capture of long
	Logical Standby Upgrade from 9.2 may appear to hang
	Required if replicating from lower release to 11107
	Streams memory accounting incorrect, leading capture to 'PAUSED IN FLOW CONTROL'
	DBMS_COMPARISON patch for 11.1.0.7
	UTL_SPADV package extended to automate monitoring. Also required for 10.2.0.5 Grid Control.
	Archive log is not automatically registered when second cdc is built.
	ORA-600 [KWQBMCRCPTS101] when removing streams
	ORA-600 [KWQBMCRCPTS101] after drop propagation with spilled msgs

 

THERE ARE NO RECOMMENDED ONE OFF PATCHES FOR 10205.
 

On top of 10.2.0.4.4

PSU 10.2.0.4.4 can be downloaded from and you can find documentation for it on .

Patch	Comments
	Includes the fix for bugs 6134664 and 6915767, which are related to ORA-600 [kwqbmcrcpts101] errors. Plus fix for bug 6748184, related to error ORA-1426 with declarative transformation on local propagation

On top of 10.2.0.4.3

PSU 10.2.0.4.3 can be downloaded from and you can find documentation for it on .

Patch	Comments
	Includes the fix for bugs 6134664 and 6915767, which are related to ORA-600 [kwqbmcrcpts101] errors. Plus fix for bug 6748184, related to error ORA-1426 with declarative transformation on local propagation

On top of 10.2.0.4.2

PSU 10.2.0.4.2 can be downloaded from and you can find documentation for it on .

Patch	Comments
	Merges fix for bugs 6600051 and 6915767. Alternatively you can use
	ORA-600 [kwqbmcrcpts101] can occur during spill. Alternatively you can use

On top of 10.2.0.4.1

PSU 10.2.0.4.1 can be downloaded from and you can find documentation for it on .

Patch	Comments
	Apply process is slow after upgrading to
	Excessive memory usage for lcr cache due to large freelists
	AQ propogation may fail after changing queue_to_queue=>true
	Propagation ORA-600 [KWQPCBK179], [1], [1369]

On top of 10.2.0.4.0

10.2.0.4 can be downloaded from

Patch	Comments
or (merged with CPU molecule 16)	Merge label request on top of 10.2.0.4 for bugs 8488171 8464061 does include the merge with CPU molecule 16 (Unpublished )
	Apply aborting with ORA-600 [KNLQDQM2USR:4]
	ORA-26773 Malformed redo on capture of long
	Apply process is slow after upgrading
	Excessive memory usage for lcr cache due to large freelists
	AQ propogation may fail after changing queue_to_queue=>true Applicable only if QUEUE_TO_QUEUE=>TRUE
	Propagation ORA-600 [KWQPCBK179], [1], [1369]

On top of 10.2.0.3

10.2.0.3 can be downloaded from

Patch	Comments
	Tracking Bug for Inventory of Data Guard Logminer/Logical Standby. Includes Fixes for Streams Capture process. If patches 6067600 and/or 6067611 are already applied, please rollback before applying this patch.
	Tracking Bug for Inventory of Data Guard Physical Standby
	Leak in Perm Allocations with library cache. ORA-4031 generated.
	Merge label request on top of 10.2.0.3 for bugs 6134664 6614017
	Propagation ORA-600 [KWQPCBK179], [1], [1369]

On top of 10.2.0.2

10.2.0.2 can be downloaded from

Patch	Comments
	Merge patch for Streams Capture process
	Leak in Perm Allocations with Library Cache
	Streams Apply patch. Replaces
	REQUIRED_CHECKPOINT_SCN not moving forward
	Merge of bugs 6636023 and 5526410
	ORA-600 [KWQBMCRCPTS101] while spilling messages (recreate prop)
	Propagation ORA-600 [KWQPCBK179], [1], [1369]

On top of 10.1.0.X

10.1.0.5 can be downloaded from

Patch	Comments
	Logminer reader consumes too much CPU when idle (5-7%)
	CDC Capture process aborts. ORA-600[KRVXGCTASI:ARRAY SIZE]/ORA-1280 in alert log

10.1.0.4 can be downloaded from

No recommendations

10.1.0.3 can be downloaded from

Patch	Comments
	Streams Megapatch Only for platforms : AIX 5L - 64bit and HPUX- 64bit
	Streams Megapatch Only for platforms : Solaris 64bit/Linux x86/ Linux Itanium
	Streams Megapatch Only for Windows platforms

On top of 9.2.0.X

9.2.0.6 can be downloaded from

Patch	Comments
	Streams OEM GUI and Oracle Management Server patch. See note below.

Note: (also applicable to 9.2.0.5)

After any patchset is applied to an existing streams database, be sure to perform in each database, the database migration steps for the patchset.

startup migrate
catpatch.sql

For best results, implement the following suggestions.

• Double the shared_pool_size
• Set the hidden init.ora parameter _first_spare_parameter=50 (for 50% of the shared_pool_size parameter)
• Use the manual flow control scripts available on
• On multi-cpu machines, set the hidden init.ora parameter _kghdsidx_count=1.

9.2.0.5 can be downloaded from

For best results, implement the suggestions listed in 9.2.0.6 above.

Patch	Comments
	Logmnr_spill$ table grows in unbounded fashion
	Streams OEM GUI and Oracle Management Server patch. See note below.
	Captured_scn, Applied_scn not updating - logmnr checkpoints not completing

9.2.0.4 can be downloaded from

Patch	Comments
	The combination of this patch and the manual flow control scripts .eliminates most issues with ORA-4031 and ORA-1435 for Streams.
	Streams OEM GUI and Oracle Management Server patch. See note below.

Note on Streams OEM GUI and Oracle Management Server patch

This patch is a consolidation of multiple patches with the Streams Wizard for the Streams OEM Gui and Oracle Management Server and is a generic patch for all platforms.
This patch must be installed on both the server ( where your OMS is running) and the client (where you launch the OEM Console).
You will need to restart the OMS.
For further information, check the README file for the patch.

 

References

- Oracle Database Server and Networking Patches for Microsoft Platforms
- Oracle Database (RDBMS) Releases Support Status Summary
- Client / Server / Interoperability Support Between Different Oracle Versions
- ORA-600 [KWQBMCRCPTS101] reported by a Qmon slave process after dropping a Streams Propagation
- Release Schedule of Current Database Releases
- Oracle Recommended Patches -- Oracle Database