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.