• Latest Updates

    Post Top Ad

    04 February, 2013

    Home Unlabelled 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

    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:
    • Patch Set Documentation
    • Bugs Fixed in this Patch Set by Category
    • Documentation Accessibility

    1 Patch Set Documentation

    There are two documents related to this release of the Oracle Database patch set:
    • Oracle Database Patch Set Notes, 10g release 2 (10.2.0.4) Patch Set for each platform
      This document provides:
      • System requirements and information about how to install or reinstall the patch set
      • A list of all bugs fixed to date that are specific to the platforms
      • A list of known issues relating to Oracle Database on the platforms
    • Oracle Database List of Bugs Fixed, 10g release 2 (10.2.0.4) (this document)
    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 ReleaseBug NumberDescription
    10.2.0.44204383Dump [kkqtnlocbk] optimizing ANSI OUTER JOINs with subqueries
    10.2.0.44702830OERI[kkoljt1] when using star transformation with an ANSI outer join
    10.2.0.44901291Wrong results with left outer joins on view with a function
    10.2.0.45188321wrong results (no rows) from ANSI outer join
    10.2.0.45590396Dump or Wrong Results with ANSI JOINS and CONNECT BY
    10.2.0.45652086OERI[15160] from ANSI join
    10.2.0.45765958OERI[qcscpqbTxt] / OERI[qcsfbdnp:1] from ANSI query in PLSQL
    10.2.0.45964193OERI[kkqsRewriteCorrCols-1] during query rewrite with ANSI joins
    10.2.0.45988085Dump [kkodsel] from STAR transformation with ANSI view
    10.2.0.46033480High parse time of query when using ANSI style joins
    10.2.0.34433936ORA-907 from FULL / LEFT OUTER joins
    10.2.0.34582764Wrong results from ANSI OUTER join with inline view
    10.2.0.34615392Join elimination not working with ANSI join syntax
    10.2.0.34625102Wrong results using ANSI join when NL join is performed
    10.2.0.34932843Wrong results from full outer join with TABLE() function
    10.2.0.35005052OERI:voprsla1 from ANSI query with TABLE() and domain index
    10.2.0.24308414Join predicate push may not occur for UNION [ALL] views
    10.2.0.24369235ANSI 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 ReleaseBug NumberDescription
    10.2.0.45386204Block corruption / OERI[kddummy_blkchk] after direct load of ASSM segment
    10.2.0.45530583ASSM managed INDEX updates can be slow compared to non-ASSM
    10.2.0.45557421Self-deadlock (ORA-60) on FB enqueue if session killed during INSERT in ASSM
    10.2.0.45637976ORA-8103/ORA-1410 from concurrent INSERT / export on ASSM tables
    10.2.0.45695131HW enqueue deadlock / OERI:1153 from array insert with SAVE EXCEPTIONS to READ ONLY ASSM segment
    10.2.0.45728380DML may spin under ktspffc searching for space in ASSM segment
    10.2.0.46086497OERI[ktspgetmyb-1] / bitmap segment corruption for ASSM segments
    10.2.0.46376915HW enqueue contention for ASSM LOB segments
    10.2.0.33610777Excessive CPU from INDEX insert into ASSM index segment
    10.2.0.34055634TRUNCATE table has to much overhead when operating on empty segments
    10.2.0.34188324Wasted space possible in ASSM segments
    10.2.0.34475314DELETE then INSERT without commit on ASSM segment can be slow
    10.2.0.34660718Allow choice between space / performance for ASSM segments
    10.2.0.34694312Index inserts to ASSM segments can be slow
    10.2.0.34887955Unnecessary extent allocated in locally managed ASSM tablespace in RAC
    10.2.0.35034679Hang / errors making ASSM tablespace read only with concurrent DML
    10.2.0.35349632Poor performance for ASSM insert after large DELETE
    10.2.0.24288876Excessive redo / undo generation from insert/update with ASSM indexes
    10.2.0.24486753DMLS contention with ASSM segments
    10.2.0.24517470Table 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 ReleaseBug NumberDescription
    10.2.0.44395849ESM tool hangs connecting to directory server on SSL port
    10.2.0.45079968SSL auth client connections create erroneous trace files in udump
    10.2.0.45527753ESM errors and does not show global role, which is added by ESM cmdline
    10.2.0.45584798Unnecessary trace files using EUS with LDAP_DIRECTORY_PASSWORD='PASSWORD'
    10.2.0.46005762SYS_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 ReleaseBug NumberDescription
    10.2.0.44478139ORA-28031 "maximum of 148 enabled roles" when creating queue table
    10.2.0.44618808AQ operation requiring exclusive lib cache lock may hang
    10.2.0.44715375OERI[kwqmtdel] in q00 process in RAC when any instance goes down
    10.2.0.44719848Streams DELETE_ERROR does not maintain AQ$_QTABLE_I
    10.2.0.44733582Upgrade to 10.2 deletes statistics on AQ tables
    10.2.0.44745691OERI[kghufree_06] from AQ propogation of XML payload
    10.2.0.45018886OERI:[kwqitnmptme:wait] in Qnnn during propagation of delayed messages
    10.2.0.45092843Dump (kpceclose) in EMON
    10.2.0.45095889PGA leak during propagation in "kwqpcbk:koioalm" and "kwqpcbk:csid"
    10.2.0.45225596AQ propogation does not work after failover
    10.2.0.45358598EMN0 not posted for ha notification
    10.2.0.45408664Messages not marked as undeliverable after transformation failure
    10.2.0.45415506ORA-4020 when dbms_aqadm.purge_queue_table and select are run
    10.2.0.45439588Notifications not delivered when client machine has multiple NICs
    10.2.0.45452715OERI[kwqbgqc: bad state] reported after restart of database
    10.2.0.45494866PLS-302 'dbver_10i' importing 10g export into 9i with AQ
    10.2.0.45506702Dequeue delay experienced after reconfiguration
    10.2.0.45523578DBMS_AQADM.add_subscriber fails with ORA-1925 "maximum of x roles exceeded"
    10.2.0.45526245"ksxplookup: warning cnh incarnation number" messages in QMNC trace
    10.2.0.45545530EMON may spin in kpcopen
    10.2.0.45561130Performance of long running transaction using AQ degrades over time
    10.2.0.45580871AQ bytes message <= 2000 bytes incompatible between PLSQL and Java
    10.2.0.45590163Message dequeued more than once from single consumer queue
    10.2.0.45594352JMS-120 / OCI-1858 when dequeueing AQ bytes message with JDBC-OCI
    10.2.0.45605319Cursor leak from QMON coordinator exceptions
    10.2.0.45608198Memory leak by advanced queuing XML transformation
    10.2.0.45648610ORA-25235 during AQ propagation
    10.2.0.45654680JMS worker thread does not end if exception thrown in onMessage() method
    10.2.0.45655612AQ$_PENDING_MESSAGES table can grow indefinitely
    10.2.0.45666374FIFO does not occur when multiple listens are followed by dequeues
    10.2.0.45717536Dequeue can suffer from a memory leak
    10.2.0.45725109Hang if AQ listener onMessage() method raises an error
    10.2.0.45734276Queue slave process may spin in kwqitptm
    10.2.0.45751016AQ messages enqueued at non-owner instance not moved from WAIT to READY
    10.2.0.45758963UGA memory leak possible from AQ dequeue
    10.2.0.45852253ORA-25316 from AQ after rollback to savepoint with loopback database link
    10.2.0.45857313OERI[kwqbmcrcpts101] after drop propagation
    10.2.0.45941601TM deadlock from concurrent dbms_aqadm_sys.alter_subscriber()
    10.2.0.45955596DBMS_AQ.LISTEN hangs after datapump has executed
    10.2.0.45962680Dump[kwqicgsubname1] on an AQ enqueue call
    10.2.0.46001290Node down events not posted in AQ when node leaves the cluster
    10.2.0.46016707OERI[kwqpuspse0-hwmack] from propogation
    10.2.0.46044513Cannot dequeue a message with a correlation padded with spaces
    10.2.0.46049324Memory leak from array dequeue
    10.2.0.46057422ORA-25228 occurs every 30 seconds in racgimon session trace file
    10.2.0.46065604DBMS_AQ.DEQUEUE_ARRAY PGA memory leak
    10.2.0.46143688node startups cAN spend up to 2 mins in AQ partition code
    10.2.0.46154655QMON fails to update queue table affinity for several minutes after failover
    10.2.0.34515626AQ enqueue option visibility=DBMS_AQ.IMMEDIATE does not work for ENQUEUE_ARRAY
    10.2.0.34527173AQ$_JMS_TEXT_MESSAGE.SET_TEXT method does not work correctly with multi-byte character sets
    10.2.0.34543871High CPU use by Qxxx proceses when using RETENTION
    10.2.0.34640637OERI[kwqidorefetch:err][3135] from AQ
    10.2.0.34730389ORA-30757 on propagation from 10.2 -> 8i
    10.2.0.34752021Dump (kpoaqeqopp) on AQ propagation from 8i to 10.2
    10.2.0.34756409High latency in AQ OCI notifications
    10.2.0.35001358Dump (kwqppay2aqe) on propagation of a transformed message
    10.2.0.35178202RAC AQ dequeue on different instance to enqueue is slow
    10.2.0.24375798ORA-60 deadlock from AQ enqueue
    10.2.0.24425689AQ message state may not be set to READY in RAC
    10.2.0.24519477AQ dequeue by correlation id is extremely expensive
    10.2.0.24585640AQ 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 ReleaseBug NumberDescription
    10.2.0.44436832False ORA-979 "not a group by expression" with literal replacement
    10.2.0.44587572ORA-12801/ORA-60 possible from parallel DML with grouping sets
    10.2.0.44597871ORA-904 from query using CUBE
    10.2.0.45162852Dump from FIRST / LAST aggregations on a NULL table
    10.2.0.45196061Dump in evaopn2() from WITH query using WINDOW functions
    10.2.0.45216642Dump from SQL using window functions
    10.2.0.45286826Wrong results from complex view merge with windowing
    10.2.0.45302124Join Predicates are not push inside window functions -- superceded fix
    10.2.0.45641873ORA-904 using a WITH clause that includes a UNION
    10.2.0.45670585OERI [kxfxsSendCounter1] / OERI [15574] / spin from WINDOW query
    10.2.0.45847881ORA-3001 from GROUPING SET query against a view containing a function
    10.2.0.45906937Wrong result using ROW_NUMBER in SQL using a WITH query block
    10.2.0.45942097OERI:qernsRowP from SQL with GROUP BY , ROLLUP and DISTINCT aggregates
    10.2.0.46012053OERI [qctcte1] from GROUPING SETs query
    10.2.0.46026281OERI[qeshCloseHTI.2] from spreadsheet query
    10.2.0.46051782Wrong results using GROUPING SETS with ORDER BY and DISTINCT
    10.2.0.35055892Wrong results from NVL with analytic function in HAVING clause
    10.2.0.24402808Parallel refresh of MVIEW with GROUPING SETS can give bad MVIEW data
    10.2.0.24551356Dump (evagrp) using GROUPING functions
    10.2.0.24573980Dump 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 ReleaseBug NumberDescription
    10.2.0.44902585OERI[510] and ORA-28106 using application context over 30 bytes long
    10.2.0.46005762SYS_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 ReleaseBug NumberDescription
    10.2.0.45702177Instance 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 ReleaseBug NumberDescription
    10.2.0.45526987 *ASM instance hang / OERI [2103] on DB instance. This bug is alerted in Note:468572.1
    10.2.0.45081798 +Additional diagnostics for OERI[2103] when ASM involved
    10.2.0.46051728 P*HPUX Itanium: Cannot use ASM (ORA-15059). This bug is alerted in Note:434500.1
    10.2.0.44110313ASM disk resize fails for OS devices grown after ASM instance startup
    10.2.0.44319031Wrong header_status in V$ASM_DISK when disk is offline
    10.2.0.44380450Unbalanced space usage if diskgroup has only two disks, both of different size
    10.2.0.44431215"backup archivelog all delete input" from RMAN removes ASM directory
    10.2.0.44489948ASM hangs during a parallel mount and shutdown in RAC
    10.2.0.44767278OERI[kcrrupirfs.20] archiving redo to standby with ASM
    10.2.0.45230765LGWR spins while waiting for 'log file parallel write' using ASM
    10.2.0.45471453OERI[kfkfilrqarr01] using ASM
    10.2.0.45472917DBVERIFY may error if ASM disk disconnected
    10.2.0.45483613OERI [kfgscAcquireLcl_6] in ASM
    10.2.0.45502365OERI [kfcDel20] in ASM
    10.2.0.45504989PMON dump [kfgGlobalClose] / instance crash
    10.2.0.45554692Error ORA-15196 reporting ASM block header invalid ora-15196 after ORA-600[kfcgetbuffer10]
    10.2.0.45555908OERI[kghstack_underflow_internal_2] in kfrcsoDelete
    10.2.0.45556674V$ASM* dynamic views leak cursors (ORA-01000)
    10.2.0.45575584Failure of an entire failure group is detected one disk at a time
    10.2.0.45576584Poor ASM parallel read performance
    10.2.0.45682184OERI[kfdAuDealloc2] from resize/drop more than 16TB ASM file
    10.2.0.45743325ASM instance fails with OERI[kfaDropCOP04]
    10.2.0.45757711ORA-15080 during file creation / resize on ASM with HARD
    10.2.0.45757752OERI:kghstack_alloc / OERI:kfcbCkpt04 / ASM crash
    10.2.0.45761185ORA-15041 diskgroup space exhausted after adding disks to a diskgroup
    10.2.0.45891737Dump (kcblsod) / OERI:723 / Memory leak in ASM/RAC
    10.2.0.45893614Full table scan very slow on ASM
    10.2.0.45899033SMON dump (kfrCheckCtx) diskgroup instance recovery
    10.2.0.45909894ASM datafile lost after rename (ORA-1157)
    10.2.0.45922733ASM dump in kfkdumprq with event=15199 level=1050631
    10.2.0.45939241Inconsistent diskgroup configuration after rejected DISK OFFLINE
    10.2.0.46013983ASM signals OERI [kfdasecondaries01] / [kffrelocate87] during rebalance
    10.2.0.46069360DBW can spin in kfcRunnableWaiter holding a latch in ASM
    10.2.0.46139547Shadow process leak on ASM instance when diskspace exhausted (ORA-20)
    10.2.0.46334552Hang / ORA-4031 / OERI:kfrcsoDelete_3 on rollback of ASM file resize
    10.2.0.46453944ORA-15196 with ASM disks larger than 2TB using ASMLIB
    10.2.0.33811904Rebalance can fail if there is one full disk
    10.2.0.33885499ASM hang possible
    10.2.0.34229751CONVERT TABLESPACE fails to create file with DB_FILE_NAME_CONVERT on ASM
    10.2.0.34450268ASM disk mounts are serialized
    10.2.0.34466433Restoring current controlfile on ASM creates a file with "backup" string
    10.2.0.34561867ASMB may exit prematurely causing OERI in client
    10.2.0.34671721OERI [kfcInitDlocn02] possible in ASM instance
    10.2.0.34691191Failure during file grow may leak ASM disk space
    10.2.0.34709210ASM LMS OERI[504] on [kfcl le freelist] latch
    10.2.0.34709214ASM may crash with OERI[kfclGetLock40]
    10.2.0.34752481Skewed ASM disk allocation when single file resized many times
    10.2.0.34865736ASM resource should not have dependency on VIP
    10.2.0.34872617Dump (kfclDumpLe) in ASM
    10.2.0.34883032ASM fails with ORA-15096 during crash or instance recovery
    10.2.0.34886660ASMB can fail with OERI:kffmAllocate_1
    10.2.0.34907496Processes hang after adding disk back to ASM diskgroup using force option
    10.2.0.34943406LMON needs to message SMON to start recovery in ASM instance
    10.2.0.34960705ASM waits longer than necessary during reconfiguration
    10.2.0.34966352OERI[unsorted_pins_4] possible on ASM
    10.2.0.34967266DB recovery blocked by ASM recovery
    10.2.0.35012099ASM rebalance problems
    10.2.0.35024639ASM hangs if private interface down on a surviving node
    10.2.0.35039964ASM disks show as provisioned although kfed shows valid disk header
    10.2.0.35089630Dump (kfncInitSlavePool) / ORA-15012 from Log Miner / Streams against LOGs on ASM
    10.2.0.35090822OERI[17092] / ORA-10382 when ASM IO completes concurrently with DISKGROUP dismount
    10.2.0.35134663OERI[2103] with ASM
    10.2.0.35226903OERI:[kfcDeadlockAvoid01] when running "check all repair"
    10.2.0.35360719ASM and database instances hang when disk array gets disconnected
    10.2.0.35515492Data corruption when ASM failgroup removed
    10.2.0.24747535 *A diskgroup cannot be mounted on both nodes at the same time. This bug is alerted in Note:353065.1
    10.2.0.24237629OERI[kfdjoin5] on ASM instance with multiple diskgroups
    10.2.0.24362919CRS ASM failure recovery does not recover database instances
    10.2.0.24413010OERI[kffdmove01] selecting from V$ASM_ALIAS in ASM instance
    10.2.0.24455512ASM instance startup can be slow in RAC environments
    10.2.0.24478323OERI[kfcDeadlockAvoid01] on SQL against V$ASM_ALIAS
    10.2.0.24490933RMAN backup fails when backupsize > free on ASM but reclaimable space available
    10.2.0.24503419Cannot drop disk normal with less than 3 failgroups
    10.2.0.24550821OERI[kfklufsscannext] in ASM during disk discovery
    10.2.0.24666938OERI[kjbdowncvt:__l] can occur in ASM
    10.2.0.24671216ASM operations on a file are blocked while it is resized
    10.2.0.24693247Dump (kfcgetbuffer) while resizing a tablespace using ASM storage
    10.2.0.24700681ASM disk shrinkage can corrupt ASM metadata
    10.2.0.24772979OERI[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 ReleaseBug NumberDescription
    10.2.0.44596807OERI[6002] on update statement with concurrent ONLINE rebuild of bitmap indexes
    10.2.0.44697632OERI[atbbjie2] from exchange partition with bitmap join indexes
    10.2.0.45063279OERI[kdibllockrange:not validated] updating a partitioned bitmap index
    10.2.0.45113934PQ slave dump in qerixGetKey() when using bitmap index access
    10.2.0.45262017Query on partitioned table with bitmap index gives OERI[qernsRowP]
    10.2.0.45331374OERI [kdiblsorget:rowidIllegal] updating partitioned table with row migration
    10.2.0.45401876wrong results when optimizer uses 'bitmap conversion'
    10.2.0.45449488Suboptimal plan for SQL with negated predicates (BITMAP MINUS)
    10.2.0.45667683Parse of query can spin in kkosbn
    10.2.0.45960268Dump (kkoiodoi) when FIRST_K_ROWS considers bitmap index
    10.2.0.34475125Wrong results with join of FULL INDEX SCAN (MIN/MAX) with bitmap index
    10.2.0.34533389ANALYZE INDEX VALIDATE STRUCTURE does not update INDEX_STATS for bitmap indexes
    10.2.0.34615091Wrong result using bitmap index on partition table with INLIST
    10.2.0.35015557Dump under kkoNewExtractedBMKey or qerixGetKey with bitmap plan and function based index
    10.2.0.35078743Dump (in qkabxo) using bitmap access path in FIRST K ROWS
    10.2.0.24274669Bitmap index may be corrupted during REBUILD
    10.2.0.24421063Exchange partition fails with ORA-14098 with 2 or more bitmap join indexes
    10.2.0.24554846DBMS_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 ReleaseBug NumberDescription
    10.2.0.45165904Materialized View DDL may execute when it should wait
    10.2.0.45252389CDC apply changes lead to maximum open cursors exceeded (ORA-1000)
    10.2.0.45533982Updated columns set to null show old not-null values in change table using async CDC
    10.2.0.45693948ORA-31466 error when setting up CDC with table names using multibyte characters
    10.2.0.45881493CDC ordered sequence causes large performance degradation on RAC
    10.2.0.46064864Archives containing DDL for not replicated objects take longer to process
    10.2.0.46314151'1/1/1988 0:0:0' in COMMIT_TIMESTAMP$ column when CDC apply error is re-executed
    10.2.0.34380175Orphaned segment left by DBMS_CDC_PUBLISH.PURGE
    10.2.0.35024710CDC 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 ReleaseBug NumberDescription
    10.2.0.46001843 Pcluvfy error during CRS post installation check
    10.2.0.45667023 P+Linux: CRS does not start after applying 10.2.0.3
    10.2.0.45495242 PIHPUX: CRS may not install
    10.2.0.45845104 PIWin64: 10.2.0.3 OPMD.EXE does not work
    10.2.0.43602716EVMD unable to detect EOF while reading configuration file
    10.2.0.44440013CRS startup of RAC fails when FSFO enabled
    10.2.0.44566428cluvfy displays duplicate names in the output
    10.2.0.44574574crs_start opens a physical standby database as opposed to mounting the instances
    10.2.0.44587300Improve CRS shutdown sequence
    10.2.0.44598992"Action script for resource 'ora.xxx.vip' stdout redirection" errors in crsd.log
    10.2.0.44692561cluvfy reports a failure if ssh banned enabled
    10.2.0.44882822Service failover blocked on VIP
    10.2.0.44906820EVMD deadlocks on disconnect
    10.2.0.44930431Failure of 1 CSSD can hang starting CSSD on other nodes
    10.2.0.44951464CRS shutdown stops and then restarts EVMD
    10.2.0.44996577CVU does not recognise long device names
    10.2.0.45003881Value of restart_attempts wrong after DB policy is changed
    10.2.0.45014134Improved diagnostics for oclsomon (do not overwrite log file)
    10.2.0.45093126FCF does not respond to SRV_PRECONNECT events
    10.2.0.45101517VIP does not failover with auto_start=2
    10.2.0.45125957Cannot start CRS after CRS ugprade
    10.2.0.45129769CLUVFY check subsystems which are not configured
    10.2.0.45131219CSS shuts down the node when disk IO is suspended momentarily
    10.2.0.45137401oprocd logfile is cleared after a reboot
    10.2.0.45168043VIPCA silent mode cannot handle upper case characters in hostnames
    10.2.0.45169752SRVM OCR keys not security consistent with respective CRS resources
    10.2.0.45184535PRKR-1008 from SVTCTL ADD INSTANCE / DBCA
    10.2.0.45188493crsd.bin can use excess CPU on reboot
    10.2.0.45192194CSS does not start on one of the nodes ("takeover aborted due to unknown nodes")
    10.2.0.45207138Add support for 'toc' for reboot in HPUX
    10.2.0.45220760Dump in NetLocalGroupGetMembers
    10.2.0.45236370OCR cache invalidation error with delete key operation
    10.2.0.45274513VIP,ONS,GSD check fails in cluvfy when nodename is in capital letters
    10.2.0.45278777CRSD version is 10.2.0.1 after applying 10.2.0.2 patchset
    10.2.0.45297925Disabling one instance disables restart of all the instances in the node
    10.2.0.45303454Better diagnostics when CSS voting disk IO hangs but later resumes
    10.2.0.45334170racgevtf can dump in lmmstfree
    10.2.0.45334661ocssd.log refers to non-existing node 0
    10.2.0.45336797EVMD and CSSD core files are overwritten
    10.2.0.45338035PRKR-1008 using DBCA to create RAC instance
    10.2.0.45348062A 500 ms delay can occur until CSS starts reconfiguration after vendor CM reconfiguration
    10.2.0.45365683CRS repeatedly stops and restarts VIPs while recovering multiple nodes
    10.2.0.45377165Dump from crsctl when invalid parameters are passed
    10.2.0.45388818cluvfy should not use remote shell for local node
    10.2.0.45437462CSS does not monitor vendor clusterware network
    10.2.0.45442229VIP does not failover when public LAN disconnected pulled (crsd communicating on public LAN)
    10.2.0.45442867Deadlock can occur by terminating multiple CSS clients
    10.2.0.45446160RLB information cannot be forwarded
    10.2.0.45448707Better tolerance of CRS init scripts to low system resource conditions
    10.2.0.45451987CSSD could run as root if oracle_user not set
    10.2.0.45454307CLWS OCSSD dump during startup
    10.2.0.45454388OPROCD dumps with fix for bug 5015469
    10.2.0.45458333racgimon should do more checking for connections
    10.2.0.45461281Reconfiguration delayed due to diskping seen after reboot was issued
    10.2.0.45467456Directory $ORA_CRS_HOME/crs/auth was unexpectedly removed
    10.2.0.45479767CLWS instance going down not noticed for 10 min
    10.2.0.45487604CRSD core dump
    10.2.0.45488977scls_process_spawn provides insuficient diagnostics on execve() failure
    10.2.0.45503111racgimon startd <dbname> uses a lot of CPU
    10.2.0.45507883CRS install fails in CRS root.sh due to node panics
    10.2.0.45513471cluvfy needs easy to parse output for each nodes status
    10.2.0.45529659OCSSD fails to join the cluster
    10.2.0.45533311crsctl debug log res:<name> does not check name
    10.2.0.45549682High CPU usage by srvctl
    10.2.0.45553318CRSD dump before node rebooted when killed CSSD in CRSD master
    10.2.0.45556681OCR does not correctly compare OCR configurations
    10.2.0.45568399CRS upgrade can corrupt OCR
    10.2.0.45601369OCSSD dump in clssgmmbrdatacmpl()
    10.2.0.45623137CSS time out during reconfiguration (timeout in clssgmMasterCMSync)
    10.2.0.45629557CRS does not receive reconfig from CSS on SAN failure
    10.2.0.45651085Session disconnection blocks service resource stop action
    10.2.0.45664042diagcollection.pl requires ORA_CRS_HOME environment variable
    10.2.0.45668854CRSD may dump if resource unregistered/re-registered as it starts
    10.2.0.45679560Unexpected node reboot on death of "init.cssd fatal"
    10.2.0.45690258Default VIP check_interval should be less than 60 seconds
    10.2.0.45698321Wrong return code from srvctl from failed "modify nodeapps" operation
    10.2.0.45709121CRS startup can hang
    10.2.0.45734797CSSD abort possible from concurrent startup
    10.2.0.45735507Dump in procr_open_key
    10.2.0.45735768killed ocssd.bin on a node causes other nodes's crsd restart
    10.2.0.45736843WaitOnEvictions can wait too long (another misscount)
    10.2.0.45843485Unnecessary VIP failback trial makes VIP unavailable for 14s on network down
    10.2.0.45852975Shared storage check does not discover shared disks
    10.2.0.45853909CSSD permission problems (skgxninit errors in CSSD log)
    10.2.0.45854172VIPCA fails with exception thread main error
    10.2.0.45855383CRS bundle patch does not apply on some platforms
    10.2.0.45858733cvu checks for exact package versions
    10.2.0.45861703CSSD failure 139 and node reboot if nfs mounted voting disk is remounted
    10.2.0.45862719init.crsd does not set a high file limit on all platforms (notable Linux)
    10.2.0.45893629crsd dumps after being unable to delete backup OCR file
    10.2.0.45901176Memory corruption in CLSC async connect handling
    10.2.0.45901254Starting node cannot join the cluster
    10.2.0.45903964EVMD does not shut down when OCR is corrupted
    10.2.0.45911174Hang in CLSC in nsevwait
    10.2.0.45911855Split brain resolution can fail
    10.2.0.45929527racgimon dump in clsrcwrft() during instance startup
    10.2.0.45929833OCR cannot determine the latest update
    10.2.0.45932861VIP does not switch over when CRS is stopped
    10.2.0.45938788False split brain
    10.2.0.45949311False split brain result
    10.2.0.45974219Cluster hang when node dies during reconfig
    10.2.0.46001290Node down events not posted in AQ when node leaves the cluster
    10.2.0.46005526CSS will not shutdown evmd.bin with fix for bug 5442229
    10.2.0.46022204oprocd enhanced error reporting mechanisms
    10.2.0.46029676OPEN/CLOSED messages from userid 0 after CRS shutdown
    10.2.0.46051925racgimon dump under slzgetevar -> getenv
    10.2.0.46054978Locked resources are not recovered by CRSD even once they are unlocked
    10.2.0.46057422ORA-25228 occurs every 30 seconds in racgimon session trace file
    10.2.0.46087596OCR can hang
    10.2.0.46114137Running LMS in real-time can cause CSS crash and node reboot
    10.2.0.46117687CRS slow memory leak from repeated "crsctl check crs"
    10.2.0.46134126OCR backup can fail
    10.2.0.34707711 PSolaris: 'cluvfy' fails on Solaris (Sparc-64bit)
    10.2.0.35022314 PCRS has wrong LD_LIBRARY_PATH on Solaris X86-64
    10.2.0.34127644CSS not set in high/fixed priority class using CRSCTL SET CSS PRIORITY
    10.2.0.34230367nodedown event slow to appear after public network failure
    10.2.0.34437727VIPCA fails complaining that interface is not public
    10.2.0.34459961"crsctl debug log css COMMCRS / COMMNS" commands fail
    10.2.0.34493093PRKH-1001 from "srvctl add nodeapps"
    10.2.0.34556878CRSD may dump at cls_thrmxunlock()
    10.2.0.34667776clscfg -downgrade fails
    10.2.0.34669874RLB event delivery stops after instance restart
    10.2.0.34689845OPROCD log is not set up in RUN mode
    10.2.0.34702263CRSD failure is not handled in the init script
    10.2.0.34716107CVU fails if central inventory contains a deinstalled CRS home
    10.2.0.34726670Total space of OCR is reported as 0 while executing root102.sh
    10.2.0.34728396DBCA does not change the parameter REQUIRED_RESOURCES for using ASM
    10.2.0.34734413OCR read from local cache blocked by writer working on different key
    10.2.0.34739742CLWS CRSD dump in prou_check_tag<-procr_close_key
    10.2.0.34748946CRSD aborts with OCR errors
    10.2.0.34755275CLWS CRSD aborts: fail to start monitor thread, comm failure
    10.2.0.34756170CRS/OCR delay before CRS recovery starts
    10.2.0.34759984root102 has wrong "rc" directories
    10.2.0.34769197Clients hang if a node goes down
    10.2.0.34772904PRKR-1007 / PROC-5 from srvctl
    10.2.0.34865736ASM resource should not have dependency on VIP
    10.2.0.34870952CLWS racgimon may dump
    10.2.0.34879951CLWS CRSD dump in eventutil::set_context
    10.2.0.34883916stop crs resource may be slow for shutdown abort
    10.2.0.34890793ASM resource depends on VIP even after removing required_resources
    10.2.0.34893560clscselect does not handle timeout = 0 correctly
    10.2.0.34919514CSSD does not fail when vendor clusterware present and skgxnreg fails
    10.2.0.34925962Problem with rootdelete.sbs, rootupgrade.sbs and localconfig.sbs
    10.2.0.34926814CLWS EVMD aborts in reconfiguration
    10.2.0.34936206CSS clients fail when vendor skgxn returns 0 for skgxntpshl
    10.2.0.34936950root and init scripts do not support SunCluster on Solaris X86 properly
    10.2.0.34937400GSD should not attempt to be started on Solaris x86 platforms
    10.2.0.34945458CSS group reconfiguration may not wait long enough to establish connections
    10.2.0.34946339CRS trace level cannot be modified via ocrlog.ini
    10.2.0.34951958CSSD reports graceful shutdown on private network cable pull
    10.2.0.349677611.6s - 2.0s "gap" in CRSD before crs starts recovering resources
    10.2.0.34997470CSS startup terminates when another node comes up during reconfig
    10.2.0.35004962CRS may not be able to relocate a resource when no required resources
    10.2.0.35007623Dump in clssgmfmtdatareqresp causing node reboot
    10.2.0.35011915Split-brain resolution can be slow
    10.2.0.35015469OPROCD reboots node when system date goes backwards
    10.2.0.35037858OPROCD may report no reason for reboot
    10.2.0.35037871Clearer CSSD logging needed giving reasons for reboot
    10.2.0.35052569Wait for 'reboottime' after the kill echo on some platforms
    10.2.0.35071602Need a patch utility / key editor for diagnosis/repair of OCR corruptions
    10.2.0.35077218CSS asserts in clssnmhandlevoteinfo, clssnm.c 2224, node rebooted
    10.2.0.35092622oclsomon uses the wrong timeout value
    10.2.0.35092725crsctl debug does not accept a dash - ( hyphen )
    10.2.0.35136712ocrdump prints out no value for a keys with large value
    10.2.0.35163409"srvctl modify database" fails with PRKH-1014
    10.2.0.35187351Many clscNN.log files created - can affect performance
    10.2.0.35252605CSS reconfig starts before <misscount> seconds have elapsed
    10.2.0.35350302Unexpected node reboot after 'oracle cssd shell script failure'
    10.2.0.24537790 PWindows: After reboot CRS startup can be slow
    10.2.0.24362919CRS ASM failure recovery does not recover database instances
    10.2.0.24372856CRS crashes with overlapped i/o in progress
    10.2.0.24396372Relocate of VIP fails when cable is pulled
    10.2.0.24431939ocrconfig fails to format OCR devices during replace
    10.2.0.24462591CSS cluster reconfiguration slow upon interconnect failure
    10.2.0.24466428CSS does not work properly with NFS voting disk
    10.2.0.24487491CRS will not start when CRS_HOME is on slow mounting file system
    10.2.0.24500688srvctl modify nodeapps -n node -A new_addr looses the existing VIP interface
    10.2.0.24547083Instance added using srvctl not started by CRS during CRS startup
    10.2.0.24556989"racgmain" process may dump in clsrcrpcthr() due to a race condition
    10.2.0.24567879Cloning CRS home fails
    10.2.0.24583298OCR may dump if users primary group id not in /etc/group or NIS
    10.2.0.24591165Voting disk timeout not based on single IO
    10.2.0.24642651CSS does not always resolve split brains when heavy load or long IO times
    10.2.0.24653938Adding a new node may configure VIP on the wrong interface name
    10.2.0.24682514GM may misinterpret communication failure as a node failure
    10.2.0.24698419CRS resources fail without waiting for the full timeout period
    10.2.0.24723614CRS 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 ReleaseBug NumberDescription
    10.2.0.45238255Timezone changed data in CSV format
    10.2.0.45245494Improved control over whether star transformation is performed
    10.2.0.45614566Enh: Allow library cache heaps to be purged manually
    10.2.0.45932060Enh: Add support for direct SQL on partitioned table/index
    10.2.0.45933469ORA-20 does not show in any trace / alert
    10.2.0.45966238Better diagnostics for OERI[kcbgtcr_1]
    10.2.0.46022204oprocd enhanced error reporting mechanisms
    10.2.0.34229751CONVERT TABLESPACE fails to create file with DB_FILE_NAME_CONVERT on ASM
    10.2.0.34323868INDEX hints can lead to INDEX SCAN FULL
    10.2.0.34435036RAC diagnostics can be slow
    10.2.0.34482737FGA does not record binds of type TIMESTAMP in FGA_LOG$
    10.2.0.34669305Enhancement: Add diagnostics for OERI[12333]
    10.2.0.34995640Diagnostics for RAC OERI[kjucll1]
    10.2.0.35037858OPROCD may report no reason for reboot
    10.2.0.35037871Clearer CSSD logging needed giving reasons for reboot
    10.2.0.35071602Need a patch utility / key editor for diagnosis/repair of OCR corruptions
    10.2.0.35117888Collection split rewrite not enabled by default
    10.2.0.24320012Enhancement - 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 ReleaseBug NumberDescription
    10.2.0.44061534OERI[krvtadc] / dump in capture mining redo for COMPRESSed table
    10.2.0.44600946Dump / OERI[kghstack_free1] on array insert to COMPRESSed table
    10.2.0.45496041OERI[6006] / index corruption on compressed index
    10.2.0.45577788Block corruption / OERI:6585 updating row in compressed block
    10.2.0.45599596Block corruption / OERI [kddummy_blkchk] on clustered or compressed tables
    10.2.0.45912350Dump (kdr9ir2f0rst4srp0) on select of compressed table having > 255 columns
    10.2.0.46268371ORA-12996 / ORA-12998 / corruption from ALTER TABLE DROP UNUSED COLUMNS CHECKPOINT
    10.2.0.34378206Direct 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 ReleaseBug NumberDescription
    10.2.0.44545196Corrupt index leaf from cross platform transport of compress-key indexes
    10.2.0.45034323Dictionary corruption when adding a subpartition to a table with a key compressed local index
    10.2.0.24386766IMPDP 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 ReleaseBug NumberDescription
    10.2.0.44580190Bulk insert to partitioned table can insert constraint violating rows
    10.2.0.44618715Dump inserting into a view with OLS policy on tables
    10.2.0.44620832Dump in kzrtppg with multiple referential constraints and OLS policy
    10.2.0.44771851Dump (kxccsrw) from INSERT .. AS SELECT
    10.2.0.45324773Constraints using LTRIM() may fail for valid data
    10.2.0.45462687CHECK constraint can cause wrong results
    10.2.0.45472523Non violated deferred CHECK constraint fails (ORA-2290) at commit
    10.2.0.45504961ORA-2292 slow to be signalled with many child rows
    10.2.0.45579055Dump (kxccres) updating view with instead of trigger
    10.2.0.45766196ORA-942 on schema level import of table with foreign key and XMLSchema
    10.2.0.45923497Select with constraints fails with OERI[12863]
    10.2.0.34742679ORA-604 / ORA-28133 enabling constraints on table with FGA
    10.2.0.35126551Dump (kkdcacr) from query on tables with FK constraint
    10.2.0.24321610IMPDP errors on constraints longer then 4000 bytes
    10.2.0.24629844Dump / 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 ReleaseBug NumberDescription
    10.2.0.35380055 *ORA-1555 / corruption if switch to Standby then back to Primary. This bug is alerted in Note:386830.1
    10.2.0.35212539 +LOB corruption for NOCACHE LOBs (ORA-1555/ORA-22924)
    10.2.0.35032964ORA-19731 whilst recovering plugged in file
    10.2.0.24627646EXP 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 ReleaseBug NumberDescription
    10.2.0.44201573ALTER SYSTEM RESET of an spfile parameter can corrupt the SPFILE
    10.2.0.44344935OERI from DML on TEMPORARY TABLE after autonomous TRUNCATE
    10.2.0.45690593Datafile corrupt for ASM datafiles copied using xdb/ftp
    10.2.0.45892080updateXML corrupts repeating elements
    10.2.0.46086497OERI[ktspgetmyb-1] / bitmap segment corruption for ASSM segments
    10.2.0.46132301OERI[kcb_pre_apply_1] / block corruption can occur
    10.2.0.46453944ORA-15196 with ASM disks larger than 2TB using ASMLIB
    10.2.0.34655520Block corrupted during write not noticed
    10.2.0.35017007MVIEW LOB content incorrect after refresh
    10.2.0.23875098instance stayed up after one node lost connection to voting device
    10.2.0.24275862updateXML() may delete text elements
    10.2.0.24700681ASM 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 ReleaseBug NumberDescription
    10.2.0.45034323Dictionary corruption when adding a subpartition to a table with a key compressed local index
    10.2.0.45632050OERI[kkpolpd12] / dictionary corruption from CONCURRENT partition DDL
    10.2.0.45936058Corrupt metadata from tablespace transport
    10.2.0.46436867Recompilation may skip compilation of some dependent objects (ORA-4068)
    10.2.0.34380175Orphaned segment left by DBMS_CDC_PUBLISH.PURGE
    10.2.0.34748597Moving a LOB in a partitioned table fails to update IND$
    10.2.0.35040222OERI[4823] from drop partition table after merge with update indexes
    10.2.0.24616376Corrupt MVIEW dictionary information from MVIEW on SYNONYM
    10.2.0.24760628Dictionary 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 ReleaseBug NumberDescription
    10.2.0.43569503PQ 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 ReleaseBug NumberDescription
    10.2.0.44545196Corrupt index leaf from cross platform transport of compress-key indexes
    10.2.0.45179313INSERT /*append parallel*/ can corrupt an index
    10.2.0.45181547Index corruption after insert-only merge /*+ append */ into table
    10.2.0.45496041OERI[6006] / index corruption on compressed index
    10.2.0.35380055 *ORA-1555 / corruption if switch to Standby then back to Primary. This bug is alerted in Note:386830.1
    10.2.0.35253271Wrong sort ordering for zeroes
    10.2.0.24570793 *Index corruption from array inserts (ORA-8102/ORA-1499). This bug is alerted in Note:345136.1
    10.2.0.24274669Bitmap index may be corrupted during REBUILD
    10.2.0.24409977Insert 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 ReleaseBug NumberDescription
    10.2.0.45686711 +Wrong cursor may be executed if schemas have objects with same names
    10.2.0.43419260Silent truncation on insert via DB link from single to multibyte charset
    10.2.0.44193047Sequences / synonyms / indexes not created in logical standby database
    10.2.0.44580190Bulk insert to partitioned table can insert constraint violating rows
    10.2.0.44714295It is possible to drop an OLS group which is still in use in an existing label
    10.2.0.44883635MERGE (with delete) can produce wrong results
    10.2.0.44904743ALTER SESSION SET NLS% does not work if OCI_PARSE_ONLY used
    10.2.0.44933222Apply update of clob in multibyte charset double spaces characters
    10.2.0.44959294DBMS_XMLSTORE does not follow CHAR based semantics
    10.2.0.45019803Wrong data inserted for INSERT INTO .. SELECT DISTINCT with DEFAULT values
    10.2.0.45024737Streams LCRs may be filtered when using distributed commit SCN
    10.2.0.45087369logical standby potential data loss during failover
    10.2.0.45104257SQLLoader truncates nested table columns
    10.2.0.45165904Materialized View DDL may execute when it should wait
    10.2.0.45182679INSERT as remote SELECT using CASE can produce wrong data
    10.2.0.45190543Wrong timestamp from oracle.sql.TIMESTAMPLTZ near daylight savings transition
    10.2.0.45256791Trigger "UPDATING('col')" clause can return TRUE when column not updated
    10.2.0.45352587Triggers not working correctly with timestamp datatype
    10.2.0.45436371Image corruption / spin loading multiple nested objects in multibyte
    10.2.0.45515703Streams table diverges after partial rollback on primary
    10.2.0.45554692Error ORA-15196 reporting ASM block header invalid ora-15196 after ORA-600[kfcgetbuffer10]
    10.2.0.45567934NCHAR literal replacement can produce corrupt N literals
    10.2.0.45577788Block corruption / OERI:6585 updating row in compressed block
    10.2.0.45588615Single source streams with DML handler duplicates CLOB column value
    10.2.0.45616820Triggers using :OLD values of TIMESTAMP columns see :NEW values instead
    10.2.0.45621677Logical corruption with parallel update on compressed partition
    10.2.0.45685411Updating columns to NULL in a trigger may have no effect
    10.2.0.45872835Multiple trigger execution from SERIAL insert as Parallel select
    10.2.0.45873852sqlldr inserts character data longer than the column length (CHAR length semantics)
    10.2.0.45874989Datapump import can load data longer than column definition
    10.2.0.45936058Corrupt metadata from tablespace transport
    10.2.0.46038412OCI7 clients using "CALL" SQL may execute wrong shared cursor
    10.2.0.35458753 *SQL may execute in wrong schema. This bug is alerted in Note:392673.1
    10.2.0.34335615ORA-1403 / data corruption in logical standby
    10.2.0.34378206Direct load of compressed table can load duplicate rows
    10.2.0.34627859IOT corruption possible when OVERFLOW columsn exist
    10.2.0.34711857Exp/Imp of table with LONG swaps COMMENTS metadata
    10.2.0.34717280NULL may be inserted by INSERT with a TRIGGER for NUMBER columns
    10.2.0.34771052INSTEAD-OF trigger does not update tables correctly over dblink
    10.2.0.34775068Deferred transactions not applied in the correct order when using parallel propagation
    10.2.0.34952018OCI direct path API allows invalid data for NUMBER(p,s) fields
    10.2.0.34955701Incorrect data possible from INSERT .. VALUES with correlated subquery
    10.2.0.34963106SQLLDR SKIP skips wrong number of records
    10.2.0.35049941Direct path merge records incorrect information in ALL_SUMDELTA
    10.2.0.35223223Wrong results / bad MV content after direct load
    10.2.0.24496211Wrong results after fast refresh of a partitioned materialized view
    10.2.0.24515623Update .. RETURNING with a trigger can produce corrupt column data
    10.2.0.24547458INSERT 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 ReleaseBug NumberDescription
    10.2.0.46646613 *IOT corruption after upgrade from <= 9.2 to >= 10g. This bug is alerted in Note:471479.1
    10.2.0.44450606 +LOB corruption / ORA-600 [ktsbvmap1] when updating a LOB
    10.2.0.45363584 +Array insert into partitioned table can corrupt redo
    10.2.0.44592596Corruption (ORA-1410) from multi-table insert with direct load
    10.2.0.44899479Undo/redo corruption if distributed transactions used
    10.2.0.45386204Block corruption / OERI[kddummy_blkchk] after direct load of ASSM segment
    10.2.0.45599596Block corruption / OERI [kddummy_blkchk] on clustered or compressed tables
    10.2.0.45609096MERGE / UPDATE to IOT can cause corruption
    10.2.0.45636728LOB corruption / ORA-1555 when reading LOBs after a SHRINK operation
    10.2.0.45909894ASM datafile lost after rename (ORA-1157)
    10.2.0.45941030Datapump import can produce corrupt blocks when there is a LONG / LONG RAW
    10.2.0.46268371ORA-12996 / ORA-12998 / corruption from ALTER TABLE DROP UNUSED COLUMNS CHECKPOINT
    10.2.0.35061091 +Block recovery corrupts undo header when log_parallelism > 1
    10.2.0.35212539 +LOB corruption for NOCACHE LOBs (ORA-1555/ORA-22924)
    10.2.0.34411228Block corruption with mixture of file system and RAW files
    10.2.0.34637668IMU transactions can produce out-of-order redo (OERI [3020] on recovery)
    10.2.0.35515492Data corruption when ASM failgroup removed
    10.2.0.24597251 +OERI / buffer cache corruption / crash from concurrent index block reclaimation
    10.2.0.24517470Table corruption with RAC when ASSM managed and truncate used
    10.2.0.24602031Block corruption from UPDATE or MERGE into compressed table
    10.2.0.24684074OERI: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 ReleaseBug NumberDescription
    10.2.0.45031712DBV reports blocks "soft corrupted" blocks as bad
    10.2.0.45472917DBVERIFY 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 ReleaseBug NumberDescription
    10.2.0.34728396DBCA 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 ReleaseBug NumberDescription
    10.2.0.43419260Silent truncation on insert via DB link from single to multibyte charset
    10.2.0.44311273ORA-2064 using MERGE statement over a database link
    10.2.0.44351422Dump from CREATE TABLE AS SELECT (CTAS) over DB link
    10.2.0.44373687SET_SCHEMA_INSTANTIATION_SCN does not error if database link unavailable
    10.2.0.44490782Unparse operations give wrong date for BC TO_DATE literals
    10.2.0.44491223Dump selecting ROWID with a remote join
    10.2.0.44581334Cursors accessing remote tables may be repeatedly rebuilt and not used
    10.2.0.44624183ORA-1017 reported using DB links with IDENTIFIED EXTERNALLY accounts
    10.2.0.44648039PLSQL hangs with database links and autonomous_transaction
    10.2.0.44658456ORA-920 from distributed query using CASE against remote table/s
    10.2.0.44701527Cursors not shared when executing procedures over a dblink
    10.2.0.44768022ALTER TABLE can fail with ORA-60
    10.2.0.44865959Wrong results / exception from Java Stored Procedure accessing data over DBLINK
    10.2.0.44889807False ORA-904 from co-located join (over database link)
    10.2.0.44899479Undo/redo corruption if distributed transactions used
    10.2.0.44913460Soft parsing re-occurs for select using database link
    10.2.0.45015321OERI[qerrmObnd1] [932] using binds with some functions over a DBLINK
    10.2.0.45015547Cannot create a materialized view over a database link (ORA-942)
    10.2.0.45024737Streams LCRs may be filtered when using distributed commit SCN
    10.2.0.45128933Dump from DBMS_SQL selecting TIMESTAMP data over a database link
    10.2.0.45182679INSERT as remote SELECT using CASE can produce wrong data
    10.2.0.45216523OERI[16608] from create materialize view on remote table with objects / types
    10.2.0.45223587OERI[4400] from distributed PDML with DDL
    10.2.0.45245451Intermittent ORA-904 referencing remote objects columns
    10.2.0.45246372OERI[opidsii1] accessing remote database accessing 3rd remote database
    10.2.0.45299546ORA-942 from create materialized view with join between local and remote tables
    10.2.0.45327132Wrong results from colocated OUTER join over DBLINK with TO_DATE
    10.2.0.45354469Poor performance of remote fetch with high fetch counts
    10.2.0.45405345OERI[kkofkrMarkK] when running a query using a database link
    10.2.0.45455632Dump accessing tables over a database link
    10.2.0.45467520PLSQL errors accessing synonym to remote object
    10.2.0.45509293Query with subquery across DB link has poor performance
    10.2.0.45852253ORA-25316 from AQ after rollback to savepoint with loopback database link
    10.2.0.46029071Wrong results from distributed SQL with OUTER joins
    10.2.0.46145525Dump selecting > 34 columns from HS (FDS)
    10.2.0.35550824 +Select SYSDATE over a database link increments SYSDATE
    10.2.0.34254094OERI[qerrmObnd1][932] possible for queries over DB links
    10.2.0.34321119ALTER MATERIALIZED VIEW causes ORA-32337 after DML via database link
    10.2.0.34496339RECO dumps in lxsCpStr causing instance crash
    10.2.0.34627237autonomous_transaction with DB link to shared server can self deadlock on DX
    10.2.0.34637725ORA-918 for remote DML
    10.2.0.34703253Wrong results from remote colocated join
    10.2.0.34708037ORA-904, ORA-2063 from query that uses TIME ZONE as a cast
    10.2.0.34771052INSTEAD-OF trigger does not update tables correctly over dblink
    10.2.0.34904454Wrong results from queries using remote colocated joins
    10.2.0.34957217ORA-2019 from REF cursor from procedure that uses a private dblink
    10.2.0.34964703OERI[opixrb-4] [1036] from SELECT over DBLINK with trailing :N or :Q bind names
    10.2.0.34968994Poor plan using SYSDATE in predicate over dblink
    10.2.0.34996080Wrong results from remote join
    10.2.0.35012796DUmp (in kglhdgsc) using distributed transactions
    10.2.0.35037103Dump (qerrmOieb) when selecting view across dblink
    10.2.0.35040303Dump (expepr) from distributed insert into VIEW
    10.2.0.35043975OERI[opixrm-1] [invalid handle] for remote cursor
    10.2.0.35136454Distributed statement using a synonym fails with ORA-904
    10.2.0.24177810ORA-904 with non-column constants in FROM clause with PQ or remote SQL
    10.2.0.24402255Hang / dump possible using database link
    10.2.0.24431181Dump from SELECT if it changes from remote mapped to not
    10.2.0.24456478OERI:[qerrmObnd] from remote mapped queries
    10.2.0.24507302Dump (msqfun) from SQL generation
    10.2.0.24517846Dump 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 ReleaseBug NumberDescription
    10.2.0.34864648DBUA can not upgrade database with dictionary managed temporary tablespace
    10.2.0.24562382 IUpgrade 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 ReleaseBug NumberDescription
    10.2.0.44352110ORA-39125 from expdp/impdp of triggers with nulls in WHEN clause
    10.2.0.44517481ORA-904 / ORA-20000 loading metadata with IMPDP using varying width characterset
    10.2.0.44595736ORA-6502 during impdp due to wrong logging_level put in export dump
    10.2.0.44660745TABLESPACE GROUP clause not generated by DBMS_METADATA.GET_DLL
    10.2.0.44996004EXPDP fails with ORA-31642 when NLS_SORT=binary_ci and NLS_COMP=ansi
    10.2.0.45027003ORA-39068 from EXPDP if parallel > 1
    10.2.0.45071931Datapump import with remap tablespace and schema is very slow
    10.2.0.45095025ORA-4030 (kxs-heap-c,temporary memory) using expdp
    10.2.0.45120780Long text for job gets EXP-85 ORA-6502 on dbms_sched_job_export
    10.2.0.45135951ORA-22337 on import if database schema has been evolved
    10.2.0.45152232EXPDP loses global index parameters for local domain indexes
    10.2.0.45157602Datapump export/import modifies the chains created with dbms_scheduler
    10.2.0.45220845Large packages imported via data pump are not shipped to logical standby
    10.2.0.45292551IMPDP slow when importing a table with initialized column of type varray
    10.2.0.45352426Data pump import dumps (lxinitc)
    10.2.0.45464834ORA-4030 (kxs-heap-c,temporary memory) using EXPDP
    10.2.0.45472417EXPDP on RAC fails with ORA-39014 / ORA-12801 (error signaled in parallel query server)
    10.2.0.45502124ORA-39096 importing 10.1 EXPDP file with 10.2 data pump
    10.2.0.45515882ORA-1427 from EXPDP
    10.2.0.45548895OERI [OCIKCallPush: deprecated] from EXPDP of ANYDATA column
    10.2.0.45550618Dump [nszgclient] from EXPDP
    10.2.0.45576865Dumps in strlen/kpodpmop/kpodpp errors during IMPDP
    10.2.0.45590185Consistent export data pump job (flashback_time) has poor performance
    10.2.0.45620375PLS-103 from datapump import of dbms_scheduler jobs with PLSQL_BLOCK
    10.2.0.45632683EXPDP / IMPDP may error for DDL modified tables
    10.2.0.45680970ORA-39001 when attempting to export partition defined as an object type
    10.2.0.45713912ORA-39125 / ORA-6502 from datapump import via network
    10.2.0.45714205EXPDP / IMPDP do not support long lists for parameters
    10.2.0.45718757ORA-31693 / ORA-6502 during datapump net import
    10.2.0.45857884EXPDP fails with ORA-39125 / ORA-6502
    10.2.0.45874989Datapump import can load data longer than column definition
    10.2.0.45875568IMPDP can error on create table in multibyte with ORA-39125 / ORA-6502
    10.2.0.45910237EXPDP / DBMS_METADATA has wrong syntax for for nested table with row movement enabled
    10.2.0.45941030Datapump import can produce corrupt blocks when there is a LONG / LONG RAW
    10.2.0.45972794EXPDP via network_link with parallel > 1 fails with KUP-4038
    10.2.0.46063940Datapump export / import does not handle tablespace groups
    10.2.0.46080303Datapump export does not unload data until all metadata unloaded with PARALLEL > 1
    10.2.0.46140330imp / impdp cannot create object views with circular dependencies
    10.2.0.46379123EXPDP/IMPDP ORA-39083 due to changes in MERGE privilege between 10.1 and 10.2
    10.2.0.24321610IMPDP errors on constraints longer then 4000 bytes
    10.2.0.24386766IMPDP with compressed indexes fails with ORA-14071 and ORA-39083
    10.2.0.24465417ORA-6502 from EXPDP of multibyte database
    10.2.0.24605877Datapump 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 ReleaseBug NumberDescription
    10.2.0.44531589ORA-22370 when passing sys.anydata containing collection to a method
    10.2.0.45307199OERI:OCIOpaqueDataLoad1 can occur using ODCI with AnyData / AnyDataSet
    10.2.0.45350076Anydata and timestamp can loose precision
    10.2.0.45548895OERI [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 ReleaseBug NumberDescription
    10.2.0.44450606 +LOB corruption / ORA-600 [ktsbvmap1] when updating a LOB
    10.2.0.44559728Select lob from view loops / OERI [17059] if synonym dropped
    10.2.0.44583442ORA-22877 during move hash partition with LOB
    10.2.0.44680009Insert LOB data fails with ORA-3106 or ORA-8176
    10.2.0.44745114OERI[kolrrdl:0rfc] using temporary LOBs in PLSQL
    10.2.0.44865755OERI[9999] during DBMS_LOB operation
    10.2.0.44933222Apply update of clob in multibyte charset double spaces characters
    10.2.0.45051432DBMS_LOB does not execute with the privileges of the calling procedure
    10.2.0.45176017Exp/imp loses "RETENTION" settings of LOB columns
    10.2.0.45196175OERI[kghstack_underflow_internal_1] with supplemental logging for LOBS
    10.2.0.45374820Client side dump on import of table with more than one LOB column into 32k block size
    10.2.0.45396550Spin in ktsplbfmb holding HW enqueue during LOB segment management
    10.2.0.45413989OCIStmtSetPieceInfo() does not work for piece sizes > 16777180
    10.2.0.45442534Dump in kokscold assigning NULL to CLOB
    10.2.0.45447395Shared server tied to session when BFILE used
    10.2.0.45472702ORA-1403 during SQL Apply of redo from table import (redo issue)
    10.2.0.45500044ORA-44203 on table_x_x child from concurrent LOB append and drop partition
    10.2.0.45510345ORA-22282 with LOB buffering enabled
    10.2.0.45549410Inconsistent characters read returned from OCILobRead
    10.2.0.45560256Multi threaded OCI program hang when calling OCILobLocatorAssign
    10.2.0.45588615Single source streams with DML handler duplicates CLOB column value
    10.2.0.45636728LOB corruption / ORA-1555 when reading LOBs after a SHRINK operation
    10.2.0.45644951OERI[rworupo.2] querying outline LOB with ORDER BY clause
    10.2.0.45654094ORA-3106 for SQL with RETURNING clause with indicator binds
    10.2.0.45666733LOB segment does not use free space from freelist in RAC database
    10.2.0.45674184ORA-22282 when using LOB buffering
    10.2.0.45676637OERI[17114] using EMPTY_CLOB() in a trigger
    10.2.0.45682121Multithreaded OCI clients do not mutex properly for LOB operations (ORA-21500 [17099])
    10.2.0.45721994Unexpected errors from non blocking OCI LOB calls
    10.2.0.45723140Temp LOB space not released after commit
    10.2.0.45723260Logminer slow / excess memory use processing batch inserts with LOBs
    10.2.0.45870781DBMS_LOB.INSTR() function does not find patterns across the 4gig boundary
    10.2.0.45926074OERI [12333] on update of more than one CLOB column
    10.2.0.45941355"Split partition" does not move LOB to correct tablespace
    10.2.0.45974207Unexpected ORA-1031 from LOB access - affects NCOMPed PLSQL
    10.2.0.46315913ORA-3106 for SQL using BLOBs after TAF failover
    10.2.0.46376915HW enqueue contention for ASSM LOB segments
    10.2.0.35212539 +LOB corruption for NOCACHE LOBs (ORA-1555/ORA-22924)
    10.2.0.34271217OERI:kpolcsc1 / OERI:12333 from JDBC setCharacterStream() for CLOB data
    10.2.0.34748597Moving a LOB in a partitioned table fails to update IND$
    10.2.0.34867884Lob HW lock contention with space reclaimation
    10.2.0.35011764OERI[ktsircinfo_num1] accessing a LOB
    10.2.0.35017007MVIEW LOB content incorrect after refresh
    10.2.0.35110062Wrong results from INSTR for CLOB for multibyte charactersets
    10.2.0.24278912ORA-24852 if cursor selecting BLOB is rebuilt
    10.2.0.24366667OCILobWrite with OCI_LAST_PIECE can cause OERI:12333 on next DB access.
    10.2.0.24387452ORA-22922 trying to DEREF an object view
    10.2.0.24401000OERI[16608] during import of transportable tablespace
    10.2.0.24431273LOB segment PCTVERSION space reclaimation wrong
    10.2.0.24619452OERI[koklGetLocAndFlag1] during LOB array insert
    10.2.0.24634368Performance 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 ReleaseBug NumberDescription
    10.2.0.44554026Pinning TDO may fail for extensibility types
    10.2.0.44583492Dump possible using ADT columns when table has many columns
    10.2.0.44643723After type evolution extracting attributes gets OERI[17280]
    10.2.0.44691237High "library cache" latch gets from SQL using objects in PLSQL
    10.2.0.44726702ALTER TYPE may dump (koktupd_dplvl) due to a REF dependency
    10.2.0.44895068Dump [kopxccc] during pickling
    10.2.0.45022188Direct SQLLOAD of partitioned object table of non final types fails
    10.2.0.45076729OERI[pmucitnxt] doing type manipulation
    10.2.0.45104257SQLLoader truncates nested table columns
    10.2.0.45135951ORA-22337 on import if database schema has been evolved
    10.2.0.45182299Dump on grant / revoke of privileges on a TYPE
    10.2.0.45192858DROP TABLE with object type column with statistics can dump (kknerd)
    10.2.0.45216523OERI[16608] from create materialize view on remote table with objects / types
    10.2.0.45225836DROP TYPE .. VALIDATE dumps for large partitioned table
    10.2.0.45292551IMPDP slow when importing a table with initialized column of type varray
    10.2.0.45368266ORA-904 using multiple TABLE() objects in the FROM clause
    10.2.0.45436371Image corruption / spin loading multiple nested objects in multibyte
    10.2.0.45520937Cannot upgrade images for dictionary types to 8.1 image format
    10.2.0.45577046ADD or DROP attribute causes UNION query to fail with ORA-1790
    10.2.0.45721821SGA corruption / Dump[kglobcl] / crash if objects dropped / recreated
    10.2.0.45725761Objects with debug privilege are not shown in the ALL_OBJECTS view
    10.2.0.45763434Spin in kokes2q when sorting on VARRAY column over 4k long
    10.2.0.45763538Wrong results / dump with object type column in SQL
    10.2.0.45841624OERI[kokeicadd2] accessing object with embedded substitutable attributes
    10.2.0.45910237EXPDP / DBMS_METADATA has wrong syntax for for nested table with row movement enabled
    10.2.0.46118038OERI[koputilcvto2n] on an ALTER TYPE
    10.2.0.46140330imp / impdp cannot create object views with circular dependencies
    10.2.0.46145841OERI[kologsf2] on COLLECT(..) with wrong datatype
    10.2.0.46150438COLLECT() does not work correctly for ADTs residing in different schemas
    10.2.0.46452485SGA memory corruption / OERI [17182] with fix for bug 6085625
    10.2.0.34242649Object views are slower than they need be
    10.2.0.34308089Dump / OERI on MOVE / SPLIT partition of table with ADT column/s
    10.2.0.34440681Dump from REGEXP_REPLACE referring to table expression
    10.2.0.34451506Wrong results from SQL using TABLE() constructs
    10.2.0.34583177Poor performance inserting subtype constructor into polymorphic column
    10.2.0.34644048Oracle type evolution can fail with ORA-932
    10.2.0.34744859OERI[kkbncre:sq_len3] can occur
    10.2.0.34860003Sqlplus dump / OCI-21500 [koxsihread1]
    10.2.0.34886383Dump possible unpickling images from TABLE() function
    10.2.0.34917666OERI[kcbgcur_9] from type constructor
    10.2.0.34928321Pickle of opaque type results in bad image size
    10.2.0.34932843Wrong results from full outer join with TABLE() function
    10.2.0.34959569OERI[kdic_create_journal_table_1] rebuilding REF index ONLINE
    10.2.0.34990803Dump after type evolution
    10.2.0.34992856Collection view is not merged in DML
    10.2.0.35005052OERI:voprsla1 from ANSI query with TABLE() and domain index
    10.2.0.35068565Wrong results from pipelined table funciton with prefetch enabled (default)
    10.2.0.35084961Dump (qerncRowP) from PQ with nested cursor query
    10.2.0.35130670Wrong results with CURSOR query on complex view with collection objects
    10.2.0.24260205OERI:voprvl1 in query having an outer join and WITH
    10.2.0.24350392Dump (qkexrInitOpn or evapls) with unnested subqueries using object methods
    10.2.0.24387452ORA-22922 trying to DEREF an object view
    10.2.0.24394339"IS OF TYPE" or TREAT operators in SQL can fail with ORA-22950
    10.2.0.24431181Dump from SELECT if it changes from remote mapped to not
    10.2.0.24443625OERI[koklgetlobtid0] using large collections
    10.2.0.24455919Wrong results on query with event 19027 set

    Share This
    Author Image

    About Piyush Prakash

    By at

    No comments:

    Post a Comment

    Subscribe to: Post Comments (Atom)

    Post Top Ad

    Your Ad Spot

    Pages

    About Me

    Effective Oracle Application Database Administrator (on premise and ExaCS) with proven experience in Oracle E-business Suite (11i, 12.1.3, 12.2), Oracle Database(11g, 12c, 19c), Database Security, Oracle Database Performance, VCP Demantra, Solix, Endeca, WebLogic, JDE and Peoplesoft. Currently, designated as Cloud Specialist for Cloud Transformation related to Oracle PaaS for SaaS Clients projects involving Oracle PaaS Services like ADW/ATP, OIC, VBCS, OIC SFTP, OAC, etc. along with SaaS connectivity and DR support. Cloud Deployment Models, IAM, S3, EC2, VPC, SNS, Security Groups, Subnets, VPC Peering, Tags, Amazon Glacier, S3 Bucket Replication, AWS GuardDuty, AWS CLI, Alarm, Auto Scaling, SQS, Snapshots, CRR, Inbound and Outbound Rules, SSH Key Managements, Load Balancer, Health Check of EC2, Versioning, Password Policy, File Systems.

    Send Quick Message

    Name

    Email *

    Message *