Php文档 Php问答行业资讯 Php论坛 Php手册 Php博客

游戏榜单

软件榜单

关闭导航

热搜榜

热门下载

热门标签

关闭搜索

php爱好者> php文档>Streams Specific Patches

Streams Specific Patches

时间：2010-06-28 来源：rushmeplz

Streams Specific Patches [ID 437838.1]

	Modified 26-MAY-2010 Type BULLETIN Status PUBLISHED

In this Document
  Purpose
  Scope and Application
  Streams Specific Patches
     On top of 11.1.0.7.3, 11.1.0.7.2 and 11.1.0.7.1
     On top of 11.1.0.7
     On top of 10.2.0.4.4
     On top of 10.2.0.4.3
     On top of 10.2.0.4.2
     On top of 10.2.0.4.1
     On top of 10.2.0.4.0
     On top of 10.2.0.3
     On top of 10.2.0.2
     On top of 10.1.0.X
     On top of 9.2.0.X
  References

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
Note:756671.1 - 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.

Note 854428.1 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 Patch 9352179 and you can find documentation for it on Note 9352179.8.

PSU 11.1.0.7.2 can be downloaded from Patch 9209238 and you can find documentation for it on Note 9209238.8.

PSU 11.1.0.7.1 can be downloaded from Patch 8833297 and you can find documentation for it on Note 8833297.8.

Patch	Comments
Patch 8268944	Patch for 11.1.0.7.0 should be used
Patch 8268939	Patch for 11.1.0.7.0 should be used
Patch 6915767	ORA-600 [KWQBMCRCPTS101] when removing streams
Patch 7207654	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 6890831.

Patch	Comments
Patch 8563582	Merge patch that contains fixes for: Bug 6452375 ORA-26687: no instantiation scn provided when drop child table Bug 6599920 Streams capture aborts with ORA-26744 and ORA-26773 on lob columns Bug 7175513 ORA-26773 reported by streams capture process after split partition operation Bug 7331867 Logmnr ckptunsafecount is maintained incorrectly Bug 7345904 Streams capture slow processing direct path insert, high cpu for logmnr builder Bug 7356443 Incorrect data read in streams dml handler leading to performance degradation Bug 7499353 Logmnr checkpointing may cause capture performance problem Bug 7527650 Data corruption during rollback inline lob dml with mbu Bug 7276960 Intermittent ORA-16014 errors in streams environment Bug 6882739 Avoid control file contention from data guard processes Bug 7219752 ORA-26773 Malformed redo on capture of long
Patch 7036453	Logical Standby Upgrade from 9.2 may appear to hang
Patch 7652888	Required if replicating from lower release to 11107
Patch 7719668	Streams memory accounting incorrect, leading capture to 'PAUSED IN FLOW CONTROL'
Patch 8268944	DBMS_COMPARISON patch for 11.1.0.7
Patch 8268939	UTL_SPADV package extended to automate monitoring. Also required for 10.2.0.5 Grid Control.
Patch 6955744	Archive log is not automatically registered when second cdc is built.
Patch 6915767	ORA-600 [KWQBMCRCPTS101] when removing streams
Patch 7207654	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 Patch 9352164 and you can find documentation for it on Note 9352164.8.

Patch	Comments
Patch 9566550	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 Patch 9119284 and you can find documentation for it on Note 9119284.8.

Patch	Comments
Patch 9365345	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 Patch 8833280 and you can find documentation for it on Note 8833280.8.

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

On top of 10.2.0.4.1

PSU 10.2.0.4.1 can be downloaded from Patch 8576156 and you can find documentation for it on Note 8576156.8.

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

On top of 10.2.0.4.0

10.2.0.4 can be downloaded from Patch 6810189

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

On top of 10.2.0.3

10.2.0.3 can be downloaded from Patch 5337014

Patch	Comments
Patch 6081550	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.
Patch 6081547	Tracking Bug for Inventory of Data Guard Physical Standby
Patch 6043052	Leak in Perm Allocations with library cache. ORA-4031 generated.
Patch 6901159	Merge label request on top of 10.2.0.3 for bugs 6134664 6614017
Patch 5933656	Propagation ORA-600 [KWQPCBK179], [1], [1369]

On top of 10.2.0.2

10.2.0.2 can be downloaded from Patch 4547817

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

On top of 10.1.0.X

10.1.0.5 can be downloaded from Patch 4505133

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

10.1.0.4 can be downloaded from Patch 4163362

No recommendations

10.1.0.3 can be downloaded from Patch 3761843

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

On top of 9.2.0.X

9.2.0.6 can be downloaded from Patch 3948480

Patch	Comments
Patch 3023858	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 Note 259609.1
On multi-cpu machines, set the hidden init.ora parameter _kghdsidx_count=1.

9.2.0.5 can be downloaded from Patch 3501955

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

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

9.2.0.4 can be downloaded from Patch 3095277

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

Note on Patch 3023858 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

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