Oracle Database List of Bugs Fixed
10g Release 2 (10.2.0.3) Patch Set
 
 

Oracle Database

List of Bugs Fixed

10g Release 2 (10.2.0.3) Patch Set

October 2006

This document lists the generic bugs fixed in the Oracle10g Release (10.2.0.3) Patch Set and all previous Oracle Database patch sets. Fixed platform-specific bugs are listed in the Oracle10g Patch Set Notes Release (10.2.0.3) Patch Set for each platform. This document contains the following sections:

1 Patch Set Documentation

There are two documents related to this release of the Oracle Database patch set:

The List of Bugs Fixed is a list of all generic bugs related to Oracle Database that have been fixed in this release.

Both of these documents are included with the patch set. In addition, they are available from document 316900.1, ALERT: Oracle 10g Release 2 (10.2) Support Status and Alerts on the OracleMetalink Web site: 

http://metalink.oracle.com

To locate document 316900.1:

  1. Log on to OracleMetalink.

  2. Click Advanced at the top of the OracleMetalink page.

  3. Enter 316900.1 in the Document ID field, then click Submit.

2 Bugs Fixed in this Patch Set by Category

This section describes the bugs fixed in this patch set by category. It includes the following categories:


Note:

This list of fixed bugs was current at the time that the patch set was released. Information about these fixed bugs may be revised after release of the patch set. Refer to the Patch Set section of OracleMetaLink document 316900.1 for any postrelease updates.

2.1 Oracle Server

The following list bugs for the Oracle Server product.

2.1.1 ANSI Joins

The following table lists the ANSI Joins bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4433936 ORA-907 from FULL / LEFT OUTER joins
10.2.0.3 4582764 Wrong results from ANSI OUTER join with inline view
10.2.0.3 4615392 Join elimination not working with ANSI join syntax
10.2.0.3 4625102 Wrong results using ANSI join when NL join is performed
10.2.0.3 4932843 Wrong results from full outer join with TABLE() function
10.2.0.3 5005052 OERI:voprsla1 from ANSI query with TABLE() and domain index
10.2.0.2 4308414 Join predicate push may not occur for UNION [ALL] views
10.2.0.2 4369235 ANSI joins may fail with ORA-1445

2.1.2 ASSM Space Management (Bitmap Managed Segments)

The following table lists the ASSM Space Management (Bitmap Managed Segments) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 3279497 Interupted (Ctrl-C) TRUNCATE can corrupt ASSM table
10.2.0.3 3610777 Excessive CPU from INDEX insert into ASSM index segment
10.2.0.3 4055634 TRUNCATE table has to much overhead when operating on empty segments
10.2.0.3 4188324 Wasted space possible in ASSM segments
10.2.0.3 4475314 DELETE then INSERT without commit on ASSM segment can be slow
10.2.0.3 4660718 Allow choice between space / performance for ASSM segments
10.2.0.3 4694312 Index inserts to ASSM segments can be slow
10.2.0.3 4887955 Unnecessary extent allocated in locally managed ASSM tablespace in RAC
10.2.0.3 5034679 Hang / errors making ASSM tablespace read only with concurrent DML
10.2.0.3 5349632 Poor performance for ASSM insert after large DELETE
10.2.0.2 4288876 Excessive redo / undo generation from insert/update with ASSM indexes
10.2.0.2 4486753 DMLS contention with ASSM segments
10.2.0.2 4517470 Table corruption with RAC when ASSM managed and truncate used

2.1.3 Advanced Queuing

The following table lists the Advanced Queuing bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4515626 AQ enqueue option visibility=DBMS_AQ.IMMEDIATE does not work for ENQUEUE_ARRAY
10.2.0.3 4527173 AQ$_JMS_TEXT_MESSAGE.SET_TEXT method does not work correctly with multi-byte character sets
10.2.0.3 4543871 High CPU use by Qxxx proceses when using RETENTION
10.2.0.3 4640637 OERI[kwqidorefetch:err][3135] from AQ
10.2.0.3 4730389 ORA-30757 on propagation from 10.2 -> 8i
10.2.0.3 4752021 Dump (kpoaqeqopp) on AQ propagation from 8i to 10.2
10.2.0.3 4756409 High latency in AQ OCI notifications
10.2.0.3 5001358 Dump (kwqppay2aqe) on propagation of a transformed message
10.2.0.3 5178202 RAC AQ dequeue on different instance to enqueue is slow
10.2.0.2 4375798 ORA-60 deadlock from AQ enqueue
10.2.0.2 4425689 AQ message state may not be set to READY in RAC
10.2.0.2 4519477 AQ dequeue by correlation id is extremely expensive
10.2.0.2 4585640 AQ messages may not be processed properly / QMN processes may be aborted

2.1.4 Analytic SQL (Windowing etc..)

The following table lists the Analytic SQL (Windowing etc..) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 5055892 Wrong results from NVL with analytic function in HAVING clause
10.2.0.2 4402808 Parallel refresh of MVIEW with GROUPING SETS can give bad MVIEW data
10.2.0.2 4551356 Dump (evagrp) using GROUPING functions
10.2.0.2 4573980 Dump in qeesTraverseExpr using a GROUPING operator in a GROUP BY clause

2.1.5 Automatic Storage Management (ASM)

The following table lists the Automatic Storage Management (ASM) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 3811904 Rebalance can fail if there is one full disk
10.2.0.3 3885499 ASM hang possible
10.2.0.3 4229751 CONVERT TABLESPACE fails to create file with DB_FILE_NAME_CONVERT on ASM
10.2.0.3 4450268 ASM disk mounts are serialized
10.2.0.3 4466433 Restoring current controlfile on ASM creates a file with "backup" string
10.2.0.3 4561867 ASMB may exit prematurely causing OERI in client
10.2.0.3 4671721 OERI [kfcInitDlocn02] possible in ASM instance
10.2.0.3 4691191 Failure during file grow may leak ASM disk space
10.2.0.3 4709210 ASM LMS OERI[504] on [kfcl le freelist] latch
10.2.0.3 4709214 ASM may crash with OERI[kfclGetLock40]
10.2.0.3 4752481 Skewed ASM disk allocation when single file resized many times
10.2.0.3 4865736 ASM resource should not have dependency on VIP
10.2.0.3 4872617 Dump (kfclDumpLe) in ASM
10.2.0.3 4883032 ASM fails with ORA-15096 during crash or instance recovery
10.2.0.3 4886660 ASMB can fail with OERI:kffmAllocate_1
10.2.0.3 4907496 Processes hang after adding disk back to ASM diskgroup using force option
10.2.0.3 4943406 LMON needs to message SMON to start recovery in ASM instance
10.2.0.3 4960705 ASM waits longer than necessary during reconfiguration
10.2.0.3 4966352 OERI[unsorted_pins_4] possible on ASM
10.2.0.3 4967266 DB recovery blocked by ASM recovery
10.2.0.3 5012099 ASM rebalance problems
10.2.0.3 5024639 ASM hangs if private interface down on a surviving node
10.2.0.3 5039964 ASM disks show as provisioned although kfed shows valid disk header
10.2.0.3 5089630 Dump (kfncInitSlavePool) / ORA-15012 from Log Miner / Streams against LOGs on ASM
10.2.0.3 5090822 OERI[17092] / ORA-10382 when ASM IO completes concurrently with DISKGROUP dismount
10.2.0.3 5134663 OERI[2103] with ASM
10.2.0.3 5226903 OERI:[kfcDeadlockAvoid01] when running "check all repair"
10.2.0.3 5360719 ASM and database instances hang when disk array gets disconnected
10.2.0.3 5515492 Data corruption when ASM failgroup removed
10.2.0.2 4747535 * A diskgroup cannot be mounted on both nodes at the same time. This bug is alerted in Note:353065.1
10.2.0.2 4237629 OERI[kfdjoin5] on ASM instance with multiple diskgroups
10.2.0.2 4362919 CRS ASM failure recovery does not recover database instances
10.2.0.2 4413010 OERI[kffdmove01] selecting from V$ASM_ALIAS in ASM instance
10.2.0.2 4455512 ASM instance startup can be slow in RAC environments
10.2.0.2 4478323 OERI[kfcDeadlockAvoid01] on SQL against V$ASM_ALIAS
10.2.0.2 4490933 RMAN backup fails when backupsize > free on ASM but reclaimable space available
10.2.0.2 4503419 Cannot drop disk normal with less than 3 failgroups
10.2.0.2 4550821 OERI[kfklufsscannext] in ASM during disk discovery
10.2.0.2 4666938 OERI[kjbdowncvt:__l] can occur in ASM
10.2.0.2 4671216 ASM operations on a file are blocked while it is resized
10.2.0.2 4693247 Dump (kfcgetbuffer) while resizing a tablespace using ASM storage
10.2.0.2 4700681 ASM disk shrinkage can corrupt ASM metadata
10.2.0.2 4772979 OERI[kfdskAlloc0] in RDBMS instance when adding back a dropped disk

2.1.6 Bitmap Indexes

The following table lists the Bitmap Indexes bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4475125 Wrong results with join of FULL INDEX SCAN (MIN/MAX) with bitmap index
10.2.0.3 4533389 ANALYZE INDEX VALIDATE STRUCTURE does not update INDEX_STATS for bitmap indexes
10.2.0.3 4615091 Wrong result using bitmap index on partition table with INLIST
10.2.0.3 5015557 Dump under kkoNewExtractedBMKey or qerixGetKey with bitmap plan and function based index
10.2.0.3 5078743 Dump (in qkabxo) using bitmap access path in FIRST K ROWS
10.2.0.2 4274669 Bitmap index may be corrupted during REBUILD
10.2.0.2 4421063 Exchange partition fails with ORA-14098 with 2 or more bitmap join indexes
10.2.0.2 4554846 DBMS_STATS.GATHER_INDEX_STATS can be slow for a partitioned table with bitmap indexes

2.1.7 Change Data Capture

The following table lists the Change Data Capture bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4380175 Orphaned segment left by DBMS_CDC_PUBLISH.PURGE
10.2.0.3 5024710 CDC queue tables always end up in SYSTEM or SYSAUX tablespace

2.1.8 Cluster Ready Services / Parallel Server Management

The following table lists the Cluster Ready Services / Parallel Server Management bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4707711 P Solaris: 'cluvfy' fails on Solaris (Sparc-64bit)
10.2.0.3 5022314 P CRS has wrong LD_LIBRARY_PATH on Solaris X86-64
10.2.0.3 4127644 CSS not set in high/fixed priority class using CRSCTL SET CSS PRIORITY
10.2.0.3 4230367 nodedown event slow to appear after public network failure
10.2.0.3 4437727 VIPCA fails complaining that interface is not public
10.2.0.3 4459961 "crsctl debug log css COMMCRS / COMMNS" commands fail
10.2.0.3 4462367 CRS starts instance with too low file limit
10.2.0.3 4493093 PRKH-1001 from "srvctl add nodeapps"
10.2.0.3 4556878 CRSD may dump at cls_thrmxunlock()
10.2.0.3 4667776 clscfg -downgrade fails
10.2.0.3 4669874 RLB event delivery stops after instance restart
10.2.0.3 4689845 OPROCD log is not set up in RUN mode
10.2.0.3 4702263 CRSD failure is not handled in the init script
10.2.0.3 4716107 CVU fails if central inventory contains a deinstalled CRS home
10.2.0.3 4723189 Veritas Cluster Software not supported properly on some platforms
10.2.0.3 4726670 Total space of OCR is reported as 0 while executing root102.sh
10.2.0.3 4728396 DBCA does not change the parameter REQUIRED_RESOURCES for using ASM
10.2.0.3 4734413 OCR read from local cache blocked by writer working on different key
10.2.0.3 4739742 CLWS CRSD dump in prou_check_tag<-procr_close_key
10.2.0.3 4748946 CRSD aborts with OCR errors
10.2.0.3 4755275 CLWS CRSD aborts: fail to start monitor thread, comm failure
10.2.0.3 4756170 CRS/OCR delay before CRS recovery starts
10.2.0.3 4759984 root102 has wrong "rc" directories
10.2.0.3 4769197 Clients hang if a node goes down
10.2.0.3 4772904 PRKR-1007 / PROC-5 from srvctl
10.2.0.3 4865736 ASM resource should not have dependency on VIP
10.2.0.3 4870952 CLWS racgimon may dump
10.2.0.3 4879951 CLWS CRSD dump in eventutil::set_context
10.2.0.3 4883916 stop crs resource may be slow for shutdown abort
10.2.0.3 4890793 ASM resource depends on VIP even after removing required_resources
10.2.0.3 4893560 clscselect does not handle timeout = 0 correctly
10.2.0.3 4919514 CSSD does not fail when vendor clusterware present and skgxnreg fails
10.2.0.3 4925962 Problem with rootdelete.sbs, rootupgrade.sbs and localconfig.sbs
10.2.0.3 4926814 CLWS EVMD aborts in reconfiguration
10.2.0.3 4936206 CSS clients fail when vendor skgxn returns 0 for skgxntpshl
10.2.0.3 4936950 root and init scripts do not support SunCluster on Solaris X86 properly
10.2.0.3 4937400 GSD should not attempt to be started on Solaris x86 platforms
10.2.0.3 4945458 CSS group reconfiguration may not wait long enough to establish connections
10.2.0.3 4946339 CRS trace level cannot be modified via ocrlog.ini
10.2.0.3 4951958 CSSD reports graceful shutdown on private network cable pull
10.2.0.3 4967761 1.6s - 2.0s "gap" in CRSD before crs starts recovering resources
10.2.0.3 4997470 CSS startup terminates when another node comes up during reconfig
10.2.0.3 5004962 CRS may not be able to relocate a resource when no required resources
10.2.0.3 5007623 Dump in clssgmfmtdatareqresp causing node reboot
10.2.0.3 5011915 Split-brain resolution can be slow
10.2.0.3 5015469 OPROCD reboots node when system date goes backwards
10.2.0.3 5037858 OPROCD may report no reason for reboot
10.2.0.3 5037871 Clearer CSSD logging needed giving reasons for reboot
10.2.0.3 5052569 Wait for 'reboottime' after the kill echo on some platforms
10.2.0.3 5071602 Need a patch utility / key editor for diagnosis/repair of OCR corruptions
10.2.0.3 5077218 CSS asserts in clssnmhandlevoteinfo, clssnm.c 2224, node rebooted
10.2.0.3 5092622 oclsomon uses the wrong timeout value
10.2.0.3 5092725 crsctl debug does not accept a dash - ( hyphen )
10.2.0.3 5136712 ocrdump prints out no value for a keys with large value
10.2.0.3 5163409 "srvctl modify database" fails with PRKH-1014
10.2.0.3 5187351 Many clscNN.log files created - can affect performance
10.2.0.3 5252605 CSS reconfig starts before <misscount> seconds have elapsed
10.2.0.3 5350302 Unexpected node reboot after 'oracle cssd shell script failure'
10.2.0.2 4537790 P Windows: After reboot CRS startup can be slow
10.2.0.2 4362919 CRS ASM failure recovery does not recover database instances
10.2.0.2 4372856 CRS crashes with overlapped i/o in progress
10.2.0.2 4396372 Relocate of VIP fails when cable is pulled
10.2.0.2 4431939 ocrconfig fails to format OCR devices during replace
10.2.0.2 4462591 CSS cluster reconfiguration slow upon interconnect failure
10.2.0.2 4466428 CSS does not work properly with NFS voting disk
10.2.0.2 4487491 CRS will not start when CRS_HOME is on slow mounting file system
10.2.0.2 4500688 srvctl modify nodeapps -n node -A new_addr looses the existing VIP interface
10.2.0.2 4547083 Instance added using srvctl not started by CRS during CRS startup
10.2.0.2 4556989 "racgmain" process may dump in clsrcrpcthr() due to a race condition
10.2.0.2 4567879 Cloning CRS home fails
10.2.0.2 4583298 OCR may dump if users primary group id not in /etc/group or NIS
10.2.0.2 4591165 Voting disk timeout not based on single IO
10.2.0.2 4642651 CSS does not always resolve split brains when heavy load or long IO times
10.2.0.2 4653938 Adding a new node may configure VIP on the wrong interface name
10.2.0.2 4682514 GM may misinterpret communication failure as a node failure
10.2.0.2 4698419 CRS resources fail without waiting for the full timeout period
10.2.0.2 4723614 CRS does not detect failure of some CRS scripts

2.1.9 Code Improvement

The following table lists the Code Improvement bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4229751 CONVERT TABLESPACE fails to create file with DB_FILE_NAME_CONVERT on ASM
10.2.0.3 4323868 INDEX hints can lead to INDEX SCAN FULL
10.2.0.3 4435036 RAC diagnostics can be slow
10.2.0.3 4482737 FGA does not record binds of type TIMESTAMP in FGA_LOG$
10.2.0.3 4669305 Enhancement: Add diagnostics for OERI[12333]
10.2.0.3 4995640 Diagnostics for RAC OERI[kjucll1]
10.2.0.3 5037858 OPROCD may report no reason for reboot
10.2.0.3 5037871 Clearer CSSD logging needed giving reasons for reboot
10.2.0.3 5071602 Need a patch utility / key editor for diagnosis/repair of OCR corruptions
10.2.0.3 5117888 Collection split rewrite not enabled by default
10.2.0.2 4320012 Enhancement - Add support for Albania and Albanian in NLS

2.1.10 Compressed Data Storage

The following table lists the Compressed Data Storage bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4378206 Direct load of compressed table can load duplicate rows

2.1.11 Compressed Key Index / IOT

The following table lists the Compressed Key Index / IOT bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.2 4386766 IMPDP with compressed indexes fails with ORA-14071 and ORA-39083

2.1.12 Constraint Related

The following table lists the Constraint Related bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4742679 ORA-604 / ORA-28133 enabling constraints on table with FGA
10.2.0.3 5126551 Dump (kkdcacr) from query on tables with FK constraint
10.2.0.2 4321610 IMPDP errors on constraints longer then 4000 bytes
10.2.0.2 4629844 Dump / wrong results from query with CHECK constraint

2.1.13 Corrupt/Bad Backup

The following table lists the Corrupt/Bad Backup bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 5380055 * ORA-1555 / corruption if switch to Standby then back to Primary. This bug is alerted in Note:386830.1
10.2.0.3 5212539 + LOB corruption for NOCACHE LOBs (ORA-1555/ORA-22924)
10.2.0.3 5032964 ORA-19731 whilst recovering plugged in file
10.2.0.2 4627646 EXP may not export COLUMN COMMENTS on VIEWS

2.1.14 Corruption

The following table lists the Corruption bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 3279497 Interupted (Ctrl-C) TRUNCATE can corrupt ASSM table
10.2.0.3 4655520 Block corrupted during write not noticed
10.2.0.3 5017007 MVIEW LOB content incorrect after refresh
10.2.0.2 3875098 instance stayed up after one node lost connection to voting device
10.2.0.2 4275862 updateXML() may delete text elements
10.2.0.2 4700681 ASM disk shrinkage can corrupt ASM metadata

2.1.15 Corruption (Dictionary)

The following table lists the Corruption (Dictionary) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4380175 Orphaned segment left by DBMS_CDC_PUBLISH.PURGE
10.2.0.3 4748597 Moving a LOB in a partitioned table fails to update IND$
10.2.0.3 5040222 OERI[4823] from drop partition table after merge with update indexes
10.2.0.2 4616376 Corrupt MVIEW dictionary information from MVIEW on SYNONYM
10.2.0.2 4760628 Dictionary corruption adding POLICY to a SYNONYM

2.1.16 Corruption (Index)

The following table lists the Corruption (Index) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 5380055 * ORA-1555 / corruption if switch to Standby then back to Primary. This bug is alerted in Note:386830.1
10.2.0.2 4570793 * Index corruption from array inserts (ORA-8102/ORA-1499). This bug is alerted in Note:345136.1
10.2.0.2 4274669 Bitmap index may be corrupted during REBUILD
10.2.0.2 4409977 Insert into a partition with bitmap indexes can corrupt the index (ORA-1499)

2.1.17 Corruption (Logical)

The following table lists the Corruption (Logical) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 5458753 * SQL may execute in wrong schema. This bug is alerted in Note:392673.1
10.2.0.3 4335615 ORA-1403 / data corruption in logical standby
10.2.0.3 4378206 Direct load of compressed table can load duplicate rows
10.2.0.3 4627859 IOT corruption possible when OVERFLOW columsn exist
10.2.0.3 4711857 Exp/Imp of table with LONG swaps COMMENTS metadata
10.2.0.3 4717280 NULL may be inserted by INSERT with a TRIGGER for NUMBER columns
10.2.0.3 4771052 INSTEAD-OF trigger does not update tables correctly over dblink
10.2.0.3 4775068 Deferred transactions not applied in the correct order when using parallel propagation
10.2.0.3 4952018 OCI direct path API allows invalid data for NUMBER(p,s) fields
10.2.0.3 4955701 Incorrect data possible from INSERT .. VALUES with correlated subquery
10.2.0.3 4963106 SQLLDR SKIP skips wrong number of records
10.2.0.3 5049941 Direct path merge records incorrect information in ALL_SUMDELTA
10.2.0.3 5223223 Wrong results / bad MV content after direct load
10.2.0.2 4496211 Wrong results after fast refresh of a partitioned materialized view
10.2.0.2 4515623 Update .. RETURNING with a trigger can produce corrupt column data
10.2.0.2 4547458 INSERT triggers produce NULL for the USER function

2.1.18 Corruption (Physical)

The following table lists the Corruption (Physical) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 5212539 + LOB corruption for NOCACHE LOBs (ORA-1555/ORA-22924)
10.2.0.3 4411228 Block corruption with mixture of file system and RAW files
10.2.0.3 4637668 IMU transactions can produce out-of-order redo (OERI [3020] on recovery)
10.2.0.3 5061091 Block recovery corrupts undo header when log_parallelism > 1
10.2.0.3 5515492 Data corruption when ASM failgroup removed
10.2.0.2 4517470 Table corruption with RAC when ASSM managed and truncate used
10.2.0.2 4602031 Block corruption from UPDATE or MERGE into compressed table
10.2.0.2 4684074 OERI:510 / block corruption (ORA-1578) with DB_BLOCK_CHECKING

2.1.19 Database Configuration Assistant

The following table lists the Database Configuration Assistant bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4728396 DBCA does not change the parameter REQUIRED_RESOURCES for using ASM

2.1.20 Database Link / Distributed

The following table lists the Database Link / Distributed bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4254094 OERI[QERRMOBND1][932] possible for queries over DB links
10.2.0.3 4321119 ALTER MATERIALIZED VIEW causes ORA-32337 after DML via database link
10.2.0.3 4496339 RECO dumps in lxsCpStr causing instance crash
10.2.0.3 4627237 autonomous_transaction with DB link to shared server can self deadlock on DX
10.2.0.3 4637725 ORA-918 for remote DML
10.2.0.3 4703253 Wrong results from remote colocated join
10.2.0.3 4708037 ORA-904, ORA-2063 from query that uses TIME ZONE as a cast
10.2.0.3 4771052 INSTEAD-OF trigger does not update tables correctly over dblink
10.2.0.3 4904454 Wrong results from queries using remote colocated joins
10.2.0.3 4957217 ORA-2019 from REF cursor from procedure that uses a private dblink
10.2.0.3 4964703 OERI[opixrb-4] [1036] from SELECT over DBLINK with trailing :N or :Q bind names
10.2.0.3 4968994 Poor plan using SYSDATE in predicate over dblink
10.2.0.3 4996080 Wrong results from remote join
10.2.0.3 5012796 DUmp (in kglhdgsc) using distributed transactions
10.2.0.3 5037103 Dump (qerrmOieb) when selecting view across dblink
10.2.0.3 5040303 Dump (expepr) from distributed insert into VIEW
10.2.0.3 5043975 OERI[opixrm-1] [invalid handle] for remote cursor
10.2.0.3 5136454 Distributed statement using a synonym fails with ORA-904
10.2.0.3 5550824 Select SYSDATE over a database link increments SYSDATE
10.2.0.2 4177810 ORA-904 with non-column constants in FROM clause with PQ or remote SQL
10.2.0.2 4402255 Hang / dump possible using database link
10.2.0.2 4431181 Dump from SELECT if it changes from remote mapped to not
10.2.0.2 4456478 OERI:[qerrmObnd] from remote mapped queries
10.2.0.2 4507302 Dump (msqfun) from SQL generation
10.2.0.2 4517846 Dump from remote query when SQL_TRACE / event 10046 set

2.1.21 Database Upgrade Assistant

The following table lists the Database Upgrade Assistant bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4864648 DBUA can not upgrade database with dictionary managed temporary tablespace
10.2.0.2 4562382 I Upgrade to 10.2 with DBUA or manually (running utlu102x.sql) can be slow

2.1.22 Datapump Export/Import

The following table lists the Datapump Export/Import bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.2 4321610 IMPDP errors on constraints longer then 4000 bytes
10.2.0.2 4386766 IMPDP with compressed indexes fails with ORA-14071 and ORA-39083
10.2.0.2 4465417 ORA-6502 from EXPDP of multibyte database
10.2.0.2 4605877 Datapump export / import errors for wrapped package with comments

2.1.23 Datatypes (LOBs/CLOB/BLOB/BFILE)

The following table lists the Datatypes (LOBs/CLOB/BLOB/BFILE) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 5212539 + LOB corruption for NOCACHE LOBs (ORA-1555/ORA-22924)
10.2.0.3 4271217 OERI:kpolcsc1 / OERI:12333 from JDBC setCharacterStream() for CLOB data
10.2.0.3 4748597 Moving a LOB in a partitioned table fails to update IND$
10.2.0.3 4867884 Lob HW lock contention with space reclaimation
10.2.0.3 5011764 OERI[ktsircinfo_num1] accessing a LOB
10.2.0.3 5017007 MVIEW LOB content incorrect after refresh
10.2.0.3 5110062 Wrong results from INSTR for CLOB for multibyte charactersets
10.2.0.2 4278912 ORA-24852 if cursor selecting BLOB is rebuilt
10.2.0.2 4366667 OCILobWrite with OCI_LAST_PIECE can cause OERI:12333 on next DB access.
10.2.0.2 4387452 ORA-22922 trying to DEREF an object view
10.2.0.2 4401000 OERI[16608] during import of transportable tablespace
10.2.0.2 4431273 LOB segment PCTVERSION space reclaimation wrong
10.2.0.2 4619452 OERI[koklGetLocAndFlag1] during LOB array insert
10.2.0.2 4634368 Performance issues with LOBs during reclaimation

2.1.24 Datatypes (Objects/Types/Collections)

The following table lists the Datatypes (Objects/Types/Collections) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4242649 Object views are slower than they need be
10.2.0.3 4308089 Dump / OERI on MOVE / SPLIT partition of table with ADT column/s
10.2.0.3 4440681 Dump from REGEXP_REPLACE referring to table expression
10.2.0.3 4451506 Wrong results from SQL using TABLE() constructs
10.2.0.3 4583177 Poor performance inserting subtype constructor into polymorphic column
10.2.0.3 4644048 Oracle type evolution can fail with ORA-932
10.2.0.3 4744859 OERI[kkbncre:sq_len3] can occur
10.2.0.3 4860003 Sqlplus dump / OCI-21500 [koxsihread1]
10.2.0.3 4886383 Dump possible unpickling images from TABLE() function
10.2.0.3 4917666 OERI[kcbgcur_9] from type constructor
10.2.0.3 4928321 Pickle of opaque type results in bad image size
10.2.0.3 4932843 Wrong results from full outer join with TABLE() function
10.2.0.3 4959569 OERI[kdic_create_journal_table_1] rebuilding REF index ONLINE
10.2.0.3 4990803 Dump after type evolution
10.2.0.3 4992856 Collection view is not merged in DML
10.2.0.3 5005052 OERI:voprsla1 from ANSI query with TABLE() and domain index
10.2.0.3 5068565 Wrong results from pipelined table funciton with prefetch enabled (default)
10.2.0.3 5084961 Dump (qerncRowP) from PQ with nested cursor query
10.2.0.3 5130670 Wrong results with CURSOR query on complex view with collection objects
10.2.0.2 4260205 OERI:voprvl1 in query having an outer join and WITH
10.2.0.2 4350392 Dump (qkexrInitOpn or evapls) with unnested subqueries using object methods
10.2.0.2 4387452 ORA-22922 trying to DEREF an object view
10.2.0.2 4394339 "IS OF TYPE" or TREAT operators in SQL can fail with ORA-22950
10.2.0.2 4431181 Dump from SELECT if it changes from remote mapped to not
10.2.0.2 4443625 OERI[koklgetlobtid0] using large collections
10.2.0.2 4455919 Wrong results on query with event 19027 set

2.1.25 Datatypes (TIMESTAMP)

The following table lists the Datatypes (TIMESTAMP) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4272872 TIMESTAMPTZ is not affected by setSessionTimeZone
10.2.0.3 4460775 TIMESTAMP types may not exist in migrated database
10.2.0.3 4482737 FGA does not record binds of type TIMESTAMP in FGA_LOG$
10.2.0.3 4689959 Version 3 TIMEZONE files
10.2.0.3 4690953 Conversion of the TIMESTAMP WITH LOCAL TZ from Oracle type in Java fails
10.2.0.3 4708037 ORA-904, ORA-2063 from query that uses TIME ZONE as a cast
10.2.0.3 4776636 Wrong value for TIMESTAMP WITH TIME ZONE when NLS_CALENDAR set
10.2.0.3 4914281 TIMESTAMP WITH TIMEZONE values before 1800 corrupted
10.2.0.3 5055175 Dump [kkslpkp] using literal replacement with timezone literals
10.2.0.3 5075470 JVM timezone changes for Commonwealth games 2006
10.2.0.3 5218433 OERI[qmximv_maptype] select an XMLType table with TIMESTAMP types
10.2.0.2 4197704 OERI:7005 from queries involving partitions and TIMESTAMPs
10.2.0.2 4550702 SQLLOAD direct load gets ORA-1866 for storing systimestamp
10.2.0.2 4616093 Wrong results from dattime expressions with a timezone

2.1.26 Deadlock

The following table lists the Deadlock bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4627237 autonomous_transaction with DB link to shared server can self deadlock on DX
10.2.0.3 4699610 CKPT can self deadlock waiting for MTTR state object which it holds
10.2.0.3 4732503 Self-deadlock on TT enqueue
10.2.0.3 4765374 Create table with XML schema causes ORA-4020
10.2.0.3 4876140 ORA-4020 on registering XML schemas using recursive references
10.2.0.3 4913415 Global deadlock not reported in RAC
10.2.0.3 5012368 Undetected deadlock in RAC
10.2.0.3 5363031 deadlock on broker metadata lock when FSFO is enabled
10.2.0.3 5386881 ORA-60 deadlock from terminal recovery
10.2.0.2 3987280 Concurrent GRANT / SET ROLE can hang / deadlock
10.2.0.2 4153150 Deadlock on dc_rollback_segments from concurrent parallel load and undo segment creation
10.2.0.2 4185270 PMON "failed to acquire row cache enqueue" cleaning a dead process
10.2.0.2 4313246 PLSQL execution can hold dc_users row cache lock leading to hang / deadlocks
10.2.0.2 4375798 ORA-60 deadlock from AQ enqueue
10.2.0.2 4382653 Deadlock / ORA-4020 gathering statistics on indices
10.2.0.2 4446011 Hang with row cache lock deadlock from concurrent ALTER USER / TRUNCATE
10.2.0.2 4579381 Deadlock on DC_USERS in RAC (ORA-4020)

2.1.27 Direct Path Operations

The following table lists the Direct Path Operations bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4378206 Direct load of compressed table can load duplicate rows
10.2.0.3 4639659 SQLLDR direct load of IOT gets OERI[iot_gtab_mr_rcnt_mismatch]
10.2.0.3 4952018 OCI direct path API allows invalid data for NUMBER(p,s) fields
10.2.0.3 5049941 Direct path merge records incorrect information in ALL_SUMDELTA
10.2.0.3 5068048 SQL*loader hang on direct path load on multi CPU machine
10.2.0.3 5223223 Wrong results / bad MV content after direct load
10.2.0.2 4550702 SQLLOAD direct load gets ORA-1866 for storing systimestamp

2.1.28 Domain Indexes

The following table lists the Domain Indexes bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 3652491 Error for parallel query with ORDER BY and DOMAIN index
10.2.0.3 4134994 Extensible optimizer may use default costs
10.2.0.3 5005052 OERI:voprsla1 from ANSI query with TABLE() and domain index
10.2.0.3 5173194 Errors from partition range scan of LOCAL DOMAIN index
10.2.0.2 4188472 Memory leak using DOMAIN indexes
10.2.0.2 4304759 ORA-14297 can occur on ALTER TABLE EXCHANGE [sub]partition
10.2.0.2 4502066 Crash during rebuild of partition domain index leaves index unusable

2.1.29 Excessive CPU Usage

The following table lists the Excessive CPU Usage bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 3610777 Excessive CPU from INDEX insert into ASSM index segment
10.2.0.3 4543871 High CPU use by Qxxx proceses when using RETENTION
10.2.0.3 4685163 Merge SQL uses more CPU in 10.2 than 10.1
10.2.0.3 4900129 High CPU consumption during parse for unused CHECK constraints
10.2.0.3 5131645 10g hard parse CPU regression [ appopd->qksfrochild ]

2.1.30 Export/Import

The following table lists the Export/Import bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4383811 OERI:qerxtAgentOpen_911 during datapump import
10.2.0.3 4634712 EXPDP errors ORA-39125 ORA-22814 ORA-6512
10.2.0.3 4656020 Export / import of schema based XMLType table fails
10.2.0.3 4671082 IMPDP fails with ORA-2421
10.2.0.3 4693439 ORA-1406 from FULL export with auditing
10.2.0.3 4704626 User level import export with SB XMLTYPE table does not preserve scope
10.2.0.3 4711857 Exp/Imp of table with LONG swaps COMMENTS metadata
10.2.0.3 4736134 IMP-61 on import due to hashcode mismatch
10.2.0.3 4744469 IMPDP grants all roles to user creating them exceeding max enabled roles ORA-316
10.2.0.3 4758949 ORA-6550 error importing statistics
10.2.0.3 4868804 DBMS_METADATA / datapump export does not handle indexes on Materialized Views
10.2.0.3 4869987 ORA-39167 from EXPDP
10.2.0.3 4898699 Reverse key index with system generated name is not exported
10.2.0.3 4963080 Datapump export/import fails for partitioned table
10.2.0.3 5031489 ORA-1455 during full database export
10.2.0.3 5120417 EXPDP does not export procact_instance objects if obj#1 does not exist
10.2.0.3 5151960 IMPDP via NETWORK_LINK EXCLUDE/INCLUDE filters execute on wrong DB
10.2.0.2 4627646 EXP may not export COLUMN COMMENTS on VIEWS

2.1.31 Expression Filters / Rules

The following table lists the Expression Filters / Rules bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 5030164 ADD_ELEMENTARY_ATTRIBUTE can fail with ORA-12899
10.2.0.3 5078837 ORA-41661 from DBMS_RLMGR with NLS_NUMERIC_CHARACTERS using "," for the decimal point

2.1.32 External Tables

The following table lists the External Tables bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4715572 Wrong results / errors from select from external table with FIXED recordsize
10.2.0.2 4547785 Dump (kudmxopp) when accessing external table in parallel

2.1.33 Flashback

The following table lists the Flashback bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4874986 OERI[2142] while using flashback feature
10.2.0.3 5104579 Flashback query results on RAC inconsistent after rebooting 1 instance
10.2.0.3 5106952 Flashback log space not being reclaimed
10.2.0.2 4453449 OERI:3020 / corruption errors from multiple FLASHBACK DATABASE

2.1.34 Function Based Index (Including DESC Indexes)

The following table lists the Function Based Index (Including DESC Indexes) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 5092688 + Wrong results if function based index exists
10.2.0.3 4376021 Wrong results from INLIST involving function based index
10.2.0.3 4767699 Spin in qcsjFindFroInQbc for query with join and functional index
10.2.0.3 4871743 OERI [kkfi.qbcvfr] creating view which uses ROWID of another view
10.2.0.3 4939157 Dump (evaopn2) using a functional index
10.2.0.3 5005939 OERI[qkssao2s1] during DBMS_SQLTUNE
10.2.0.3 5015557 Dump under kkoNewExtractedBMKey or qerixGetKey with bitmap plan and function based index
10.2.0.3 5045474 Optimizer may not use function based index with NLSSORT of a CHAR column
10.2.0.2 4486132 Query using function based index gives wrong results

2.1.35 Gateways / Heterogeneous Services

The following table lists the Gateways / Heterogeneous Services bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4516151 SQLServer streams gives error if DML has nulls for date column
10.2.0.3 4629856 Wrong results selecting a LONG and a NULL over HS
10.2.0.3 4739749 Gateway returns ORA-28500 when it cannot process schemaname
10.2.0.3 4995320 Memory corruption / OERI[17114] from HS
10.2.0.3 5155213 Excessive memory use for ARRAY operations over HS
10.2.0.2 4360941 Column contents not displayed if HS query contains explict NULL

2.1.36 Global Temporary Tables

The following table lists the Global Temporary Tables bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 3889156 OERI[kcblibr_1] using global temporary table if client disconnected

2.1.37 Globalization Support (NLS)

The following table lists the Globalization Support (NLS) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4527173 AQ$_JMS_TEXT_MESSAGE.SET_TEXT method does not work correctly with multi-byte character sets
10.2.0.3 4598613 ORA-2248 from 10.2/10.1.0.5 client with NLS_LANG set to territory SWITZERLAND
10.2.0.3 4627522 ORA-1407 updating VARCHAR2 in AL32UTF8 database
10.2.0.3 4657575 CONVERT may dump converting ISO2022-JP data
10.2.0.3 4679879 ls/dir does show file information correctly on XDB FTP if NLS_LANGUAGE=JAPANESE
10.2.0.3 4689959 Version 3 TIMEZONE files
10.2.0.3 4950241 DBMS_APPLY_ADM.EXECUTE_ALL_ERRORS() fails with ORA-1403
10.2.0.3 4964703 OERI[opixrb-4] [1036] from SELECT over DBLINK with trailing :N or :Q bind names
10.2.0.3 5033218 ORA-6502 if TRIGGER modifies column value with >= 1001 character value
10.2.0.3 5045474 Optimizer may not use function based index with NLSSORT of a CHAR column
10.2.0.3 5075470 JVM timezone changes for Commonwealth games 2006
10.2.0.3 5078837 ORA-41661 from DBMS_RLMGR with NLS_NUMERIC_CHARACTERS using "," for the decimal point
10.2.0.3 5110062 Wrong results from INSTR for CLOB for multibyte charactersets
10.2.0.3 5253271 Wrong sort ordering for zeroes
10.2.0.3 5333814 OraSimpleDateFormat::parse on date with "pm" incorrectly becomes "am"
10.2.0.3 5345437 Intermittent wrong data / NLS errors (eg ORA-1801)
10.2.0.2 3942889 DBMS_METADATA.GET_DDL can output garbage characters in multibyte
10.2.0.2 4044836 ALTER SESSION to set an NLS parameter may fail silently
10.2.0.2 4320012 Enhancement - Add support for Albania and Albanian in NLS
10.2.0.2 4383610 application info attributes are not translated correctly in utf16 environment
10.2.0.2 4465417 ORA-6502 from EXPDP of multibyte database
10.2.0.2 4476695 OCI always performs NLS validation
10.2.0.2 4496189 V$SESSION.PROGRAM can contain partial MULTIBYTE characters
10.2.0.2 4501686 ORA-932 using TO_CHAR with NLS parameters in a pipelined function
10.2.0.2 4549495 OERI:1350 using 10gR2 with older NLS files

2.1.38 Hang (Involving Shared Resource)

The following table lists the Hang (Involving Shared Resource) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 3885499 ASM hang possible
10.2.0.3 4672266 LMS hang waiting for 'kjc: wait for msg sends to complete' during shutdown
10.2.0.3 4699610 CKPT can self deadlock waiting for MTTR state object which it holds
10.2.0.3 4732503 Self-deadlock on TT enqueue
10.2.0.3 5016142 SMON rollback of large transactions blocks other actions
10.2.0.3 5024639 ASM hangs if private interface down on a surviving node
10.2.0.3 5151675 Cannot archive redo.log in spite of good multiple log members
10.2.0.3 5208973 RAC may hang due to deadlock between LMS / MMAN latching
10.2.0.3 5360719 ASM and database instances hang when disk array gets disconnected
10.2.0.2 4164021 OERI [2103] during BACKUP CONTROLFILE to TRACE
10.2.0.2 4480100 Latch contention for "row cache objects" latch covering DC_USERS

2.1.39 Hang (Process Hang)

The following table lists the Hang (Process Hang) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4390868 Contention on DC_SEGMENTS due to small cache size on SYS.AUDSES$
10.2.0.3 4558970 RMAN RECOVER compilation can be slow
10.2.0.3 4602661 Adding a datafile hangs other sessions and new connections with resource manager
10.2.0.3 4627237 autonomous_transaction with DB link to shared server can self deadlock on DX
10.2.0.3 4725679 Switchover to logical standby hangs
10.2.0.3 4752179 Hang when calling extproc and killing client application
10.2.0.3 4755405 Excessive waits for "gcs drm freeze in enter server mode" in gsiat
10.2.0.3 4872999 RAC instance cannot get global enqueue
10.2.0.3 4882834 Excessive SS and TS contention in RAC
10.2.0.3 4907496 Processes hang after adding disk back to ASM diskgroup using force option
10.2.0.3 4956243 ALTER DATABASE BEGIN BACKUP hangs if other instance is mounted
10.2.0.3 5034679 Hang / errors making ASSM tablespace read only with concurrent DML
10.2.0.3 5068048 SQL*loader hang on direct path load on multi CPU machine
10.2.0.3 5117717 DG broker must disable/enable threads for logical switchover and failover
10.2.0.3 5143296 Reinstate of old primary hangs when old primary is disabling itself
10.2.0.3 5181800 Async LNS holds CF enqueue while issuing network calls rfsopen/rfsclose
10.2.0.2 3987280 Concurrent GRANT / SET ROLE can hang / deadlock
10.2.0.2 4153150 Deadlock on dc_rollback_segments from concurrent parallel load and undo segment creation
10.2.0.2 4313246 PLSQL execution can hold dc_users row cache lock leading to hang / deadlocks
10.2.0.2 4396718 RAC session may hang for global enqueue requested NOWAIT
10.2.0.2 4402255 Hang / dump possible using database link
10.2.0.2 4446011 Hang with row cache lock deadlock from concurrent ALTER USER / TRUNCATE
10.2.0.2 4579381 Deadlock on DC_USERS in RAC (ORA-4020)
10.2.0.2 4671216 ASM operations on a file are blocked while it is resized

2.1.40 Hang (Process Spins)

The following table lists the Hang (Process Spins) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 3610777 Excessive CPU from INDEX insert into ASSM index segment
10.2.0.3 4370351 High parse CPU (in qksfroInit) for large queries
10.2.0.3 4627203 tuxedo server process spins holding transaction branch allocation latch
10.2.0.3 4767699 Spin in qcsjFindFroInQbc for query with join and functional index
10.2.0.3 5131645 10g hard parse CPU regression [ appopd->qksfrochild ]
10.2.0.3 5162241 Dump / spin from query using "WITH" subquery with aggregation or DISTINCT

2.1.41 Hash Join

The following table lists the Hash Join bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4604970 + Wrong results with 'hash group by' aggregation enabled

2.1.42 Index Only Tables (IOT)

The following table lists the Index Only Tables (IOT) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4627859 IOT corruption possible when OVERFLOW columsn exist
10.2.0.3 4639659 SQLLDR direct load of IOT gets OERI[iot_gtab_mr_rcnt_mismatch]
10.2.0.3 4726573 Secondary index on global partitioned IOT is not used
10.2.0.3 4763768 OERI[17056] during analyze table compute stats on IOT
10.2.0.3 4925342 OERI [25027] / OERI [25012] on IOT analyze estimate statistics
10.2.0.3 4996133 OERI[kcbgtcr_5] updating an IOT in RAC environment
10.2.0.3 5074814 Dump (kkofmx) from DBMS_ADVISOR.EXECUTE_TASK for some IOT tables
10.2.0.3 5095700 Partition pruning does not occur DBMS_STATS for partitioned IOTs
10.2.0.3 5115350 ORA-932 during ALTER TABLE MOVE with nested tables IOTs
10.2.0.2 4457034 OERI:qkaffsindex3 can occur from CONNECT BY on IOT

2.1.43 Instance May Crash

The following table lists the Instance May Crash bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 3291723 DBWR may crash instance if shared pool memory low
10.2.0.3 4339429 RAC instance crash with OERI:[kclbla_2] / dump (skgxpimprp)
10.2.0.3 4393878 OERI[kclchkping_2] in shared server / PMON
10.2.0.3 4496339 RECO dumps in lxsCpStr causing instance crash
10.2.0.3 4637008 Frequent ORA-379 can occur
10.2.0.3 4704890 OERI[kslgetl:1] after adding CPU using dynamic reconfiguration
10.2.0.3 4709210 ASM LMS OERI[504] on [kfcl le freelist] latch
10.2.0.3 4709214 ASM may crash with OERI[kfclGetLock40]
10.2.0.3 4859002 PMON crash cleaning up serially_reusable PLSQL
10.2.0.3 4863048 LMS OERI[kjbmpocr:dsb] / instance crash with RAC
10.2.0.3 4903532 RAC instance may be evicted as LMS may not process messages quickly enough
10.2.0.3 4997495 Instance crash with OERI[504][mostly latch-free SCN]
10.2.0.3 5007623 Dump in clssgmfmtdatareqresp causing node reboot
10.2.0.3 5015469 OPROCD reboots node when system date goes backwards
10.2.0.3 5031173 Instance terminated by LMON ORA-602
10.2.0.3 5036588 LMD0 process dump (kewmuprbsm_update_rbsm)
10.2.0.3 5068253 LGWR crashes instance with OERI[kcrfw_redo_write_lwn_len]
10.2.0.3 5134663 OERI[2103] with ASM
10.2.0.3 5183472 Crash due to ORA-453 against DIAG
10.2.0.2 4164021 OERI [2103] during BACKUP CONTROLFILE to TRACE
10.2.0.2 4384672 SMON may fail with ORA-27103 during recovery of failed RAC instance
10.2.0.2 4473142 OERI[kcoadd_size] can occur in RAC
10.2.0.2 4583298 OCR may dump if users primary group id not in /etc/group or NIS
10.2.0.2 4666938 OERI[kjbdowncvt:__l] can occur in ASM
10.2.0.2 4671216 ASM operations on a file are blocked while it is resized
10.2.0.2 4693247 Dump (kfcgetbuffer) while resizing a tablespace using ASM storage
10.2.0.2 4704981 OERI[17148] / PMON dump in kksLockDelete

2.1.44 Instance Startup

The following table lists the Instance Startup bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4452690 ORA-67 / LMON crash during startup
10.2.0.3 5032921 ORA-3700 in LGWR after 'alter database activate standby database'
10.2.0.3 5039964 ASM disks show as provisioned although kfed shows valid disk header
10.2.0.3 5095940 OERI[kcvent_internal_2] during database open
10.2.0.2 4601462 P Win: OERI:OSDEP_INTERNAL can occur on startup at sssxcpttcs1
10.2.0.2 4345035 OERI:3619 on startup with transported read only tablespace
10.2.0.2 4394171 Automatic offlining of the datafile in noarchivelog leaves datafile unrecoverable
10.2.0.2 4455512 ASM instance startup can be slow in RAC environments
10.2.0.2 4642433 Delays possible concurrently starting numerous instances concurrently

2.1.45 Interoperability (Between Releases)

The following table lists the Interoperability (Between Releases) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4730389 ORA-30757 on propagation from 10.2 -> 8i
10.2.0.3 4752021 Dump (kpoaqeqopp) on AQ propagation from 8i to 10.2
10.2.0.3 4998752 SA_SESSION.SET_ROW_LABEL returnS ORA-1400 on ("lbacsys"."sessinfo"."key")
10.2.0.3 5000380 OCIAttrget(..., OCI_ATTR_PARAM_COUNT, ...) fails against 8i server

2.1.46 JDBC

The following table lists the JDBC bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4271217 OERI:kpolcsc1 / OERI:12333 from JDBC setCharacterStream() for CLOB data
10.2.0.3 4272872 TIMESTAMPTZ is not affected by setSessionTimeZone
10.2.0.3 4689781 JDBC client failover using FAN ONS does not handle site failures
10.2.0.3 5021340 OJMS generates unsharable dequeue SQL
10.2.0.3 5127944 PLS-103 from oracle.sql.TRANSDUMP.getTransitions()
10.2.0.3 5333814 OraSimpleDateFormat::parse on date with "pm" incorrectly becomes "am"
10.2.0.2 4057655 ArrayIndexOutOfBoundsException from JDBC using large number
10.2.0.2 4434249 ORA-2051 at non-native XAresource.end() when other branch is prepared

2.1.47 JavaVM / JSP / Corba etc..

The following table lists the JavaVM / JSP / Corba etc.. bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4655283 Dump (in joe_run_vm) running Java stored procedure
10.2.0.3 4924174 Performance degradation in JavaVM
10.2.0.3 5035666 OERI:16363 opening Java socket from a migratable session
10.2.0.3 5075470 JVM timezone changes for Commonwealth games 2006
10.2.0.3 5151518 Dump under AccessControlContext executing stored Java
10.2.0.2 4475814 java.security.NoSuchAlgorithmException from stored Java for other providers
10.2.0.2 4477328 Dump (eoa_get_dedicated_ctx) using migratable sessions with stored Java
10.2.0.2 4550168 Java stored procedure creates OS directories with wrong permissions
10.2.0.2 4593539 UGA memory leak using java.lang.ref.References in stored Java

2.1.48 Job Queues

The following table lists the Job Queues bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 5095398 Dump (in LdiDateDateSubtract) in RAC when stopping a chain Job
10.2.0.3 5102834 "restartable" job attribute does not work for detached or remote jobs
10.2.0.2 4434392 Job queue does not work when FIXED_DATE set

2.1.49 LDAP / Oracle Internet Directory

The following table lists the LDAP / Oracle Internet Directory bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4673628 ORA-12154 attempting to use Instant Client with OID / LDAP
10.2.0.3 5122955 Enterprise user login can be slow with very many user groups

2.1.50 Latch Contention

The following table lists the Latch Contention bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4742607 "cache buffer chains" latch contention from concurrent index range scans
10.2.0.3 4758819 Latch contention possible on buffer cache hash latches
10.2.0.3 5060485 Latch contention on "logminer workarea:krvxasr" during SQL Apply
10.2.0.2 4480100 Latch contention for "row cache objects" latch covering DC_USERS

2.1.51 Leak (Memory Leak / Growth)

The following table lists the Leak (Memory Leak / Growth) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4434887 MMON UGA memory leak
10.2.0.3 4694045 Insert of XML doc takes up large amount of memory
10.2.0.3 4726645 MMON has a slow memory leak ("koh-kghu sessi")
10.2.0.3 4746146 Pro client memory leak reexecuting SQL after ORA-1422
10.2.0.3 4924174 Performance degradation in JavaVM
10.2.0.3 4941173 RSM and DMON memory leak
10.2.0.3 4970079 SMON fails with ORA-4030 during clean up of non-existent objects
10.2.0.3 5003119 UGA memory leak by repeating DBMS_REFRESH.REFRESH in PLSQL
10.2.0.3 5004782 Memory leak on repeated connect/disconnect
10.2.0.3 5128946 Memory leak due to DDL reparse
10.2.0.3 5155213 Excessive memory use for ARRAY operations over HS
10.2.0.2 4188472 Memory leak using DOMAIN indexes
10.2.0.2 4554682 XDB ftp upload leaks memory (ORA-4030) with nested table storage
10.2.0.2 4571978 Logminer memory leak in a logical standby configuration
10.2.0.2 4593539 UGA memory leak using java.lang.ref.References in stored Java

2.1.52 Leak (Resources Eg: File Handles)

The following table lists the Leak (Resources Eg: File Handles) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 5077897 +P Windows: Server side handle leak
10.2.0.3 5053820 OCITransRollback() with non-blocking mode leaks cursors

2.1.53 Literal Replacement (CURSOR_SHARING)

The following table lists the Literal Replacement (CURSOR_SHARING) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4200541 Parse error when CURSOR_SHARING=FORCE|SIMILAR with user binds
10.2.0.3 4254094 OERI[QERRMOBND1][932] possible for queries over DB links
10.2.0.3 4607460 Dump [opipls] when CURSOR_SHARING = SIMILAR | FORCE
10.2.0.3 4698156 ORA-12850 querying GV$ views when CURSOR_SHARING=FORCE
10.2.0.3 5055175 Dump [kkslpkp] using literal replacement with timezone literals
10.2.0.2 3880881 Dump (kkslMarkLiteralBinds) using cursor sharing
10.2.0.2 4359367 High version_count with cursor sharing
10.2.0.2 4451881 OERI[kkslhsh1] from Insert as SELECT
10.2.0.2 4456646 Dump (kxscod/memcmp) using literal replacement
10.2.0.2 4458226 High version count with cursor_sharing=force

2.1.54 LogMiner

The following table lists the LogMiner bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4758632 Logminer reader consumes too much CPU when idle
10.2.0.3 5041103 Memory corruption from Log Miner
10.2.0.3 5057629 Dump (krvdtln) / ORA-1294 from DBMS_LOGMNR.start_logmnr
10.2.0.3 5089630 Dump (kfncInitSlavePool) / ORA-15012 from Log Miner / Streams against LOGs on ASM
10.2.0.3 5090574 Log Miner very slow processing rolled back DDL
10.2.0.3 5096921 Wrong results returned when using Log Miner SCN range
10.2.0.3 5117361 Capture process aborts with OERI[krvxgctasi:array size]/ORA-1280
10.2.0.2 4466087 Dump when querying V$LOGMNR_CONTENTS

2.1.55 Memory Corruption

The following table lists the Memory Corruption bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 5114396 + PGA corruption / dumps from session switching with shared servers
10.2.0.3 5388136 PI The fix for bug 5033218 can cause triggers to dump (pfrust) with NVARCHAR2/NCHAR :OLD/:NEW values
10.2.0.3 4380928 ALTER MATERIALIZED VIEW LOG add filter columns may dump
10.2.0.3 4900807 Process private memory corruption / dump in LMD0
10.2.0.3 4995320 Memory corruption / OERI[17114] from HS
10.2.0.3 5041103 Memory corruption from Log Miner
10.2.0.3 5261264 Random memory corruptions during FAL archiving
10.2.0.2 4487195 Dump (kghtshrt) / memory corruption as PQ slave may share SQL incorrectly

2.1.56 Merge SQL (MERGE .. USING)

The following table lists the Merge SQL (MERGE .. USING) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4644798 Dump (kkmups) using MERGE SQL
10.2.0.3 4685163 Merge SQL uses more CPU in 10.2 than 10.1
10.2.0.3 5049941 Direct path merge records incorrect information in ALL_SUMDELTA
10.2.0.2 4395296 MERGE with APPEND hint dumps instead of giving ORA-30926
10.2.0.2 4602031 Block corruption from UPDATE or MERGE into compressed table
10.2.0.2 4630549 ORA-904 / dump from MERGE SQL

2.1.57 Migration / Upgrade / Downgrade

The following table lists the Migration / Upgrade / Downgrade bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 5383828 PI The fix for bug 5033218 can cause ORA-604 / ORA-1405 compiling triggers
10.2.0.3 4380942 ORA-6502 from catjava.sql when upgrading from 8i to 10g
10.2.0.3 4460775 TIMESTAMP types may not exist in migrated database
10.2.0.3 4594030 10g optimizer cannot use the outline created by lower version
10.2.0.3 4638550 OERI[dmlsrvColLenChk_2:dty] during upgrade from 9.2 to 10.2
10.2.0.3 4719372 RMAN configuration lost after upgrade of recovery catalog
10.2.0.3 4860003 Sqlplus dump / OCI-21500 [koxsihread1]
10.2.0.2 4562382 I Upgrade to 10.2 with DBUA or manually (running utlu102x.sql) can be slow

2.1.58 Multi Table Insert SQL

The following table lists the Multi Table Insert SQL bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4944292 Multi-table insert may dump (koklgolx)

2.1.59 NUMA Related

The following table lists the NUMA Related bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.2 4414666 OERI[KGHALO4] can occur on NUMA
10.2.0.2 4551680 Dump (in kcrf_pvt_strand_bind) with NUMA

2.1.60 Network

The following table lists the Network bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4297024 sqlnet.ora not loaded
10.2.0.2 4562889 Small memory leak possible in Net

2.1.61 OCCI

The following table lists the OCCI bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4618016 OCCI applicaton dump / OCI-21500 in StatementImpl::doOCIExecute
10.2.0.2 4375458 OCCI isNull() returns false for null object returned from procedure

2.1.62 OCI

The following table lists the OCI bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4554284 ORA-3106 can occur with row shipping on a non blocking OCI connection
10.2.0.3 4627522 ORA-1407 updating VARCHAR2 in AL32UTF8 database
10.2.0.3 4644880 Client dump using dynamic XA registration
10.2.0.3 4666849 Client OCI tracing dumps for long queries (EVENT_10842)
10.2.0.3 4952018 OCI direct path API allows invalid data for NUMBER(p,s) fields
10.2.0.3 5004782 Memory leak on repeated connect/disconnect
10.2.0.3 5037807 ociap.h uses the "text" in oratypes.h which conflicts with fstream.h on some platforms
10.2.0.3 5053820 OCITransRollback() with non-blocking mode leaks cursors
10.2.0.2 4366667 OCILobWrite with OCI_LAST_PIECE can cause OERI:12333 on next DB access.
10.2.0.2 4383610 application info attributes are not translated correctly in utf16 environment
10.2.0.2 4456928 OCIStmtExecute behaves wrong when using OCI_BATCH_ERRORS and then OCI_DEFAULT
10.2.0.2 4476695 OCI always performs NLS validation

2.1.63 Online DDL

The following table lists the Online DDL bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4959569 OERI[kdic_create_journal_table_1] rebuilding REF index ONLINE
10.2.0.2 4364202 Failed ONLINE index rebuild not cleaned up by SMON quickly

2.1.64 Optimizer

The following table lists the Optimizer bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4323868 INDEX hints can lead to INDEX SCAN FULL
10.2.0.3 4370351 High parse CPU (in qksfroInit) for large queries
10.2.0.3 4376021 Wrong results from INLIST involving function based index
10.2.0.3 4475125 Wrong results with join of FULL INDEX SCAN (MIN/MAX) with bitmap index
10.2.0.3 4483286 OPTIMIZER_INDEX_COST_ADJ is not used for INDEX FAST FULL SCAN
10.2.0.3 4492467 Dump(kkquhcus) from cost based query transformation
10.2.0.3 4573396 CBO does not account for chained rows
10.2.0.3 4594030 10g optimizer cannot use the outline created by lower version
10.2.0.3 4595987 DELETE SQL costs are incorrect
10.2.0.3 4599763 DBMS_STATS fails with OERI:qospgtbc
10.2.0.3 4615392 Join elimination not working with ANSI join syntax
10.2.0.3 4639977 OERI[kkqcby: qbcfkkc not zero] from CONNECT BY query
10.2.0.3 4648181 OERI [15160] possible from pushed predicates
10.2.0.3 4711525 Parsing of bitmapped plans can be slow
10.2.0.3 4743096 Dump (in vopqbc) from SQL with complex view
10.2.0.3 4763768 OERI[17056] during analyze table compute stats on IOT
10.2.0.3 4772145 Gathering statistics on large indexes is slow
10.2.0.3 4892211 DBMS_STATS does not recognise lower case / special characters in column names
10.2.0.3 4900129 High CPU consumption during parse for unused CHECK constraints
10.2.0.3 4904838 INDEX_SS hint may not be honoured and skip scan costing wrong
10.2.0.3 4908162 Suboptimal plan possible for partitioned table with many joins
10.2.0.3 4968994 Poor plan using SYSDATE in predicate over dblink
10.2.0.3 4969029 Query optimization may dump [in kkoijg]
10.2.0.3 5005866 NULL first element is left in multicolumn inlist
10.2.0.3 5014836 INSERT as SELECT plan can differ from SELECT plan
10.2.0.3 5015214 UNION ALL predicate puhdown does not work for more than 2 way join
10.2.0.3 5015557 Dump under kkoNewExtractedBMKey or qerixGetKey with bitmap plan and function based index
10.2.0.3 5036879 Dump (kkoajt) during parse
10.2.0.3 5043097 OERI [15160] during query optimization
10.2.0.3 5078743 Dump (in qkabxo) using bitmap access path in FIRST K ROWS
10.2.0.3 5083297 Poor parsing performance with deeply nested view references
10.2.0.3 5094204 Wrong results from SORT-MERGE with UNUSABLE index
10.2.0.3 5095700 Partition pruning does not occur DBMS_STATS for partitioned IOTs
10.2.0.3 5104624 Explain plan fails with ORA-928
10.2.0.3 5109749 Wrong results / ORA-1428 from SQL using functional index with subquery unnesting
10.2.0.3 5162241 Dump / spin from query using "WITH" subquery with aggregation or DISTINCT
10.2.0.2 3870575 Suboptimal query plan for CONNECT BY with join conditions
10.2.0.2 4308414 Join predicate push may not occur for UNION [ALL] views
10.2.0.2 4350392 Dump (qkexrInitOpn or evapls) with unnested subqueries using object methods
10.2.0.2 4382653 Deadlock / ORA-4020 gathering statistics on indices
10.2.0.2 4417410 Analyzing a single composite partition can be slow
10.2.0.2 4418361 _SORT_ELIMINATION_COST_RATIO is not effective
10.2.0.2 4479933 Index skip scan not considered for > or >= with bind variables
10.2.0.2 4483951 Wrong results from MERGE JOIN with subquery predicate on right table with ROWID
10.2.0.2 4485790 Fix from bug 4132901 missing from 10.2
10.2.0.2 4492257 Suboptimal plan possible
10.2.0.2 4493256 Wrong result possible from complex view merging of ALL/ANY/[NOT]IN subquery
10.2.0.2 4498443 ORA-979 from SQL with HAVING
10.2.0.2 4506312 RBO can produce unnecessary negation predicates during OR expansion with CHAR columns
10.2.0.2 4519016 Wrong cardinality for INLINE view
10.2.0.2 4545463 CBO uses wrong partition for costing when pruning with bind peeking
10.2.0.2 4554846 DBMS_STATS.GATHER_INDEX_STATS can be slow for a partitioned table with bitmap indexes
10.2.0.2 4570598 Cheapest plan may be rejected in FIRST_ROWS
10.2.0.2 4584065 ORDERED hint may not give desired join order
10.2.0.2 4618615 Query with bind variable against column with histogram has wrong selectivity
10.2.0.2 4626732 OERI [evapls1] / dumps from predicate pullup
10.2.0.2 4627335 ORA-904 error from DBMS_STATS against index with special character/s
10.2.0.2 4629844 Dump / wrong results from query with CHECK constraint
10.2.0.2 4706964 DBMS_STATS.GATHER_DICTIONARY_STATS errors if schema name has special characters
10.2.0.2 4731671 Cannot disable transitive predicates with Anti-joins
10.2.0.2 4752979 Bitmap access paths not used for START WITH in CONNECT BY queries

2.1.65 Oracle Data Mining

The following table lists the Oracle Data Mining bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4772951 SVM build fails with ORA-40102: invalid input name for data mining operation
10.2.0.3 4864912 Cannot rebuild AR model reusing a previously used name results

2.1.66 Oracle Disk Manager

The following table lists the Oracle Disk Manager bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4637591 OERI:ksfd_dbuf1 possible using ODM with VLM
10.2.0.3 4671499 ORA-17500 ODM error
10.2.0.3 4945389 ORA-1114 write error on file header when tablespace is READ ONLY
10.2.0.2 4349508 IO errors during recovery of ODM file

2.1.67 Oracle Label Security

The following table lists the Oracle Label Security bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4998752 SA_SESSION.SET_ROW_LABEL returnS ORA-1400 on ("lbacsys"."sessinfo"."key")

2.1.68 Oracle Text (Formerly interMedia Text)

The following table lists the Oracle Text (Formerly interMedia Text) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 3652491 Error for parallel query with ORDER BY and DOMAIN index
10.2.0.3 5173194 Errors from partition range scan of LOCAL DOMAIN index
10.2.0.2 4381316 Local TEXT index invalidated when truncating a partition

2.1.69 PL/SQL

The following table lists the PL/SQL bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4752541 + Intermittent PLS-306 / ORA-1722 / ORA-1858 under load
10.2.0.3 4502755 Accessing DBMS_XMLDOM.DOMDocument in PLSQL can dump
10.2.0.3 4557554 ORA-3106 dynamically executing PLSQL with many bind variables
10.2.0.3 4859002 PMON crash cleaning up serially_reusable PLSQL
10.2.0.3 5018738 CONVERT function fails in PLSQL with ORA-1482
10.2.0.3 5136454 Distributed statement using a synonym fails with ORA-904
10.2.0.2 4458790 + ORA-6502 selecting MAX/MIN into a CHAR variable in PLSQL
10.2.0.2 4313246 PLSQL execution can hold dc_users row cache lock leading to hang / deadlocks
10.2.0.2 4375458 OCCI isNull() returns false for null object returned from procedure
10.2.0.2 4466869 ORA-14403 from bulk PLSQL operations after truncate operation
10.2.0.2 4480100 Latch contention for "row cache objects" latch covering DC_USERS
10.2.0.2 4501686 ORA-932 using TO_CHAR with NLS parameters in a pipelined function
10.2.0.2 4517291 Dump (evaopn2) from native pipelined table function with a CONCATENATION
10.2.0.2 4605877 Datapump export / import errors for wrapped package with comments

2.1.70 PL/SQL (DBMS Packages)

The following table lists the PL/SQL (DBMS Packages) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4552927 DBMS_CRYPTO.ENCRYPT throws ORA-28233 when encrypting NULL data
10.2.0.3 4599763 DBMS_STATS fails with OERI:qospgtbc
10.2.0.3 4707226 ORA-20000 from AUTO_SPACE_ADVISOR_JOB if tablespace dropped
10.2.0.3 4766532 OERI[kesqsmakesql:phv] from DBMS_SQLTUNE
10.2.0.3 4772145 Gathering statistics on large indexes is slow
10.2.0.3 4868804 DBMS_METADATA / datapump export does not handle indexes on Materialized Views
10.2.0.3 4892211 DBMS_STATS does not recognise lower case / special characters in column names
10.2.0.3 5005939 OERI[qkssao2s1] during DBMS_SQLTUNE
10.2.0.3 5074814 Dump (kkofmx) from DBMS_ADVISOR.EXECUTE_TASK for some IOT tables
10.2.0.3 5086622 Double encryption error
10.2.0.3 5095700 Partition pruning does not occur DBMS_STATS for partitioned IOTs
10.2.0.2 3942889 DBMS_METADATA.GET_DDL can output garbage characters in multibyte
10.2.0.2 4382653 Deadlock / ORA-4020 gathering statistics on indices
10.2.0.2 4460350 Tables shared by multiple rule classes with DMLEvents="i" causes errors
10.2.0.2 4476592 DBMS_REPAIR.REBUILD_FREELISTS does not uniformly allocate to each freelist group
10.2.0.2 4531413 Rules with negation and a single positive event fires invalid actions
10.2.0.2 4627335 ORA-904 error from DBMS_STATS against index with special character/s

2.1.71 PL/SQL External Procedures (EXTPROC)

The following table lists the PL/SQL External Procedures (EXTPROC) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4752179 Hang when calling extproc and killing client application

2.1.72 Parallel Query (PQO)

The following table lists the Parallel Query (PQO) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 3652491 Error for parallel query with ORDER BY and DOMAIN index
10.2.0.3 4257187 Dump (qkkisojkey) from PQ with OUTER JOIN and ORDER BY / GROUP BY
10.2.0.3 4502270 OERI [pxtmpalo_pkey] / wrong results can occur executing parallel queries
10.2.0.3 4691657 OERI[kxfprdp:1] if PQ slave session is killed
10.2.0.3 4771672 DBA_SEGMENTS.BLOCKS wrong after parallel create index
10.2.0.3 4951307 PMON cannot delete process queue state object
10.2.0.3 4960265 Wrong results using BLOOM filter in internode PQ
10.2.0.3 5020831 FGA reports ORA-604, ORA-12801 ORA-10382 errors for PQ slaves
10.2.0.3 5084961 Dump (qerncRowP) from PQ with nested cursor query
10.2.0.3 5140532 wrong results from PQ with hash distribution with fixed CHAR join keys
10.2.0.2 4177810 ORA-904 with non-column constants in FROM clause with PQ or remote SQL
10.2.0.2 4384780 OERI[qkaOrderByPD 3] from parallel distinct outer join with ROWNUM
10.2.0.2 4409977 Insert into a partition with bitmap indexes can corrupt the index (ORA-1499)
10.2.0.2 4478711 ORA-604 / ORA-24794 from parallel query
10.2.0.2 4507302 Dump (msqfun) from SQL generation
10.2.0.2 4547785 Dump (kudmxopp) when accessing external table in parallel
10.2.0.2 4568216 OERI[kslgetl:1] in parallel query slaves after ALTER SYSTEM to increase max slaves
10.2.0.2 4583410 OERI[15570] from parallel NESTED LOOPS with UNION ALL with pushed predicates

2.1.73 Partitioned Tables

The following table lists the Partitioned Tables bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4308089 Dump / OERI on MOVE / SPLIT partition of table with ADT column/s
10.2.0.3 4461334 Index subpartitions do not inherit index level logging attribute
10.2.0.3 4540140 Dump (qkkMatchPrefix2) from INLIST with subpartitions
10.2.0.3 4615091 Wrong result using bitmap index on partition table with INLIST
10.2.0.3 4639101 False ORA-904 when adding partition to partitioned XMLType table
10.2.0.3 4726573 Secondary index on global partitioned IOT is not used
10.2.0.3 4748597 Moving a LOB in a partitioned table fails to update IND$
10.2.0.3 4888264 Wrong results from select on partitioned table with NULL in multicolumn inlist
10.2.0.3 4908162 Suboptimal plan possible for partitioned table with many joins
10.2.0.3 5011764 OERI[ktsircinfo_num1] accessing a LOB
10.2.0.3 5040222 OERI[4823] from drop partition table after merge with update indexes
10.2.0.3 5095700 Partition pruning does not occur DBMS_STATS for partitioned IOTs
10.2.0.3 5173194 Errors from partition range scan of LOCAL DOMAIN index
10.2.0.3 5228983 Wrong results from SQL with correlation on partition key
10.2.0.3 5349632 Poor performance for ASSM insert after large DELETE
10.2.0.2 4197704 OERI:7005 from queries involving partitions and TIMESTAMPs
10.2.0.2 4304759 ORA-14297 can occur on ALTER TABLE EXCHANGE [sub]partition
10.2.0.2 4381316 Local TEXT index invalidated when truncating a partition
10.2.0.2 4389673 SKIP_UNUSABLE_INDEXES does not take effect for unusable subpartitions
10.2.0.2 4421063 Exchange partition fails with ORA-14098 with 2 or more bitmap join indexes
10.2.0.2 4430427 ORA-604 / ORA-903 from SQL against partitioned table with subquery partition pruning
10.2.0.2 4466869 ORA-14403 from bulk PLSQL operations after truncate operation
10.2.0.2 4496211 Wrong results after fast refresh of a partitioned materialized view
10.2.0.2 4502066 Crash during rebuild of partition domain index leaves index unusable
10.2.0.2 4545463 CBO uses wrong partition for costing when pruning with bind peeking
10.2.0.2 4554846 DBMS_STATS.GATHER_INDEX_STATS can be slow for a partitioned table with bitmap indexes

2.1.74 Performance Affected (General)

The following table lists the Performance Affected (General) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4373733 Streams apply performing synchronous redo writes
10.2.0.3 4390868 Contention on DC_SEGMENTS due to small cache size on SYS.AUDSES$
10.2.0.3 4758819 Latch contention possible on buffer cache hash latches
10.2.0.3 4867884 Lob HW lock contention with space reclaimation
10.2.0.3 4868650 Bursty writes from DBWR with small FAST_START_MTTR_TARGET
10.2.0.3 4894027 Poor SQL apply performance in RAC
10.2.0.3 4924174 Performance degradation in JavaVM
10.2.0.3 5001975 Multiple remote destinations shipped serially in local_first setup
10.2.0.3 5016142 SMON rollback of large transactions blocks other actions
10.2.0.3 5021340 OJMS generates unsharable dequeue SQL
10.2.0.3 5065930 "log file sync" timeouts can occur
10.2.0.3 5075434 Small performance overhead in RAC (waits for "KJC: Wait for msg sends to complete")
10.2.0.3 5095887 Foreground waits too long before exiting server mode after instance recovery
10.2.0.3 5187351 Many clscNN.log files created - can affect performance
10.2.0.3 5448588 Slow LGWR sync performance for large redo write sizes
10.2.0.2 4185270 PMON "failed to acquire row cache enqueue" cleaning a dead process
10.2.0.2 4467101 RAC lock converts are significantly delayed in race condition
10.2.0.2 4508821 DBWRs of both nodes on RAC sometimes do not process CIC concurrently

2.1.75 Performance Monitoring

The following table lists the Performance Monitoring bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4008133 Dump (skgslsgf) selecting from V$LOCK related views
10.2.0.3 4237613 Wrong V$SGASTAT values for "ASM extent pointer array"
10.2.0.3 4417285 Duplicate "direct path write temp" wait events
10.2.0.3 4533389 ANALYZE INDEX VALIDATE STRUCTURE does not update INDEX_STATS for bitmap indexes
10.2.0.3 4698156 ORA-12850 querying GV$ views when CURSOR_SHARING=FORCE
10.2.0.3 4942939 Very high values for ODM/ASM readtim/writetim in V$FILESTAT
10.2.0.2 3519807 ORA-4031 querying V$SEGSTAT
10.2.0.2 4336997 Queries against GV$SQL_PLAN slow
10.2.0.2 4383610 application info attributes are not translated correctly in utf16 environment
10.2.0.2 4472437 Used percent metrics for SYSTEM tablespace not updated when locally managed
10.2.0.2 4517846 Dump from remote query when SQL_TRACE / event 10046 set

2.1.76 Performance Of Certain Operations Affected

The following table lists the Performance Of Certain Operations Affected bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4151363 Drop / truncate slow in RAC
10.2.0.3 4411462 Poor fast refresh performance due to hints
10.2.0.3 4583177 Poor performance inserting subtype constructor into polymorphic column
10.2.0.3 4597354 DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE() is resource intensive
10.2.0.3 4722900 Incremental MV refresh can be slow
10.2.0.3 5080775 ALTER SYSTEM KILL SESSION IMMEDIATE slow
10.2.0.3 5090574 Log Miner very slow processing rolled back DDL
10.2.0.3 5122955 Enterprise user login can be slow with very many user groups
10.2.0.3 5158711 Parsing XML using DBMS_XMLGEN / DBMS_XMLDOM can be slow
10.2.0.3 5178202 RAC AQ dequeue on different instance to enqueue is slow
10.2.0.3 5349632 Poor performance for ASSM insert after large DELETE
10.2.0.2 4288876 Excessive redo / undo generation from insert/update with ASSM indexes
10.2.0.2 4417410 Analyzing a single composite partition can be slow
10.2.0.2 4430964 ALTER TABLESPACE READ WRITE slow with very large buffer cache
10.2.0.2 4432906 PMON slow to clean locked rows from rolled back XA transaction
10.2.0.2 4435949 10.2 RAC async memory copy slower than earlier releases
10.2.0.2 4446528 PMON can be slow to clear row locks for rolled back XA transaction
10.2.0.2 4455512 ASM instance startup can be slow in RAC environments
10.2.0.2 4486753 DMLS contention with ASSM segments
10.2.0.2 4505011 xquery variable processing performs poorly
10.2.0.2 4519477 AQ dequeue by correlation id is extremely expensive
10.2.0.2 4548861 RMAN restore archivelog until sequence takes a long time to complete
10.2.0.2 4554846 DBMS_STATS.GATHER_INDEX_STATS can be slow for a partitioned table with bitmap indexes
10.2.0.2 4634368 Performance issues with LOBs during reclaimation

2.1.77 Performance Of Query/ies Affected

The following table lists the Performance Of Query/ies Affected bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4969880 + Allow the fix for bug 3646162 to be disabled
10.2.0.3 4055634 TRUNCATE table has to much overhead when operating on empty segments
10.2.0.3 4134994 Extensible optimizer may use default costs
10.2.0.3 4242649 Object views are slower than they need be
10.2.0.3 4475314 DELETE then INSERT without commit on ASSM segment can be slow
10.2.0.3 4483286 OPTIMIZER_INDEX_COST_ADJ is not used for INDEX FAST FULL SCAN
10.2.0.3 4573396 CBO does not account for chained rows
10.2.0.3 4595987 DELETE SQL costs are incorrect
10.2.0.3 4694312 Index inserts to ASSM segments can be slow
10.2.0.3 4711525 Parsing of bitmapped plans can be slow
10.2.0.3 4726573 Secondary index on global partitioned IOT is not used
10.2.0.3 4763057 XMLTable can get a suboptimal re-write
10.2.0.3 4768040 CTAS different to the SELECT statement plan
10.2.0.3 4772145 Gathering statistics on large indexes is slow
10.2.0.3 4900129 High CPU consumption during parse for unused CHECK constraints
10.2.0.3 4908162 Suboptimal plan possible for partitioned table with many joins
10.2.0.3 4968994 Poor plan using SYSDATE in predicate over dblink
10.2.0.3 4992856 Collection view is not merged in DML
10.2.0.3 5002720 Queries against V$STANDBY_LOG can be slow - slows down logical standby queries
10.2.0.3 5005866 NULL first element is left in multicolumn inlist
10.2.0.3 5015214 UNION ALL predicate puhdown does not work for more than 2 way join
10.2.0.3 5045474 Optimizer may not use function based index with NLSSORT of a CHAR column
10.2.0.3 5083297 Poor parsing performance with deeply nested view references
10.2.0.3 5084239 FACT hint forces suboptimal plan with star transformation
10.2.0.3 5095700 Partition pruning does not occur DBMS_STATS for partitioned IOTs
10.2.0.3 5129233 Poor execution plan with complex expression in a partition pruning predicate
10.2.0.3 5131645 10g hard parse CPU regression [ appopd->qksfrochild ]
10.2.0.3 5195882 Queries in FGAC use full table scan instead of index access
10.2.0.3 5218128 No rewrite for updateXML() when target is out of line
10.2.0.3 5353622 XQuery not always rewritten completely
10.2.0.2 3870575 Suboptimal query plan for CONNECT BY with join conditions
10.2.0.2 4308414 Join predicate push may not occur for UNION [ALL] views
10.2.0.2 4336997 Queries against GV$SQL_PLAN slow
10.2.0.2 4418361 _SORT_ELIMINATION_COST_RATIO is not effective
10.2.0.2 4469489 Performance problems with fix for bug 2336663
10.2.0.2 4479933 Index skip scan not considered for > or >= with bind variables
10.2.0.2 4492257 Suboptimal plan possible
10.2.0.2 4519016 Wrong cardinality for INLINE view
10.2.0.2 4545463 CBO uses wrong partition for costing when pruning with bind peeking
10.2.0.2 4569842 Suboptimal query plans can occur when using XMLtable()
10.2.0.2 4570598 Cheapest plan may be rejected in FIRST_ROWS
10.2.0.2 4618615 Query with bind variable against column with histogram has wrong selectivity
10.2.0.2 4693374 No view merging of DBA_TAB_COLUMNS
10.2.0.2 4752979 Bitmap access paths not used for START WITH in CONNECT BY queries

2.1.78 Physical Standby Database / Dataguard

The following table lists the Physical Standby Database / Dataguard bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 5380055 * ORA-1555 / corruption if switch to Standby then back to Primary. This bug is alerted in Note:386830.1
10.2.0.3 5212539 + LOB corruption for NOCACHE LOBs (ORA-1555/ORA-22924)
10.2.0.3 4395779 ORA-16086 error when recovery area not used for redo logs
10.2.0.3 4676659 ORA-16009 in alert log with standby and LGWR ASYNC
10.2.0.3 4725406 Dataguard clients may get routed back to a dead primary
10.2.0.3 4941173 RSM and DMON memory leak
10.2.0.3 4953737 RAC hangs at arc shutdown accessing standby
10.2.0.3 5002448 Terminal recovery may purge SRL's for threads incorrectly
10.2.0.3 5010182 RAC instance recovery remote archival problem causes switchover to hang
10.2.0.3 5011019 OERI[2103] on bystander standby during target standby failover
10.2.0.3 5032921 ORA-3700 in LGWR after 'alter database activate standby database'
10.2.0.3 5095577 DMON process never starts (dump rfm_get_opaque)
10.2.0.3 5117717 DG broker must disable/enable threads for logical switchover and failover
10.2.0.3 5143296 Reinstate of old primary hangs when old primary is disabling itself
10.2.0.3 5146287 Data guard potential false gap request must be restricted
10.2.0.3 5181800 Async LNS holds CF enqueue while issuing network calls rfsopen/rfsclose
10.2.0.3 5196220 Reinstate of a physical standby database does not work
10.2.0.3 5209063 Logical standby gap fetch broken on RAC when one thread is disabled
10.2.0.3 5215729 An inopportune ping can cause gap in archivals after switchover at a bystander
10.2.0.3 5261264 Random memory corruptions during FAL archiving
10.2.0.3 5363031 deadlock on broker metadata lock when FSFO is enabled
10.2.0.3 5386881 ORA-60 deadlock from terminal recovery
10.2.0.3 5448588 Slow LGWR sync performance for large redo write sizes
10.2.0.2 4528572 Data guard may generate partial archive logs which can cause ORA-326

2.1.79 Pro* Precompiler

The following table lists the Pro* Precompiler bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4644880 Client dump using dynamic XA registration
10.2.0.3 4746146 Pro client memory leak reexecuting SQL after ORA-1422
10.2.0.3 4918154 Pro "unsafe_null = yes" returns wrong results

2.1.80 Query Rewrite (Including Materialized Views)

The following table lists the Query Rewrite (Including Materialized Views) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 3945479 Bad materialized view metadata is definition uses "WITH"
10.2.0.3 4321119 ALTER MATERIALIZED VIEW causes ORA-32337 after DML via database link
10.2.0.3 4380928 ALTER MATERIALIZED VIEW LOG add filter columns may dump
10.2.0.3 4411462 Poor fast refresh performance due to hints
10.2.0.3 4499307 SUMDELTA$ rows not always purged for complex materialized views
10.2.0.3 4722900 Incremental MV refresh can be slow
10.2.0.3 4744972 ORA-942 on join with table associated with an MVIEW in a different schema
10.2.0.3 4747312 ORA-911 using DECLARE_REWRITE_EQUIVALENCE
10.2.0.3 4868804 DBMS_METADATA / datapump export does not handle indexes on Materialized Views
10.2.0.3 5003119 UGA memory leak by repeating DBMS_REFRESH.REFRESH in PLSQL
10.2.0.3 5004076 MVIEWS have INVALID status after migration to 64 bit
10.2.0.3 5017007 MVIEW LOB content incorrect after refresh
10.2.0.3 5049941 Direct path merge records incorrect information in ALL_SUMDELTA
10.2.0.3 5052568 Query rewrite does not work for SQL with LIKE clause
10.2.0.3 5223223 Wrong results / bad MV content after direct load
10.2.0.3 5276400 Wrong results with query rewrite
10.2.0.2 4402808 Parallel refresh of MVIEW with GROUPING SETS can give bad MVIEW data
10.2.0.2 4496211 Wrong results after fast refresh of a partitioned materialized view
10.2.0.2 4506871 Query rewrite does not work ifa VPD security policy is enabled
10.2.0.2 4549585 ORA-32321 on dbms_refresh.refresh after master site upgrade
10.2.0.2 4616376 Corrupt MVIEW dictionary information from MVIEW on SYNONYM

2.1.81 RAC (Real Application Clusters) / OPS

The following table lists the RAC (Real Application Clusters) / OPS bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4339429 RAC instance crash with OERI:[kclbla_2] / dump (skgxpimprp)
10.2.0.3 4393878 OERI[kclchkping_2] in shared server / PMON
10.2.0.3 4435036 RAC diagnostics can be slow
10.2.0.3 4452690 ORA-67 / LMON crash during startup
10.2.0.3 4479323 OPEN RESETLOGS can fail with OERI[3705] in RAC
10.2.0.3 4602169 ORA-29702 during shutdown in RAC
10.2.0.3 4639236 OERI [kclcls_5] possible in RAC recreating an object
10.2.0.3 4672087 Delay in LMON during nested reconfiguration
10.2.0.3 4672266 LMS hang waiting for 'kjc: wait for msg sends to complete' during shutdown
10.2.0.3 4679094 In RAC a transaction may get stuck in prepare mode (ORA-1591)
10.2.0.3 4682574 Delay between end of CSS reconfig and LMON recovery
10.2.0.3 4689781 JDBC client failover using FAN ONS does not handle site failures
10.2.0.3 4690794 "error in kqlmbivg see lck trace file" messages
10.2.0.3 4709210 ASM LMS OERI[504] on [kfcl le freelist] latch
10.2.0.3 4737607 vips do not failover when IP is down
10.2.0.3 4750469 OERI:kjrfr7 can occur in RAC
10.2.0.3 4755405 Excessive waits for "gcs drm freeze in enter server mode" in gsiat
10.2.0.3 4766586 CGS reconfig timeout due to long time to capture diagnostics
10.2.0.3 4773318 "tossing bad MUPD msg pid XX" during reconfiguration
10.2.0.3 4863048 LMS OERI[kjbmpocr:dsb] / instance crash with RAC
10.2.0.3 4865820 LMS dump (kclnrembg)
10.2.0.3 4872999 RAC instance cannot get global enqueue
10.2.0.3 4874273 SMON waits in "ges enter server mode" > 1s before first pass
10.2.0.3 4882834 Excessive SS and TS contention in RAC
10.2.0.3 4887955 Unnecessary extent allocated in locally managed ASSM tablespace in RAC
10.2.0.3 4894027 Poor SQL apply performance in RAC
10.2.0.3 4900807 Process private memory corruption / dump in LMD0
10.2.0.3 4903532 RAC instance may be evicted as LMS may not process messages quickly enough
10.2.0.3 4913415 Global deadlock not reported in RAC
10.2.0.3 4928371 Connections still possible to aborting instance in RAC
10.2.0.3 4933038 _FAST_START_INSTANCE_RECOVERY_TARGET problem
10.2.0.3 4943406 LMON needs to message SMON to start recovery in ASM instance
10.2.0.3 4943839 RMAN restore can fail in RAC if backups not shared between nodes
10.2.0.3 4953737 RAC hangs at arc shutdown accessing standby
10.2.0.3 4956243 ALTER DATABASE BEGIN BACKUP hangs if other instance is mounted
10.2.0.3 4960265 Wrong results using BLOOM filter in internode PQ
10.2.0.3 4960705 ASM waits longer than necessary during reconfiguration
10.2.0.3 4960746 Dynamic remastering slower than necessary
10.2.0.3 4963850 Failover blocked - service start waits on second pass recovery to acquire UL
10.2.0.3 4967266 DB recovery blocked by ASM recovery
10.2.0.3 4995640 Diagnostics for RAC OERI[kjucll1]
10.2.0.3 4996133 OERI[kcbgtcr_5] updating an IOT in RAC environment
10.2.0.3 4997495 Instance crash with OERI[504][mostly latch-free SCN]
10.2.0.3 4998752 SA_SESSION.SET_ROW_LABEL returnS ORA-1400 on ("lbacsys"."sessinfo"."key")
10.2.0.3 5010182 RAC instance recovery remote archival problem causes switchover to hang
10.2.0.3 5012368 Undetected deadlock in RAC
10.2.0.3 5022093 OERI:[kjsbstat:unknownmaster] possible in RAC
10.2.0.3 5031173 Instance terminated by LMON ORA-602
10.2.0.3 5036588 LMD0 process dump (kewmuprbsm_update_rbsm)
10.2.0.3 5061068 RAC using "broadcast on commit" can see delayed commit times
10.2.0.3 5071492 LMS crash with OERI[kclastf_1]
10.2.0.3 5075434 Small performance overhead in RAC (waits for "KJC: Wait for msg sends to complete")
10.2.0.3 5095398 Dump (in LdiDateDateSubtract) in RAC when stopping a chain Job
10.2.0.3 5095887 Foreground waits too long before exiting server mode after instance recovery
10.2.0.3 5104579 Flashback query results on RAC inconsistent after rebooting 1 instance
10.2.0.3 5117717 DG broker must disable/enable threads for logical switchover and failover
10.2.0.3 5170699 Allow _lm_dd_interval=0 to minimize deadlock detection time in RAC
10.2.0.3 5178202 RAC AQ dequeue on different instance to enqueue is slow
10.2.0.3 5183472 Crash due to ORA-453 against DIAG
10.2.0.3 5208973 RAC may hang due to deadlock between LMS / MMAN latching
10.2.0.3 5209063 Logical standby gap fetch broken on RAC when one thread is disabled
10.2.0.3 5360719 ASM and database instances hang when disk array gets disconnected
10.2.0.2 3875098 instance stayed up after one node lost connection to voting device
10.2.0.2 4164021 OERI [2103] during BACKUP CONTROLFILE to TRACE
10.2.0.2 4235176 OERI:ksprlspeeq3 can occur in RAC
10.2.0.2 4348230 OERI:2103 should try to remove the blocking session
10.2.0.2 4377352 OERI [ksfdrfms2] during instance recovery of second thread
10.2.0.2 4384672 SMON may fail with ORA-27103 during recovery of failed RAC instance
10.2.0.2 4396718 RAC session may hang for global enqueue requested NOWAIT
10.2.0.2 4425689 AQ message state may not be set to READY in RAC
10.2.0.2 4435949 10.2 RAC async memory copy slower than earlier releases
10.2.0.2 4455512 ASM instance startup can be slow in RAC environments
10.2.0.2 4467101 RAC lock converts are significantly delayed in race condition
10.2.0.2 4473142 OERI[kcoadd_size] can occur in RAC
10.2.0.2 4476592 DBMS_REPAIR.REBUILD_FREELISTS does not uniformly allocate to each freelist group
10.2.0.2 4486753 DMLS contention with ASSM segments
10.2.0.2 4500930 RECO slow to clean up failed 2PC from RAC node failure
10.2.0.2 4508821 DBWRs of both nodes on RAC sometimes do not process CIC concurrently
10.2.0.2 4510545 OERI[kcbbxsv_2] can occur in RAC
10.2.0.2 4579381 Deadlock on DC_USERS in RAC (ORA-4020)
10.2.0.2 4631662 RAC send timeouts possible with UDP

2.1.82 RMAN (Recovery Manager)

The following table lists the RMAN (Recovery Manager) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4229751 CONVERT TABLESPACE fails to create file with DB_FILE_NAME_CONVERT on ASM
10.2.0.3 4466433 Restoring current controlfile on ASM creates a file with "backup" string
10.2.0.3 4558970 RMAN RECOVER compilation can be slow
10.2.0.3 4578844 MAXSETSIZE creates backupsets of size greater than MAXSETSIZE.
10.2.0.3 4590425 RMAN exit status is 0 when validate errors
10.2.0.3 4654856 ORA-17502 making RMAN duplexed backupsets to ASM diskgroup
10.2.0.3 4719372 RMAN configuration lost after upgrade of recovery catalog
10.2.0.3 4754328 RMAN resync catalog fails with ORA-1 (TS_P unique constraint violated)
10.2.0.3 4755799 RMAN-20070 error on primary after dataguard switchover
10.2.0.3 4759016 OERI [kghfrf1] doing RMAN backup
10.2.0.3 4941096 CATALOG BACKUPPIECE with backup controlfile does not populate the RMAN catalog
10.2.0.3 4943839 RMAN restore can fail in RAC if backups not shared between nodes
10.2.0.3 5082607 OERI:[kutyxtt_convert_b2_01] on convert datafile from Tru64 to AIX
10.2.0.2 3657899 Registering database in RMAN fails with ORA-1400
10.2.0.2 4477186 ORA-1157 reported for each offline file during backup with skip offline clause
10.2.0.2 4490933 RMAN backup fails when backupsize > free on ASM but reclaimable space available
10.2.0.2 4531791 ORA-1422 error during RMAN resync of deleted object
10.2.0.2 4548861 RMAN restore archivelog until sequence takes a long time to complete
10.2.0.2 4596065 RMAN backup generates empty trace files when DB_RECOVERY_FILE_DEST is set

2.1.83 Read Only Tablespace/s

The following table lists the Read Only Tablespace/s bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.2 4345035 OERI:3619 on startup with transported read only tablespace
10.2.0.2 4430964 ALTER TABLESPACE READ WRITE slow with very large buffer cache

2.1.84 Recovery

The following table lists the Recovery bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4479323 OPEN RESETLOGS can fail with OERI[3705] in RAC
10.2.0.3 4637668 IMU transactions can produce out-of-order redo (OERI [3020] on recovery)
10.2.0.3 5001975 Multiple remote destinations shipped serially in local_first setup
10.2.0.3 5077208 MRP may fail with OERI[kcpcvc3] after a tablespace drop
10.2.0.2 4349508 IO errors during recovery of ODM file
10.2.0.2 4394171 Automatic offlining of the datafile in noarchivelog leaves datafile unrecoverable
10.2.0.2 4453449 OERI:3020 / corruption errors from multiple FLASHBACK DATABASE
10.2.0.2 4476592 DBMS_REPAIR.REBUILD_FREELISTS does not uniformly allocate to each freelist group
10.2.0.2 4542620 ARCH process may hold disk space for failed archives
10.2.0.2 4594917 Write IO error can cause incorrect file header checkpoint information
10.2.0.2 4596558 Background managed recovery does not use parallel recovery by default

2.1.85 Regular Expressions

The following table lists the Regular Expressions bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4440681 Dump from REGEXP_REPLACE referring to table expression
10.2.0.3 5351519 Dump using REGEXP_REPLACE() operator
10.2.0.2 4544429 Dump (lxregmatpush) from regular expression evaluation

2.1.86 Replication

The following table lists the Replication bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4698119 Trace files are created for every replicated dml
10.2.0.3 4775068 Deferred transactions not applied in the correct order when using parallel propagation
10.2.0.2 4102969 Dump when updating table with synchronous replication

2.1.87 Resource Manager

The following table lists the Resource Manager bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 3448940 OERI[kskbind:!unb&!uinit] using resource manager with shared server connections
10.2.0.3 4602661 Adding a datafile hangs other sessions and new connections with resource manager

2.1.88 Row Level Security / FGA

The following table lists the Row Level Security / FGA bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4482737 FGA does not record binds of type TIMESTAMP in FGA_LOG$
10.2.0.3 4742679 ORA-604 / ORA-28133 enabling constraints on table with FGA
10.2.0.3 5020831 FGA reports ORA-604, ORA-12801 ORA-10382 errors for PQ slaves
10.2.0.3 5040303 Dump (expepr) from distributed insert into VIEW
10.2.0.3 5195882 Queries in FGAC use full table scan instead of index access
10.2.0.2 4107478 Cannot drop SYNONYM policies (ORA-28102)
10.2.0.2 4506871 Query rewrite does not work ifa VPD security policy is enabled
10.2.0.2 4760628 Dictionary corruption adding POLICY to a SYNONYM

2.1.89 SQL*Loader

The following table lists the SQL*Loader bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4639659 SQLLDR direct load of IOT gets OERI[iot_gtab_mr_rcnt_mismatch]
10.2.0.3 4955701 Incorrect data possible from INSERT .. VALUES with correlated subquery
10.2.0.3 4963106 SQLLDR SKIP skips wrong number of records
10.2.0.3 5068048 SQL*loader hang on direct path load on multi CPU machine
10.2.0.3 5223223 Wrong results / bad MV content after direct load
10.2.0.3 5226671 SQLLDR cannot load CLOBs larger than 20mb (READSIZE limit too low)
10.2.0.2 4550702 SQLLOAD direct load gets ORA-1866 for storing systimestamp

2.1.90 Security ( Authentication / Privileges / Auditing )

The following table lists the Security ( Authentication / Privileges / Auditing ) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4447168 Dump (kghalp) with auditing enabled
10.2.0.3 4600757 ORA-9817 when AUDIT_TRAIL=XML and AUDIT_SYS_OPERATIONS=TRUE
10.2.0.3 4693439 ORA-1406 from FULL export with auditing
10.2.0.3 4926541 REVOKE ALL PRIVILEGES does not revoke UNLIMITED TABLESPACE privilege
10.2.0.3 5122955 Enterprise user login can be slow with very many user groups
10.2.0.2 4500915 Dump (strlen/sprintf) during select with AUDIT_TRAIL=db_extended

2.1.91 Shared Pool Affected

The following table lists the Shared Pool Affected bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4994956 Number of configured shared pool subpools not correct
10.2.0.3 5345437 Intermittent wrong data / NLS errors (eg ORA-1801)
10.2.0.2 3519807 ORA-4031 querying V$SEGSTAT
10.2.0.2 4359367 High version_count with cursor sharing
10.2.0.2 4458226 High version count with cursor_sharing=force

2.1.92 Shared Server (formerly MTS)

The following table lists the Shared Server (formerly MTS) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 5114396 + PGA corruption / dumps from session switching with shared servers
10.2.0.3 3448940 OERI[kskbind:!unb&!uinit] using resource manager with shared server connections
10.2.0.3 4361163 It is not possible to have > 1000 shared servers on some platforms
10.2.0.3 4627237 autonomous_transaction with DB link to shared server can self deadlock on DX

2.1.93 Space Management

The following table lists the Space Management bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.2 4476592 DBMS_REPAIR.REBUILD_FREELISTS does not uniformly allocate to each freelist group

2.1.94 Space Management (Locally Managed Tablespaces)

The following table lists the Space Management (Locally Managed Tablespaces) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.2 4472437 Used percent metrics for SYSTEM tablespace not updated when locally managed

2.1.95 Star Transformation

The following table lists the Star Transformation bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 5084239 FACT hint forces suboptimal plan with star transformation
10.2.0.3 5104624 Explain plan fails with ORA-928
10.2.0.3 5169712 Wrong results with star transformation , rownum and semijoin
10.2.0.3 5172444 OERI[15160] on complex query with joinback elimination
10.2.0.2 4248629 Star transformation may dump (in kkojnp)
10.2.0.2 4395548 OERI[expcmo_strdef1] from star transformation
10.2.0.2 4450399 OERI:15160 during joinback elimination of 1-row tables in star transformation

2.1.96 Star Transformation With Temp. Tables

The following table lists the Star Transformation With Temp. Tables bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.2 4308710 Wrong results from temp table star transformation
10.2.0.2 4502658 Dump with STAR temp table transformation

2.1.97 Storage Space Usage Affected

The following table lists the Storage Space Usage Affected bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4188324 Wasted space possible in ASSM segments
10.2.0.3 4499307 SUMDELTA$ rows not always purged for complex materialized views
10.2.0.3 4660718 Allow choice between space / performance for ASSM segments
10.2.0.3 4691191 Failure during file grow may leak ASM disk space
10.2.0.3 4752481 Skewed ASM disk allocation when single file resized many times
10.2.0.3 4872898 Migrated-row created when chained row within a block updates
10.2.0.3 4887955 Unnecessary extent allocated in locally managed ASSM tablespace in RAC
10.2.0.3 5106952 Flashback log space not being reclaimed
10.2.0.2 4288876 Excessive redo / undo generation from insert/update with ASSM indexes

2.1.98 Streams / Logical Standby

The following table lists the Streams / Logical Standby bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4335615 ORA-1403 / data corruption in logical standby
10.2.0.3 4373733 Streams apply performing synchronous redo writes
10.2.0.3 4379765 Streams has extra propagation tracing
10.2.0.3 4446613 Apply in DROP PARTITION state for long time
10.2.0.3 4461688 OERI[qkaPobs1] during instance startup of logical standby
10.2.0.3 4516151 SQLServer streams gives error if DML has nulls for date column
10.2.0.3 4725679 Switchover to logical standby hangs
10.2.0.3 4758632 Logminer reader consumes too much CPU when idle
10.2.0.3 4894027 Poor SQL apply performance in RAC
10.2.0.3 4950241 DBMS_APPLY_ADM.EXECUTE_ALL_ERRORS() fails with ORA-1403
10.2.0.3 5041103 Memory corruption from Log Miner
10.2.0.3 5060485 Latch contention on "logminer workarea:krvxasr" during SQL Apply
10.2.0.3 5089630 Dump (kfncInitSlavePool) / ORA-15012 from Log Miner / Streams against LOGs on ASM
10.2.0.3 5090574 Log Miner very slow processing rolled back DDL
10.2.0.3 5104430 ORA-1309 from PURGE_SESSION
10.2.0.3 5117361 Capture process aborts with OERI[krvxgctasi:array size]/ORA-1280
10.2.0.3 5359321 Streams capture fails OERI[krvxalfs: non unique entries in]
10.2.0.2 4497530 Streams capture dump [krvxgctasi] mining CTAS operation
10.2.0.2 4571978 Logminer memory leak in a logical standby configuration

2.1.99 Transparent Application Failover

The following table lists the Transparent Application Failover bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4689781 JDBC client failover using FAN ONS does not handle site failures
10.2.0.3 4737607 vips do not failover when IP is down
10.2.0.3 4963850 Failover blocked - service start waits on second pass recovery to acquire UL

2.1.100 Transparent Data Encryption

The following table lists the Transparent Data Encryption bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4748222 Update column with TDE gets OERI:[ztsmdwl failed] if there is a trigger

2.1.101 Transportable Tablespaces

The following table lists the Transportable Tablespaces bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 5082607 OERI:[kutyxtt_convert_b2_01] on convert datafile from Tru64 to AIX
10.2.0.3 5152323 IMPDP fails during TTS import of partitioned table with XMLTYPE STORE AS CLOB
10.2.0.3 5186784 OERI[ktecgetsh-inc] from DML against transported tablespace
10.2.0.2 4345035 OERI:3619 on startup with transported read only tablespace
10.2.0.2 4401000 OERI[16608] during import of transportable tablespace

2.1.102 Triggers

The following table lists the Triggers bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 5383828 PI The fix for bug 5033218 can cause ORA-604 / ORA-1405 compiling triggers
10.2.0.3 5388136 PI The fix for bug 5033218 can cause triggers to dump (pfrust) with NVARCHAR2/NCHAR :OLD/:NEW values
10.2.0.3 4712729 ORA-21780 can get raised for a table with a BEFORE ROW trigger on it.
10.2.0.3 4717280 NULL may be inserted by INSERT with a TRIGGER for NUMBER columns
10.2.0.3 4748222 Update column with TDE gets OERI:[ztsmdwl failed] if there is a trigger
10.2.0.3 4771052 INSTEAD-OF trigger does not update tables correctly over dblink
10.2.0.3 4908068 ORA-1400 from BEFORE INSERT trigger using INSERT with SUBQUERY in VALUES clause
10.2.0.3 5033218 ORA-6502 if TRIGGER modifies column value with >= 1001 character value
10.2.0.3 5033476 Dump executing a DML which uses a CONNECT BY when there is a trigger
10.2.0.2 4387399 OERI[17018] signalled by logon trigger
10.2.0.2 4515623 Update .. RETURNING with a trigger can produce corrupt column data
10.2.0.2 4547458 INSERT triggers produce NULL for the USER function

2.1.103 Truncate

The following table lists the Truncate bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 3279497 Interupted (Ctrl-C) TRUNCATE can corrupt ASSM table
10.2.0.3 4055634 TRUNCATE table has to much overhead when operating on empty segments
10.2.0.3 4151363 Drop / truncate slow in RAC
10.2.0.2 4381316 Local TEXT index invalidated when truncating a partition
10.2.0.2 4442372 OERI [ktspshsp-1] after aborted TRUNCATE
10.2.0.2 4446011 Hang with row cache lock deadlock from concurrent ALTER USER / TRUNCATE
10.2.0.2 4466869 ORA-14403 from bulk PLSQL operations after truncate operation
10.2.0.2 4517470 Table corruption with RAC when ASSM managed and truncate used

2.1.104 Workload repository / reporting

The following table lists the Workload repository / reporting bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4359124 AWR errors with ORA-1 (on SYS.WRH$_SQLTEXT_PK) kewrafm1 error=13509
10.2.0.3 4597354 DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE() is resource intensive
10.2.0.3 4950024 ORA-39083/PLS-302 during import of metric threshold settings

2.1.105 Wrong Results

The following table lists the Wrong Results bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 5458753 * SQL may execute in wrong schema. This bug is alerted in Note:392673.1
10.2.0.3 4604970 + Wrong results with 'hash group by' aggregation enabled
10.2.0.3 5092688 + Wrong results if function based index exists
10.2.0.3 4237613 Wrong V$SGASTAT values for "ASM extent pointer array"
10.2.0.3 4272872 TIMESTAMPTZ is not affected by setSessionTimeZone
10.2.0.3 4376021 Wrong results from INLIST involving function based index
10.2.0.3 4451506 Wrong results from SQL using TABLE() constructs
10.2.0.3 4475125 Wrong results with join of FULL INDEX SCAN (MIN/MAX) with bitmap index
10.2.0.3 4502270 OERI [pxtmpalo_pkey] / wrong results can occur executing parallel queries
10.2.0.3 4568043 XMLDOM.SUBSTRINGDATA dump / wrong result for offset >= 4000
10.2.0.3 4580399 ORA-942 from "&apos;" in text node with DBMS_XMLSTORE.INSERTXML()
10.2.0.3 4582764 Wrong results from ANSI OUTER join with inline view
10.2.0.3 4610323 Wrong node order accessing SCHEMA BASED XML via HTTP
10.2.0.3 4615091 Wrong result using bitmap index on partition table with INLIST
10.2.0.3 4622729 Wrong results from NOT IN subquery
10.2.0.3 4625102 Wrong results using ANSI join when NL join is performed
10.2.0.3 4629856 Wrong results selecting a LONG and a NULL over HS
10.2.0.3 4679879 ls/dir does show file information correctly on XDB FTP if NLS_LANGUAGE=JAPANESE
10.2.0.3 4685811 V$FILESPACE_USAGE.USED_SPACE wrong when rollback segments have been shrunk
10.2.0.3 4689959 Version 3 TIMEZONE files
10.2.0.3 4703253 Wrong results from remote colocated join
10.2.0.3 4704594 Using CAST in a select statement can return incorrect column size
10.2.0.3 4713210 extract() can return erroneous namespace
10.2.0.3 4715104 ORA-22835 / truncated data from USER/ALL/DBA_EXTERNAL_TABLES
10.2.0.3 4715572 Wrong results / errors from select from external table with FIXED recordsize
10.2.0.3 4769762 Wrong results from base-uri() and docuemnt-uri() handling doc() and collection()
10.2.0.3 4771672 DBA_SEGMENTS.BLOCKS wrong after parallel create index
10.2.0.3 4776636 Wrong value for TIMESTAMP WITH TIME ZONE when NLS_CALENDAR set
10.2.0.3 4888264 Wrong results from select on partitioned table with NULL in multicolumn inlist
10.2.0.3 4904454 Wrong results from queries using remote colocated joins
10.2.0.3 4911954 V$RECOVERY_FILE_DEST SPACE_USED / NUMBER_OF_FILES are wrong
10.2.0.3 4914205 Query/update using bind variable with existsnode returns the same row
10.2.0.3 4914281 TIMESTAMP WITH TIMEZONE values before 1800 corrupted
10.2.0.3 4918154 Pro "unsafe_null = yes" returns wrong results
10.2.0.3 4928321 Pickle of opaque type results in bad image size
10.2.0.3 4932843 Wrong results from full outer join with TABLE() function
10.2.0.3 4949257 Unnested subquery returns wrong result
10.2.0.3 4950942 Wrong describe information for VIEW over a NUMBER datatype with FLOAT
10.2.0.3 4960265 Wrong results using BLOOM filter in internode PQ
10.2.0.3 4996080 Wrong results from remote join
10.2.0.3 5055892 Wrong results from NVL with analytic function in HAVING clause
10.2.0.3 5068565 Wrong results from pipelined table funciton with prefetch enabled (default)
10.2.0.3 5089814 Wrong results "col(+) = NULL" with an OUTER JOIN
10.2.0.3 5094204 Wrong results from SORT-MERGE with UNUSABLE index
10.2.0.3 5096921 Wrong results returned when using Log Miner SCN range
10.2.0.3 5104579 Flashback query results on RAC inconsistent after rebooting 1 instance
10.2.0.3 5109749 Wrong results / ORA-1428 from SQL using functional index with subquery unnesting
10.2.0.3 5110062 Wrong results from INSTR for CLOB for multibyte charactersets
10.2.0.3 5130670 Wrong results with CURSOR query on complex view with collection objects
10.2.0.3 5140532 wrong results from PQ with hash distribution with fixed CHAR join keys
10.2.0.3 5162069 Wrong results from XMLAgg with GROUP BY
10.2.0.3 5169712 Wrong results with star transformation , rownum and semijoin
10.2.0.3 5191781 CONNECT BY query returns rows in different order
10.2.0.3 5228983 Wrong results from SQL with correlation on partition key
10.2.0.3 5253271 Wrong sort ordering for zeroes
10.2.0.3 5276400 Wrong results with query rewrite
10.2.0.3 5333814 OraSimpleDateFormat::parse on date with "pm" incorrectly becomes "am"
10.2.0.3 5345437 Intermittent wrong data / NLS errors (eg ORA-1801)
10.2.0.3 5550824 Select SYSDATE over a database link increments SYSDATE
10.2.0.2 3942889 DBMS_METADATA.GET_DDL can output garbage characters in multibyte
10.2.0.2 4044836 ALTER SESSION to set an NLS parameter may fail silently
10.2.0.2 4251268 Foldering of row from non schema based XMLType table does not show proper file size in DAV
10.2.0.2 4308710 Wrong results from temp table star transformation
10.2.0.2 4360941 Column contents not displayed if HS query contains explict NULL
10.2.0.2 4375458 OCCI isNull() returns false for null object returned from procedure
10.2.0.2 4383610 application info attributes are not translated correctly in utf16 environment
10.2.0.2 4402808 Parallel refresh of MVIEW with GROUPING SETS can give bad MVIEW data
10.2.0.2 4455919 Wrong results on query with event 19027 set
10.2.0.2 4456928 OCIStmtExecute behaves wrong when using OCI_BATCH_ERRORS and then OCI_DEFAULT
10.2.0.2 4466869 ORA-14403 from bulk PLSQL operations after truncate operation
10.2.0.2 4472437 Used percent metrics for SYSTEM tablespace not updated when locally managed
10.2.0.2 4483951 Wrong results from MERGE JOIN with subquery predicate on right table with ROWID
10.2.0.2 4486132 Query using function based index gives wrong results
10.2.0.2 4493256 Wrong result possible from complex view merging of ALL/ANY/[NOT]IN subquery
10.2.0.2 4496211 Wrong results after fast refresh of a partitioned materialized view
10.2.0.2 4616093 Wrong results from dattime expressions with a timezone
10.2.0.2 4629844 Dump / wrong results from query with CHECK constraint
10.2.0.2 4871035 Disable "row shipping" by default in 10.2.0.2 onwards

2.1.106 XA / Distributed Transactions

The following table lists the XA / Distributed Transactions bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4627203 tuxedo server process spins holding transaction branch allocation latch
10.2.0.3 4627237 autonomous_transaction with DB link to shared server can self deadlock on DX
10.2.0.3 4644880 Client dump using dynamic XA registration
10.2.0.3 4679094 In RAC a transaction may get stuck in prepare mode (ORA-1591)
10.2.0.3 4891103 OERI[4442] using XA
10.2.0.2 4432906 PMON slow to clean locked rows from rolled back XA transaction
10.2.0.2 4434249 ORA-2051 at non-native XAresource.end() when other branch is prepared
10.2.0.2 4446528 PMON can be slow to clear row locks for rolled back XA transaction
10.2.0.2 4500930 RECO slow to clean up failed 2PC from RAC node failure
10.2.0.2 4505304 ORA-1591 from index block cleanout

2.1.107 XDB

The following table lists the XDB bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 3365793 OERI[qmxtgrenumpredrewriteprocess] with out of line elements from another schema
10.2.0.3 3703236 Transfer of files to XDB may fail before the timeout is reached
10.2.0.3 4172384 Dump using DBMS_XMLDOM with shared servers or session migration
10.2.0.3 4500235 Whitespace not preserved with xml:space or DTD mixed content
10.2.0.3 4502755 Accessing DBMS_XMLDOM.DOMDocument in PLSQL can dump
10.2.0.3 4537877 XDB should only accept 'true','false',1,0 for xs:boolean
10.2.0.3 4568043 XMLDOM.SUBSTRINGDATA dump / wrong result for offset >= 4000
10.2.0.3 4580399 ORA-942 from "&apos;" in text node with DBMS_XMLSTORE.INSERTXML()
10.2.0.3 4584239 Dump during a cross join query using XMLSEQUENCE
10.2.0.3 4587607 ORA-31187 hit when uploading an XML instance
10.2.0.3 4587761 XMLType.getNamespace() returns NULL for non schema based documents
10.2.0.3 4610323 Wrong node order accessing SCHEMA BASED XML via HTTP
10.2.0.3 4612208 Cannot export/import SCH-XT table into different user
10.2.0.3 4639101 False ORA-904 when adding partition to partitioned XMLType table
10.2.0.3 4656020 Export / import of schema based XMLType table fails
10.2.0.3 4675505 Dump (koxss2gpage) using XMLTYPE in updates
10.2.0.3 4679879 ls/dir does show file information correctly on XDB FTP if NLS_LANGUAGE=JAPANESE
10.2.0.3 4694045 Insert of XML doc takes up large amount of memory
10.2.0.3 4699502 xmldom.setAttribute() and removeAttribute() behave incorrectly
10.2.0.3 4704626 User level import export with SB XMLTYPE table does not preserve scope
10.2.0.3 4713210 extract() can return erroneous namespace
10.2.0.3 4728105 ORA-19276 with XMLTable()
10.2.0.3 4751888 Registration of schema including blockdefault="substitution" gives ORA-31038
10.2.0.3 4759183 Corrupt XML values from XMLAgg()
10.2.0.3 4763057 XMLTable can get a suboptimal re-write
10.2.0.3 4765374 Create table with XML schema causes ORA-4020
10.2.0.3 4766097 Unable to extract contents from XMLType after insert - ORA-31167
10.2.0.3 4769762 Wrong results from base-uri() and docuemnt-uri() handling doc() and collection()
10.2.0.3 4866544 OERI [qmxtrBuildPdAcc:toid] selecting from USER_XML_SCHEMAS
10.2.0.3 4876140 ORA-4020 on registering XML schemas using recursive references
10.2.0.3 4912961 False ORA-19026 with simpletype and enumeration
10.2.0.3 4914205 Query/update using bind variable with existsnode returns the same row
10.2.0.3 4924933 No rewrite during update of simpletype
10.2.0.3 4928321 Pickle of opaque type results in bad image size
10.2.0.3 4955476 DTD reference removed after parsing XML using parseClob
10.2.0.3 4963080 Datapump export/import fails for partitioned table
10.2.0.3 4965973 ORA-31079 when insert / select on a schema based XMLType table with "xsi:type"
10.2.0.3 4970030 XSL processor ignores new line characters
10.2.0.3 5004612 updateXML does not work updating attribute value with a CLOB
10.2.0.3 5019081 Update of schema based XML resource fails with unique constraint on nested table
10.2.0.3 5021540 ORA-30937 while inserting substitutiongroup elem imported from schema with no ns
10.2.0.3 5038284 OERI[qmtsGetCompilationContext1] / ORA-31079 from schema registration
10.2.0.3 5114306 Dump (qmuhshget_internal) from DBMS_XMLStore.insertXML
10.2.0.3 5115350 ORA-932 during ALTER TABLE MOVE with nested tables IOTs
10.2.0.3 5117888 Collection split rewrite not enabled by default
10.2.0.3 5152323 IMPDP fails during TTS import of partitioned table with XMLTYPE STORE AS CLOB
10.2.0.3 5158711 Parsing XML using DBMS_XMLGEN / DBMS_XMLDOM can be slow
10.2.0.3 5162069 Wrong results from XMLAgg with GROUP BY
10.2.0.3 5174023 Dump registering XML schema with attrgroup refs
10.2.0.3 5212798 "xsd:dateTime" cannot be mapped to TIMESTAMP WITH TIME ZONE
10.2.0.3 5218128 No rewrite for updateXML() when target is out of line
10.2.0.3 5218433 OERI[qmximv_maptype] select an XMLType table with TIMESTAMP types
10.2.0.3 5353622 XQuery not always rewritten completely
10.2.0.2 4251268 Foldering of row from non schema based XMLType table does not show proper file size in DAV
10.2.0.2 4275862 updateXML() may delete text elements
10.2.0.2 4404796 DBMS_XMLPARSER does not use DTD to validate
10.2.0.2 4448018 Dump (qmrvkko) from resource_view / path_view XDB query
10.2.0.2 4504041 Dump (koxsh2copy) inserting into an XML table using createSchemaBasedXML()
10.2.0.2 4505011 xquery variable processing performs poorly
10.2.0.2 4529672 ORA-19276 from xquery expression containing specific namespaces
10.2.0.2 4534622 XQuery wrong results when the WHERE clause has a predicate expression
10.2.0.2 4554682 XDB ftp upload leaks memory (ORA-4030) with nested table storage
10.2.0.2 4560790 XMLPARSER.SETDOCTYPE and XMLPARSER.PARSEDTD<BUFFER/CLOB> do not set the DTD.
10.2.0.2 4569842 Suboptimal query plans can occur when using XMLtable()
10.2.0.2 4668935 ORA-19112 using XQuery fn:collection() with sub-folders

2.1.108 XML

The following table lists the XML bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4172384 Dump using DBMS_XMLDOM with shared servers or session migration
10.2.0.3 4568043 XMLDOM.SUBSTRINGDATA dump / wrong result for offset >= 4000
10.2.0.3 4580399 ORA-942 from "&apos;" in text node with DBMS_XMLSTORE.INSERTXML()

2.1.109 Error May Occur

The following table lists the Error May Occur bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 5380055 * ORA-1555 / corruption if switch to Standby then back to Primary. This bug is alerted in Note:386830.1
10.2.0.3 5458753 * SQL may execute in wrong schema. This bug is alerted in Note:392673.1
10.2.0.3 4752541 + Intermittent PLS-306 / ORA-1722 / ORA-1858 under load
10.2.0.3 5212539 + LOB corruption for NOCACHE LOBs (ORA-1555/ORA-22924)
10.2.0.3 5383828 PI The fix for bug 5033218 can cause ORA-604 / ORA-1405 compiling triggers
10.2.0.3 3652491 Error for parallel query with ORDER BY and DOMAIN index
10.2.0.3 4200541 Parse error when CURSOR_SHARING=FORCE|SIMILAR with user binds
10.2.0.3 4321119 ALTER MATERIALIZED VIEW causes ORA-32337 after DML via database link
10.2.0.3 4343398 Alert log reports ORA-2097 / ORA-439 on 10.1.0.4 Standard Edition
10.2.0.3 4361163 It is not possible to have > 1000 shared servers on some platforms
10.2.0.3 4380942 ORA-6502 from catjava.sql when upgrading from 8i to 10g
10.2.0.3 4395779 ORA-16086 error when recovery area not used for redo logs
10.2.0.3 4433936 ORA-907 from FULL / LEFT OUTER joins
10.2.0.3 4460775 TIMESTAMP types may not exist in migrated database
10.2.0.3 4516151 SQLServer streams gives error if DML has nulls for date column
10.2.0.3 4523125 ORA-3106 if cursor flushed between executions
10.2.0.3 4527173 AQ$_JMS_TEXT_MESSAGE.SET_TEXT method does not work correctly with multi-byte character sets
10.2.0.3 4552927 DBMS_CRYPTO.ENCRYPT throws ORA-28233 when encrypting NULL data
10.2.0.3 4554284 ORA-3106 can occur with row shipping on a non blocking OCI connection
10.2.0.3 4557554 ORA-3106 dynamically executing PLSQL with many bind variables
10.2.0.3 4587607 ORA-31187 hit when uploading an XML instance
10.2.0.3 4598613 ORA-2248 from 10.2/10.1.0.5 client with NLS_LANG set to territory SWITZERLAND
10.2.0.3 4602169 ORA-29702 during shutdown in RAC
10.2.0.3 4627522 ORA-1407 updating VARCHAR2 in AL32UTF8 database
10.2.0.3 4637008 Frequent ORA-379 can occur
10.2.0.3 4637725 ORA-918 for remote DML
10.2.0.3 4639101 False ORA-904 when adding partition to partitioned XMLType table
10.2.0.3 4644048 Oracle type evolution can fail with ORA-932
10.2.0.3 4654856 ORA-17502 making RMAN duplexed backupsets to ASM diskgroup
10.2.0.3 4671499 ORA-17500 ODM error
10.2.0.3 4673628 ORA-12154 attempting to use Instant Client with OID / LDAP
10.2.0.3 4676659 ORA-16009 in alert log with standby and LGWR ASYNC
10.2.0.3 4693439 ORA-1406 from FULL export with auditing
10.2.0.3 4698156 ORA-12850 querying GV$ views when CURSOR_SHARING=FORCE
10.2.0.3 4704626 User level import export with SB XMLTYPE table does not preserve scope
10.2.0.3 4707226 ORA-20000 from AUTO_SPACE_ADVISOR_JOB if tablespace dropped
10.2.0.3 4708037 ORA-904, ORA-2063 from query that uses TIME ZONE as a cast
10.2.0.3 4712729 ORA-21780 can get raised for a table with a BEFORE ROW trigger on it.
10.2.0.3 4715104 ORA-22835 / truncated data from USER/ALL/DBA_EXTERNAL_TABLES
10.2.0.3 4715572 Wrong results / errors from select from external table with FIXED recordsize
10.2.0.3 4722189 Instant client libraries may be used from a FULL ORACLE_HOME
10.2.0.3 4727556 ORA-3117 on describe of packages
10.2.0.3 4730389 ORA-30757 on propagation from 10.2 -> 8i
10.2.0.3 4736134 IMP-61 on import due to hashcode mismatch
10.2.0.3 4739749 Gateway returns ORA-28500 when it cannot process schemaname
10.2.0.3 4742679 ORA-604 / ORA-28133 enabling constraints on table with FGA
10.2.0.3 4744469 IMPDP grants all roles to user creating them exceeding max enabled roles ORA-316
10.2.0.3 4744972 ORA-942 on join with table associated with an MVIEW in a different schema
10.2.0.3 4747312 ORA-911 using DECLARE_REWRITE_EQUIVALENCE
10.2.0.3 4754328 RMAN resync catalog fails with ORA-1 (TS_P unique constraint violated)
10.2.0.3 4755799 RMAN-20070 error on primary after dataguard switchover
10.2.0.3 4758949 ORA-6550 error importing statistics
10.2.0.3 4772904 PRKR-1007 / PROC-5 from srvctl
10.2.0.3 4864912 Cannot rebuild AR model reusing a previously used name results
10.2.0.3 4869987 ORA-39167 from EXPDP
10.2.0.3 4908068 ORA-1400 from BEFORE INSERT trigger using INSERT with SUBQUERY in VALUES clause
10.2.0.3 4937225 ORA-22 from OCIStmtExecute after OCISessionBegin
10.2.0.3 4945389 ORA-1114 write error on file header when tablespace is READ ONLY
10.2.0.3 4950024 ORA-39083/PLS-302 during import of metric threshold settings
10.2.0.3 4950241 DBMS_APPLY_ADM.EXECUTE_ALL_ERRORS() fails with ORA-1403
10.2.0.3 4956438 ORA-1404 when altering a table
10.2.0.3 4957217 ORA-2019 from REF cursor from procedure that uses a private dblink
10.2.0.3 4963080 Datapump export/import fails for partitioned table
10.2.0.3 4965973 ORA-31079 when insert / select on a schema based XMLType table with "xsi:type"
10.2.0.3 4970079 SMON fails with ORA-4030 during clean up of non-existent objects
10.2.0.3 4994956 Number of configured shared pool subpools not correct
10.2.0.3 5000380 OCIAttrget(..., OCI_ATTR_PARAM_COUNT, ...) fails against 8i server
10.2.0.3 5004612 updateXML does not work updating attribute value with a CLOB
10.2.0.3 5008142 Select from V$SGA_TARGET_ADVICE can fail with ORA-1476
10.2.0.3 5018738 CONVERT function fails in PLSQL with ORA-1482
10.2.0.3 5031489 ORA-1455 during full database export
10.2.0.3 5032921 ORA-3700 in LGWR after 'alter database activate standby database'
10.2.0.3 5033218 ORA-6502 if TRIGGER modifies column value with >= 1001 character value
10.2.0.3 5057629 Dump (krvdtln) / ORA-1294 from DBMS_LOGMNR.start_logmnr
10.2.0.3 5076617 Cannot drop datafile using alter tablespace (ORA-3263)
10.2.0.3 5078837 ORA-41661 from DBMS_RLMGR with NLS_NUMERIC_CHARACTERS using "," for the decimal point
10.2.0.3 5084109 Create view may dump (in qcsjgcn) or fail with ORA-918
10.2.0.3 5086622 Double encryption error
10.2.0.3 5104430 ORA-1309 from PURGE_SESSION
10.2.0.3 5104624 Explain plan fails with ORA-928
10.2.0.3 5115350 ORA-932 during ALTER TABLE MOVE with nested tables IOTs
10.2.0.3 5117361 Capture process aborts with OERI[krvxgctasi:array size]/ORA-1280
10.2.0.3 5127944 PLS-103 from oracle.sql.TRANSDUMP.getTransitions()
10.2.0.3 5136454 Distributed statement using a synonym fails with ORA-904
10.2.0.3 5151675 Cannot archive redo.log in spite of good multiple log members
10.2.0.3 5151960 IMPDP via NETWORK_LINK EXCLUDE/INCLUDE filters execute on wrong DB
10.2.0.3 5152323 IMPDP fails during TTS import of partitioned table with XMLTYPE STORE AS CLOB
10.2.0.3 5173194 Errors from partition range scan of LOCAL DOMAIN index
10.2.0.3 5260370 Intermittent ORA-904
10.2.0.3 5345437 Intermittent wrong data / NLS errors (eg ORA-1801)
10.2.0.2 4458790 + ORA-6502 selecting MAX/MIN into a CHAR variable in PLSQL
10.2.0.2 3494626 ORA-32036 from WITH clause
10.2.0.2 3519807 ORA-4031 querying V$SEGSTAT
10.2.0.2 4057655 ArrayIndexOutOfBoundsException from JDBC using large number
10.2.0.2 4177810 ORA-904 with non-column constants in FROM clause with PQ or remote SQL
10.2.0.2 4278912 ORA-24852 if cursor selecting BLOB is rebuilt
10.2.0.2 4304759 ORA-14297 can occur on ALTER TABLE EXCHANGE [sub]partition
10.2.0.2 4349508 IO errors during recovery of ODM file
10.2.0.2 4364202 Failed ONLINE index rebuild not cleaned up by SMON quickly
10.2.0.2 4369235 ANSI joins may fail with ORA-1445
10.2.0.2 4386766 IMPDP with compressed indexes fails with ORA-14071 and ORA-39083
10.2.0.2 4387452 ORA-22922 trying to DEREF an object view
10.2.0.2 4394339 "IS OF TYPE" or TREAT operators in SQL can fail with ORA-22950
10.2.0.2 4421063 Exchange partition fails with ORA-14098 with 2 or more bitmap join indexes
10.2.0.2 4430427 ORA-604 / ORA-903 from SQL against partitioned table with subquery partition pruning
10.2.0.2 4434249 ORA-2051 at non-native XAresource.end() when other branch is prepared
10.2.0.2 4465417 ORA-6502 from EXPDP of multibyte database
10.2.0.2 4478711 ORA-604 / ORA-24794 from parallel query
10.2.0.2 4496189 V$SESSION.PROGRAM can contain partial MULTIBYTE characters
10.2.0.2 4498443 ORA-979 from SQL with HAVING
10.2.0.2 4500930 RECO slow to clean up failed 2PC from RAC node failure
10.2.0.2 4505304 ORA-1591 from index block cleanout
10.2.0.2 4519934 AUTO_SPACE_ADVISOR_JOB can fail with ORA-44003
10.2.0.2 4522300 ORA-1858 decoding dates with trailing spaces and non numberic character
10.2.0.2 4529672 ORA-19276 from xquery expression containing specific namespaces
10.2.0.2 4531791 ORA-1422 error during RMAN resync of deleted object
10.2.0.2 4549585 ORA-32321 on dbms_refresh.refresh after master site upgrade
10.2.0.2 4550702 SQLLOAD direct load gets ORA-1866 for storing systimestamp
10.2.0.2 4627335 ORA-904 error from DBMS_STATS against index with special character/s
10.2.0.2 4630549 ORA-904 / dump from MERGE SQL
10.2.0.2 4668935 ORA-19112 using XQuery fn:collection() with sub-folders

2.1.110 Internal Error May Occur (ORA-600)

The following table lists the Internal Error May Occur (ORA-600) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 5380055 * ORA-1555 / corruption if switch to Standby then back to Primary. This bug is alerted in Note:386830.1
10.2.0.3 3279497 Interupted (Ctrl-C) TRUNCATE can corrupt ASSM table
10.2.0.3 3448940 OERI[kskbind:!unb&!uinit] using resource manager with shared server connections
10.2.0.3 3889156 OERI[kcblibr_1] using global temporary table if client disconnected
10.2.0.3 4254094 OERI[QERRMOBND1][932] possible for queries over DB links
10.2.0.3 4271217 OERI:kpolcsc1 / OERI:12333 from JDBC setCharacterStream() for CLOB data
10.2.0.3 4308089 Dump / OERI on MOVE / SPLIT partition of table with ADT column/s
10.2.0.3 4339429 RAC instance crash with OERI:[kclbla_2] / dump (skgxpimprp)
10.2.0.3 4383811 OERI:qerxtAgentOpen_911 during datapump import
10.2.0.3 4393878 OERI[kclchkping_2] in shared server / PMON
10.2.0.3 4461688 OERI[qkaPobs1] during instance startup of logical standby
10.2.0.3 4479323 OPEN RESETLOGS can fail with OERI[3705] in RAC
10.2.0.3 4502270 OERI [pxtmpalo_pkey] / wrong results can occur executing parallel queries
10.2.0.3 4502755 Accessing DBMS_XMLDOM.DOMDocument in PLSQL can dump
10.2.0.3 4528339 OERI [12406] from CONNECT BY query with subqueries
10.2.0.3 4557725 OERI:qkaAddSibling from SQL using bitmap index
10.2.0.3 4561867 ASMB may exit prematurely causing OERI in client
10.2.0.3 4581871 OERI[kslpspr1] can occur
10.2.0.3 4599763 DBMS_STATS fails with OERI:qospgtbc
10.2.0.3 4627203 tuxedo server process spins holding transaction branch allocation latch
10.2.0.3 4637591 OERI:ksfd_dbuf1 possible using ODM with VLM
10.2.0.3 4638550 OERI[dmlsrvColLenChk_2:dty] during upgrade from 9.2 to 10.2
10.2.0.3 4639236 OERI [kclcls_5] possible in RAC recreating an object
10.2.0.3 4639659 SQLLDR direct load of IOT gets OERI[iot_gtab_mr_rcnt_mismatch]
10.2.0.3 4639977 OERI[kkqcby: qbcfkkc not zero] from CONNECT BY query
10.2.0.3 4640637 OERI[kwqidorefetch:err][3135] from AQ
10.2.0.3 4648181 OERI [15160] possible from pushed predicates
10.2.0.3 4671721 OERI [kfcInitDlocn02] possible in ASM instance
10.2.0.3 4682861 OERI[kfcnullconvert20] in ASM instance
10.2.0.3 4686191 OERI[kpnxppce-1] using row shipping with hash cluster
10.2.0.3 4690953 Conversion of the TIMESTAMP WITH LOCAL TZ from Oracle type in Java fails
10.2.0.3 4691657 OERI[kxfprdp:1] if PQ slave session is killed
10.2.0.3 4704890 OERI[kslgetl:1] after adding CPU using dynamic reconfiguration
10.2.0.3 4709210 ASM LMS OERI[504] on [kfcl le freelist] latch
10.2.0.3 4735795 OERI:qctcte1 with UNION in an "and exists" subselect
10.2.0.3 4741394 OERI [12406] from CONNECT BY query
10.2.0.3 4744859 OERI[kkbncre:sq_len3] can occur
10.2.0.3 4748222 Update column with TDE gets OERI:[ztsmdwl failed] if there is a trigger
10.2.0.3 4750469 OERI:kjrfr7 can occur in RAC
10.2.0.3 4759016 OERI [kghfrf1] doing RMAN backup
10.2.0.3 4763768 OERI[17056] during analyze table compute stats on IOT
10.2.0.3 4766532 OERI[kesqsmakesql:phv] from DBMS_SQLTUNE
10.2.0.3 4859002 PMON crash cleaning up serially_reusable PLSQL
10.2.0.3 4860003 Sqlplus dump / OCI-21500 [koxsihread1]
10.2.0.3 4863048 LMS OERI[kjbmpocr:dsb] / instance crash with RAC
10.2.0.3 4866544 OERI [qmxtrBuildPdAcc:toid] selecting from USER_XML_SCHEMAS
10.2.0.3 4871743 OERI [kkfi.qbcvfr] creating view which uses ROWID of another view
10.2.0.3 4874986 OERI[2142] while using flashback feature
10.2.0.3 4886660 ASMB can fail with OERI:kffmAllocate_1
10.2.0.3 4890281 OERI[KGHALO4] can occur under qesblGetFilter
10.2.0.3 4891103 OERI[4442] using XA
10.2.0.3 4917666 OERI[kcbgcur_9] from type constructor
10.2.0.3 4925342 OERI [25027] / OERI [25012] on IOT analyze estimate statistics
10.2.0.3 4940513 OERI[kturrur11] can occur with multi block undo
10.2.0.3 4952782 OERI:qernsRowP from GROUP BY with ORDER BY DESC
10.2.0.3 4959569 OERI[kdic_create_journal_table_1] rebuilding REF index ONLINE
10.2.0.3 4964703 OERI[opixrb-4] [1036] from SELECT over DBLINK with trailing :N or :Q bind names
10.2.0.3 4966352 OERI[unsorted_pins_4] possible on ASM
10.2.0.3 4995320 Memory corruption / OERI[17114] from HS
10.2.0.3 4996133 OERI[kcbgtcr_5] updating an IOT in RAC environment
10.2.0.3 4997495 Instance crash with OERI[504][mostly latch-free SCN]
10.2.0.3 5005052 OERI:voprsla1 from ANSI query with TABLE() and domain index
10.2.0.3 5005939 OERI[qkssao2s1] during DBMS_SQLTUNE
10.2.0.3 5011019 OERI[2103] on bystander standby during target standby failover
10.2.0.3 5011764 OERI[ktsircinfo_num1] accessing a LOB
10.2.0.3 5022093 OERI:[kjsbstat:unknownmaster] possible in RAC
10.2.0.3 5035666 OERI:16363 opening Java socket from a migratable session
10.2.0.3 5040222 OERI[4823] from drop partition table after merge with update indexes
10.2.0.3 5043097 OERI [15160] during query optimization
10.2.0.3 5043975 OERI[opixrm-1] [invalid handle] for remote cursor
10.2.0.3 5061952 OERI[kmgsb_resize_sga_target_1] when SGA_TARGET is changed
10.2.0.3 5068253 LGWR crashes instance with OERI[kcrfw_redo_write_lwn_len]
10.2.0.3 5071492 LMS crash with OERI[kclastf_1]
10.2.0.3 5077208 MRP may fail with OERI[kcpcvc3] after a tablespace drop
10.2.0.3 5078743 Dump (in qkabxo) using bitmap access path in FIRST K ROWS
10.2.0.3 5082607 OERI:[kutyxtt_convert_b2_01] on convert datafile from Tru64 to AIX
10.2.0.3 5089217 OERI:[qkacon:NFswrwo] when using CONNECT BY with ORDER SIBLINGS
10.2.0.3 5090822 OERI[17092] / ORA-10382 when ASM IO completes concurrently with DISKGROUP dismount
10.2.0.3 5095940 OERI[kcvent_internal_2] during database open
10.2.0.3 5117361 Capture process aborts with OERI[krvxgctasi:array size]/ORA-1280
10.2.0.3 5118147 OERI[kssadpm: null parent] can occur
10.2.0.3 5134663 OERI[2103] with ASM
10.2.0.3 5156031 Select from GV$AQ can report OERI[kwqldqs: invalid state][8]
10.2.0.3 5172444 OERI[15160] on complex query with joinback elimination
10.2.0.3 5186784 OERI[ktecgetsh-inc] from DML against transported tablespace
10.2.0.3 5218433 OERI[qmximv_maptype] select an XMLType table with TIMESTAMP types
10.2.0.3 5226903 OERI:[kfcDeadlockAvoid01] when running "check all repair"
10.2.0.3 5359321 Streams capture fails OERI[krvxalfs: non unique entries in]
10.2.0.2 4601462 P Win: OERI:OSDEP_INTERNAL can occur on startup at sssxcpttcs1
10.2.0.2 4197704 OERI:7005 from queries involving partitions and TIMESTAMPs
10.2.0.2 4235176 OERI:ksprlspeeq3 can occur in RAC
10.2.0.2 4237629 OERI[kfdjoin5] on ASM instance with multiple diskgroups
10.2.0.2 4260205 OERI:voprvl1 in query having an outer join and WITH
10.2.0.2 4297280 OERI[17059] can occur if over 32767 schemas reference an object
10.2.0.2 4308839 OERI:qkaffsindex3 from index FFS with ORDER BY
10.2.0.2 4345035 OERI:3619 on startup with transported read only tablespace
10.2.0.2 4350392 Dump (qkexrInitOpn or evapls) with unnested subqueries using object methods
10.2.0.2 4366667 OCILobWrite with OCI_LAST_PIECE can cause OERI:12333 on next DB access.
10.2.0.2 4377352 OERI [ksfdrfms2] during instance recovery of second thread
10.2.0.2 4384780 OERI[qkaOrderByPD 3] from parallel distinct outer join with ROWNUM
10.2.0.2 4387399 OERI[17018] signalled by logon trigger
10.2.0.2 4395548 OERI[expcmo_strdef1] from star transformation
10.2.0.2 4401000 OERI[16608] during import of transportable tablespace
10.2.0.2 4401437 CONNECT BY query may fail with OERI:qergiStart1 / OERI:qesmmCValStat4
10.2.0.2 4413010 OERI[kffdmove01] selecting from V$ASM_ALIAS in ASM instance
10.2.0.2 4414666 OERI[KGHALO4] can occur on NUMA
10.2.0.2 4439465 OERI [kdtdelrow-2] / ORA-604 from BULK inserts
10.2.0.2 4442372 OERI [ktspshsp-1] after aborted TRUNCATE
10.2.0.2 4443625 OERI[koklgetlobtid0] using large collections
10.2.0.2 4450399 OERI:15160 during joinback elimination of 1-row tables in star transformation
10.2.0.2 4451881 OERI[kkslhsh1] from Insert as SELECT
10.2.0.2 4453449 OERI:3020 / corruption errors from multiple FLASHBACK DATABASE
10.2.0.2 4456478 OERI:[qerrmObnd] from remote mapped queries
10.2.0.2 4457034 OERI:qkaffsindex3 can occur from CONNECT BY on IOT
10.2.0.2 4473142 OERI[kcoadd_size] can occur in RAC
10.2.0.2 4478323 OERI[kfcDeadlockAvoid01] on SQL against V$ASM_ALIAS
10.2.0.2 4487610 OERI[13009] on select for update on chained row
10.2.0.2 4510545 OERI[kcbbxsv_2] can occur in RAC
10.2.0.2 4549495 OERI:1350 using 10gR2 with older NLS files
10.2.0.2 4550821 OERI[kfklufsscannext] in ASM during disk discovery
10.2.0.2 4552113 OERI:kkxmexcs3/OERI:kkxmexcs4 using object binds
10.2.0.2 4568216 OERI[kslgetl:1] in parallel query slaves after ALTER SYSTEM to increase max slaves
10.2.0.2 4583410 OERI[15570] from parallel NESTED LOOPS with UNION ALL with pushed predicates
10.2.0.2 4602031 Block corruption from UPDATE or MERGE into compressed table
10.2.0.2 4619452 OERI[koklGetLocAndFlag1] during LOB array insert
10.2.0.2 4626732 OERI [evapls1] / dumps from predicate pullup
10.2.0.2 4632438 OERI[kksfbc-reparse-infinite-loop] can occur
10.2.0.2 4634023 OERI:ktrgtc_1 from fetch across commit
10.2.0.2 4666938 OERI[kjbdowncvt:__l] can occur in ASM
10.2.0.2 4671216 ASM operations on a file are blocked while it is resized
10.2.0.2 4684074 OERI:510 / block corruption (ORA-1578) with DB_BLOCK_CHECKING
10.2.0.2 4704981 OERI[17148] / PMON dump in kksLockDelete
10.2.0.2 4772979 OERI[kfdskAlloc0] in RDBMS instance when adding back a dropped disk

2.1.111 Process May Dump (ORA-7445) / Abend / Abort

The following table lists the Process May Dump (ORA-7445) / Abend / Abort bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 5114396 + PGA corruption / dumps from session switching with shared servers
10.2.0.3 5388136 PI The fix for bug 5033218 can cause triggers to dump (pfrust) with NVARCHAR2/NCHAR :OLD/:NEW values
10.2.0.3 3945479 Bad materialized view metadata is definition uses "WITH"
10.2.0.3 4008133 Dump (skgslsgf) selecting from V$LOCK related views
10.2.0.3 4257187 Dump (qkkisojkey) from PQ with OUTER JOIN and ORDER BY / GROUP BY
10.2.0.3 4308089 Dump / OERI on MOVE / SPLIT partition of table with ADT column/s
10.2.0.3 4380928 ALTER MATERIALIZED VIEW LOG add filter columns may dump
10.2.0.3 4417341 SKIP LOCKED mishandles fetch out of sequence errors
10.2.0.3 4440681 Dump from REGEXP_REPLACE referring to table expression
10.2.0.3 4447168 Dump (kghalp) with auditing enabled
10.2.0.3 4492467 Dump(kkquhcus) from cost based query transformation
10.2.0.3 4496339 RECO dumps in lxsCpStr causing instance crash
10.2.0.3 4540140 Dump (qkkMatchPrefix2) from INLIST with subpartitions
10.2.0.3 4597692 Dump [qksdsExeStmt] using SQL tuning advisor for long query
10.2.0.3 4607460 Dump [opipls] when CURSOR_SHARING = SIMILAR | FORCE
10.2.0.3 4627203 tuxedo server process spins holding transaction branch allocation latch
10.2.0.3 4644798 Dump (kkmups) using MERGE SQL
10.2.0.3 4644880 Client dump using dynamic XA registration
10.2.0.3 4655283 Dump (in joe_run_vm) running Java stored procedure
10.2.0.3 4657575 CONVERT may dump converting ISO2022-JP data
10.2.0.3 4666849 Client OCI tracing dumps for long queries (EVENT_10842)
10.2.0.3 4675505 Dump (koxss2gpage) using XMLTYPE in updates
10.2.0.3 4739742 CLWS CRSD dump in prou_check_tag<-procr_close_key
10.2.0.3 4743096 Dump (in vopqbc) from SQL with complex view
10.2.0.3 4748946 CRSD aborts with OCR errors
10.2.0.3 4752021 Dump (kpoaqeqopp) on AQ propagation from 8i to 10.2
10.2.0.3 4865820 LMS dump (kclnrembg)
10.2.0.3 4870952 CLWS racgimon may dump
10.2.0.3 4872617 Dump (kfclDumpLe) in ASM
10.2.0.3 4891103 OERI[4442] using XA
10.2.0.3 4904890 Dump (upduaw) from UPDATE
10.2.0.3 4939157 Dump (evaopn2) using a functional index
10.2.0.3 4944292 Multi-table insert may dump (koklgolx)
10.2.0.3 4954651 Dump [evacssr] from view with select list subquery with CASE expression
10.2.0.3 4969029 Query optimization may dump [in kkoijg]
10.2.0.3 4990803 Dump after type evolution
10.2.0.3 5001358 Dump (kwqppay2aqe) on propagation of a transformed message
10.2.0.3 5007623 Dump in clssgmfmtdatareqresp causing node reboot
10.2.0.3 5011764 OERI[ktsircinfo_num1] accessing a LOB
10.2.0.3 5012796 DUmp (in kglhdgsc) using distributed transactions
10.2.0.3 5015557 Dump under kkoNewExtractedBMKey or qerixGetKey with bitmap plan and function based index
10.2.0.3 5033476 Dump executing a DML which uses a CONNECT BY when there is a trigger
10.2.0.3 5036588 LMD0 process dump (kewmuprbsm_update_rbsm)
10.2.0.3 5036879 Dump (kkoajt) during parse
10.2.0.3 5037103 Dump (qerrmOieb) when selecting view across dblink
10.2.0.3 5040303 Dump (expepr) from distributed insert into VIEW
10.2.0.3 5055175 Dump [kkslpkp] using literal replacement with timezone literals
10.2.0.3 5057629 Dump (krvdtln) / ORA-1294 from DBMS_LOGMNR.start_logmnr
10.2.0.3 5074814 Dump (kkofmx) from DBMS_ADVISOR.EXECUTE_TASK for some IOT tables
10.2.0.3 5084109 Create view may dump (in qcsjgcn) or fail with ORA-918
10.2.0.3 5084961 Dump (qerncRowP) from PQ with nested cursor query
10.2.0.3 5089039 Select with bind variables can dump in ttcfopr()
10.2.0.3 5089630 Dump (kfncInitSlavePool) / ORA-15012 from Log Miner / Streams against LOGs on ASM
10.2.0.3 5095398 Dump (in LdiDateDateSubtract) in RAC when stopping a chain Job
10.2.0.3 5095577 DMON process never starts (dump rfm_get_opaque)
10.2.0.3 5099167 MMNL dump under kewa_sample_session
10.2.0.3 5103658 Dump (ksxpfixcb) from select against V$CONFIGURED_INTERCONNECTS
10.2.0.3 5114306 Dump (qmuhshget_internal) from DBMS_XMLStore.insertXML
10.2.0.3 5116402 A dump can occur in ksxpfixcb
10.2.0.3 5126551 Dump (kkdcacr) from query on tables with FK constraint
10.2.0.3 5151518 Dump under AccessControlContext executing stored Java
10.2.0.3 5162241 Dump / spin from query using "WITH" subquery with aggregation or DISTINCT
10.2.0.3 5174023 Dump registering XML schema with attrgroup refs
10.2.0.3 5176312 MMON dumps in kswsgetosstat
10.2.0.3 5351519 Dump using REGEXP_REPLACE() operator
10.2.0.2 3880881 Dump (kkslMarkLiteralBinds) using cursor sharing
10.2.0.2 4102969 Dump when updating table with synchronous replication
10.2.0.2 4248629 Star transformation may dump (in kkojnp)
10.2.0.2 4395296 MERGE with APPEND hint dumps instead of giving ORA-30926
10.2.0.2 4402255 Hang / dump possible using database link
10.2.0.2 4419809 Dump on insert to view with CHECK OPTION with NOT IN subquery
10.2.0.2 4431181 Dump from SELECT if it changes from remote mapped to not
10.2.0.2 4438061 Dump (kghlkaftf) can occur using VLM
10.2.0.2 4448018 Dump (qmrvkko) from resource_view / path_view XDB query
10.2.0.2 4456646 Dump (kxscod/memcmp) using literal replacement
10.2.0.2 4466087 Dump when querying V$LOGMNR_CONTENTS
10.2.0.2 4477328 Dump (eoa_get_dedicated_ctx) using migratable sessions with stored Java
10.2.0.2 4485790 Fix from bug 4132901 missing from 10.2
10.2.0.2 4487195 Dump (kghtshrt) / memory corruption as PQ slave may share SQL incorrectly
10.2.0.2 4497530 Streams capture dump [krvxgctasi] mining CTAS operation
10.2.0.2 4500915 Dump (strlen/sprintf) during select with AUDIT_TRAIL=db_extended
10.2.0.2 4502658 Dump with STAR temp table transformation
10.2.0.2 4504041 Dump (koxsh2copy) inserting into an XML table using createSchemaBasedXML()
10.2.0.2 4507302 Dump (msqfun) from SQL generation
10.2.0.2 4517291 Dump (evaopn2) from native pipelined table function with a CONCATENATION
10.2.0.2 4517846 Dump from remote query when SQL_TRACE / event 10046 set
10.2.0.2 4530273 OERI[qkeexhs] can occur using binds
10.2.0.2 4544429 Dump (lxregmatpush) from regular expression evaluation
10.2.0.2 4547785 Dump (kudmxopp) when accessing external table in parallel
10.2.0.2 4551356 Dump (evagrp) using GROUPING functions
10.2.0.2 4551680 Dump (in kcrf_pvt_strand_bind) with NUMA
10.2.0.2 4573980 Dump in qeesTraverseExpr using a GROUPING operator in a GROUP BY clause
10.2.0.2 4629844 Dump / wrong results from query with CHECK constraint
10.2.0.2 4630549 ORA-904 / dump from MERGE SQL
10.2.0.2 4693247 Dump (kfcgetbuffer) while resizing a tablespace using ASM storage

2.1.112 Miscellaneous

The following table lists the Miscellaneous bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4940262 P Allow 2.7Gb SGA on 32bit Linux
10.2.0.3 3603160 AWR should recompile SYS views after purge operation drops partitions
10.2.0.3 4522561 Alert log grows fast in an archiver stuck situation - ORA-19504
10.2.0.3 4624398 "SELECT FOR UPDATE WAIT" lock timeout may be longer than specified
10.2.0.3 4670363 Repeated "LGWR: Archivelog for thread" trace messages
10.2.0.3 4883174 Archive produces to many log entries "kcrrwkx: nothing to do (end)"
10.2.0.3 4998064 Event 10298 trace should not be enabled for any level
10.2.0.3 5098050 Log writer does not close a stale log member until max errors is reached.
10.2.0.3 5099908 SELECT FOR UPDATE WAIT X timeout may be longer than specified
10.2.0.3 5228464 genezi executable not included in instant client package
10.2.0.2 4519934 AUTO_SPACE_ADVISOR_JOB can fail with ORA-44003
10.2.0.2 4632780 PMON "failed to acquire latch" during shutdown

2.1.113 Notable change of behaviour introduced in 10.2.0.2

The following table lists the Notable change of behaviour introduced in 10.2.0.2 bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.2 4871035 Disable "row shipping" by default in 10.2.0.2 onwards

2.2 PL/SQL

The following list bugs for the PL/SQL product.

2.2.1 PL/SQL

The following table lists the PL/SQL bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4326946 OERI[15431] / memory leak from PLSQL
10.2.0.3 4444429 ORA-6550 and PLS-801 from remote synonym translation via DB LINK
10.2.0.3 4643322 ORA-22167 possible from BULK DML RETURNING INTO
10.2.0.3 4654321 UTL_MAIL malforms message body for certain email clients
10.2.0.3 4661687 Dump under pitcbrv_recv from UTL_HTTP
10.2.0.3 4698207 ORA-22922 getting CLOB when CURSOR_SPACE_FOR_TIME set to TRUE
10.2.0.3 4705928 Memory leak using small VARRAYs in a callout
10.2.0.3 4768178 Dump (pfrdef1_get_tdo) passing ADT to PLSQL
10.2.0.3 4864649 ORA-1001 from REF cursor
10.2.0.3 4872783 No space-pad in comparing with concatinated variables
10.2.0.3 4889301 Regular expressions on CLOBS fails if destination CLOB = input CLOB
10.2.0.3 4906932 Dump (in pfrfln) using native PLSQL pipelined function
10.2.0.3 5102847 DBMS_UTLITY.FORMAT_CALL_STACK returns nothing when called via an RPC
10.2.0.3 5118748 ORA-4030 / memory leak using PLSQL with collections ("pmucp2upkl korfp")
10.2.0.3 5249253 Dump in diu_node_use_statistics
10.2.0.2 4319529 REPLACE calls for CLOB variables can leak temporary LOBs
10.2.0.2 4375405 PLSQL may assign wrong variable value
10.2.0.2 4463574 A false PLS-123 error can occur compiling PLSQL
10.2.0.2 4466305 Corrupt mails from UTL_MAIL if subject over 65 characters long
10.2.0.2 4522817 UTL_COMPRESS.LZ_COMPRESS fails with ORA-29294
10.2.0.2 4572934 ORA-6502 when using char semantics and char (n byte)
10.2.0.2 4577670 ORA-22921 creating wrapped text using dbms_ddl.wrap in multibyte
10.2.0.2 4753869 OERI[kopp2upic#807: invalid coll] / OERI:kodpunp1 when out of memory

2.3 Oracle Transparent Gateway for IBM DRDA

The following list bugs for the Oracle Transparent Gateway for IBM DRDA product.

2.3.1 Oracle Transparent Gateway for IBM DRDA

The following table lists the Oracle Transparent Gateway for IBM DRDA bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 5024716 FLOAT column not converted correctly over TG4DRDA
10.2.0.3 5373604 Memory leak using block fethcing over HS with hs_fds_fetch_rows > 1
10.2.0.2 4651566 Distributed transactions to TG4DRDA can fail

2.4 SQL*Plus

The following list bugs for the SQL*Plus product.

2.4.1 SQL*Plus

The following table lists the SQL*Plus bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4510978 Sqlplus SPOOL output much slower in 10g than 8i
10.2.0.3 4878869 Stack space of sqlplus process grows during startup
10.2.0.2 4595395 CLEAR SCREEN causes SQLPLUS command line to dump

2.5 Precompilers

The following list bugs for the Precompilers product.

2.5.1 Precompilers

The following table lists the Precompilers bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 3559326 Pro C errors for "naked" type declarations
10.2.0.3 3698018 Enhancement - add ProC/C++ OCI level statement caching (STMT_CACHE)
10.2.0.3 4639508 Precompile dumps when SQLCHECK=FULL if code references remote objects
10.2.0.3 4889483 Procobol PCB-400 from EXEC SQL INCLUDE without a period
10.2.0.3 5009280 Scrolling cursors do not work when on XA connection in Pro
10.2.0.3 5128494 Pro connection pool signals ORA-18 using CONTEXT ALLOCATE and FREE repeatedly
10.2.0.2 4204585 ProC produces bad code with lines=yes if SQL includes a '\'
10.2.0.2 4335104 ProCobol generates invalid code for IF block after EXEC CICS

2.6 Oracle Net Services

The following list bugs for the Oracle Net Services product.

2.6.1 Oracle Net Services

The following table lists the Oracle Net Services bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 3306350 Client connections using NAMES do not close the connection
10.2.0.3 3807408 Cannot externally authenticate user with quote in username
10.2.0.3 3934729 Random dumps (nstimexp) using DCD with shared servers
10.2.0.3 4114966 TNSPING dumps when names.no_persistent_resources=true is set in sqlnet.ora
10.2.0.3 4279598 Change to default behaviour for keeping LDAP client connections open
10.2.0.3 4531069 ORA-3113 using pool=on when sqlnet.expire_time is set
10.2.0.3 4610806 Executables may dump under nnflfrm
10.2.0.3 4769781 Client hangs on 2nd connect using LDAP directory server
10.2.0.3 4933023 Bequeath connections fail if SQLNET.OUTBOUND_CONNECT_TIMEOUT is set
10.2.0.3 4944639 ORA-4052 from using LDAP named dblink in PLSQL
10.2.0.3 5123958 ORA-12571/ORA-12536 with sqlnet.outbound_connect_timeout set
10.2.0.3 5368791 outbound_connect_timeout needs to be at address level, not connect level
10.2.0.2 4410137 "IO exception checksum failed" using 3des168 encryption
10.2.0.2 4420032 Connection leak in OJDBC thin client library file ojdbc_14.jar

2.7 Oracle interMedia

The following list bugs for the Oracle interMedia product.

2.7.1 Oracle interMedia

The following table lists the Oracle interMedia bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4886281 IMG-703 uploading a large jpeg file
10.2.0.3 4939295 updatetime is not updated after putmetadata
10.2.0.2 4547759 interMedia always errors for non standard DICOM objects
10.2.0.2 4550041 XML Schema Definition, Conformance Level Fix

2.8 Oracle Text

The following list bugs for the Oracle Text product.

2.8.1 Oracle Text

The following table lists the Oracle Text bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 3879892 Filtering may fail on certain Ichitaro documents (DRG-11207)
10.2.0.3 4359997 Dump / spin Text indexing Chinese/Japanese with wrong NLS setting
10.2.0.3 4366444 Cursor leak using SYNC(on commit) with Text
10.2.0.3 4465964 Dump using CTX_DOC.THEMES with NLS_LENGTH_SEMANTICS=CHAR
10.2.0.3 4541137 umlaut character in token not stored correctly in Text index in UTF8
10.2.0.3 4589659 CTX_DOC.MARKUP incorrect using Japanese VGram lexer
10.2.0.3 4742903 Text query expansion results in too many terms
10.2.0.3 4776116 Dump Text indexing PDF with certain Korean characters
10.2.0.3 4898338 worldlexer fails for some characters (DRG-50857)
10.2.0.3 4925189 CTXCAT query may return wrong result when using multi-colum index
10.2.0.3 4957634 Text Index creation with worldlexer can dump (drlwtkn)
10.2.0.3 5005469 There is no script to assist with migration from korean_lexer to korean_morph_lexer
10.2.0.3 5014128 Context index optimize with rebuild option takes long time
10.2.0.3 5036380 worldlexer index creation can dump (drlwtkn)
10.2.0.3 5060137 Progessive relaxation returns no hits although it should
10.2.0.3 5079472 ORA-54 when doing optimize_index with rebuild option and sync simultaneously
10.2.0.3 5095220 Parallel Optimize Index Rebuild does not run in parallel
10.2.0.3 5150177 Create Text index on master detail datastore is slow
10.2.0.3 5220353 No error returned when indexing fails on a BFILE column in a multicolumn datastore
10.2.0.3 5233309 ORA-1426 possible creating Text index
10.2.0.2 4147186 CTX_DOC.MARKUP may produce wrong tag positions
10.2.0.2 4165079 Wrong results from attribute search with XML tag names over 64 characters long
10.2.0.2 4465587 CTXHX fails filtering XML and CSV using unicode as output charset
10.2.0.2 4472797 Text upgrade scripts do not upgrade to latest Patchset
10.2.0.2 4523989 CTX_REPORT.TOKEN_INFO can dump in dreetsl1
10.2.0.2 4628013 Oracle Text cannot filter Microsoft Outlook (msg) files

2.9 Advanced Networking Option

The following list bugs for the Advanced Networking Option product.

2.9.1 Advanced Networking Option

The following table lists the Advanced Networking Option bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 5141966 ORA-1041 on Kerberos authenticated connections to an AIX RDBMS from a Windows
10.2.0.2 4278371 P Win: Authentication fails if workgroup name same as NetBIOS name
10.2.0.2 4308824 P Win: NTS authentication fails to MTS connection

2.10 Oracle Database Configuration Assistant

The following list bugs for the Oracle Database Configuration Assistant product.

2.10.1 Oracle Database Configuration Assistant

The following table lists the Oracle Database Configuration Assistant bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4714878 DBCA cannot use or delete DBA templates
10.2.0.2 4705807 rconfig and dbca scripts do not pick up ORACLE_BASE
10.2.0.2 4709052 Ultrasearch config fails from DBCA on a precreated DB

2.11 Oracle ODBC Driver

The following list bugs for the Oracle ODBC Driver product.

2.11.1 Oracle ODBC Driver

The following table lists the Oracle ODBC Driver bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4150034 Some ODBC API catalogue functions can be slow
10.2.0.3 4371966 ODBC "input string too long, limit 4096" if long string has CR / LF
10.2.0.3 4735799 ODBC driver can truncate data retrieved with SQLFetchScroll()
10.2.0.3 4878228 ODBC dump
10.2.0.3 4878372 ODBC memory leak
10.2.0.3 4878377 ODBC memory leak
10.2.0.3 4880062 Calling SQLBindCol after SQLColumns returns 0 as the datatype
10.2.0.3 4886344 ODBC uninitialized memory read
10.2.0.3 4886366 ODBC uninitialized memory read
10.2.0.3 4961312 ODBC memory leak vor SQLBulkOperations
10.2.0.3 5015342 ODBC sqlcolumns() does not return correct values for all datatypes
10.2.0.3 5220440 ODBC driver truncates CLOB against unicode database

2.12 JPublisher

The following list bugs for the JPublisher product.

2.12.1 JPublisher

The following table lists the JPublisher bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4607523 JPUB ORA-19011 when the return type (XMLTYPE) is over certain

2.13 Oracle Spatial

The following list bugs for the Oracle Spatial product.

2.13.1 Oracle Spatial

The following table lists the Oracle Spatial bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4211810 Spatial does not work for usernames containing a \ backslash
10.2.0.3 4450497 Upgrade 9.0 to 10g causes SDO_INDEX_METADATA null fetch errors
10.2.0.3 4571717 UNION of two valid geometries returns ORA-13350
10.2.0.3 4607533 Wrong results from SDO_INTERSECTION
10.2.0.3 4692886 Spatial function sdo_lrs.offset_geom_segment has problems with Arcs
10.2.0.3 4707623 SDO_INTERSECTION returns wrong results for different tolerances
10.2.0.3 4723914 ORA-6502 / EXP-78 when exporting function based spatial indexes
10.2.0.3 4742014 Wrong result from SDO_INTERSECTION
10.2.0.3 4745776 Incomplete results for spatial query
10.2.0.3 4752108 Domain index opererator applied to all UNION ALL branches
10.2.0.3 4919879 GeoRasterViewer fails with java.lang.NoClassDefFoundError
10.2.0.3 5019846 sdo_geor.getcellvalue() wrongly raises ORA-13457
10.2.0.3 5037707 sdo_geom.relate determine returns unknown mask: 010011011
10.2.0.3 5055754 Dump [mdgoplun] when the result of SDO_DIFFERENCE is a null geometry
10.2.0.3 5092335 SDO_NN query using SDO_BATCH_SIZE performs badly
10.2.0.3 5115096 ALL_SDO_NETWORK_CONSTRAINTS is missing OWNER and CLASS columns
10.2.0.3 5152407 CHANGEFORMATCOPY returns wrong result when only compression ratio is changed
10.2.0.3 5175219 Wrong results from SDO_INTERSECTION
10.2.0.3 5210128 R-Tree metadata reads do not use bind variables
10.2.0.3 5243019 Memory leak in SDO_GEOM.WITHIN_DISTANCE, SDO_WITHIN_DISTANCE, SDO_NN
10.2.0.3 5247178 Wrong SDO_INTERSECTION respective SDO_AREA results depending on tolerance
10.2.0.3 5375259 Wrong results from SDO_RELATE
10.2.0.3 5487727 SDO_ANYINTERACT can be slow
10.2.0.2 3754304 COMMIT after INSERT into GEOMETRY fails with ORA-604 / ORA-6512 from MDSYS.SDO_IDX
10.2.0.2 4405052 ORA-13331 from SDO_LRS.DYNAMIC_SEGMENT at spatial discontinuity
10.2.0.2 4405471 SDO_GEOM.SDO_INTERSECTION returns NULL on geometries that intersect
10.2.0.2 4419284 Oracle Spatial router not returning optimal route
10.2.0.2 4419865 ORA-13122 with concurrent Spatial sessions using same topology
10.2.0.2 4437864 getcellcoordinate returns wrong result if the input coordinate is in cell space
10.2.0.2 4466502 Spatial topology - remove edge does not work if the edge is a loop
10.2.0.2 4483414 WITHIN-DISTANCE may miss rows following an uncommitted INSERT
10.2.0.2 4490900 SDO_TOPO_MAP may throw TopoEntityNotFoundException
10.2.0.2 4514980 TOPO feature update does not always lock primitives
10.2.0.2 4528923 Feature layer in constructor cannot include feature table owner
10.2.0.2 4865248 Memory size required for loading unblocked images is double the image size
10.2.0.2 4902398 sdo_geor.getcellvalue cannot handle negative row/column number

2.14 Oracle Ultra Search

The following list bugs for the Oracle Ultra Search product.

2.14.1 Oracle Ultra Search

The following table lists the Oracle Ultra Search bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4191512 URL result by Ultrasearch does not work if there is a SPACE
10.2.0.3 4663819 "max size" of "temporary directory location and size" does not work
10.2.0.3 4760824 ORA-1422 when same document is crawled in two file datasources
10.2.0.2 4477115 USCA fails with OID SSL login

2.15 Oracle Database Upgrade Assistant

The following list bugs for the Oracle Database Upgrade Assistant product.

2.15.1 Oracle Database Upgrade Assistant

The following table lists the Oracle Database Upgrade Assistant bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 3883839 Startup RAC DB In Upgrade Mode Fail
10.2.0.3 4714878 Cannot Use Or Delete DBA Templates On 10.1.0.4
10.2.0.3 5467397 DBUA Needs A Way To Support 64 Bit Upgrade
10.2.0.3 5109473 10.2dv-060315: EM Failed In DBCA During Add RAC Node
10.2.0.3 5052501 10.2dv-060214: DBCA Prompts Listener Warning During 2nd Datavault RAC Install
10.2.0.3 4690433 DBCA Should Not Create Autostart Oracleservice<Sid> Services.

2.16 JDBC

The following list bugs for the JDBC product.

2.16.1 JDBC

The following table lists the JDBC bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4272639 JDBC returns XAER_RMERR in xa_commit
10.2.0.3 4398431 Hang when retrieving a connection from the implicit connection cache
10.2.0.3 4426058 First end-to-end metrics after start of VM are not sent to server
10.2.0.3 4507211 Thin JDBC connection properties terminal not reflected in V$SESSION
10.2.0.3 4509540 NullPointerException from omitting registerOutParameter() when calling PLSQL
10.2.0.3 4551798 JDBC clients can get OERI[12333] on cancel from second thread
10.2.0.3 4566966 ORA-1460 binding NCHAR to a CALL statement in JDBC
10.2.0.3 4580690 JDBC returns wrong date from a TIMESTAMPTZ column
10.2.0.3 4638698 JDBC getDate returns wrong value for a specific dates
10.2.0.3 4670851 Binding CustomDatum for a CHAR fails
10.2.0.3 4688040 JDBC does not support batch size > 65535 in 10g
10.2.0.3 4688156 NullPointerException possible if network error occurs
10.2.0.3 4714537 Named WHERE clause parameter must be surrounded by spaces
10.2.0.3 4732343 Type evolution not fully supported by JDBC
10.2.0.3 4736325 JDBC does not handle space between ":" and bind name
10.2.0.3 4751145 ArrayOutOfBoundsException when fetchsize is changed
10.2.0.3 4768476 ArrayOutOfBoundsException with many NCHAR OUT binds
10.2.0.3 4880797 Enhancement: Add JDBC support for Albanian and Macedonian Locales
10.2.0.3 4891464 NCHAR literal binds parsed incorrectly in JDBC
10.2.0.3 4896035 removeCache does not have an abort option
10.2.0.3 4904415 ORA-1459 with 2 PlsqlIndexTable binds in JDBC
10.2.0.3 4904868 JDBC deadlock using Scrollable ResultSet
10.2.0.3 4915735 getProcedures() returns duplicate rows
10.2.0.3 4931235 Dump (lxgu2t) / memory corruption from stored Java using String binds
10.2.0.3 4958448 JDBC XA cannot end a suspended transaction when using 2 connections
10.2.0.3 4963720 JDBC Statement cache holding more memory than expected
10.2.0.3 4998582 JDBC OCI throws exception executing PLSQL with OUT parameters using CALL
10.2.0.3 5019367 racle.net.CONNECT_TIMEOUT does not work when server / listener is hanging
10.2.0.3 5021342 Connection errors occur when interupting network with JDBC Thin
10.2.0.3 5045849 TIMESTAMP value incorrect when retrieved using getTimestamp with Calendar object
10.2.0.3 5058024 ArrayOutOfBoundsException executing SQL with using binds and ScrollableResultSet
10.2.0.3 5071674 handleAbandonedConnection() callback method does not work
10.2.0.3 5111887 Java thread deadlock registering OUT parameter concurrent with closing connection
10.2.0.3 5139924 OutOfMemoryError when getString is used against a Clob column
10.2.0.3 5157526 JDBC driver is not able connect using service_name and JNDI of J2EE servers
10.2.0.3 5174701 SQLException fetching Timestamp through getTimestamp()
10.2.0.3 5246867 V$SESSION.PROGRAM is not populated properly for JDBC Thin
10.2.0.2 3735857 V$SESSION.OSUSER not populated for JDBC clients
10.2.0.2 4257485 ArrayIndexOutOfBounds from defineColumnType with over 100 columns
10.2.0.2 4294423 internal error: image is not in 8.1 format
10.2.0.2 4375870 OracleOCIConnectionPool default constructor missing some initialization
10.2.0.2 4388999 Multithreaded JDBC gets NetException accessing LONG RAW
10.2.0.2 4390125 JDBC update count is wrong with batching
10.2.0.2 4399371 ArrayIndexOutOfBoundsException using statement caching
10.2.0.2 4439540 Close of ScrollableResultset may deadlock at Java level
10.2.0.2 4448950 OERI:12333 binding a NULL as FIXED_CHAR from JDBC
10.2.0.2 4451780 Client side dump using getObject() on a closed Statement
10.2.0.2 4455912 Using a LONG column within a transaction causes xa_end() to hang in JDBC
10.2.0.2 4463416 Resultset.getDate can return ArrayIndexOutOfBoundsException
10.2.0.2 4488715 ORA-1483 on changing bind types for numeric/date binds
10.2.0.2 4489098 initxa.sql needs to specify pragma
10.2.0.2 4492522 PhysicalConnection.getVersion is syncronized
10.2.0.2 4499144 refreshCache( REFRESH_INVALID_CONNECTIONS ) does not work
10.2.0.2 4504411 JDBC can get ORA-6502 from PLSQL calls when supplying maxLength to registerOutParameter()
10.2.0.2 4551137 NullPointerException when fetching raw column with NULL value
10.2.0.2 4594085 JDBC Thin sets timezone improperly
10.2.0.2 4629654 ORA-12705 at JDBC connect with mixed language/country for locale
10.2.0.2 4652261 setBytes() inserts null into BLOB column after a previous call to setNull()

2.17 Oracle Security Service

The following list bugs for the Oracle Security Service product.

2.17.1 Oracle Security Service

The following table lists the Oracle Security Service bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4082155 JVM may dump in SSL code under load (rare)
10.2.0.3 4555795 Certificate mapping - fetch value from Subject Alt Name
10.2.0.3 4700543 SSL sessions can fail during negotiation
10.2.0.3 4715022 OWM unable to save a wallet after importing trusted certficate
10.2.0.3 4892623 Import of trusted CA cert in OWM can fail
10.2.0.3 5055442 SSL connections fail when running in FIPS mode.
10.2.0.2 3066733 Cannot create a certificate request with OWM that contains special characters
10.2.0.2 5396837 File handle leak from nzcrlGetCRLFromFile

2.18 Oracle XML Developers Kit

The following list bugs for the Oracle XML Developers Kit product.

2.18.1 Oracle XML Developers Kit

The following table lists the Oracle XML Developers Kit bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4563343 Classes generated by Jaxb Class Generator fail with exception
10.2.0.3 4638391 Wrong output from concat of XSL variable or attributes with normal strings
10.2.0.3 4662345 TRANSX Java API is slow
10.2.0.3 4680398 XSL Processor can leak memory when transforming stylesheet
10.2.0.3 4736248 XDK fails to compile an XSL file if baseuri contains a space character
10.2.0.3 4744317 XSLT transform fails when tag contains '_' at beginning
10.2.0.3 4760148 JAXP transform does not keep output escaping
10.2.0.3 4760744 Wrong result when value of an attribute is same as its name
10.2.0.3 4891220 XSLProcess() can allocate a lot of memory
10.2.0.3 5012135 domsample using xdk new C++ api leaks memory
10.2.0.3 5099703 ISSCHEMAVALID very slow for certain documents
10.2.0.2 4443086 XMLDOMException thrown in appendChild
10.2.0.2 4469241 CXmlCtx constructor cannot set encoding properties
10.2.0.2 4529007 XSL transformation hangs / LPX-302 with multiple sorts
10.2.0.2 4533048 XSLT transformation does not use correct memory context in List management
10.2.0.2 4545869 XDK for C parser generates LPX-256 when parsing valid XML / DTD file
10.2.0.2 4547445 CR LF characters converted to blank space in JAXB
10.2.0.2 4585869 XMLPrintDriver.close() does not close the handle properly

2.19 Oracle XML SQL Utility (XSU)

The following list bugs for the Oracle XML SQL Utility (XSU) product.

2.19.1 Oracle XML SQL Utility (XSU)

The following table lists the Oracle XML SQL Utility (XSU) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 5082904 JDBC Thin NullPointerException in OracleXMLQuery.setSkipRows()

2.20 Net Configuration Assistant - NetCA

The following list bugs for the Net Configuration Assistant - NetCA product.

2.20.1 Net Configuration Assistant - NetCA

The following table lists the Net Configuration Assistant - NetCA bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4536817 NETMGR unable to create a NET entry with a service_name longer than 8 characters

2.21 Oracle OLAP

The following list bugs for the Oracle OLAP product.

2.21.1 Oracle OLAP

The following table lists the Oracle OLAP bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4291719 ADVISE_CUBE() does not produce different valuesets for different precompute %
10.2.0.3 4554310 Closing connection with open cursormanager causes OERI:xsenter
10.2.0.3 4592645 Dump (lxowrichar) from OLAP
10.2.0.3 4594651 DBMS_ODM reports ORA-6533 subscript beyond count
10.2.0.3 4652142 OLAP import fails if export EIF DB charset is different
10.2.0.3 4689285 UGA memory leak and AW corrupt after maintenance
10.2.0.3 4692633 Poor performance of last descendant queries
10.2.0.3 4693369 OLAP dump in xsxeq running aggregate
10.2.0.3 4722589 Wrong results joining two active catalog OLAP table function views
10.2.0.3 4745026 Wrong results against value-based hierarchy with depth=20
10.2.0.3 4768374 Dump in OLAPI - broken pipe using EPB ownership DIMS
10.2.0.3 4768531 Allocate fails with protect and negative source value
10.2.0.3 4775129 OLAP DML function AW(ACQUIRED) does not work
10.2.0.3 4864556 Compile a model in an AW can dump
10.2.0.3 4919367 OLAP cannot add value to cube
10.2.0.3 4938850 divide-by-zero exception in geneva forecasting
10.2.0.3 4969277 OLAP assign trigger on a QDR variable reports wrong value
10.2.0.3 5079963 delete/clear data does not work when using compressed composites
10.2.0.3 5117953 OLAP build log can show the wrong log
10.2.0.3 5123809 Error adding a measvalstep - ORA-932 "inconsistent datatypes"
10.2.0.3 5141255 oracle.AWXML.AWException error creating an index
10.2.0.3 5154963 Partial eif export followed by an import does not finish
10.2.0.3 5203715 Excessive OLAP process memory allocation
10.2.0.3 5243313 CWM2_OLAP_AW_ACCESS invalid after upgrade to 10.2.0.2
10.2.0.2 2968950 Analytical workspace TrackPrg does not return expected results
10.2.0.2 4101871 Dump executing some analytic workspace programs
10.2.0.2 4402965 limit to existing dimension value unsuccessful (ORA-35654)
10.2.0.2 4405509 OLAP display name columns are too small
10.2.0.2 4429146 Incorrect limit generated on table function when label clause used in limitmap
10.2.0.2 4461098 Collection of fixes to DBMS_ODM for OLAP
10.2.0.2 4482878 EIF import does not work correctly (dimvalues get lost)
10.2.0.2 4504468 Aggregation with weightby specified for illegal operator dumps
10.2.0.2 4507043 ORA-6510 attempting to enable SQL access to an OLAP cube
10.2.0.2 4553859 Wrong results from 10.2 OLAP with 10.1 client
10.2.0.2 4591667 OLAP migration from 6.3.4 to Oracle 10g does not work properly
10.2.0.2 4633649 Relation becomes invalid when deleting multiple members of dimension
10.2.0.2 4636635 Standard form objects are not maintained after eif import into standard form AW
10.2.0.2 4636982 Limit keep nth sets wrong status after context apply
10.2.0.2 4676906 Dump running OLAP SQL query with conditional calc

2.22 Enterprise Manager for Grid Control

The following list bugs for the Enterprise Manager for Grid Control product.

2.22.1 Enterprise Manager for Grid Control

The following table lists the Enterprise Manager for Grid Control bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 5096503 Flashback Existing Table:Table Selected From Flashlight No Double Quotation Mark
10.2.0.3 4685882 NLS TRANS:GC10201MM10: Flashback Table Failed With Schema Name Containing Dot
10.2.0.3 4576517 GCUPGR: Restore Control File - Does Not Accept Values Changed From Advanced OPTI
10.2.0.3 4626115 Cannot Restore Controlfile With ASM Storage
10.2.0.3 4703149 NLS TRSN: Help: RMAN Encryption Is Not Exposed In GC
10.2.0.3 3876149 Creation Of Physical Standby Database With EM Grid 10g Dataguard Fails
10.2.0.3 4703400 Ora-20411 Submitting Streams Job Through EM 10g Database Control
10.2.0.3 4381955 Password Verification/Session \Limits Implementd Via Profiles Causing Issues
10.2.0.3 4755328 Ora-29532 Errors Got During 10104 To 10202 UPG; Upgrade Hangs At 87 %; Shared OH
10.2.0.3 4947197 EMCA Fails When Several SIDs Are Written In EM_SID_LIST Parameter
10.2.0.3 5039179 [PSR10202-LNX-RC3] Need To Set TZ When Using EMCTL To Start Dbconsole
10.2.0.3 5053934 EMCP Should Not Blindly Overwrite /Tmp/Orainst.Loc
10.2.0.3 4445730 ADDM Additonal Informaiton Should List Warnings That Are Relevant To The Task
10.2.0.3 3467825 817 Database Useraudit Throw Metric Error On LABSMPQA-Pc20
10.2.0.3 3848831 Grid Control Top Sessions Reports Same Data For All Active Sessions
10.2.0.3 4929856 Cluster Database Shows As Up With 2 Instances Shown As Down
10.2.0.3 4638757 NLS:GC10201MM8:Internal Error Of Cluster Managed Service Failed For We Target DB
10.2.0.3 5148171 APPSST: Rconfig - Archive Log Status
10.2.0.3 5259576 Multiplex Redo Logs With Non-Omf Storage Gives Error
10.2.0.3 5192409 Adding Short-Named Discovered Host Causes Exception
10.2.0.3 3509907 EM:Administration:Users: Error Occurs When Change Default Role From User
10.2.0.3 4866231 Agent Crashes In Direct Sga Fetchlet When Collector Shared Memory Doesn't
10.2.0.3 5256706 Pass The Buffer Size Through The Written Parameter Of LIBDSGA APIS
10.2.0.3 4769090 ASM 'Internal' Storage Is Calculated And Displayed Incorrectly
10.2.0.3 4889538 Grid Control : Selecting Tablespace Link In Administration Page <Hangs?>
10.2.0.3 4766676 Support Dbcontrol In Https By Default - EMCTL
10.2.0.3 4760696 OMS:NT:Page Hanging On "Load Data From User Files" Links First Page
10.2.0.3 4667071 Problem Regarding Export Of Metadata Of Table/Schema On MM9

2.23 Oracle Globalization Development Kit

The following list bugs for the Oracle Globalization Development Kit product.

2.23.1 Oracle Globalization Development Kit

The following table lists the Oracle Globalization Development Kit bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.3 4643021 orai18n.jar should not depend on the Oracle XML parser
10.2.0.2 4459467 Formatting "0" returns incorrect value if format mask does not have any decimal

3 Documentation Accessibility

Our goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For more information, visit the Oracle Accessibility Program Web site at http://www.oracle.com/accessibility/.

Accessibility of Code Examples in Documentation

Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.

Accessibility of Links to External Web Sites in Documentation

This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.

TTY Access to Oracle Support Services

Oracle provides dedicated Text Telephone (TTY) access to Oracle Support Services within the United States of America 24 hours a day, seven days a week. For TTY support, call 800.446.2398.

Oracle Database 10g List of Bugs Fixed, Oracle10g Release 10.2.0.3

Copyright © 2006, Oracle. All rights reserved.

The Programs (which include both the software and documentation) contain proprietary information; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disassembly, or decompilation of the Programs, except to the extent required to obtain interoperability with other independently created software or as specified by law, is prohibited.

The information contained in this document is subject to change without notice. If you find any problems in the documentation, please report them to us in writing. This document is not warranted to be error-free. Except as may be expressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose.

If the Programs are delivered to the United States Government or anyone licensing or using the Programs on behalf of the United States Government, the following notice is applicable:

U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the Programs, including documentation and technical data, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement, and, to the extent applicable, the additional rights set forth in FAR 52.227-19, Commercial Computer Software—Restricted Rights (June 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065

The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and we disclaim liability for any damages caused by such use of the Programs.

Oracle, JD Edwards, PeopleSoft, and Retek are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

The Programs may provide links to Web sites and access to content, products, and services from third parties. Oracle is not responsible for the availability of, or any content provided on, third-party Web sites. You bear all risks associated with the use of such content. If you choose to purchase any products or services from a third party, the relationship is directly between you and the third party. Oracle is not responsible for: (a) the quality of third-party products or services; or (b) fulfilling any of the terms of the agreement with the third party, including delivery of products or services and warranty obligations related to purchased products or services. Oracle is not responsible for any loss or damage of any sort that you may incur from dealing with any third party.

Oracle Logo
Copyright © 2006, Oracle. All rights reserved.