Skip Headers
Oracle Database List of Bugs Fixed
10g Release 2 (10.2.0.4) Patch Set 3
 
 

Oracle Database

List of Bugs Fixed

10g Release 2 (10.2.0.4) Patch Set 3

 

February 2008

This document lists the generic bugs fixed in the Oracle Database 10g Release (10.2.0.4) Patch Set and all previous Oracle Database patch sets. Fixed platform-specific bugs are listed in the Oracle Database Patch Set Notes 10g release 2 (10.2.0.4) 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.4 4204383 Dump [kkqtnlocbk] optimizing ANSI OUTER JOINs with subqueries
10.2.0.4 4702830 OERI[kkoljt1] when using star transformation with an ANSI outer join
10.2.0.4 4901291 Wrong results with left outer joins on view with a function
10.2.0.4 5188321 wrong results (no rows) from ANSI outer join
10.2.0.4 5590396 Dump or Wrong Results with ANSI JOINS and CONNECT BY
10.2.0.4 5652086 OERI[15160] from ANSI join
10.2.0.4 5765958 OERI[qcscpqbTxt] / OERI[qcsfbdnp:1] from ANSI query in PLSQL
10.2.0.4 5964193 OERI[kkqsRewriteCorrCols-1] during query rewrite with ANSI joins
10.2.0.4 5988085 Dump [kkodsel] from STAR transformation with ANSI view
10.2.0.4 6033480 High parse time of query when using ANSI style joins
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.4 5386204 Block corruption / OERI[kddummy_blkchk] after direct load of ASSM segment
10.2.0.4 5530583 ASSM managed INDEX updates can be slow compared to non-ASSM
10.2.0.4 5557421 Self-deadlock (ORA-60) on FB enqueue if session killed during INSERT in ASSM
10.2.0.4 5637976 ORA-8103/ORA-1410 from concurrent INSERT / export on ASSM tables
10.2.0.4 5695131 HW enqueue deadlock / OERI:1153 from array insert with SAVE EXCEPTIONS to READ ONLY ASSM segment
10.2.0.4 5728380 DML may spin under ktspffc searching for space in ASSM segment
10.2.0.4 6086497 OERI[ktspgetmyb-1] / bitmap segment corruption for ASSM segments
10.2.0.4 6376915 HW enqueue contention for ASSM LOB segments
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 / Secure Networking

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

Fixed in Release Bug Number Description
10.2.0.4 4395849 ESM tool hangs connecting to directory server on SSL port
10.2.0.4 5079968 SSL auth client connections create erroneous trace files in udump
10.2.0.4 5527753 ESM errors and does not show global role, which is added by ESM cmdline
10.2.0.4 5584798 Unnecessary trace files using EUS with LDAP_DIRECTORY_PASSWORD='PASSWORD'
10.2.0.4 6005762 SYS_CONTEXT('USERENV','AUTHENTICATION_METHOD') returns NULL

2.1.4 Advanced Queuing

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

Fixed in Release Bug Number Description
10.2.0.4 4478139 ORA-28031 "maximum of 148 enabled roles" when creating queue table
10.2.0.4 4618808 AQ operation requiring exclusive lib cache lock may hang
10.2.0.4 4715375 OERI[kwqmtdel] in q00 process in RAC when any instance goes down
10.2.0.4 4719848 Streams DELETE_ERROR does not maintain AQ$_QTABLE_I
10.2.0.4 4733582 Upgrade to 10.2 deletes statistics on AQ tables
10.2.0.4 4745691 OERI[kghufree_06] from AQ propogation of XML payload
10.2.0.4 5018886 OERI:[kwqitnmptme:wait] in Qnnn during propagation of delayed messages
10.2.0.4 5092843 Dump (kpceclose) in EMON
10.2.0.4 5095889 PGA leak during propagation in "kwqpcbk:koioalm" and "kwqpcbk:csid"
10.2.0.4 5225596 AQ propogation does not work after failover
10.2.0.4 5358598 EMN0 not posted for ha notification
10.2.0.4 5408664 Messages not marked as undeliverable after transformation failure
10.2.0.4 5415506 ORA-4020 when dbms_aqadm.purge_queue_table and select are run
10.2.0.4 5439588 Notifications not delivered when client machine has multiple NICs
10.2.0.4 5452715 OERI[kwqbgqc: bad state] reported after restart of database
10.2.0.4 5494866 PLS-302 'dbver_10i' importing 10g export into 9i with AQ
10.2.0.4 5506702 Dequeue delay experienced after reconfiguration
10.2.0.4 5523578 DBMS_AQADM.add_subscriber fails with ORA-1925 "maximum of x roles exceeded"
10.2.0.4 5526245 "ksxplookup: warning cnh incarnation number" messages in QMNC trace
10.2.0.4 5545530 EMON may spin in kpcopen
10.2.0.4 5561130 Performance of long running transaction using AQ degrades over time
10.2.0.4 5580871 AQ bytes message <= 2000 bytes incompatible between PLSQL and Java
10.2.0.4 5590163 Message dequeued more than once from single consumer queue
10.2.0.4 5594352 JMS-120 / OCI-1858 when dequeueing AQ bytes message with JDBC-OCI
10.2.0.4 5605319 Cursor leak from QMON coordinator exceptions
10.2.0.4 5608198 Memory leak by advanced queuing XML transformation
10.2.0.4 5648610 ORA-25235 during AQ propagation
10.2.0.4 5654680 JMS worker thread does not end if exception thrown in onMessage() method
10.2.0.4 5655612 AQ$_PENDING_MESSAGES table can grow indefinitely
10.2.0.4 5666374 FIFO does not occur when multiple listens are followed by dequeues
10.2.0.4 5717536 Dequeue can suffer from a memory leak
10.2.0.4 5725109 Hang if AQ listener onMessage() method raises an error
10.2.0.4 5734276 Queue slave process may spin in kwqitptm
10.2.0.4 5751016 AQ messages enqueued at non-owner instance not moved from WAIT to READY
10.2.0.4 5758963 UGA memory leak possible from AQ dequeue
10.2.0.4 5852253 ORA-25316 from AQ after rollback to savepoint with loopback database link
10.2.0.4 5857313 OERI[kwqbmcrcpts101] after drop propagation
10.2.0.4 5941601 TM deadlock from concurrent dbms_aqadm_sys.alter_subscriber()
10.2.0.4 5955596 DBMS_AQ.LISTEN hangs after datapump has executed
10.2.0.4 5962680 Dump[kwqicgsubname1] on an AQ enqueue call
10.2.0.4 6001290 Node down events not posted in AQ when node leaves the cluster
10.2.0.4 6016707 OERI[kwqpuspse0-hwmack] from propogation
10.2.0.4 6044513 Cannot dequeue a message with a correlation padded with spaces
10.2.0.4 6049324 Memory leak from array dequeue
10.2.0.4 6057422 ORA-25228 occurs every 30 seconds in racgimon session trace file
10.2.0.4 6065604 DBMS_AQ.DEQUEUE_ARRAY PGA memory leak
10.2.0.4 6143688 node startups cAN spend up to 2 mins in AQ partition code
10.2.0.4 6154655 QMON fails to update queue table affinity for several minutes after failover
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.5 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.4 4436832 False ORA-979 "not a group by expression" with literal replacement
10.2.0.4 4587572 ORA-12801/ORA-60 possible from parallel DML with grouping sets
10.2.0.4 4597871 ORA-904 from query using CUBE
10.2.0.4 5162852 Dump from FIRST / LAST aggregations on a NULL table
10.2.0.4 5196061 Dump in evaopn2() from WITH query using WINDOW functions
10.2.0.4 5216642 Dump from SQL using window functions
10.2.0.4 5286826 Wrong results from complex view merge with windowing
10.2.0.4 5302124 Join Predicates are not push inside window functions -- superceded fix
10.2.0.4 5641873 ORA-904 using a WITH clause that includes a UNION
10.2.0.4 5670585 OERI [kxfxsSendCounter1] / OERI [15574] / spin from WINDOW query
10.2.0.4 5847881 ORA-3001 from GROUPING SET query against a view containing a function
10.2.0.4 5906937 Wrong result using ROW_NUMBER in SQL using a WITH query block
10.2.0.4 5942097 OERI:qernsRowP from SQL with GROUP BY , ROLLUP and DISTINCT aggregates
10.2.0.4 6012053 OERI [qctcte1] from GROUPING SETs query
10.2.0.4 6026281 OERI[qeshCloseHTI.2] from spreadsheet query
10.2.0.4 6051782 Wrong results using GROUPING SETS with ORDER BY and DISTINCT
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.6 Application Context

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

Fixed in Release Bug Number Description
10.2.0.4 4902585 OERI[510] and ORA-28106 using application context over 30 bytes long
10.2.0.4 6005762 SYS_CONTEXT('USERENV','AUTHENTICATION_METHOD') returns NULL

2.1.7 Automatic SGA Memory Management

The following table lists the Automatic SGA Memory Management bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.4 5702177 Instance crash from OERI[kghchoose_grow_1]

2.1.8 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.4 5526987 * ASM instance hang / OERI [2103] on DB instance. This bug is alerted in Note:468572.1
10.2.0.4 5081798 + Additional diagnostics for OERI[2103] when ASM involved
10.2.0.4 6051728 P* HPUX Itanium: Cannot use ASM (ORA-15059). This bug is alerted in Note:434500.1
10.2.0.4 4110313 ASM disk resize fails for OS devices grown after ASM instance startup
10.2.0.4 4319031 Wrong header_status in V$ASM_DISK when disk is offline
10.2.0.4 4380450 Unbalanced space usage if diskgroup has only two disks, both of different size
10.2.0.4 4431215 "backup archivelog all delete input" from RMAN removes ASM directory
10.2.0.4 4489948 ASM hangs during a parallel mount and shutdown in RAC
10.2.0.4 4767278 OERI[kcrrupirfs.20] archiving redo to standby with ASM
10.2.0.4 5230765 LGWR spins while waiting for 'log file parallel write' using ASM
10.2.0.4 5471453 OERI[kfkfilrqarr01] using ASM
10.2.0.4 5472917 DBVERIFY may error if ASM disk disconnected
10.2.0.4 5483613 OERI [kfgscAcquireLcl_6] in ASM
10.2.0.4 5502365 OERI [kfcDel20] in ASM
10.2.0.4 5504989 PMON dump [kfgGlobalClose] / instance crash
10.2.0.4 5554692 Error ORA-15196 reporting ASM block header invalid ora-15196 after ORA-600[kfcgetbuffer10]
10.2.0.4 5555908 OERI[kghstack_underflow_internal_2] in kfrcsoDelete
10.2.0.4 5556674 V$ASM* dynamic views leak cursors (ORA-01000)
10.2.0.4 5575584 Failure of an entire failure group is detected one disk at a time
10.2.0.4 5576584 Poor ASM parallel read performance
10.2.0.4 5682184 OERI[kfdAuDealloc2] from resize/drop more than 16TB ASM file
10.2.0.4 5743325 ASM instance fails with OERI[kfaDropCOP04]
10.2.0.4 5757711 ORA-15080 during file creation / resize on ASM with HARD
10.2.0.4 5757752 OERI:kghstack_alloc / OERI:kfcbCkpt04 / ASM crash
10.2.0.4 5761185 ORA-15041 diskgroup space exhausted after adding disks to a diskgroup
10.2.0.4 5891737 Dump (kcblsod) / OERI:723 / Memory leak in ASM/RAC
10.2.0.4 5893614 Full table scan very slow on ASM
10.2.0.4 5899033 SMON dump (kfrCheckCtx) diskgroup instance recovery
10.2.0.4 5909894 ASM datafile lost after rename (ORA-1157)
10.2.0.4 5922733 ASM dump in kfkdumprq with event=15199 level=1050631
10.2.0.4 5939241 Inconsistent diskgroup configuration after rejected DISK OFFLINE
10.2.0.4 6013983 ASM signals OERI [kfdasecondaries01] / [kffrelocate87] during rebalance
10.2.0.4 6069360 DBW can spin in kfcRunnableWaiter holding a latch in ASM
10.2.0.4 6139547 Shadow process leak on ASM instance when diskspace exhausted (ORA-20)
10.2.0.4 6334552 Hang / ORA-4031 / OERI:kfrcsoDelete_3 on rollback of ASM file resize
10.2.0.4 6453944 ORA-15196 with ASM disks larger than 2TB using ASMLIB
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.9 Bitmap Indexes

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

Fixed in Release Bug Number Description
10.2.0.4 4596807 OERI[6002] on update statement with concurrent ONLINE rebuild of bitmap indexes
10.2.0.4 4697632 OERI[atbbjie2] from exchange partition with bitmap join indexes
10.2.0.4 5063279 OERI[kdibllockrange:not validated] updating a partitioned bitmap index
10.2.0.4 5113934 PQ slave dump in qerixGetKey() when using bitmap index access
10.2.0.4 5262017 Query on partitioned table with bitmap index gives OERI[qernsRowP]
10.2.0.4 5331374 OERI [kdiblsorget:rowidIllegal] updating partitioned table with row migration
10.2.0.4 5401876 wrong results when optimizer uses 'bitmap conversion'
10.2.0.4 5449488 Suboptimal plan for SQL with negated predicates (BITMAP MINUS)
10.2.0.4 5667683 Parse of query can spin in kkosbn
10.2.0.4 5960268 Dump (kkoiodoi) when FIRST_K_ROWS considers bitmap index
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.10 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.4 5165904 Materialized View DDL may execute when it should wait
10.2.0.4 5252389 CDC apply changes lead to maximum open cursors exceeded (ORA-1000)
10.2.0.4 5533982 Updated columns set to null show old not-null values in change table using async CDC
10.2.0.4 5693948 ORA-31466 error when setting up CDC with table names using multibyte characters
10.2.0.4 5881493 CDC ordered sequence causes large performance degradation on RAC
10.2.0.4 6064864 Archives containing DDL for not replicated objects take longer to process
10.2.0.4 6314151 '1/1/1988 0:0:0' in COMMIT_TIMESTAMP$ column when CDC apply error is re-executed
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.11 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.4 6001843 P cluvfy error during CRS post installation check
10.2.0.4 5667023 P+ Linux: CRS does not start after applying 10.2.0.3
10.2.0.4 5495242 PI HPUX: CRS may not install
10.2.0.4 5845104 PI Win64: 10.2.0.3 OPMD.EXE does not work
10.2.0.4 3602716 EVMD unable to detect EOF while reading configuration file
10.2.0.4 4440013 CRS startup of RAC fails when FSFO enabled
10.2.0.4 4566428 cluvfy displays duplicate names in the output
10.2.0.4 4574574 crs_start opens a physical standby database as opposed to mounting the instances
10.2.0.4 4587300 Improve CRS shutdown sequence
10.2.0.4 4598992 "Action script for resource 'ora.xxx.vip' stdout redirection" errors in crsd.log
10.2.0.4 4692561 cluvfy reports a failure if ssh banned enabled
10.2.0.4 4882822 Service failover blocked on VIP
10.2.0.4 4906820 EVMD deadlocks on disconnect
10.2.0.4 4930431 Failure of 1 CSSD can hang starting CSSD on other nodes
10.2.0.4 4951464 CRS shutdown stops and then restarts EVMD
10.2.0.4 4996577 CVU does not recognise long device names
10.2.0.4 5003881 Value of restart_attempts wrong after DB policy is changed
10.2.0.4 5014134 Improved diagnostics for oclsomon (do not overwrite log file)
10.2.0.4 5093126 FCF does not respond to SRV_PRECONNECT events
10.2.0.4 5101517 VIP does not failover with auto_start=2
10.2.0.4 5125957 Cannot start CRS after CRS ugprade
10.2.0.4 5129769 CLUVFY check subsystems which are not configured
10.2.0.4 5131219 CSS shuts down the node when disk IO is suspended momentarily
10.2.0.4 5137401 oprocd logfile is cleared after a reboot
10.2.0.4 5168043 VIPCA silent mode cannot handle upper case characters in hostnames
10.2.0.4 5169752 SRVM OCR keys not security consistent with respective CRS resources
10.2.0.4 5184535 PRKR-1008 from SVTCTL ADD INSTANCE / DBCA
10.2.0.4 5188493 crsd.bin can use excess CPU on reboot
10.2.0.4 5192194 CSS does not start on one of the nodes ("takeover aborted due to unknown nodes")
10.2.0.4 5207138 Add support for 'toc' for reboot in HPUX
10.2.0.4 5220760 Dump in NetLocalGroupGetMembers
10.2.0.4 5236370 OCR cache invalidation error with delete key operation
10.2.0.4 5274513 VIP,ONS,GSD check fails in cluvfy when nodename is in capital letters
10.2.0.4 5278777 CRSD version is 10.2.0.1 after applying 10.2.0.2 patchset
10.2.0.4 5297925 Disabling one instance disables restart of all the instances in the node
10.2.0.4 5303454 Better diagnostics when CSS voting disk IO hangs but later resumes
10.2.0.4 5334170 racgevtf can dump in lmmstfree
10.2.0.4 5334661 ocssd.log refers to non-existing node 0
10.2.0.4 5336797 EVMD and CSSD core files are overwritten
10.2.0.4 5338035 PRKR-1008 using DBCA to create RAC instance
10.2.0.4 5348062 A 500 ms delay can occur until CSS starts reconfiguration after vendor CM reconfiguration
10.2.0.4 5365683 CRS repeatedly stops and restarts VIPs while recovering multiple nodes
10.2.0.4 5377165 Dump from crsctl when invalid parameters are passed
10.2.0.4 5388818 cluvfy should not use remote shell for local node
10.2.0.4 5437462 CSS does not monitor vendor clusterware network
10.2.0.4 5442229 VIP does not failover when public LAN disconnected pulled (crsd communicating on public LAN)
10.2.0.4 5442867 Deadlock can occur by terminating multiple CSS clients
10.2.0.4 5446160 RLB information cannot be forwarded
10.2.0.4 5448707 Better tolerance of CRS init scripts to low system resource conditions
10.2.0.4 5451987 CSSD could run as root if oracle_user not set
10.2.0.4 5454307 CLWS OCSSD dump during startup
10.2.0.4 5454388 OPROCD dumps with fix for bug 5015469
10.2.0.4 5458333 racgimon should do more checking for connections
10.2.0.4 5461281 Reconfiguration delayed due to diskping seen after reboot was issued
10.2.0.4 5467456 Directory $ORA_CRS_HOME/crs/auth was unexpectedly removed
10.2.0.4 5479767 CLWS instance going down not noticed for 10 min
10.2.0.4 5487604 CRSD core dump
10.2.0.4 5488977 scls_process_spawn provides insuficient diagnostics on execve() failure
10.2.0.4 5503111 racgimon startd <dbname> uses a lot of CPU
10.2.0.4 5507883 CRS install fails in CRS root.sh due to node panics
10.2.0.4 5513471 cluvfy needs easy to parse output for each nodes status
10.2.0.4 5529659 OCSSD fails to join the cluster
10.2.0.4 5533311 crsctl debug log res:<name> does not check name
10.2.0.4 5549682 High CPU usage by srvctl
10.2.0.4 5553318 CRSD dump before node rebooted when killed CSSD in CRSD master
10.2.0.4 5556681 OCR does not correctly compare OCR configurations
10.2.0.4 5568399 CRS upgrade can corrupt OCR
10.2.0.4 5601369 OCSSD dump in clssgmmbrdatacmpl()
10.2.0.4 5623137 CSS time out during reconfiguration (timeout in clssgmMasterCMSync)
10.2.0.4 5629557 CRS does not receive reconfig from CSS on SAN failure
10.2.0.4 5651085 Session disconnection blocks service resource stop action
10.2.0.4 5664042 diagcollection.pl requires ORA_CRS_HOME environment variable
10.2.0.4 5668854 CRSD may dump if resource unregistered/re-registered as it starts
10.2.0.4 5679560 Unexpected node reboot on death of "init.cssd fatal"
10.2.0.4 5690258 Default VIP check_interval should be less than 60 seconds
10.2.0.4 5698321 Wrong return code from srvctl from failed "modify nodeapps" operation
10.2.0.4 5709121 CRS startup can hang
10.2.0.4 5734797 CSSD abort possible from concurrent startup
10.2.0.4 5735507 Dump in procr_open_key
10.2.0.4 5735768 killed ocssd.bin on a node causes other nodes's crsd restart
10.2.0.4 5736843 WaitOnEvictions can wait too long (another misscount)
10.2.0.4 5843485 Unnecessary VIP failback trial makes VIP unavailable for 14s on network down
10.2.0.4 5852975 Shared storage check does not discover shared disks
10.2.0.4 5853909 CSSD permission problems (skgxninit errors in CSSD log)
10.2.0.4 5854172 VIPCA fails with exception thread main error
10.2.0.4 5855383 CRS bundle patch does not apply on some platforms
10.2.0.4 5858733 cvu checks for exact package versions
10.2.0.4 5861703 CSSD failure 139 and node reboot if nfs mounted voting disk is remounted
10.2.0.4 5862719 init.crsd does not set a high file limit on all platforms (notable Linux)
10.2.0.4 5893629 crsd dumps after being unable to delete backup OCR file
10.2.0.4 5901176 Memory corruption in CLSC async connect handling
10.2.0.4 5901254 Starting node cannot join the cluster
10.2.0.4 5903964 EVMD does not shut down when OCR is corrupted
10.2.0.4 5911174 Hang in CLSC in nsevwait
10.2.0.4 5911855 Split brain resolution can fail
10.2.0.4 5929527 racgimon dump in clsrcwrft() during instance startup
10.2.0.4 5929833 OCR cannot determine the latest update
10.2.0.4 5932861 VIP does not switch over when CRS is stopped
10.2.0.4 5938788 False split brain
10.2.0.4 5949311 False split brain result
10.2.0.4 5974219 Cluster hang when node dies during reconfig
10.2.0.4 6001290 Node down events not posted in AQ when node leaves the cluster
10.2.0.4 6005526 CSS will not shutdown evmd.bin with fix for bug 5442229
10.2.0.4 6022204 oprocd enhanced error reporting mechanisms
10.2.0.4 6029676 OPEN/CLOSED messages from userid 0 after CRS shutdown
10.2.0.4 6051925 racgimon dump under slzgetevar -> getenv
10.2.0.4 6054978 Locked resources are not recovered by CRSD even once they are unlocked
10.2.0.4 6057422 ORA-25228 occurs every 30 seconds in racgimon session trace file
10.2.0.4 6087596 OCR can hang
10.2.0.4 6114137 Running LMS in real-time can cause CSS crash and node reboot
10.2.0.4 6117687 CRS slow memory leak from repeated "crsctl check crs"
10.2.0.4 6134126 OCR backup can fail
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 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 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.12 Code Improvement

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

Fixed in Release Bug Number Description
10.2.0.4 5238255 Timezone changed data in CSV format
10.2.0.4 5245494 Improved control over whether star transformation is performed
10.2.0.4 5614566 Enh: Allow library cache heaps to be purged manually
10.2.0.4 5932060 Enh: Add support for direct SQL on partitioned table/index
10.2.0.4 5933469 ORA-20 does not show in any trace / alert
10.2.0.4 5966238 Better diagnostics for OERI[kcbgtcr_1]
10.2.0.4 6022204 oprocd enhanced error reporting mechanisms
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.13 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.4 4061534 OERI[krvtadc] / dump in capture mining redo for COMPRESSed table
10.2.0.4 4600946 Dump / OERI[kghstack_free1] on array insert to COMPRESSed table
10.2.0.4 5496041 OERI[6006] / index corruption on compressed index
10.2.0.4 5577788 Block corruption / OERI:6585 updating row in compressed block
10.2.0.4 5599596 Block corruption / OERI [kddummy_blkchk] on clustered or compressed tables
10.2.0.4 5912350 Dump (kdr9ir2f0rst4srp0) on select of compressed table having > 255 columns
10.2.0.4 6268371 ORA-12996 / ORA-12998 / corruption from ALTER TABLE DROP UNUSED COLUMNS CHECKPOINT
10.2.0.3 4378206 Direct load of compressed table can load duplicate rows

2.1.14 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.4 4545196 Corrupt index leaf from cross platform transport of compress-key indexes
10.2.0.4 5034323 Dictionary corruption when adding a subpartition to a table with a key compressed local index
10.2.0.2 4386766 IMPDP with compressed indexes fails with ORA-14071 and ORA-39083

2.1.15 Constraint Related

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

Fixed in Release Bug Number Description
10.2.0.4 4580190 Bulk insert to partitioned table can insert constraint violating rows
10.2.0.4 4618715 Dump inserting into a view with OLS policy on tables
10.2.0.4 4620832 Dump in kzrtppg with multiple referential constraints and OLS policy
10.2.0.4 4771851 Dump (kxccsrw) from INSERT .. AS SELECT
10.2.0.4 5324773 Constraints using LTRIM() may fail for valid data
10.2.0.4 5462687 CHECK constraint can cause wrong results
10.2.0.4 5472523 Non violated deferred CHECK constraint fails (ORA-2290) at commit
10.2.0.4 5504961 ORA-2292 slow to be signalled with many child rows
10.2.0.4 5579055 Dump (kxccres) updating view with instead of trigger
10.2.0.4 5766196 ORA-942 on schema level import of table with foreign key and XMLSchema
10.2.0.4 5923497 Select with constraints fails with OERI[12863]
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.16 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.17 Corruption

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

Fixed in Release Bug Number Description
10.2.0.4 4201573 ALTER SYSTEM RESET of an spfile parameter can corrupt the SPFILE
10.2.0.4 4344935 OERI from DML on TEMPORARY TABLE after autonomous TRUNCATE
10.2.0.4 5690593 Datafile corrupt for ASM datafiles copied using xdb/ftp
10.2.0.4 5892080 updateXML corrupts repeating elements
10.2.0.4 6086497 OERI[ktspgetmyb-1] / bitmap segment corruption for ASSM segments
10.2.0.4 6132301 OERI[kcb_pre_apply_1] / block corruption can occur
10.2.0.4 6453944 ORA-15196 with ASM disks larger than 2TB using ASMLIB
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.18 Corruption (Dictionary)

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

Fixed in Release Bug Number Description
10.2.0.4 5034323 Dictionary corruption when adding a subpartition to a table with a key compressed local index
10.2.0.4 5632050 OERI[kkpolpd12] / dictionary corruption from CONCURRENT partition DDL
10.2.0.4 5936058 Corrupt metadata from tablespace transport
10.2.0.4 6436867 Recompilation may skip compilation of some dependent objects (ORA-4068)
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.19 Corruption (Incorrect / Missing Corruption Checks)

The following table lists the Corruption (Incorrect / Missing Corruption Checks) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.4 3569503 PQ may signal a false ORA-8103 under load

2.1.20 Corruption (Index)

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

Fixed in Release Bug Number Description
10.2.0.4 4545196 Corrupt index leaf from cross platform transport of compress-key indexes
10.2.0.4 5179313 INSERT /*append parallel*/ can corrupt an index
10.2.0.4 5181547 Index corruption after insert-only merge /*+ append */ into table
10.2.0.4 5496041 OERI[6006] / index corruption on compressed index
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 5253271 Wrong sort ordering for zeroes
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.21 Corruption (Logical)

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

Fixed in Release Bug Number Description
10.2.0.4 5686711 + Wrong cursor may be executed if schemas have objects with same names
10.2.0.4 3419260 Silent truncation on insert via DB link from single to multibyte charset
10.2.0.4 4193047 Sequences / synonyms / indexes not created in logical standby database
10.2.0.4 4580190 Bulk insert to partitioned table can insert constraint violating rows
10.2.0.4 4714295 It is possible to drop an OLS group which is still in use in an existing label
10.2.0.4 4883635 MERGE (with delete) can produce wrong results
10.2.0.4 4904743 ALTER SESSION SET NLS% does not work if OCI_PARSE_ONLY used
10.2.0.4 4933222 Apply update of clob in multibyte charset double spaces characters
10.2.0.4 4959294 DBMS_XMLSTORE does not follow CHAR based semantics
10.2.0.4 5019803 Wrong data inserted for INSERT INTO .. SELECT DISTINCT with DEFAULT values
10.2.0.4 5024737 Streams LCRs may be filtered when using distributed commit SCN
10.2.0.4 5087369 logical standby potential data loss during failover
10.2.0.4 5104257 SQLLoader truncates nested table columns
10.2.0.4 5165904 Materialized View DDL may execute when it should wait
10.2.0.4 5182679 INSERT as remote SELECT using CASE can produce wrong data
10.2.0.4 5190543 Wrong timestamp from oracle.sql.TIMESTAMPLTZ near daylight savings transition
10.2.0.4 5256791 Trigger "UPDATING('col')" clause can return TRUE when column not updated
10.2.0.4 5352587 Triggers not working correctly with timestamp datatype
10.2.0.4 5436371 Image corruption / spin loading multiple nested objects in multibyte
10.2.0.4 5515703 Streams table diverges after partial rollback on primary
10.2.0.4 5554692 Error ORA-15196 reporting ASM block header invalid ora-15196 after ORA-600[kfcgetbuffer10]
10.2.0.4 5567934 NCHAR literal replacement can produce corrupt N literals
10.2.0.4 5577788 Block corruption / OERI:6585 updating row in compressed block
10.2.0.4 5588615 Single source streams with DML handler duplicates CLOB column value
10.2.0.4 5616820 Triggers using :OLD values of TIMESTAMP columns see :NEW values instead
10.2.0.4 5621677 Logical corruption with parallel update on compressed partition
10.2.0.4 5685411 Updating columns to NULL in a trigger may have no effect
10.2.0.4 5872835 Multiple trigger execution from SERIAL insert as Parallel select
10.2.0.4 5873852 sqlldr inserts character data longer than the column length (CHAR length semantics)
10.2.0.4 5874989 Datapump import can load data longer than column definition
10.2.0.4 5936058 Corrupt metadata from tablespace transport
10.2.0.4 6038412 OCI7 clients using "CALL" SQL may execute wrong shared cursor
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.22 Corruption (Physical)

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

Fixed in Release Bug Number Description
10.2.0.4 6646613 * IOT corruption after upgrade from <= 9.2 to >= 10g. This bug is alerted in Note:471479.1
10.2.0.4 4450606 + LOB corruption / ORA-600 [ktsbvmap1] when updating a LOB
10.2.0.4 5363584 + Array insert into partitioned table can corrupt redo
10.2.0.4 4592596 Corruption (ORA-1410) from multi-table insert with direct load
10.2.0.4 4899479 Undo/redo corruption if distributed transactions used
10.2.0.4 5386204 Block corruption / OERI[kddummy_blkchk] after direct load of ASSM segment
10.2.0.4 5599596 Block corruption / OERI [kddummy_blkchk] on clustered or compressed tables
10.2.0.4 5609096 MERGE / UPDATE to IOT can cause corruption
10.2.0.4 5636728 LOB corruption / ORA-1555 when reading LOBs after a SHRINK operation
10.2.0.4 5909894 ASM datafile lost after rename (ORA-1157)
10.2.0.4 5941030 Datapump import can produce corrupt blocks when there is a LONG / LONG RAW
10.2.0.4 6268371 ORA-12996 / ORA-12998 / corruption from ALTER TABLE DROP UNUSED COLUMNS CHECKPOINT
10.2.0.3 5061091 + Block recovery corrupts undo header when log_parallelism > 1
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 5515492 Data corruption when ASM failgroup removed
10.2.0.2 4597251 + OERI / buffer cache corruption / crash from concurrent index block reclaimation
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.23 DBVerify Utility

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

Fixed in Release Bug Number Description
10.2.0.4 5031712 DBV reports blocks "soft corrupted" blocks as bad
10.2.0.4 5472917 DBVERIFY may error if ASM disk disconnected

2.1.24 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.25 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.4 3419260 Silent truncation on insert via DB link from single to multibyte charset
10.2.0.4 4311273 ORA-2064 using MERGE statement over a database link
10.2.0.4 4351422 Dump from CREATE TABLE AS SELECT (CTAS) over DB link
10.2.0.4 4373687 SET_SCHEMA_INSTANTIATION_SCN does not error if database link unavailable
10.2.0.4 4490782 Unparse operations give wrong date for BC TO_DATE literals
10.2.0.4 4491223 Dump selecting ROWID with a remote join
10.2.0.4 4581334 Cursors accessing remote tables may be repeatedly rebuilt and not used
10.2.0.4 4624183 ORA-1017 reported using DB links with IDENTIFIED EXTERNALLY accounts
10.2.0.4 4648039 PLSQL hangs with database links and autonomous_transaction
10.2.0.4 4658456 ORA-920 from distributed query using CASE against remote table/s
10.2.0.4 4701527 Cursors not shared when executing procedures over a dblink
10.2.0.4 4768022 ALTER TABLE can fail with ORA-60
10.2.0.4 4865959 Wrong results / exception from Java Stored Procedure accessing data over DBLINK
10.2.0.4 4889807 False ORA-904 from co-located join (over database link)
10.2.0.4 4899479 Undo/redo corruption if distributed transactions used
10.2.0.4 4913460 Soft parsing re-occurs for select using database link
10.2.0.4 5015321 OERI[qerrmObnd1] [932] using binds with some functions over a DBLINK
10.2.0.4 5015547 Cannot create a materialized view over a database link (ORA-942)
10.2.0.4 5024737 Streams LCRs may be filtered when using distributed commit SCN
10.2.0.4 5128933 Dump from DBMS_SQL selecting TIMESTAMP data over a database link
10.2.0.4 5182679 INSERT as remote SELECT using CASE can produce wrong data
10.2.0.4 5216523 OERI[16608] from create materialize view on remote table with objects / types
10.2.0.4 5223587 OERI[4400] from distributed PDML with DDL
10.2.0.4 5245451 Intermittent ORA-904 referencing remote objects columns
10.2.0.4 5246372 OERI[opidsii1] accessing remote database accessing 3rd remote database
10.2.0.4 5299546 ORA-942 from create materialized view with join between local and remote tables
10.2.0.4 5327132 Wrong results from colocated OUTER join over DBLINK with TO_DATE
10.2.0.4 5354469 Poor performance of remote fetch with high fetch counts
10.2.0.4 5405345 OERI[kkofkrMarkK] when running a query using a database link
10.2.0.4 5455632 Dump accessing tables over a database link
10.2.0.4 5467520 PLSQL errors accessing synonym to remote object
10.2.0.4 5509293 Query with subquery across DB link has poor performance
10.2.0.4 5852253 ORA-25316 from AQ after rollback to savepoint with loopback database link
10.2.0.4 6029071 Wrong results from distributed SQL with OUTER joins
10.2.0.4 6145525 Dump selecting > 34 columns from HS (FDS)
10.2.0.3 5550824 + Select SYSDATE over a database link increments SYSDATE
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.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.26 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.27 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.4 4352110 ORA-39125 from expdp/impdp of triggers with nulls in WHEN clause
10.2.0.4 4517481 ORA-904 / ORA-20000 loading metadata with IMPDP using varying width characterset
10.2.0.4 4595736 ORA-6502 during impdp due to wrong logging_level put in export dump
10.2.0.4 4660745 TABLESPACE GROUP clause not generated by DBMS_METADATA.GET_DLL
10.2.0.4 4996004 EXPDP fails with ORA-31642 when NLS_SORT=binary_ci and NLS_COMP=ansi
10.2.0.4 5027003 ORA-39068 from EXPDP if parallel > 1
10.2.0.4 5071931 Datapump import with remap tablespace and schema is very slow
10.2.0.4 5095025 ORA-4030 (kxs-heap-c,temporary memory) using expdp
10.2.0.4 5120780 Long text for job gets EXP-85 ORA-6502 on dbms_sched_job_export
10.2.0.4 5135951 ORA-22337 on import if database schema has been evolved
10.2.0.4 5152232 EXPDP loses global index parameters for local domain indexes
10.2.0.4 5157602 Datapump export/import modifies the chains created with dbms_scheduler
10.2.0.4 5220845 Large packages imported via data pump are not shipped to logical standby
10.2.0.4 5292551 IMPDP slow when importing a table with initialized column of type varray
10.2.0.4 5352426 Data pump import dumps (lxinitc)
10.2.0.4 5464834 ORA-4030 (kxs-heap-c,temporary memory) using EXPDP
10.2.0.4 5472417 EXPDP on RAC fails with ORA-39014 / ORA-12801 (error signaled in parallel query server)
10.2.0.4 5502124 ORA-39096 importing 10.1 EXPDP file with 10.2 data pump
10.2.0.4 5515882 ORA-1427 from EXPDP
10.2.0.4 5548895 OERI [OCIKCallPush: deprecated] from EXPDP of ANYDATA column
10.2.0.4 5550618 Dump [nszgclient] from EXPDP
10.2.0.4 5576865 Dumps in strlen/kpodpmop/kpodpp errors during IMPDP
10.2.0.4 5590185 Consistent export data pump job (flashback_time) has poor performance
10.2.0.4 5620375 PLS-103 from datapump import of dbms_scheduler jobs with PLSQL_BLOCK
10.2.0.4 5632683 EXPDP / IMPDP may error for DDL modified tables
10.2.0.4 5680970 ORA-39001 when attempting to export partition defined as an object type
10.2.0.4 5713912 ORA-39125 / ORA-6502 from datapump import via network
10.2.0.4 5714205 EXPDP / IMPDP do not support long lists for parameters
10.2.0.4 5718757 ORA-31693 / ORA-6502 during datapump net import
10.2.0.4 5857884 EXPDP fails with ORA-39125 / ORA-6502
10.2.0.4 5874989 Datapump import can load data longer than column definition
10.2.0.4 5875568 IMPDP can error on create table in multibyte with ORA-39125 / ORA-6502
10.2.0.4 5910237 EXPDP / DBMS_METADATA has wrong syntax for for nested table with row movement enabled
10.2.0.4 5941030 Datapump import can produce corrupt blocks when there is a LONG / LONG RAW
10.2.0.4 5972794 EXPDP via network_link with parallel > 1 fails with KUP-4038
10.2.0.4 6063940 Datapump export / import does not handle tablespace groups
10.2.0.4 6080303 Datapump export does not unload data until all metadata unloaded with PARALLEL > 1
10.2.0.4 6140330 imp / impdp cannot create object views with circular dependencies
10.2.0.4 6379123 EXPDP/IMPDP ORA-39083 due to changes in MERGE privilege between 10.1 and 10.2
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.28 Datatypes (AnyData)

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

Fixed in Release Bug Number Description
10.2.0.4 4531589 ORA-22370 when passing sys.anydata containing collection to a method
10.2.0.4 5307199 OERI:OCIOpaqueDataLoad1 can occur using ODCI with AnyData / AnyDataSet
10.2.0.4 5350076 Anydata and timestamp can loose precision
10.2.0.4 5548895 OERI [OCIKCallPush: deprecated] from EXPDP of ANYDATA column

2.1.29 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.4 4450606 + LOB corruption / ORA-600 [ktsbvmap1] when updating a LOB
10.2.0.4 4559728 Select lob from view loops / OERI [17059] if synonym dropped
10.2.0.4 4583442 ORA-22877 during move hash partition with LOB
10.2.0.4 4680009 Insert LOB data fails with ORA-3106 or ORA-8176
10.2.0.4 4745114 OERI[kolrrdl:0rfc] using temporary LOBs in PLSQL
10.2.0.4 4865755 OERI[9999] during DBMS_LOB operation
10.2.0.4 4933222 Apply update of clob in multibyte charset double spaces characters
10.2.0.4 5051432 DBMS_LOB does not execute with the privileges of the calling procedure
10.2.0.4 5176017 Exp/imp loses "RETENTION" settings of LOB columns
10.2.0.4 5196175 OERI[kghstack_underflow_internal_1] with supplemental logging for LOBS
10.2.0.4 5374820 Client side dump on import of table with more than one LOB column into 32k block size
10.2.0.4 5396550 Spin in ktsplbfmb holding HW enqueue during LOB segment management
10.2.0.4 5413989 OCIStmtSetPieceInfo() does not work for piece sizes > 16777180
10.2.0.4 5442534 Dump in kokscold assigning NULL to CLOB
10.2.0.4 5447395 Shared server tied to session when BFILE used
10.2.0.4 5472702 ORA-1403 during SQL Apply of redo from table import (redo issue)
10.2.0.4 5500044 ORA-44203 on table_x_x child from concurrent LOB append and drop partition
10.2.0.4 5510345 ORA-22282 with LOB buffering enabled
10.2.0.4 5549410 Inconsistent characters read returned from OCILobRead
10.2.0.4 5560256 Multi threaded OCI program hang when calling OCILobLocatorAssign
10.2.0.4 5588615 Single source streams with DML handler duplicates CLOB column value
10.2.0.4 5636728 LOB corruption / ORA-1555 when reading LOBs after a SHRINK operation
10.2.0.4 5644951 OERI[rworupo.2] querying outline LOB with ORDER BY clause
10.2.0.4 5654094 ORA-3106 for SQL with RETURNING clause with indicator binds
10.2.0.4 5666733 LOB segment does not use free space from freelist in RAC database
10.2.0.4 5674184 ORA-22282 when using LOB buffering
10.2.0.4 5676637 OERI[17114] using EMPTY_CLOB() in a trigger
10.2.0.4 5682121 Multithreaded OCI clients do not mutex properly for LOB operations (ORA-21500 [17099])
10.2.0.4 5721994 Unexpected errors from non blocking OCI LOB calls
10.2.0.4 5723140 Temp LOB space not released after commit
10.2.0.4 5723260 Logminer slow / excess memory use processing batch inserts with LOBs
10.2.0.4 5870781 DBMS_LOB.INSTR() function does not find patterns across the 4gig boundary
10.2.0.4 5926074 OERI [12333] on update of more than one CLOB column
10.2.0.4 5941355 "Split partition" does not move LOB to correct tablespace
10.2.0.4 5974207 Unexpected ORA-1031 from LOB access - affects NCOMPed PLSQL
10.2.0.4 6315913 ORA-3106 for SQL using BLOBs after TAF failover
10.2.0.4 6376915 HW enqueue contention for ASSM LOB segments
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.30 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.4 4554026 Pinning TDO may fail for extensibility types
10.2.0.4 4583492 Dump possible using ADT columns when table has many columns
10.2.0.4 4643723 After type evolution extracting attributes gets OERI[17280]
10.2.0.4 4691237 High "library cache" latch gets from SQL using objects in PLSQL
10.2.0.4 4726702 ALTER TYPE may dump (koktupd_dplvl) due to a REF dependency
10.2.0.4 4895068 Dump [kopxccc] during pickling
10.2.0.4 5022188 Direct SQLLOAD of partitioned object table of non final types fails
10.2.0.4 5076729 OERI[pmucitnxt] doing type manipulation
10.2.0.4 5104257 SQLLoader truncates nested table columns
10.2.0.4 5135951 ORA-22337 on import if database schema has been evolved
10.2.0.4 5182299 Dump on grant / revoke of privileges on a TYPE
10.2.0.4 5192858 DROP TABLE with object type column with statistics can dump (kknerd)
10.2.0.4 5216523 OERI[16608] from create materialize view on remote table with objects / types
10.2.0.4 5225836 DROP TYPE .. VALIDATE dumps for large partitioned table
10.2.0.4 5292551 IMPDP slow when importing a table with initialized column of type varray
10.2.0.4 5368266 ORA-904 using multiple TABLE() objects in the FROM clause
10.2.0.4 5436371 Image corruption / spin loading multiple nested objects in multibyte
10.2.0.4 5520937 Cannot upgrade images for dictionary types to 8.1 image format
10.2.0.4 5577046 ADD or DROP attribute causes UNION query to fail with ORA-1790
10.2.0.4 5721821 SGA corruption / Dump[kglobcl] / crash if objects dropped / recreated
10.2.0.4 5725761 Objects with debug privilege are not shown in the ALL_OBJECTS view
10.2.0.4 5763434 Spin in kokes2q when sorting on VARRAY column over 4k long
10.2.0.4 5763538 Wrong results / dump with object type column in SQL
10.2.0.4 5841624 OERI[kokeicadd2] accessing object with embedded substitutable attributes
10.2.0.4 5910237 EXPDP / DBMS_METADATA has wrong syntax for for nested table with row movement enabled
10.2.0.4 6118038 OERI[koputilcvto2n] on an ALTER TYPE
10.2.0.4 6140330 imp / impdp cannot create object views with circular dependencies
10.2.0.4 6145841 OERI[kologsf2] on COLLECT(..) with wrong datatype
10.2.0.4 6150438 COLLECT() does not work correctly for ADTs residing in different schemas
10.2.0.4 6452485 SGA memory corruption / OERI [17182] with fix for bug 6085625
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.31 Datatypes (TIMESTAMP)

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

Fixed in Release Bug Number Description
10.2.0.4 4992603 TIMESTAMP.timestampValue(Calendar) does not exist
10.2.0.4 5126270 Version 3 TIMEZONE check script (utltzuv2.sql)
10.2.0.4 5128933 Dump from DBMS_SQL selecting TIMESTAMP data over a database link
10.2.0.4 5190543 Wrong timestamp from oracle.sql.TIMESTAMPLTZ near daylight savings transition
10.2.0.4 5238255 Timezone changed data in CSV format
10.2.0.4 5350076 Anydata and timestamp can loose precision
10.2.0.4 5350339 ORA-979 using TIMESTAMP in triggers and GROUP BY clause
10.2.0.4 5352587 Triggers not working correctly with timestamp datatype
10.2.0.4 5417281 oracle.sql.DATE looses a year when constructed from BC Timestamp
10.2.0.4 5468695 TIMESTAMPTZ wrong near daylight switch
10.2.0.4 5616820 Triggers using :OLD values of TIMESTAMP columns see :NEW values instead
10.2.0.4 5632264 Version 4 TIMEZONE files
10.2.0.4 5688685 JVM timezone changes for Western Australia December 2006 (superceeded)
10.2.0.4 5726033 timezdif.csv for version 4 timezone files
10.2.0.4 5865568 JVM timezone changes (version 4 timezone data for JVM)
10.2.0.4 5885079 Incorrect output from INTERVALDS.stringValue() for negative intervals
10.2.0.4 5910187 No bind peeking for implicit string bind to timestamp
10.2.0.4 5923970 Include objects/nested tables in utltzuv2.sql
10.2.0.4 5961654 ldiinterfromtz returns wrong offset during DST fallback
10.2.0.4 5973217 OCCI::intervalds object attribute uses day precision for fractional seconds
10.2.0.4 6156762 OCCI fractional seconds portion can be wrong
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.32 Deadlock

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

Fixed in Release Bug Number Description
10.2.0.4 5907779 + Self deadlock hang on "cursor: pin S wait on X" (typically from DBMS_STATS)
10.2.0.4 4441119 Not enough information dumped when RAC detects a deadlock
10.2.0.4 4587572 ORA-12801/ORA-60 possible from parallel DML with grouping sets
10.2.0.4 4768022 ALTER TABLE can fail with ORA-60
10.2.0.4 5334733 Deadlock resolution can be slow in RAC
10.2.0.4 5415506 ORA-4020 when dbms_aqadm.purge_queue_table and select are run
10.2.0.4 5454831 RAC deadlock possible on working set latches
10.2.0.4 5470095 Self deadlock should provide more targeted diagnostics
10.2.0.4 5485914 Mutex self deadlock after DBMS_MONITOR.session_trace_enable
10.2.0.4 5557421 Self-deadlock (ORA-60) on FB enqueue if session killed during INSERT in ASSM
10.2.0.4 5604698 Deadlock between 'library cache lock' and 'library cache pin' using Streams
10.2.0.4 5685189 Self deadlock on dc_objects after DBMS_SPACE.UNUSED_SPACE errors
10.2.0.4 5695131 HW enqueue deadlock / OERI:1153 from array insert with SAVE EXCEPTIONS to READ ONLY ASSM segment
10.2.0.4 5883112 False deadlock in RAC
10.2.0.4 5941601 TM deadlock from concurrent dbms_aqadm_sys.alter_subscriber()
10.2.0.4 5983020 MMON deadlock with user session executing ALTER USER
10.2.0.4 5998048 Deadlock on COMMIT updating AUD$ / Performance degradation when FGA is enabled
10.2.0.4 6057351 AWR deadlock between Mxxx processes during snapshot purging process
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 4552067 Deadlock / ORA-4020 using TRUNCATE SQL against global temporary tables
10.2.0.2 4579381 Deadlock on DC_USERS in RAC (ORA-4020)

2.1.33 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.4 5022188 Direct SQLLOAD of partitioned object table of non final types fails
10.2.0.4 5179313 INSERT /*append parallel*/ can corrupt an index
10.2.0.4 5181547 Index corruption after insert-only merge /*+ append */ into table
10.2.0.4 5228136 ORA-26065 from SQLLDR direct path load of objects containing a LOB and constraints
10.2.0.4 5386204 Block corruption / OERI[kddummy_blkchk] after direct load of ASSM segment
10.2.0.4 5510918 Log miner slow mining direct load redo
10.2.0.4 5941030 Datapump import can produce corrupt blocks when there is a LONG / LONG RAW
10.2.0.4 5944227 SQLloader direct path load into IOT can dump [kdblldrp]
10.2.0.4 5953355 OERI[klaprs_30] / OERI[klaprs_10] during SQLLOADER direct path load
10.2.0.4 5973648 ORA-54 during concurrent parallel direct SQLLOAD in RAC
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.34 Domain Indexes

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

Fixed in Release Bug Number Description
10.2.0.4 4566516 Transportable tablespace does not handle domain indexes
10.2.0.4 4644425 SGA corruption on UPDATE with functional domain index
10.2.0.4 5136863 OERI from join between partitioned table and domain index
10.2.0.4 5152232 EXPDP loses global index parameters for local domain indexes
10.2.0.4 5228074 OERI[12455] raised from SQL with DOMAIN index when FOR UPDATE option is used
10.2.0.4 5307199 OERI:OCIOpaqueDataLoad1 can occur using ODCI with AnyData / AnyDataSet
10.2.0.4 5370332 ODCITableFetch fails with ORA-28579
10.2.0.4 5403398 Dump when costing user defined operators / functions
10.2.0.4 5530761 ORA-1031 from EXP of domain index
10.2.0.4 5656948 Dump returning collection from ODCIAggregate
10.2.0.4 5908945 Dump [qxopqdca] with ancilliary operator
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.35 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.4 6455161 + Higher CPU / Higher "cache buffer chains" latch gets / Higher "consistent gets" after truncate/Rebuild
10.2.0.4 4605569 LCK may accumulate CPU time on one instance
10.2.0.4 4697189 High CPU usage for large sorts
10.2.0.4 5362897 Non linear CPU increase when adding more shared server sessions
10.2.0.4 5399325 Mutex latch spin causes high CPU on non-CAS platforms
10.2.0.4 5471994 LCK may accumulate CPU time when SMON does Serial Transaction recovery
10.2.0.4 5530958 Larger SGAs and SQL in long running transactions can use excess CPU in ktaifm
10.2.0.4 5734276 Queue slave process may spin in kwqitptm
10.2.0.4 5896963 High LGWR CPU and longer "log file sync" with fix for bug 5065930
10.2.0.4 5958244 LMS processes running in realtime can spin
10.2.0.4 6001617 LCK may accumulate CPU time / ORA-4031 possible
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 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 ]
10.2.0.3 5505337 Excessive CPU time spent freeing cursor stats when shared pool under load

2.1.36 Export/Import

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

Fixed in Release Bug Number Description
10.2.0.4 3370858 Import fails (ORA-932) using FROMUSER / TOUSER for schema based xmltype
10.2.0.4 4038803 IMP-3 / ORA-1722 when using nls_numeric_characters != '.,'
10.2.0.4 4328909 Resource plans and resource groups not imported during full import
10.2.0.4 4559546 Cannot used exp/imp of MVIEW with XMLTYPE column
10.2.0.4 4912371 Dump possible in kohrsmc()
10.2.0.4 5120780 Long text for job gets EXP-85 ORA-6502 on dbms_sched_job_export
10.2.0.4 5176017 Exp/imp loses "RETENTION" settings of LOB columns
10.2.0.4 5349808 IMP-60 hit when importing a table with an XML schema based XMLType column
10.2.0.4 5374820 Client side dump on import of table with more than one LOB column into 32k block size
10.2.0.4 5391326 ORA-942 importing functional indexes as SYS
10.2.0.4 5402151 ORA-439 when importing into Standard Edition db using streams_instantiation=y
10.2.0.4 5494866 PLS-302 'dbver_10i' importing 10g export into 9i with AQ
10.2.0.4 5530761 ORA-1031 from EXP of domain index
10.2.0.4 5664206 ORA-6502 during export of functional index expression over 4k
10.2.0.4 5766196 ORA-942 on schema level import of table with foreign key and XMLSchema
10.2.0.4 5872788 ORA-29821 importing OPERATORS
10.2.0.4 6140330 imp / impdp cannot create object views with circular dependencies
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.37 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.4 6349820 Expression filter indexable attributes truncates length to 500 characters
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.38 External Tables

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

Fixed in Release Bug Number Description
10.2.0.4 4644351 OERI[15819] / wrong results from parallel select
10.2.0.4 5195356 Dump (memcpy) under kudmprcbk() when accessing external table
10.2.0.4 5600425 wrong results from select on external table
10.2.0.4 5676948 OERI [qxxmslSelectLocator_10] from SQL*Loader
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.39 Flashback

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

Fixed in Release Bug Number Description
10.2.0.4 4459574 FLASHBACK_TRANSACTION_QUERY shows multi row INSERT as SELECT as only one row
10.2.0.4 5172559 ora-600's during reinstate of logical standby after fast-start failover
10.2.0.4 5209867 ORA-38777 is thrown by MRP when flashback through resetlogs
10.2.0.4 5225733 After flashback operation, new logs are not applied in logical standby
10.2.0.4 5385614 Select using BETWEEN SCN / TIMESTAMP fails (OERI [ktrviupk_4])
10.2.0.4 5486023 "GLOBAL CACHE ELEMENT DUMP" in LMS trace with FLASHBACK
10.2.0.4 5891280 MRP0 on standby may not start (OERI:krfg_aset_1)
10.2.0.4 5933838 Database crash (ORA-449) after ALTER DATABASE FLASHBACK OFF in RAC
10.2.0.4 5949116 Flashback logs are not purged when archiver is out of disk space
10.2.0.4 6010833 Recovery following flashback does not utilize changes in online redo log
10.2.0.4 6168063 High "Flashback buf free by RVWR" waits
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.40 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.4 4619997 Function based index may not be used for INLIST predicate
10.2.0.4 4916783 Wrong results from query using INLIST predicate if FUNCTION BASED index
10.2.0.4 5377092 Wrong results from FAST FULL SCAN of an index on a CASE expression
10.2.0.4 5391326 ORA-942 importing functional indexes as SYS
10.2.0.4 5513123 DUmp [kkfies] from SQL using functional indexes with subqueries
10.2.0.4 5526851 Wrong Results (missing rows) on CONNECT BY when using function-based index
10.2.0.4 5574966 Dump (evaopn2) or Wrong Results with views and function-based index
10.2.0.4 5619833 Dump (qerixGetKey) from query rewrite on join including functional index
10.2.0.4 5664206 ORA-6502 during export of functional index expression over 4k
10.2.0.4 5686412 Dump (evaopn2) from query using functional index
10.2.0.4 5796376 Dump [kkobrak] from index join with a FUNCTION based index
10.2.0.4 5843316 Wrong results with index join and function-based index
10.2.0.4 5860221 Apply aborts with OERI[17147] / memory corruption with FUNCTION BASED index
10.2.0.4 5889331 Dump from cost based optimization of INSERT .. SELECT with function based index
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 4717546 Wrong results / poor plan when function based index exists
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.41 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.4 3197358 Dump when DBMS_HS_RESULT_SET is fetched out of sequence
10.2.0.4 4767996 Dump in HS with very long TNS connect string
10.2.0.4 4864563 HS does not send to_number predicate to HS database
10.2.0.4 4998706 Gateway agent trace does not work
10.2.0.4 5175364 Data truncation / null data selecting NVARCHAR2 over TG4MSQL
10.2.0.4 5229137 PLS-201 compiling program units referencing tables on RDB
10.2.0.4 5489166 INSERT SQL over HS may error
10.2.0.4 5601756 HS does not supply size for large objects (ORA-28500)
10.2.0.4 5610906 HSODBC dump invoking Data Dictionary translation query multiple times
10.2.0.4 5738652 Intermittent lost RPC connection when executing FDS stored procedure
10.2.0.4 5898868 SELECT FOR UPDATE errors over HS to Teradata
10.2.0.4 5900857 ORA-23619 from HS log based replication
10.2.0.4 5935527 Cursor leak with fix for bug 5260266
10.2.0.4 6053772 Dump [kpubsuuc] for SQL over HS using binds
10.2.0.4 6145525 Dump selecting > 34 columns from HS (FDS)
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.42 Gateways / ODBC

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

Fixed in Release Bug Number Description
10.2.0.4 5385973 ODP.NET gets truncated char/varchar data in HSODBC environment

2.1.43 Gateways / Transparent Gateway For DRDA

The following table lists the Gateways / Transparent Gateway For DRDA bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.4 5877437 TG4DRDA gets sqlcode=-102, sqlstate=54002 using concat function

2.1.44 Gateways / Transparent Gateway For SQL Server

The following table lists the Gateways / Transparent Gateway For SQL Server bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.4 4552393 Heterogenous apply fails for updates with WHERE .. IS NULL
10.2.0.4 5733637 Select for update fails against TG4MSQL
10.2.0.4 5844876 ORA-28550 from TG4SYBS

2.1.45 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.4 4344935 OERI from DML on TEMPORARY TABLE after autonomous TRUNCATE
10.2.0.4 4736557 ORA-1466 on read only transaction
10.2.0.4 5081271 PMON may crash the instance with OERI:kcblibr_1 during temp table cleanup
10.2.0.4 5689991 ORA-8176 fetching from global temporary table with INSERTS between fetches
10.2.0.4 5696474 Diagnostic enhancement for ORA-600 errors on global temporary tables
10.2.0.3 3889156 OERI[kcblibr_1] using global temporary table if client disconnected
10.2.0.2 4552067 Deadlock / ORA-4020 using TRUNCATE SQL against global temporary tables

2.1.46 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.4 3419260 Silent truncation on insert via DB link from single to multibyte charset
10.2.0.4 3945156 ORA-979 from DBMS.GATHER_TABLE_STATS when NLS_COMP=LINGUISTIC
10.2.0.4 4346448 NLS_COMP = ANSI gives wrong results comparing CHAR with VARCHAR2
10.2.0.4 4517481 ORA-904 / ORA-20000 loading metadata with IMPDP using varying width characterset
10.2.0.4 4730249 Logical Standby or Adhoc query fails with ORA-1801 when using a different characterset
10.2.0.4 4904743 ALTER SESSION SET NLS% does not work if OCI_PARSE_ONLY used
10.2.0.4 4905638 Wrong results / errors in session that opens the database for certain NCHAR characterset
10.2.0.4 4933222 Apply update of clob in multibyte charset double spaces characters
10.2.0.4 4959294 DBMS_XMLSTORE does not follow CHAR based semantics
10.2.0.4 4996004 EXPDP fails with ORA-31642 when NLS_SORT=binary_ci and NLS_COMP=ansi
10.2.0.4 5017909 V$SQL / V$SQLAREA.SQL_FULLTEXT corrupt for multibyte
10.2.0.4 5120476 No blank padding with multibyte charset if no character set conversion
10.2.0.4 5126270 Version 3 TIMEZONE check script (utltzuv2.sql)
10.2.0.4 5128625 OERI[17147] / OERI [17182] / NULL result from NLSSORT
10.2.0.4 5175364 Data truncation / null data selecting NVARCHAR2 over TG4MSQL
10.2.0.4 5252496 Wrong result when using a LIKE predicate with NLS_COMP = LINGUISTIC
10.2.0.4 5259741 DBMS_XMLGEN.CONVERT trims output for multibyte database
10.2.0.4 5285966 Dump [lxhlod] on select passing NULL for NLS parameter to a function
10.2.0.4 5326327 OERI[qctbyt : bfc] using NLS_LENGTH_SEMANTICS=CHAR
10.2.0.4 5436371 Image corruption / spin loading multiple nested objects in multibyte
10.2.0.4 5444175 glb files created in gdk_custom.zip by ginstall are ignored by Java
10.2.0.4 5494008 Wrong results from LIKE in multibyte when NLS_COMP=linguistic and NLS_SORT=binary_ci(ai)
10.2.0.4 5526851 Wrong Results (missing rows) on CONNECT BY when using function-based index
10.2.0.4 5567934 NCHAR literal replacement can produce corrupt N literals
10.2.0.4 5576865 Dumps in strlen/kpodpmop/kpodpp errors during IMPDP
10.2.0.4 5594352 JMS-120 / OCI-1858 when dequeueing AQ bytes message with JDBC-OCI
10.2.0.4 5604120 Performance problems after applying calendar deviation
10.2.0.4 5632264 Version 4 TIMEZONE files
10.2.0.4 5685296 Logical apply stops with PLS-103 due to NLS_NUMERIC_CHARACTERS setting
10.2.0.4 5693948 ORA-31466 error when setting up CDC with table names using multibyte characters
10.2.0.4 5712086 OERI[17147] / dump from TO_CHAR(date) with over long FORMAT string in multibyte
10.2.0.4 5757315 Spin possible comparing 2 strings with monolingual sort (NLS_SORT)
10.2.0.4 5873852 sqlldr inserts character data longer than the column length (CHAR length semantics)
10.2.0.4 5875568 IMPDP can error on create table in multibyte with ORA-39125 / ORA-6502
10.2.0.4 5903706 ISO2022-JP-OUTLOOK has no mapping for the katakana middle dot character
10.2.0.4 5985257 Wrong results from UTL_I18N.TRANSLITERATE using 'hwkatakana_fwkatakana'
10.2.0.4 6357601 Romanian base letter mapping missing for some characters
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.47 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.4 5526987 * ASM instance hang / OERI [2103] on DB instance. This bug is alerted in Note:468572.1
10.2.0.4 4489948 ASM hangs during a parallel mount and shutdown in RAC
10.2.0.4 5057695 SHUTDOWN IMMEDIATE can be slow
10.2.0.4 5079641 Switchover hangs attempting to recover a log file from a previous primary
10.2.0.4 5188493 crsd.bin can use excess CPU on reboot
10.2.0.4 5230765 LGWR spins while waiting for 'log file parallel write' using ASM
10.2.0.4 5387017 Primary hang when physical standby "shutdown immediate"
10.2.0.4 5688403 'IPC Send timeout' error just after 'flush_cache' event in RAC
10.2.0.4 5931789 Database hang possible as CKPT cannot get controlfile enqueue (CF)
10.2.0.4 5955955 DWB may spin when collecting object level statistics with concurrent DDL
10.2.0.4 6069360 DBW can spin in kfcRunnableWaiter holding a latch in ASM
10.2.0.4 6310591 DB hang with CKPT waiting for enquiry response in RAC
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 4480100 + Latch contention for "row cache objects" latch covering DC_USERS
10.2.0.2 4164021 OERI [2103] during BACKUP CONTROLFILE to TRACE

2.1.48 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.4 5907779 + Self deadlock hang on "cursor: pin S wait on X" (typically from DBMS_STATS)
10.2.0.4 3140249 Data guard broker hangs when standby listener is down
10.2.0.4 4618808 AQ operation requiring exclusive lib cache lock may hang
10.2.0.4 4648039 PLSQL hangs with database links and autonomous_transaction
10.2.0.4 4927753 GRANT / ALTER USER can hang
10.2.0.4 4930431 Failure of 1 CSSD can hang starting CSSD on other nodes
10.2.0.4 5023410 QC can wait on "PX Deq: Join ACK" when slave is available
10.2.0.4 5166735 DBMS_SCHEDULER "EXECUTABLE" jobs with large amounts of data output to STDERR can hang
10.2.0.4 5225733 After flashback operation, new logs are not applied in logical standby
10.2.0.4 5378806 xa_rollback cannot interrupt a long running SELECT branch
10.2.0.4 5382088 Fast start failover can hang on broker MIV mismatch
10.2.0.4 5392993 DDL can hang if EXPLAIN PLAN issued previously for the same DDL statement
10.2.0.4 5396550 Spin in ktsplbfmb holding HW enqueue during LOB segment management
10.2.0.4 5444539 Database connections not released after database failover or recycle
10.2.0.4 5454831 RAC deadlock possible on working set latches
10.2.0.4 5500044 ORA-44203 on table_x_x child from concurrent LOB append and drop partition
10.2.0.4 5503590 Logminer Adhoc can hang or error mining logs from a RAC database
10.2.0.4 5511675 OCCI hang in terminateStatelessConnectionPool
10.2.0.4 5560256 Multi threaded OCI program hang when calling OCILobLocatorAssign
10.2.0.4 5567141 OERI[526] / hang with fix for bug 5508574 installed with > 31 CPUs
10.2.0.4 5602452 Capture gets stuck in 'dictionary initialization' after recovery
10.2.0.4 5604698 Deadlock between 'library cache lock' and 'library cache pin' using Streams
10.2.0.4 5654680 JMS worker thread does not end if exception thrown in onMessage() method
10.2.0.4 5725109 Hang if AQ listener onMessage() method raises an error
10.2.0.4 5746223 Old primary hangs after a FSFO and prevents automatic reinstatement
10.2.0.4 5898210 Hang from concurrent MV refresh and library cache invalidation in RAC
10.2.0.4 5955596 DBMS_AQ.LISTEN hangs after datapump has executed
10.2.0.4 5974219 Cluster hang when node dies during reconfig
10.2.0.4 5983020 MMON deadlock with user session executing ALTER USER
10.2.0.4 6013968 Hang / OERI:504 with patch for bug 5863519 installed
10.2.0.4 6019084 RAC hang possible when node leaves the cluster with fix for bug 5844816
10.2.0.4 6057351 AWR deadlock between Mxxx processes during snapshot purging process
10.2.0.4 6144079 Instance crash in RAC (OERI:2103)
10.2.0.4 6334552 Hang / ORA-4031 / OERI:kfrcsoDelete_3 on rollback of ASM file resize
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.49 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.4 6110331 + OERI[kcbget_37] / OERI[1100] / spin possible
10.2.0.4 3551896 Dump / spin from SELECT on V$SESSTAT
10.2.0.4 4387531 Spin running XPATH on SB table with IOT structured varrays
10.2.0.4 4553025 Large inserts into hash clustered tables can spin
10.2.0.4 4605569 LCK may accumulate CPU time on one instance
10.2.0.4 4697189 High CPU usage for large sorts
10.2.0.4 4699720 MMON or PMON spin in RAC
10.2.0.4 5369855 OERI:733 or Spin (qksopLogSame) from star transformation
10.2.0.4 5417292 Query compilation may spin in kkogtp
10.2.0.4 5436371 Image corruption / spin loading multiple nested objects in multibyte
10.2.0.4 5471994 LCK may accumulate CPU time when SMON does Serial Transaction recovery
10.2.0.4 5484652 QMNC process spin in Streams
10.2.0.4 5545530 EMON may spin in kpcopen
10.2.0.4 5631915 Select from V$ views using X$KGLLK can spin
10.2.0.4 5667683 Parse of query can spin in kkosbn
10.2.0.4 5670585 OERI [kxfxsSendCounter1] / OERI [15574] / spin from WINDOW query
10.2.0.4 5718007 Spin (in qcopxla / qcopx0la) with OR predicates on PARTITION key columns
10.2.0.4 5728380 DML may spin under ktspffc searching for space in ASSM segment
10.2.0.4 5734276 Queue slave process may spin in kwqitptm
10.2.0.4 5757315 Spin possible comparing 2 strings with monolingual sort (NLS_SORT)
10.2.0.4 5763245 Parse may spin in kkpapRTPRuningSetup
10.2.0.4 5763434 Spin in kokes2q when sorting on VARRAY column over 4k long
10.2.0.4 5952530 Spin / hang after cluster reconfiguration
10.2.0.4 5955955 DWB may spin when collecting object level statistics with concurrent DDL
10.2.0.4 5958244 LMS processes running in realtime can spin
10.2.0.4 6001617 LCK may accumulate CPU time / ORA-4031 possible
10.2.0.4 6041084 Spin during parse of query with INLIST against list partition key
10.2.0.4 6069360 DBW can spin in kfcRunnableWaiter holding a latch in ASM
10.2.0.4 6084108 Dump / CPU spin possible after an ORA-3115
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.50 Hash Join

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

Fixed in Release Bug Number Description
10.2.0.4 5383936 + Wrong results from Parallel Query with OUTER join and HASH join
10.2.0.4 4540971 Hash group by significantly over allocates memory and breaks V$SQL_XX statistics
10.2.0.4 4566991 Hash group-by is not reported in v$sql_workarea_active
10.2.0.4 5376015 Wrong results with hash semijoin when build rows do not fit in memory
10.2.0.4 5759075 Wrong results from PQ with HASH on ANSI CHAR join
10.2.0.4 5893340 OERI [32695] [hash aggregation can't be done]
10.2.0.4 5947623 Excess PGA memory used by hash joins
10.2.0.3 4604970 + Wrong results with 'hash group by' aggregation enabled

2.1.51 Index Organized Tables (IOT)

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

Fixed in Release Bug Number Description
10.2.0.4 6646613 * IOT corruption after upgrade from <= 9.2 to >= 10g. This bug is alerted in Note:471479.1
10.2.0.4 4387531 Spin running XPATH on SB table with IOT structured varrays
10.2.0.4 4725385 DBMS_STATS on partitioned IOT with additional indexes can be slow
10.2.0.4 4770292 Wrong results from CONNECT BY query on IOT with secondary index/es
10.2.0.4 5236908 Primary key index not used for IOT
10.2.0.4 5255455 DML error logging not working for primary key violation with insert on IOT table
10.2.0.4 5494240 OERI[15201] during select from an IOT
10.2.0.4 5558244 OERI[kcbnew_3] can occur
10.2.0.4 5609096 MERGE / UPDATE to IOT can cause corruption
10.2.0.4 5685645 Logminer does not support IOT with OVERFLOW if table has been altered
10.2.0.4 5741044 Query performing fast full scan on partitioned IOT
10.2.0.4 5847521 Hierarchical (CONNECT BY) query on IOT returns wrong results
10.2.0.4 5924538 Logical standby apply fails with ORA-1427 for operations on IOTs
10.2.0.4 5944227 SQLloader direct path load into IOT can dump [kdblldrp]
10.2.0.4 6070548 Dump (qertbGetPartitionNumber) / wrong results from bitmap access to IOT
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 4741394 OERI [12406]/Wrong Results from CONNECT BY query
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.52 Install Is Not Performed Correctly

The following table lists the Install Is Not Performed Correctly bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.2.0.4 6051728 P* HPUX Itanium: Cannot use ASM (ORA-15059). This bug is alerted in Note:434500.1
10.2.0.4 5495242 PI HPUX: CRS may not install
10.2.0.4 5845104 PI Win64: 10.2.0.3 OPMD.EXE does not work
10.2.0.4 5507883 CRS install fails in CRS root.sh due to node panics
10.2.0.3 5496862 PI AIX: Mandatory patch to use Oracle with IBM Technology Level 5 (5300-5)

2.1.53 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.4 5605370 * Various dumps / instance crash possible. This bug is alerted in Note:454464.1
10.2.0.4 4422686 LMD/LMS cannot be frozen during reconfig
10.2.0.4 4433838 Resizing cache crashes instance with OERI[kmgs_pre_process_request_6]
10.2.0.4 4744529 OERI:kclpred_1 / crash possible in RAC
10.2.0.4 5081271 PMON may crash the instance with OERI:kcblibr_1 during temp table cleanup
10.2.0.4 5118012 Instance crash with OERI[kclswrite_3] with multiple DBW processes
10.2.0.4 5118272 Instance crash with ORA-600 [1433], [60] due to lgwr filling up msg blocks. (Messages could be for LGWR or ARCH).
10.2.0.4 5131219 CSS shuts down the node when disk IO is suspended momentarily
10.2.0.4 5190596 LMON dumps LMS0 too often during DRM leading to IPC send timout
10.2.0.4 5324905 nsprecv() can corrupt the SGA when using shared servers
10.2.0.4 5375583 LMS process dies with OERI[kclexpandlock_1]
10.2.0.4 5377099 Dump [kksfreeheap] / OERI:504 / SGA corruption / crash possible
10.2.0.4 5384248 OERI[k2gtelock: !k2gtca] / instance crash cleaning up distributed transaction
10.2.0.4 5412994 Dump in ksrchconnect_ctx leading to instance crash
10.2.0.4 5476873 Instance crash due to PMON ORA-601 / OERI[ksudlp1]
10.2.0.4 5504989 PMON dump [kfgGlobalClose] / instance crash
10.2.0.4 5512921 Instance crash caused by SMON OERI[kcblus_1] / dump
10.2.0.4 5554692 Error ORA-15196 reporting ASM block header invalid ora-15196 after ORA-600[kfcgetbuffer10]
10.2.0.4 5578157 Instance crash with ORA-600 [1433] (RSM has all message blocks)
10.2.0.4 5587421 LMS fails with OERI [kjmpmsg_1]
10.2.0.4 5600050 LMON may fails with OERI [kjbrref:pkey] during DRM
10.2.0.4 5690100 RAC instance crash with OERI[kjbmpwrite:wip2]
10.2.0.4 5702177 Instance crash from OERI[kghchoose_grow_1]
10.2.0.4 5721821 SGA corruption / Dump[kglobcl] / crash if objects dropped / recreated
10.2.0.4 5730717 OERI:kclchkinteg_18 / LMS crashes the instance
10.2.0.4 5757752 OERI:kghstack_alloc / OERI:kfcbCkpt04 / ASM crash
10.2.0.4 5762514 DBWR crashes instance with OERI[kcbbctsc_3]
10.2.0.4 5863519 Instance crash due to LMS dump (in kclcsr)
10.2.0.4 5899033 SMON dump (kfrCheckCtx) diskgroup instance recovery
10.2.0.4 5933838 Database crash (ORA-449) after ALTER DATABASE FLASHBACK OFF in RAC
10.2.0.4 5962344 Dump from Logminer due to stack corruption under krvtgct_GetColumnTranslation
10.2.0.4 5983403 PMON may crash the instance with OERI[kksStatsRecovery-Bad-Opcode]
10.2.0.4 6005113 OERI[kclrwrite_7] in DBWn process followed by instance crash in RAC
10.2.0.4 6013983 ASM signals OERI [kfdasecondaries01] / [kffrelocate87] during rebalance
10.2.0.4 6018125 Instance crash during dynamic remastering or instance reconfiguration
10.2.0.4 6035614 Instance crash / dump [kghunphy] with fix for bug 5922239
10.2.0.4 6075582 OERI[kjbmpref:sh] / dump [kjmpbmsg] in LMS causing instance crash
10.2.0.4 6144079 Instance crash in RAC (OERI:2103)
10.2.0.4 6239052 LMS can crash instance with OERI[kjbrchkinteg:last]
10.2.0.3 5071492 +I RAC instances may crash on 64bit platforms
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 5106909 Instance crash with OERI [kjbrasr:pkey] in RAC
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 4597251 + OERI / buffer cache corruption / crash from concurrent index block reclaimation
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.54 Instance Startup

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

Fixed in Release Bug Number Description
10.2.0.4 5752399 P+ Sol: Mandatory Patch to use Oracle with Veritas or Solstice Disk Suite on Solaris
10.2.0.4 4440013 CRS startup of RAC fails when FSFO enabled
10.2.0.4 4771560 Open resetlogs can fail with ORA-1667
10.2.0.4 5247609 RMAN slow performance during register database/open resetlogs
10.2.0.4 5572026 ORA-942 / ORA-1031 in tracefile when starting the database as SYSOPER
10.2.0.4 5744546 MMON OERI [1403]
10.2.0.4 5855896 Reconfiguration takes a long time restarting instance in active/standby RAC
10.2.0.4 5857949 Startup may fail due to dump [rfmsoexinst] from DMON
10.2.0.4 6143688 node startups cAN spend up to 2 mins in AQ partition code
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.55 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.4 5933477 * Client <= 9.2.0.7 / 10.1.0.4 can dump when running against higher level database. This bug is alerted in Note:455832.1
10.2.0.4 5245451 Intermittent ORA-904 referencing remote objects columns
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.56 JDBC

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

Fixed in Release Bug Number Description
10.2.0.4 4308334 OERI[12314] during XA commit/rollback/prepare while attached to different transaction
10.2.0.4 4992603 TIMESTAMP.timestampValue(Calendar) does not exist
10.2.0.4 5190543 Wrong timestamp from oracle.sql.TIMESTAMPLTZ near daylight savings transition
10.2.0.4 5417281 oracle.sql.DATE looses a year when constructed from BC Timestamp
10.2.0.4 5468695 TIMESTAMPTZ wrong near daylight switch
10.2.0.4 5734901 JDBC Thin XMLType.getDOM fails with SQLException
10.2.0.4 5885079 Incorrect output from INTERVALDS.stringValue() for negative intervals
10.2.0.4 5945463 XA clients should not require execute privilege on DBMS_SYSTEM
10.2.0.4 6278984 java.awt.font.glyphvector.getglyphoutline returns empty shape
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.57 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.4 4865959 Wrong results / exception from Java Stored Procedure accessing data over DBLINK
10.2.0.4 4898765 NullPointerException from stored Java when maxAdvance of glyph computed
10.2.0.4 5074285 Dump [eorealize_xref] from stored Java using reflective methods
10.2.0.4 5258410 Dump [eoa_scan_mark_object] using stored Java threads
10.2.0.4 5372831 OERI:26599 / dumps in JVM after database has been closed for recovery / opened
10.2.0.4 5400158 OERI[17078] / dump running Java DDL (loadjava) concurrently
10.2.0.4 5688685 JVM timezone changes for Western Australia December 2006 (superceeded)
10.2.0.4 5711011 "SocketException: socket is closed" using RMI with shared servers
10.2.0.4 5862057 Oracle JVM incorrectly returns true for "x instanceof object[]" when "x" is a class
10.2.0.4 5865568 JVM timezone changes (version 4 timezone data for JVM)
10.2.0.4 5963041 Socket.shutdownOutput() closes the socket in the Oracle JVM
10.2.0.4 6065183 A dump in AccessControlContext methods in the Oracle JVM
10.2.0.4 6065728 Oracle JVM performance enhancement
10.2.0.4 6120084 Dump (eoistrnrep->strncpy) in Oracle JVM
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.58 Job Queues

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

Fixed in Release Bug Number Description
10.2.0.4 4552696 DBMS_Scheduler is suppressing no_data_found exceptions in jobs
10.2.0.4 4904904 Problems with DBMS_SCHEDULER JOB_START time (eg ORA-1877)
10.2.0.4 5111250 DBMS_SCHEDULER jobs fail silently with OLS / OID
10.2.0.4 5120780 Long text for job gets EXP-85 ORA-6502 on dbms_sched_job_export
10.2.0.4 5140631 V$SESSION.sql_address not set by DBMS_SCHEDULER
10.2.0.4 5157602 Datapump export/import modifies the chains created with dbms_scheduler
10.2.0.4 5166735 DBMS_SCHEDULER "EXECUTABLE" jobs with large amounts of data output to STDERR can hang
10.2.0.4 5377153 DBMS_SCHEDULER call heap memory leak when changing attributes of a job
10.2.0.4 5593617 Job scheduler cannot be used on logical standby (ORA-16224)
10.2.0.4 5620375 PLS-103 from datapump import of dbms_scheduler jobs with PLSQL_BLOCK
10.2.0.4 5928612 V$SESSION SQL_ADDRESS / SQL_HASH_VALUE not set for DBMS_JOBs
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.59 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.4 4571240 ESM denies access to non-orcladmin users if anonymous binds disabled
10.2.0.4 5111250 DBMS_SCHEDULER jobs fail silently with OLS / OID
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.60 Latch Contention

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

Fixed in Release Bug Number Description
10.2.0.4 6455161 + Higher CPU / Higher "cache buffer chains" latch gets / Higher "consistent gets" after truncate/Rebuild
10.2.0.4 4691237 High "library cache" latch gets from SQL using objects in PLSQL
10.2.0.4 5918642 Heavy latch contention with DB_CACHE_ADVICE on
10.2.0.4 6333663 Shared pool latch contention due to fragmentation of large pool
10.2.0.3 4770693 PI+ Intel Solaris: Unnecessary latch sleeps by default
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.61 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.4 5108234 P Win: High memory (virtual bytes) consumption per connection in 10.2
10.2.0.4 4475206 Excess PGA memory use with many hash joins
10.2.0.4 4540971 Hash group by significantly over allocates memory and breaks V$SQL_XX statistics
10.2.0.4 4587117 ORA-384 can occur even if there is free space in some pool/s
10.2.0.4 5058318 Memory leak (in "koh-kghu" heap of type "kolccst obj")
10.2.0.4 5089522 Memory leak in niotns in MRP process
10.2.0.4 5095025 ORA-4030 (kxs-heap-c,temporary memory) using expdp
10.2.0.4 5095889 PGA leak during propagation in "kwqpcbk:koioalm" and "kwqpcbk:csid"
10.2.0.4 5220562 ORA-4030 (sort subheap,sort key) on insert a partitioned table with concurrent DDL
10.2.0.4 5377153 DBMS_SCHEDULER call heap memory leak when changing attributes of a job
10.2.0.4 5377973 Register schema fails with ORA-4031
10.2.0.4 5382621 OCCI memory leak in getColumnListMetaData()
10.2.0.4 5386986 Leak / ORA-4031 leak when DROP UNUSED COLUMN issued on large partitioned table
10.2.0.4 5391505 High PGA consumption for query (kxs-heap-c) from OR expansion
10.2.0.4 5408970 Memory leak using XMLType() constructor on ADT in a loop
10.2.0.4 5464834 ORA-4030 (kxs-heap-c,temporary memory) using EXPDP
10.2.0.4 5477912 Memory leak parsing DTD
10.2.0.4 5482555 Shared server does not release memory
10.2.0.4 5485417 Memory leak of "blockers api immd" during global hang analyze
10.2.0.4 5516917 Excessive mermory usage when running a query using nested loops
10.2.0.4 5529797 PGA leak / OERI KWQPCBK179 during Streams propogation
10.2.0.4 5548510 _FIX_CONTROL parameter leaks memory in the shared pool
10.2.0.4 5556674 V$ASM* dynamic views leak cursors (ORA-01000)
10.2.0.4 5573238 Shared pool memory use / ORA-4031 due to "obj stat memo" in one subpool
10.2.0.4 5608198 Memory leak by advanced queuing XML transformation
10.2.0.4 5618049 "mvobj part des" leaked memory after partition DDL (ORA-4031)
10.2.0.4 5629416 Client memory leak after switching schema
10.2.0.4 5668025 XMLParser.Parse() can leak memory
10.2.0.4 5717536 Dequeue can suffer from a memory leak
10.2.0.4 5723260 Logminer slow / excess memory use processing batch inserts with LOBs
10.2.0.4 5758963 UGA memory leak possible from AQ dequeue
10.2.0.4 5891737 Dump (kcblsod) / OERI:723 / Memory leak in ASM/RAC
10.2.0.4 5947623 Excess PGA memory used by hash joins
10.2.0.4 6011182 Parsing of large query takes long time / memory leak / ORA-4030 /4031
10.2.0.4 6043052 Leak in perm allocations with library cache comments. ora-4031 generated
10.2.0.4 6049324 Memory leak from array dequeue
10.2.0.4 6065604 DBMS_AQ.DEQUEUE_ARRAY PGA memory leak
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.62 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.4 4584641 Cursor leak using DBMS_XMLGEN with a PLSQL function returning sys_refcursor
10.2.0.4 4918946 OCCI terminateEnvironment can leave threads
10.2.0.4 5141429 "skgspawn 27142" errors and defunct Oracle processes
10.2.0.4 5166745 Excessive redo generation with auditing enabled
10.2.0.4 5252389 CDC apply changes lead to maximum open cursors exceeded (ORA-1000)
10.2.0.4 5557660 ORA-20 / process group leak from OCI Connection Pool connections
10.2.0.4 5605319 Cursor leak from QMON coordinator exceptions
10.2.0.4 5935527 Cursor leak with fix for bug 5260266
10.2.0.4 6043052 Leak in perm allocations with library cache comments. ora-4031 generated
10.2.0.4 6139547 Shadow process leak on ASM instance when diskspace exhausted (ORA-20)
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.63 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.4 5146740 + Wrong results with bind variables/CURSOR_SHARING
10.2.0.4 2837580 Dump if SQL has > ~35000 literals
10.2.0.4 4202503 Parse errors possible using CONTAINS with cursor_sharing=similar/force
10.2.0.4 4436832 False ORA-979 "not a group by expression" with literal replacement
10.2.0.4 4513695 Poor performance for SELECT with ROWNUM=1 with literal replacement
10.2.0.4 5155885 OERI[kkslgbv0] with CURSOR_SHARING=similar
10.2.0.4 5177766 OERI[17059] with SESSION_CACHED_CURSORS
10.2.0.4 5254759 ORA-12801/ORA-1008 occurs on a parallel query with bind variables
10.2.0.4 5364819 OERI[kkslpbp:1] when using literal replacement
10.2.0.4 5476507 OERI[15868] / OERI[15160] can occur with cursor sharing
10.2.0.4 5757106 OERI[15851] selecting aggregate of a constant with literal replacement
10.2.0.4 5762750 ORA-907 when cursor_sharing is enabled
10.2.0.4 5863277 ORA-1008 from SQL on second run when cursor_sharing=similar/force
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.64 LogMiner

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

Fixed in Release Bug Number Description
10.2.0.4 5035058 V$LOGMNR_CONTENTS.MineValue may not show an UNDO value
10.2.0.4 5299237 Inconsistent results from v$logmnr_contents with committed_data_only
10.2.0.4 5388885 Hang / OERI[krvxbpns01] accessing V$LOGMNR_CONTENTS from RAC
10.2.0.4 5437445 Incorrect username displayed from logminer adhoc query when auditing is on
10.2.0.4 5503590 Logminer Adhoc can hang or error mining logs from a RAC database
10.2.0.4 5510918 Log miner slow mining direct load redo
10.2.0.4 5518651 ORA-1031 from dbms_logmnr_d.build
10.2.0.4 5531784 V$LOGMNR_CONTENTS CSF may be wrong
10.2.0.4 5685645 Logminer does not support IOT with OVERFLOW if table has been altered
10.2.0.4 5723260 Logminer slow / excess memory use processing batch inserts with LOBs
10.2.0.4 5744428 dbms_logmnr_d.build may get a downstream build failure
10.2.0.4 5888733 Wrong results from V$LOGMNR_CONTENTS referencing AUDIT_SESSIONID
10.2.0.4 5962344 Dump from Logminer due to stack corruption under krvtgct_GetColumnTranslation
10.2.0.4 6064864 Archives containing DDL for not replicated objects take longer to process
10.2.0.4 6114833 Logminer does not signal error if log unavailable in continuous_mine
10.2.0.4 6124804 Dump [krvxbpc_processcommit] selecting from v$logmnr_contents
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.65 Memory Corruption

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

Fixed in Release Bug Number Description
10.2.0.4 4583492 Dump possible using ADT columns when table has many columns
10.2.0.4 4644425 SGA corruption on UPDATE with functional domain index
10.2.0.4 4745691 OERI[kghufree_06] from AQ propogation of XML payload
10.2.0.4 4899479 Undo/redo corruption if distributed transactions used
10.2.0.4 5128625 OERI[17147] / OERI [17182] / NULL result from NLSSORT
10.2.0.4 5172559 ora-600's during reinstate of logical standby after fast-start failover
10.2.0.4 5324905 nsprecv() can corrupt the SGA when using shared servers
10.2.0.4 5583634 OERI [17147] / dump after inserting a text node of size 64000
10.2.0.4 5671774 Memory corruption due to TDE with imported certificate
10.2.0.4 5681955 SGA corruption in RAC (OERI [17114] / OERI [17112])
10.2.0.4 5712086 OERI[17147] / dump from TO_CHAR(date) with over long FORMAT string in multibyte
10.2.0.4 5716932 Memory corruption / OERI [17147] / dump selecting from PATH_VIEW
10.2.0.4 5721821 SGA corruption / Dump[kglobcl] / crash if objects dropped / recreated
10.2.0.4 5860221 Apply aborts with OERI[17147] / memory corruption with FUNCTION BASED index
10.2.0.4 5900857 ORA-23619 from HS log based replication
10.2.0.4 6136494 Capture process aborts with OERI [17112] / OERI [17147]
10.2.0.4 6452485 SGA memory corruption / OERI [17182] with fix for bug 6085625
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 4918154 Client memory corruption / wrong results from SQLT_AVC / Pro "unsafe_null = yes"
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 4597251 + OERI / buffer cache corruption / crash from concurrent index block reclaimation
10.2.0.2 4487195 Dump (kghtshrt) / memory corruption as PQ slave may share SQL incorrectly

2.1.66 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.4 4216668 Dump from INSERT / MERGE on internal columns
10.2.0.4 4311273 ORA-2064 using MERGE statement over a database link
10.2.0.4 4406211 Dump (insLoadRowInfo) from MERGE SQL with false condition
10.2.0.4 4572043 DML monitoring is incorrect for MERGE / MTI
10.2.0.4 5181547 Index corruption after insert-only merge /*+ append */ into table
10.2.0.4 5387478 ORA-28132 for user with EXEMPT ACCESS POLICY privilege
10.2.0.4 5609096 MERGE / UPDATE to IOT can cause corruption
10.2.0.4 5731952 MERGE statement does not insert rows if source is a (inline) view with parallel
10.2.0.4 6379123 EXPDP/IMPDP ORA-39083 due to changes in MERGE privilege between 10.1 and 10.2
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.67 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.4 6646613 * IOT corruption after upgrade from <= 9.2 to >= 10g. This bug is alerted in Note:471479.1
10.2.0.4 5501528 I ORA-6545 recompiling with PLSQL_WARNINGS set
10.2.0.4 5841554 I OERI:kqludp2 during upgrade to 10.2.0.3
10.2.0.4 4733582 Upgrade to 10.2 deletes statistics on AQ tables
10.2.0.4 4882839 ORA-4068 / ORA-4065 after upgrade
10.2.0.4 5094908 Dump (kokbBuildExplodedTree) recompiling a view after upgrade to 10.2
10.2.0.4 5125957 Cannot start CRS after CRS ugprade
10.2.0.4 5520937 Cannot upgrade images for dictionary types to 8.1 image format
10.2.0.4 5568399 CRS upgrade can corrupt OCR
10.2.0.4 5640527 ORA-1403 running utlu102i.sql on an 8.1.7.4 database
10.2.0.4 5715079 ORA-1281 when applying a Patch Set on a logical standby
10.2.0.4 5871314 Pickler fix needed to allow some DB upgrade / downgrade to work
10.2.0.4 5892355 OERI [22635] during upgrade
10.2.0.4 5947653 XE to EE upgrade fails in XDBx
10.2.0.4 5955764 OERI[kccirsd_4] during CONTROLFILE upgrade from pre 10.2 version
10.2.0.4 6052351 Dump running catupgrd.sql when creating/replacing streams$transformation_info
10.2.0.4 6379123 EXPDP/IMPDP ORA-39083 due to changes in MERGE privilege between 10.1 and 10.2
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.68 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.4 4397693 Dump (apaqba) from multi table insert with WHEN clause under RBO
10.2.0.4 4592596 Corruption (ORA-1410) from multi-table insert with direct load
10.2.0.3 4944292 Multi-table insert may dump (koklgolx)

2.1.69 NCOMP

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

Fixed in Release Bug Number Description
10.2.0.4 5974207 Unexpected ORA-1031 from LOB access - affects NCOMPed PLSQL

2.1.70 NUMA Related

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

Fixed in Release Bug Number Description
10.2.0.4 5173642 Data not read from cache on second execution with NUMA optimization enabled
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.71 Network

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

Fixed in Release Bug Number Description
10.2.0.4 4767996 Dump in HS with very long TNS connect string
10.2.0.4 4998706 Gateway agent trace does not work
10.2.0.4 5406976 Dump (lxhscn) if DB calls out over NET with a FAILOVER clause
10.2.0.4 5755010 Listener registration never completes
10.2.0.3 4297024 sqlnet.ora not loaded
10.2.0.2 4562889 Small memory leak possible in Net

2.1.72 OCCI

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

Fixed in Release Bug Number Description
10.2.0.4 4918946 OCCI terminateEnvironment can leave threads
10.2.0.4 5382621 OCCI memory leak in getColumnListMetaData()
10.2.0.4 5511675 OCCI hang in terminateStatelessConnectionPool
10.2.0.4 5970288 OCCI isNull() on object column always returns false even when object is null
10.2.0.4 5973217 OCCI::intervalds object attribute uses day precision for fractional seconds
10.2.0.4 6156762 OCCI fractional seconds portion can be wrong
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.73 OCI

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

Fixed in Release Bug Number Description
10.2.0.4 4730906 "ilibociei" target in ins_rdbms.mk does not work
10.2.0.4 5120476 No blank padding with multibyte charset if no character set conversion
10.2.0.4 5131157 OCI may error reexecuting a statement against a table with an altered column type
10.2.0.4 5242942 Client dump (OCIPClearMxCtr) using stateless connection pool
10.2.0.4 5292883 Dump from OCI client using OCI7 olog() call
10.2.0.4 5413989 OCIStmtSetPieceInfo() does not work for piece sizes > 16777180
10.2.0.4 5444539 Database connections not released after database failover or recycle
10.2.0.4 5510345 ORA-22282 with LOB buffering enabled
10.2.0.4 5549410 Inconsistent characters read returned from OCILobRead
10.2.0.4 5557660 ORA-20 / process group leak from OCI Connection Pool connections
10.2.0.4 5560256 Multi threaded OCI program hang when calling OCILobLocatorAssign
10.2.0.4 5629416 Client memory leak after switching schema
10.2.0.4 5643527 OCILobOpen/OCILobGetChunkSize do not return OCI_STILL_EXECUTING in non blocking mode
10.2.0.4 5682121 Multithreaded OCI clients do not mutex properly for LOB operations (ORA-21500 [17099])
10.2.0.4 5683652 OCIHandleFree performance issue
10.2.0.4 5694101 OCI piecewise operation returns wrong piece length for long / long varchar data
10.2.0.4 5715788 genezi -v reports 32-bit library instead of 64-bit
10.2.0.4 5721502 Non blocking client may dump executing PLSQL
10.2.0.4 5721702 Error information may be lost in non-blocking OCI
10.2.0.4 5721994 Unexpected errors from non blocking OCI LOB calls
10.2.0.4 5722178 ORA-1002 in non blocking mode
10.2.0.4 5736739 Compressed fetching can fail in non blocking mode
10.2.0.4 5736747 Resumed OCIStmtExecute can fail in non-blocking mode
10.2.0.4 5765361 Client dump using OCIDirPathPrepare in OCI_UTF16ID mode
10.2.0.4 5932089 FAN OCI clients not aborted by OCI on public network down
10.2.0.4 6038412 OCI7 clients using "CALL" SQL may execute wrong shared cursor
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 4918154 Client memory corruption / wrong results from SQLT_AVC / Pro "unsafe_null = yes"
10.2.0.3 4952018 OCI direct path API allows invalid data for NUMBER(p,s) fields
10.2.0.3 4962578 SELECT returns wrong results when not all columns are defined
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.74 Online DDL

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

Fixed in Release Bug Number Description
10.2.0.4 4596807 OERI[6002] on update statement with concurrent ONLINE rebuild of bitmap indexes
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.75 Optimizer

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

Fixed in Release Bug Number Description
10.2.0.4 599680 Unnecessary sort for SELECT DISTINCT
10.2.0.4 3748430 i_*part$, i_*part_obj$ should be created as unique indexes
10.2.0.4 3945156 ORA-979 from DBMS.GATHER_TABLE_STATS when NLS_COMP=LINGUISTIC
10.2.0.4 3995047 Explain plan does not show a part of the execution path
10.2.0.4 4204383 Dump [kkqtnlocbk] optimizing ANSI OUTER JOINs with subqueries
10.2.0.4 4215910 DBMS_STATS may use a 100% row sample size when not expected
10.2.0.4 4226736 Wrong clustering factor when DBMS_STATS.GATHER_INDEX_STATS runs in parallel
10.2.0.4 4273361 Unique index access not used with INLIST predicate
10.2.0.4 4397693 Dump (apaqba) from multi table insert with WHEN clause under RBO
10.2.0.4 4422100 Sort merge join on inequality should have control parameter
10.2.0.4 4444536 Unnecessary sorting when access made through a global index
10.2.0.4 4483240 INLIST may use suboptimal index
10.2.0.4 4513695 Poor performance for SELECT with ROWNUM=1 with literal replacement
10.2.0.4 4545802 Poor Outer Join Cardinality estimation with filters on outer table
10.2.0.4 4567767 Execution Plan changes upon rowcache reload
10.2.0.4 4581014 DBMS_STATS issues gathering SIZE AUTO / SKEWONLY
10.2.0.4 4587431 Dump (in kkqucsv) / spin from query with a multi column IN subquery predicate
10.2.0.4 4605810 Index may not be chosen to eliminate ORDER BY SORT
10.2.0.4 4619997 Function based index may not be used for INLIST predicate
10.2.0.4 4652100 Poor plan with bind peeking for SQL against LIST partitioned tables
10.2.0.4 4664788 Query with UNION can dump in kkqudhus
10.2.0.4 4684209 Dump (under evaopn2) with transitive predicate from CHECK constraint
10.2.0.4 4698023 CBO may treat a predicate value as 'out-of-range' when it should not
10.2.0.4 4704779 Incorrect histogram type used (frequency/height-balanced)
10.2.0.4 4708389 Nest loop join costing ignores parallelism of index used to probe in right side
10.2.0.4 4712638 OERI[15160] / dump [kkogbro]
10.2.0.4 4724074 Small CPU performance overhead during optimization
10.2.0.4 4725385 DBMS_STATS on partitioned IOT with additional indexes can be slow
10.2.0.4 4733582 Upgrade to 10.2 deletes statistics on AQ tables
10.2.0.4 4752814 Wrong selectivity on comparision of VARCHAR2 column with CHAR variable