Skip Headers

Oracle® Database List of Bugs Fixed
10g Release 1 (10.1.0.4) Patch Set 2
 

 

Copyright © 2001, 2005  Oracle. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Oracle® Database

List of Bugs Fixed

10g Release 1 (10.1.0.4) Patch Set 2

March 2005

This document lists the generic bugs fixed in the Oracle Database 10g release 1 (10.1.0.4) patch set 2. Fixed platform-specific bugs are listed in the Oracle Database Patch Set Notes 10g Release 1 (10.1.0.4) Patch Set 2 for each platform. This document contains the following sections:

Patch Set Documentation

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

Both of these documents are included with the patch set. This document is also available on OracleMetaLink, from document 263719.1, ALERT: Oracle 10g Release 1 (10.1) Support Status and Alerts at:

http://metalink.oracle.com

To locate document 263719.1:

  1. Log on to OracleMetaLink.

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

  3. Enter 263719.1 in the Document ID field and click Submit.

The following sections describe the contents of these documents.

Oracle Database Patch Set Notes, 10g Release 1 (10.1.0.4) Patch Set 2 for Each Platform

This document provides:

Oracle Database List of Bugs Fixed, 10g Release 1 (10.1.0.4) Patch Set 2

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

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 263719.1 for any post-release updates.

The following table describes the symbols and abbreviations used in the bug listings:

Symbol or Abbreviation Description
*
Indicates that the issue has been alerted.
+
Indicates that the issue is particularly notable.
OERI Indicates ORA-600 bugs. For example OERI:729 is an abbreviation of ORA-600 [729].

Symptom

The following tables list bugs in the Symptom category.

Corruption

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

Fixed in Release Bug Number Description
10.1.0.4 3022968 Serializable transaction is not properly isolated
10.1.0.4 3489246 OERI[pitl1] / ORA-1498 ANALYZING table transported from 8.1.7 to 9.2.0
10.1.0.4 3966709 Range/object reuse prematurely (ORA-8103)
10.1.0.4 4026166 Capture process discards MVDD info for renamed tables
10.1.0.4 4053888 ORA-1499 diagnostic trace does not dump REDO for the table block

Corruption (Corrupt Export)

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

Fixed in Release Bug Number Description
10.1.0.4 3579567 Corrupt export exporting a compressed table with direct=y (IMP-9)

Corruption (Dictionary)

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

Fixed in Release Bug Number Description
10.1.0.4 3370649 IOT partitions in bigfile tablespaces do not show in DBA_TAB_PARTITIONS
10.1.0.4 3455402 Concurrent DROP / ALTER TABLESPACE READ ONLY can corrupt the dictionary
10.1.0.4 3608307 OERI[7001] / dictionary corruption from upgrade/downgrade with materialized views
10.1.0.4 3798917 Duplicate DEFAULT_TBS_TYPE in DBA_PROPERTIES after upgrade to 10g
10.1.0.3 3370917 Summary metadata corrupted during REFRESH if MVIEW has inline views

Corruption (Incorrect / Missing Corruption Checks)

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

Fixed in Release Bug Number Description
10.1.0.4 3622875 False ORA-1499 from ANALYZE TABLE VALIDATE STRUCTURE CASCADE ONLINE
10.1.0.4 3853023 False ORA-8103 from EXPDP exporting an ASSM managed IOT
10.1.0.4 4002681 Log apply terminates due to corrupt redo log block header

Corruption (Index)

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

Fixed in Release Bug Number Description
10.1.0.4 2942185 Corruption occurs on direct path load into IOT with ADDED columns

Corruption (Logical)

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

Fixed in Release Bug Number Description
10.1.0.4 3878264 + Output from CTXLC corrupt on some platforms
10.1.0.4 2660473 Export of a renamed table leaves the trigger pointing to the old tablename
10.1.0.4 3111464 Fast refresh gives wrong data after update of filter column from null to value
10.1.0.4 3534299 SQLLDR may load corrupt NUMBER data for invalid ZONED DECIMAL data
10.1.0.4 3571946 DELETE trigger does not fire on delete with index scan
10.1.0.4 3648071 NAN float data can be inserted despite event 10890
10.1.0.4 3676337 Wrong data inserted into column when setxxx() called twice with different types
10.1.0.4 3682068 MV log changes not recorded with complex statement
10.1.0.4 3686945 Long CLOB data not updated correctly with LOB buffering in multibyte DB
10.1.0.4 3687456 OERI[ktspgetmyb-1] / Corrupt LOB if EXTENT size not multiple of LOB CHUNK SIZE
10.1.0.4 3700058 Rollback to a savepoint with a DB link can result in a full rollback
10.1.0.4 3740473 Wrong row deleted when using ROWNUM over a view with an ORDER BY
10.1.0.4 3743437 Corrupt packed decimal data loaded by SQLLDR conventional path
10.1.0.4 3743445 Direct path SQLLDR may load incorrect numbers for PACKED DECIMAL data
10.1.0.4 3823379 Data corruption inserting with 10g JDBC OCI drivers to UTF8 database using batching
10.1.0.4 3823608 Conventional path load may load incorrect scale/precision for numbers
10.1.0.4 3824149 Missing data possible from Insert as SELECT over database link
10.1.0.4 3876715 Cannot set a fractional portion of a TIMESTAMP in an ADT
10.1.0.4 3892672 Data inconsistency replicating between different character sets (Streams)
10.1.0.4 3908083 SQLPLUS COPY truncates long data with gateway connections
10.1.0.4 3913642 OERI[knlqdqm2usr:4] / incorrect data at Logical Standby
10.1.0.4 3917532 AnyData objects with length 232/233 may become corrupt - affects Streams
10.1.0.4 3918257 Streams capture misses out of line clob data with 9.2 compatibility
10.1.0.4 3960844 Switch to logical standby may not see active PLSQL changes (data missing)
10.1.0.4 4025276 Bind corruption with Thin driver binding NULL OracleTypes.FIXED_CHAR
10.1.0.3 3376786 * Concurrent LOB updates lost - can cause inconsistent Text Query results . This bug is alerted in Note:263548.1
10.1.0.3 2928563 Using large collections with EXTPROC can return 0 size collection
10.1.0.3 3128021 Corrupt column data after EXCHANGE PARTITION with row dependencies
10.1.0.3 3265740 Corrupt column data after PARTITION maintenence with ROWDEPENDENCIES
10.1.0.3 3313274 Direct path load of LOBs can cause data loss/truncation in streams
10.1.0.3 3361118 OERI:[7999] / LOB corruption updating a LOB in a SERIALIZABLE transaction
10.1.0.3 3365045 Functional index on DATE column can depend on NLS_DATE_FORMAT (ORA-8102 on DML)
10.1.0.3 3370235 Corrupt data possible in logical standby
10.1.0.3 3406644 Insert .. Select of a CLOB over a database link may truncate the CLOB value
10.1.0.3 3408192 Heavy concurrent DML scenarios can cause $R table to contain deleted rowids

Corruption (Physical)

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

Fixed in Release Bug Number Description
10.1.0.4 3806172 * Logical standby apply may stop with ORA-355 / ORA-353 . This bug is alerted in Note:280832.1
10.1.0.4 3069818 Corruption possible modifying a migrated or chained row
10.1.0.4 3641963 Transport of a table with LONG RAW and added columns is corrupt at target
10.1.0.4 3762714 ALTER DATABASE RECOVER MANAGED STANDBY fails with OERI[3020]
10.1.0.4 3785333 DROP COLUMN may drop wrong columns in an IOT with OVERFLOW
10.1.0.4 3811391 Updates to IOTs beyond column 255 in non-key piece can corrupt the IOT
10.1.0.4 3859298 Block corruption with high INITRANS or rapid ITL growth.
10.1.0.4 3953458 Array insert to IOT with supplemental logging can corrupt the IOT
10.1.0.4 4000840 Update can cause block corruption
10.1.0.3 3514615 * CREATE CONTROLFILE can corrupt Oracle mirrored datafiles . This bug is alerted in Note:271571.1
10.1.0.3 3841411 *P CLOB corruption after upgrade from 10.1.0.2 to 10.1.0.3 on some platforms . This bug is alerted in Note:281209.1
10.1.0.3 3397181 ALTER SYSTEM KILL SESSION of recovery slave causes stuck recovery

Corrupt/Bad Backup

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

Fixed in Release Bug Number Description
10.1.0.4 3664004 * RMAN "backup recovery files" command skips image copy backups . This bug is alerted in Note:278631.1
10.1.0.4 3575797 XMLSchemas and types are not exported in table and tablespace mode export
10.1.0.4 3615004 Corrupt backup / ORA-19675 using RMAN PROXY backup in RAC environment
10.1.0.4 3762714 ALTER DATABASE RECOVER MANAGED STANDBY fails with OERI[3020]
10.1.0.4 3844804 RMAN DELETE .. BACKED UP n TIMES can delete an archivelog not yet backed up
10.1.0.4 3955213 EXPDP may not export all private SYNONYMs

Deadlock

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

Fixed in Release Bug Number Description
10.1.0.4 3381218 Deadlock involving 'library cache lock' X mode request
10.1.0.4 3540821 ORA-4020 deadlock from concurrent ANALYZE index / query compilation against a cluster
10.1.0.4 3562032 Cancelled ONLINE index rebuild can deadlock with DML session
10.1.0.4 3585808 JDBC deadlock possible between threads
10.1.0.4 3605165 Hang/deadlock between sessions concurrently loading a cursor with INVALID trigger
10.1.0.4 3624510 JDBC deadlock between oracleConnection / scrollableResultSet
10.1.0.4 3627263 Deadlock / hang during RAC instance startup
10.1.0.4 3641819 Undetected deadlock possible in RAC
10.1.0.4 3646162 False deadlock (ORA-60) in a RAC environment / TM lock mode change
10.1.0.4 3717619 Deadlock/hang possible due to concurrent cursor loads referencing same INVALID trigger
10.1.0.4 3756949 Sequences can deadlock on space allocation failure
10.1.0.4 3777178 TA / US enqueue deadlock during transaction recovery in RAC
10.1.0.4 3896974 ORA-4020 creating DIMENSIONs from schemas simultaneously
10.1.0.4 3975268 Deadlock possible after gathering statistics for certain SYS objects
10.1.0.4 3990235 Deadlock in disk drop and instance recovery in ASM
10.1.0.3 3166756 Self deadlock (ORA-60) possible on LOB index update
10.1.0.3 3268802 Additional diagnostics for deadlock in RAC environment
10.1.0.3 3347676 Deadlock in JDBC connection pool between getConnection() and close()
10.1.0.3 3424721 Hang/deadlock from ALTER INDEX REBUILD on partition with concurrent SQL
10.1.0.3 3437870 Java thread deadlocks sharing OracleOCIConnectionPool connections between threads
10.1.0.3 3449423 OLAP may deadlock (ORA-60)

Excessive CPU Usage

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

Fixed in Release Bug Number Description
10.1.0.4 3537086 High CPU usage during parse for bitmap plans
10.1.0.4 3756797 High CPU may be used during parse of certain query forms
10.1.0.4 3768052 PLSQL Commit / Rollback wastes cursors and is slower than 8i
10.1.0.4 3941723 Streams apply may use a lot of CPU with no messages
10.1.0.4 4042122 Excessive parse time with cost based transformation
10.1.0.3 3216002 HASH JOIN ANTI / SEMI can use a lot of CPU / spin
10.1.0.3 3239873 High CPU during parse of statements with many identical predicates
10.1.0.3 3281907 Export / import of a composite partitioned table can appear to spin during IMPORT
10.1.0.3 3336594 High CPU use in QMON scanning DEF$ tables needlessly
10.1.0.3 3405237 ORA-4031 / excessing SGA consumption due to large IN LIST and NOT IN list

Feature Unusable

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

Fixed in Release Bug Number Description
10.1.0.3 3224506 XA client using TAF may not failover correctly

Fix Is Considered An Enhancement

The following table lists the Fix Is Considered An Enhancement bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.1.0.4 3264021 New DBMS_LDAP interface needed for large binary attributes
10.1.0.4 3395082 SYSMAN PLSQL objects should be kept at instance startup
10.1.0.4 3554127 Ultrasearch searchlet cannot configure via OID / service registry
10.1.0.4 3562142 Enhancement - improved performance of utlip / utlrcmp
10.1.0.4 3697152 Diagnostic to dump memory when a bad KGHU magic number is seen
10.1.0.4 3795329 Stack trace unwind is slow on some platforms
10.1.0.4 3797523 Enhancement - Include stack information in systemstate dumps
10.1.0.4 3819875 Cost-based transformation does not work with objects
10.1.0.4 3868840 _DB_BLOCK_CACHE_PROTECT has high overhead
10.1.0.4 3881099 ORA-1280 diagnostic enhancement
10.1.0.4 3903913 Streams spill data hard to decode
10.1.0.4 3906430 SSL enterprise users should not require certificate DN to match OID dn
10.1.0.4 3980583 Dump (inspre0) from DML involving GV$ views
10.1.0.4 4029071 Enhancement: Allow CRS startup to be detached from DB instance startup
10.1.0.4 4053888 ORA-1499 diagnostic trace does not dump REDO for the table block
10.1.0.3 3566945 + ENH: No block level locking for externally co-ordinated prepared transactions
10.1.0.3 3054910 ALTER TYPE does not support change of codepoint semantics
10.1.0.3 3293155 ENH: Diagnostic enhancement to help investigate memory corruptions/leaks
10.1.0.3 3316345 ENH: Enhance checks on interconnect blocks by a check for the correct DBA
10.1.0.3 3405535 ENH: utlu101i.sql script should display any INVALID components
10.1.0.3 3423843 ENH: Small OLS performance improvement
10.1.0.3 3457571 Enhancement to DBV to show highest SCN in a file / show blocks above an SCN
10.1.0.3 3551597 User sessions cannot determine if OLS database is OID enabled or not
10.1.0.3 3568528 ENH: Increase maximum OLS predicate length to 4000 bytes
10.1.0.3 3586679 ENH: Add DB2/UDB stored procedure support

Hang (Involving Shared Resource)

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

Fixed in Release Bug Number Description
10.1.0.4 3626461 CRS hang after reboot on master node
10.1.0.4 3626463 Hang possible on 'ges inquiry response' after reconfiguration
10.1.0.4 3634252 PMON unable to acquire latch when JOB_QUEUE_PROCESSES altered
10.1.0.4 3801483 Instance hang possible in RAC
10.1.0.4 3951017 Sessions hang with 'gc cr multi block request' / UDP overload
10.1.0.3 2932269 Sessions hang on "resmgr:waiting in end wait" while session tries to connect over DBLINK
10.1.0.3 3342182 Instance hang on startup possible in RAC
10.1.0.3 3420610 RAC "BAST" leak can lead to instance hang
10.1.0.3 3544142 It is possible for a process to be FROZEN while holding a latch
10.1.0.3 3577341 LGWR may hold TA [1][usn] after an OERI[4005]
10.1.0.3 3642684 Database can hang when block change tracking is enabled

Hang (Process Hang)

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

Fixed in Release Bug Number Description
10.1.0.4 2997330 Hang on library cache pin/lock
10.1.0.4 3206228 Query on V$SQLTEXT_WITH_NEWLINES spins for certain HASH_VALUE predicates
10.1.0.4 3362575 Hang possible resolving classes in the JVM
10.1.0.4 3381218 Deadlock involving 'library cache lock' X mode request
10.1.0.4 3400979 Dump of FILE_HDRS may hang or error (can result in OERI [2103])
10.1.0.4 3476477 RAC session can hang
10.1.0.4 3509265 SHUTDOWN may hang with "waiting for instances to leave: N"
10.1.0.4 3520103 ASM instance hang on "DFS lock handle"
10.1.0.4 3562032 Cancelled ONLINE index rebuild can deadlock with DML session
10.1.0.4 3566511 ONLINE index rebuild can cause DML sessions to hang.
10.1.0.4 3605165 Hang/deadlock between sessions concurrently loading a cursor with INVALID trigger
10.1.0.4 3625370 CGS nested reconfiguration may hang
10.1.0.4 3630273 Apply may hang during initialization with RAC primary
10.1.0.4 3632400 LMS may hang in kslges() waiting for a post
10.1.0.4 3644481 ASM instance hang (wait for DD enqueue)
10.1.0.4 3676676 Ctrl-C/interrupt ignored for query over DB link
10.1.0.4 3717619 Deadlock/hang possible due to concurrent cursor loads referencing same INVALID trigger
10.1.0.4 3724485 Enqueue waits may occur with no obvious holder in RAC
10.1.0.4 3802873 LDAP connections can not be established from MTS dispatchers
10.1.0.4 3833893 SMON may hold the TT enqueue preventing alter of TEMPORARY TABLESPACE
10.1.0.4 3843318 OERI[ksxpwait10] / hang possible in RAC
10.1.0.4 3852108 Concurrent truncates on global temporary table cause library cache lock waits
10.1.0.4 3876785 XML Parser hangs when processing with multiple threads
10.1.0.4 3926395 Apply execute error fails on very large transactions
10.1.0.4 3928153 "alter database [stop | abort] logical standby apply" hangs
10.1.0.4 3990235 Deadlock in disk drop and instance recovery in ASM
10.1.0.3 3566945 + ENH: No block level locking for externally co-ordinated prepared transactions
10.1.0.3 2932269 Sessions hang on "resmgr:waiting in end wait" while session tries to connect over DBLINK
10.1.0.3 3122154 AQ JMS receive(wait_time) does not return after wait_time
10.1.0.3 3253770 ORA-4021 / "library cache pin" waits on RAC executing Java stored procedures
10.1.0.3 3296914 Using binds from 8i instance to a 9i instance to a 9i Gateway can hang
10.1.0.3 3315378 A blocked ONLINE index rebuild can cause other DML to hang
10.1.0.3 3323709 Hang on execution of DBMS_REDEFINITION.START_REDEF_TABLE and concurrent insert to same table
10.1.0.3 3374640 Create local partitioned domain index can hang
10.1.0.3 3424721 Hang/deadlock from ALTER INDEX REBUILD on partition with concurrent SQL
10.1.0.3 3479558 Break/SetQueryTimeout can cause JDBC client to hang
10.1.0.3 3565109 Logminer may not be able to resolve log files with multiple archive destinations
10.1.0.3 3577341 LGWR may hold TA [1][usn] after an OERI[4005]

Hang (Process Spins)

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

Fixed in Release Bug Number Description
10.1.0.4 3771668 + Poor INSERT performance with ASSM
10.1.0.4 3206228 Query on V$SQLTEXT_WITH_NEWLINES spins for certain HASH_VALUE predicates
10.1.0.4 3300215 Parse of an OUTER JOIN on nested tables spins
10.1.0.4 3458438 Update a long >4k that affects more than 1 record over DB link hangs
10.1.0.4 3508608 CR request retry can spin in RAC for LOB data
10.1.0.4 3654532 Spin possible from query rewrite with temp table transformation
10.1.0.4 3669661 Spin possible registering certain XSD
10.1.0.4 3796771 Server spin in multibyte from DESCRIBE operation
10.1.0.4 3822213 Explain plan with STAR transformation may spin in qkaPobs
10.1.0.4 3831971 Streams Qxxx processes may spin when there is no load
10.1.0.3 3281907 Export / import of a composite partitioned table can appear to spin during IMPORT
10.1.0.3 3371796 Explain plan spins in kkorminl
10.1.0.3 3395198 Query rewrite may spin after partition exchange
10.1.0.3 3407944 OERI[5254] / dump (ktagttl) or spin from Ctrl-C of a query
10.1.0.3 3414440 Query rewrite may spin in qsmg_process_sqltxt for ANSI join in a view
10.1.0.3 3443747 A session can spin holding a library cache latch during fixed table lookup

Install Is Not Performed Correctly

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

Fixed in Release Bug Number Description
10.1.0.4 3761763 SDO_GEOMETRY invalid during install if object in recycle bin
10.1.0.4 3936668 Ultrasearch validation procedure schema incorrect
10.1.0.3 3580691 I Response files for Custom Install do not install all selected products (10g OUI)
10.1.0.3 3438751 P Linux: Async IO is not installed correctly on Linux 10.1.0.2
10.1.0.3 3413846 CRS install can fail installing CRS on a system with 9.2 RAC present

Instance May Crash

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

Fixed in Release Bug Number Description
10.1.0.4 3691672 + OERI[17067]/ OERI[26599] / dump (kgllkdl) from JavaVM / OERI:1100 from PMON
10.1.0.4 3566420 P* Solaris: OERI:[KSLAWE:!PWQ] can occur in 9.2.0.5 on 64bit Oracle on Solaris . This bug is alerted in Note:271084.1
10.1.0.4 2901988 PMON may crash the instance with OERI [k2gcbr:2] following ORA-2051
10.1.0.4 3037154 PMON may die with ORA-601 (rare)
10.1.0.4 3439552 OERI[4406] possible in SMON using automatic undo management
10.1.0.4 3440376 OERI[kclfadb_2] / LMS crashes the instance
10.1.0.4 3482748 LMS may die with OERI:kclfbbast_2
10.1.0.4 3613126 ALTER DATABASE DATAFILE OFFLINE can cause OERI[kcfquewr_2] / crash in RAC
10.1.0.4 3615072 PMON can crash the instance with [plio.c: non-reusable inst]
10.1.0.4 3638695 PMON may crash instance cleaning dead process
10.1.0.4 3640947 CRS addnode may crash existing instances
10.1.0.4 3671299 PMON may dump (kslcll) crashing the instance
10.1.0.4 3671867 OERI[kclchkinteg_2] possible in RAC environment
10.1.0.4 3679713 OS kill of a process performing ASM IO crahses instance with OERI[kffmrequestfree_1]
10.1.0.4 3724485 Enqueue waits may occur with no obvious holder in RAC
10.1.0.4 3754474 OERI[kghfre3] possible with heavy IO workload
10.1.0.4 3799470 RAC LMD crashes instance with dump in kjddgmak
10.1.0.4 3819836 OERI[1155] / instance crash possible
10.1.0.4 3857822 OERI:kfuitrninit_1 possible in ASMB when using ASM
10.1.0.4 3892704 During reconfiguration processes may fail with OERI:kjuocl1
10.1.0.4 3903314 Crash due to OERI[kfkOsmUpdReq] with ASM after IO error
10.1.0.4 3906669 LMS may fail with OERI[kjbmpclo:cvt]
10.1.0.4 3936811 Rare OERI[kjbrass:2scn] after RAC reconfiguration
10.1.0.4 3940412 PMON dump (kgllccl) cleaning up a killed process
10.1.0.4 3948384 ORA-4031 possible using LGWR ASYNC for archiving
10.1.0.4 3953494 ASM instance may crash with OERI[kfkupdateufsreq1] after rebalance of diskgroup
10.1.0.4 3983699 Dump (pfrdef1_get_tdo or kgicsr) with SERIALLY REUSABLE packages with ADTs
10.1.0.4 3996802 "alter system kill session" can crash the instance if IO slaves used
10.1.0.3 3411021 Oracle process may die due to ORA-27300/ORA-27301/ORA-27302 at skgxppost1
10.1.0.3 3452686 OERI[ktcrsp_1: drop/truncate not comp] possible in RAC at end of reconfiguration
10.1.0.3 3503661 ASM "ALTER DISKGROUP ADD DISK" can crash database
10.1.0.3 3549886 PMON may crash an instance with OERI:KSSRMP1

Latch Contention

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

Fixed in Release Bug Number Description
10.1.0.4 3797171 "cache buffers chains" latch contention increased in 10g
10.1.0.4 3885860 Latch contention form concurrent reconfiguration and SYSTEMSTATE dump
10.1.0.4 3941893 Latch contention in cursor cache when flushing AWR SQL statistics
10.1.0.4 4063046 Latch contention due to leaked CR pins for LOB data
10.1.0.3 3443747 A session can spin holding a library cache latch during fixed table lookup
10.1.0.3 3452409 STATISTICS_LEVEL >= TYPICAL can cause latch contention under load
10.1.0.3 3513427 ORA-4031 can cause many SGA heapdumps to occur causing shared pool latch contention

Leak (Memory Leak / Growth)

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

Fixed in Release Bug Number Description
10.1.0.4 2708874 OERI:KGHALP1 / ORA-4030 using FORALL with SAVE EXCEPTIONS
10.1.0.4 3194997 DDL against domain indexes can use lots of memory
10.1.0.4 3218825 Memory leak when Java Stored Procedure executed from PLSQL
10.1.0.4 3258467 High memory consumption from sessions using very many PLSQL packages
10.1.0.4 3500369 OERI[kohdtf048] / ORA-21780 / Memory leak from PLSQL
10.1.0.4 3611423 PGA memory leak in AQ propagation process(J000)
10.1.0.4 3630538 Memory leak on PObject::pin() in OCCI client
10.1.0.4 3650803 Memory leak in G4DRSRV Gateway process
10.1.0.4 3667108 Excessive memory allocated when constructing mdm model
10.1.0.4 3679149 OCISessionRelease not releasing memory for invalid connections
10.1.0.4 3748283 Small PGA memory leak in kpodscn for long running PLSQL against external tables
10.1.0.4 3756908 OCI client memory leak with End-to-End tracing enabled
10.1.0.4 3787833 ORA-4030 / excess memory use when an XML schema is registered
10.1.0.4 3789433 Memory leak possible from lmmrealloc
10.1.0.4 3795386 Insert as select of LOBS / XMLType across DB Link can leak memory
10.1.0.4 3802111 Streams capture memory leak
10.1.0.4 3825144 Excessive memory use / poor performance for CONNECT BY
10.1.0.4 3826792 JDBC OCI leaks client side memory when calling PLSQL with REF CURSOR OUT bind
10.1.0.4 3836164 ORA-4030 / high memory use from SQL with many views/branches
10.1.0.4 3853332 OCCI client memory leak using statement::setString()
10.1.0.4 3854034 OERI[733] optimizing SQL using bitmap indexes
10.1.0.4 3857050 LMON leaks memory when another instance leaves or join the cluster
10.1.0.4 3908058 Memory leak when using protocol.ora validnode_checking
10.1.0.4 3919585 Small memory leak due to oracle.xml.util.qxnamehash$weakvalue references
10.1.0.4 3926395 Apply execute error fails on very large transactions
10.1.0.4 3948384 ORA-4031 possible using LGWR ASYNC for archiving
10.1.0.4 3964817 Memory leak in external procedure for OBJECT arguments
10.1.0.3 3134518 Memory leak on "bind var" heap from invalidated PLSQL cursor
10.1.0.3 3145754 Calling EXTPROC can leak memory if there is no listener
10.1.0.3 3192557 JDBC Thin with CallableStatement consumes/leaks database UGA memory
10.1.0.3 3275045 PLSQL calling USERENV leaks memory within the PLSQL user call
10.1.0.3 3280226 ANALYZE to collect statistics may use more memory than expected
10.1.0.3 3281907 Export / import of a composite partitioned table can appear to spin during IMPORT
10.1.0.3 3302654 PGA memory leak in "cursor work heap" for queries with VIEW PUSHED PREDICATE over a SORT
10.1.0.3 3356492 DBMS_LOB.LOADFROMFILE leaks library cache locks / shared pool "perm" memory
10.1.0.3 3387491 Oracle Names LDAP proxy process leaks memory leak on reload
10.1.0.3 3390021 PGA memory leak in apply server
10.1.0.3 3405237 ORA-4031 / excessing SGA consumption due to large IN LIST and NOT IN list
10.1.0.3 3408829 TNS listener leaks memory if remote listener specified in LOCAL_LISTENER
10.1.0.3 3421087 Memory leak can occur when using DBMS_XMLGEN
10.1.0.3 3518909 Session (UGA) memory not released after using DBMS_XMLPARSER
10.1.0.3 3636602 Memory leak in Net

Leak (Resources Eg: File Handles)

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

Fixed in Release Bug Number Description
10.1.0.4 3546019 Cursor leak from interMedia image matching index inserts and updates
10.1.0.4 3571263 Excessive build-up of distributed transaction locks (DX locks)
10.1.0.4 3647829 Cursor is not always closed when database link closed (ORA-1000)
10.1.0.4 3679149 OCISessionRelease not releasing memory for invalid connections
10.1.0.4 3764557 ASM LGWR / DBWR do not release disk after it is dropped
10.1.0.4 3940410 Cursor leak (ORA-1000) from DML if concurrent session is creating a Text index ONLINE
10.1.0.4 3957178 Cursor leak on error in apply (ORA-1000)
10.1.0.3 3528069 JDBC Thin Net sockets not closed if an error occurs during the Net close operation

Memory Corruption

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

Fixed in Release Bug Number Description
10.1.0.4 3466737 Memory corruption optimizing SQL with OR predicates
10.1.0.4 3642764 PGA corruption possible with CURSOR_SPACE_FOR_TIME if NLS parameters altered
10.1.0.4 3724548 OERI[kglhdunp2_2] / OERI[1100] under high load
10.1.0.4 3737547 Client memory corruption when fetching NULL data
10.1.0.4 3800160 Internal error / memory corruption using ASM with KST trace
10.1.0.4 3802438 OERI[17148] / SGA heap corruption with NUMA pools
10.1.0.4 3830455 Memory corruption possible for invalid ISO2022 escape sequences
10.1.0.4 3884912 Dump (kghalp) can occur
10.1.0.4 3928828 OERI[kghfrh:ds] / memory corruption from AQ
10.1.0.4 3958875 Dump / memory corruption from Text index of EMAIL with long epilogue
10.1.0.4 3964487 Java stored procedure can corrupt memory in MTS
10.1.0.4 3990826 Library cache recovery structures are not cleaned up properly (SGA corruption)
10.1.0.3 3300118 Memory corruption / dump from SDO_INTERSECTION with 'WALKING'
10.1.0.3 3403305 Internal change to memory allocation (reduce memory corruption issues)
10.1.0.3 3449174 Attempt to supplementally log LONG column can OERI/dump
10.1.0.3 3451741 Dump (gxtsnGetPar) creating Text index with THEMES=YES
10.1.0.3 3469775 DBMS_XMLGEN.CONVERT can fail with OERI[17112]

Performance Affected (General)

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

Fixed in Release Bug Number Description
10.1.0.4 3894096 + Poor MView refresh performance in ASSM tablespaces
10.1.0.4 3535015 DBMS_STATS slow for partitioned tables with many partitions
10.1.0.4 3588448 Waits for 'global cache cr request' on RAC if UDP overflow occurs
10.1.0.4 3588633 Manual shrinking of the buffer cache takes a long time
10.1.0.4 3611471 High latch waits for "cache buffers chain" latch possible
10.1.0.4 3797171 "cache buffers chains" latch contention increased in 10g
10.1.0.4 3857903 LMS not posted by LGWR when hot current block requires a log flush during BAST
10.1.0.4 3893567 Concurrent SYSTEMSTATE dumps can impact performance
10.1.0.4 3948711 XA with database links may dump or perform slowly (link closed)
10.1.0.3 3438751 P Linux: Async IO is not installed correctly on Linux 10.1.0.2
10.1.0.3 3211428 ANALYZE / Batch operations can disable PREFETCH for all sessions
10.1.0.3 3312874 USE_STORED_OUTLINES causes increased "library cache lock" requests in RAC
10.1.0.3 3452409 STATISTICS_LEVEL >= TYPICAL can cause latch contention under load

Performance Of Query/ies Affected

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

Fixed in Release Bug Number Description
10.1.0.4 3771668 + Poor INSERT performance with ASSM
10.1.0.4 3177513 Join not avoided using bitmap join index if UNIQUE index exists also
10.1.0.4 3183084 Performance hit / OERI for index maintenance if TEMPORARY blocksize < index blocksize
10.1.0.4 3193835 Unnecessary partition scanning depending on predicate order
10.1.0.4 3348585 Dump (in LNXMIN) using WINDOW functions with CASE/DECODE
10.1.0.4 3359905 CONNECT BY much slower in 9.2 than 8.1
10.1.0.4 3436577 View merge does not occur for CTAS when it does for the SELECT
10.1.0.4 3440097 Suboptimal plan with count(column), bitmap index and view
10.1.0.4 3447032 DBMS_STATS.SET_COLUMN_STATS can be slow (affects IMPORT)
10.1.0.4 3491127 DBMS_STATS.GATHER_INDEX_STATS does not gather correct partitioned index stats
10.1.0.4 3499674 CBO may overestimate cost of NL join with index
10.1.0.4 3520157 Create index using FFS slower than create index from table
10.1.0.4 3530612 Dynamic partition pruning may not occur on MERGE
10.1.0.4 3533996 Using transportable tablespaces disables intra-partition PDML
10.1.0.4 3537086 High CPU usage during parse for bitmap plans
10.1.0.4 3537749 HW enqueue contention when loading lob data
10.1.0.4 3537765 SET queries with DISTINCT in query branch may have poor performance
10.1.0.4 3545209 Poor performance from semi join with NL to remote table
10.1.0.4 3566361 DBMS_IOT.NUMBER_TO_UROWID is slow
10.1.0.4 3566843 Optimizer may not choose best index
10.1.0.4 3567928 Suboptimal plan with range predicates on CHAR columns with numeric literals
10.1.0.4 3582445 Predicate on PARTITION BY clause of WINDOW function not pushed into view
10.1.0.4 3601653 Subquery partition pruning does not work with SYSDATE predicate/s
10.1.0.4 3607226 No predicate pushing into UNION ALL view with analytic function/s
10.1.0.4 3611471 High latch waits for "cache buffers chain" latch possible
10.1.0.4 3614289 Index range cost with predicate on descending key may be too high
10.1.0.4 3617028 CBO suboptimal plan for multiple 'or' conditions
10.1.0.4 3620168 DBMS_STATS may set AVG_ROW_LEN to 100
10.1.0.4 3622251 Redundant range predicates against CHAR columns not removed
10.1.0.4 3632885 In FULL OUTER JOIN a NESTED LOOPS ANTI is used when unique index exists
10.1.0.4 3637851 Additional "no-op" predicate can reduce CPU
10.1.0.4 3643862 OUTLINES can fail to freeze plan because some hints are not generated
10.1.0.4 3668224 Bind peeking does not occur for predicates of the form COL <op> FUNC(:bind)
10.1.0.4 3690369 Incorrect cardinality estimation when using LIKE predicates
10.1.0.4 3723007 Predicate push down may not occur in 10g (when it did in 9i)
10.1.0.4 3731042 Optimizer may not cost sub-query unnesting correctly
10.1.0.4 3731299 Cost based transformation may choose not to push join predicate when it should
10.1.0.4 3731357 Optimizer does not push join predicate when ROWNUM exists
10.1.0.4 3735785 Pro code with SQL_CURSOR array fetch uses single row fetches and no prefetch
10.1.0.4 3737955 Long parse times for long inlists / many AND/OR terms
10.1.0.4 3742802 Full table scan possible if selectivity of BETWEEN is 0
10.1.0.4 3745580 Poor performance from SORT MERGE JOIN plan against UNION view
10.1.0.4 3746423 Sub-optimal execution plan for range partitioned table with INLIST
10.1.0.4 3756797 High CPU may be used during parse of certain query forms
10.1.0.4 3777256 Functional indexes on CASE expressions may not be used
10.1.0.4 3780242 Query unnesting not happenning when uncorrelated subquery has ROWNUM>=1 predicate
10.1.0.4 3823191 Unnecessary sort when access made through a local index
10.1.0.4 3825144 Excessive memory use / poor performance for CONNECT BY
10.1.0.4 3830853 DELETE during REFRESH of MJV can have poor execution plan
10.1.0.4 3834770 CBO may not unnest an EXISTS() subquery with a view in the FROM clause
10.1.0.4 3855006 Sub-optimal plan with or expansion due to join order control
10.1.0.4 3859342 Sort is not parallelised in a view query with MINUS (or INTERSECT)
10.1.0.4 3867374 Zero cost possible for nested loops access to table with single bitmap semijoin
10.1.0.4 3880640 Query with ALL operator make get suboptimal plan
10.1.0.4 3889123 DB_FILE_MULTIBLOCK_READ_COUNT higher than 16 blocks has no effect in RAC
10.1.0.4 3896254 CBO used with default statistics used when DB2STATS = FALSE
10.1.0.4 3899748 Incorrect join cardinality for lossless NVL predicates
10.1.0.4 3906520 NULLs cause poor index range scan performance
10.1.0.4 3926149 XDB queries can show worse performance in 10.1.0.3 (to 10.1.0.2)
10.1.0.4 3929805 Slow execution for insert as Select over DB Link with NULL in select list
10.1.0.4 3940507 Optimizer may not push join predicate inside views with constant columns
10.1.0.4 3940888 Sub-optimal possible with bind peeking
10.1.0.4 3945774 Sub optimal plan possible for query blocks with many tables
10.1.0.4 3950045 Wrong cardinality (CDN) with functional indexes
10.1.0.4 3953483 Insert as Select with correlated sub-query with MAX function slow
10.1.0.4 3956141 OR filter in CONNECT BY query may be applied at table level
10.1.0.4 3958887 Incorrect NDV for index statistics with many duplicates
10.1.0.4 3966573 Sub-optimal plan with CONNECT BY and ROWNUM
10.1.0.4 3996053 Inefficient dynamic partition pruning SQL
10.1.0.4 4011806 Performance degradation in PLSQL loop in 10g
10.1.0.4 4012809 Wrong cardinality estimate causes join predicate to not be pushed down
10.1.0.4 4042122 Excessive parse time with cost based transformation
10.1.0.3 3211428 ANALYZE / Batch operations can disable PREFETCH for all sessions
10.1.0.3 3216002 HASH JOIN ANTI / SEMI can use a lot of CPU / spin
10.1.0.3 3317309 Bad plan choice due to poor selectivity for "col=:bind" or "col=expression" for single value column
10.1.0.3 3328542 JDBC OCI slower than Thin for LONG RAW data
10.1.0.3 3347339 Stored outline has "NO_ACCESS" instead of "INDEX" hint for domain index access
10.1.0.3 3349903 Bind peeking does not work for partitioned objects with non-equality predicates
10.1.0.3 3354231 Index skip scan is sometimes estimated at very high cost
10.1.0.3 3356951 DBMS_STATS can be slow if sample size causes < 2500 rows in the sample
10.1.0.3 3380026 Suboptimal plan possible for FIRST_ROWS for SQL with ORDER BY and indexes
10.1.0.3 3398205 CBO can waste CPU trying to optimize INSERT INTO .. VALUES statements
10.1.0.3 3400412 CBO may choose a more expensive HASH JOIN plan with no partition pruning
10.1.0.3 3412136 Poor plan (with merge join cartesian) with STAR transformation
10.1.0.3 3456044 Poor AQ performance from multiple dequeuers performing rollback
10.1.0.3 3467364 Adding datafiles serializes on the TT enqueue
10.1.0.3 3482715 CBO costing error for plans with index filter
10.1.0.3 3485930 Slow performance of DBMS_STATS with auto sample size
10.1.0.3 3492682 Queries against DBA_FREE_SPACE can be slow in 10g
10.1.0.3 3497588 Media recovery checkpoint slow when recovering a large number of datafiles
10.1.0.3 3516951 Poor execution plan with merge join cartesian with temp table transformation
10.1.0.3 3521347 Suboptimal plan possible using a ROWNUM predicate
10.1.0.3 3541407 Incorrectly remote table cardinality for TG4IFMX

Security Or Service Denial Vulnerability

The following table lists the Security Or Service Denial Vulnerability bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.1.0.3 3828166 * Oracle Security Alert #68 - Database Server Vulnerabilities Bug# . This bug is alerted in Note:281188.1

Shared Pool Affected

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

Fixed in Release Bug Number Description
10.1.0.4 3768052 PLSQL Commit / Rollback wastes cursors and is slower than 8i
10.1.0.4 3941893 Latch contention in cursor cache when flushing AWR SQL statistics
10.1.0.3 2893444 Internal SQL in the extensible optimizer does not always use bind variables
10.1.0.3 3299407 Invalidating cursors frequently can fragment the SGA and leak "kglau" memory
10.1.0.3 3356492 DBMS_LOB.LOADFROMFILE leaks library cache locks / shared pool "perm" memory
10.1.0.3 3405237 ORA-4031 / excessing SGA consumption due to large IN LIST and NOT IN list
10.1.0.3 3406977 High version count in V$SQL due to binds marked as non-data with CURSOR_SHARING=FORCE
10.1.0.3 3513427 ORA-4031 can cause many SGA heapdumps to occur causing shared pool latch contention

Storage Space Usage Affected

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

Fixed in Release Bug Number Description
10.1.0.4 3219117 LOB SEGMENT uses more space with ASSM
10.1.0.4 3516451 ALTER TABLE x SHRINK CASCADE does not shrink indexes
10.1.0.4 3687210 SUMDELTA$ rows never purged
10.1.0.4 3957037 LOB segment with PCTVERSION may use more space than expected
10.1.0.4 3970279 LOB segment with retention configuration grow in ASSM tablespace
10.1.0.4 4137362 Idle Oracle Forms sessions incorrectly appear in Active Session History
10.1.0.3 2919655 LOBs may not reuse space with automatic undo management
10.1.0.3 2952816 Improved version of 2919655 / No old LOB versions retained in 9204
10.1.0.3 3157572 Rollback of Array inserts into tables with high PCTFREE can waste space
10.1.0.3 3329096 Free space may not be used in an AUTO SPACE MANAGED segment
10.1.0.3 3449951 ORA-1562 can occur on DBMS_LOGMNR_SESSION.PURGE_SESSION or DBMS_CAPTURE.ALTER_CAPTURE
10.1.0.3 3464629 LOGMNR_SPILL$ table grows in an unbounded fashion

Wrong Results

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

Fixed in Release Bug Number Description
10.1.0.4 2055862 OracleCachedRowSet.getRow() returns wrong value after last()
10.1.0.4 2365168 Wrong results with PQO and partitioning
10.1.0.4 2738493 Wrong "session connect time" / "process last non-idle time" in V$SYSSTAT
10.1.0.4 2846640 Ambiguous columns not signalled with ANSI join syntax (wrong results instead of error)
10.1.0.4 3017095 ALTER MVIEW COMPILE does not update LAST_DDL_TIME in DBA/ALL/USER_OBJECTS
10.1.0.4 3081127 View for remote table with CHECK OPTION never reports ORA-1402
10.1.0.4 3111464 Fast refresh gives wrong data after update of filter column from null to value
10.1.0.4 3128363 OCIAttrGet returns wrong size when CURSOR_SHARING=SIMILAR or FORCE
10.1.0.4 3141614 TIMESTAMPs can get wrong data if fraction of seconds is >9 digits long
10.1.0.4 3175661 Query rewrite can give wrong results for "NOT IN"
10.1.0.4 3177769 Wrong results OR predicates inside AND chains of OR predicates
10.1.0.4 3188637 Wrong result with star transformation and OUTER join
10.1.0.4 3250883 Inline view using functional index can give wrong results
10.1.0.4 3258390 V$SESSION.SCHEMANAME may return wrong value in PLSQL of another user
10.1.0.4 3298019 Unreliable results with new_german_spelling enabled
10.1.0.4 3318204 Parallel query gives wrong results with view
10.1.0.4 3324698 Wrong tokens produced using numjoin and numgroup
10.1.0.4 3333863 DBA_JOBS.LAST_DATE is set even if the job runs with failures
10.1.0.4 3347567 Wrong results from V$SGASTAT for STREAMS_POOL
10.1.0.4 3351150 V$SQL_BIND_CAPTURE shows NULL bind names for duplicate binds
10.1.0.4 3352279 ORA-14093 / wrong results from subquery pruning with composite partitioned table
10.1.0.4 3355043 The MIN analytic returns bad data when selecting from nested collection type
10.1.0.4 3357740 Wrong results from external table in subquery
10.1.0.4 3374251 copyEvolve() does not reset modification date
10.1.0.4 3377931 SAVE EXCEPTIONS does not work reliably with a partitioned table
10.1.0.4 3385243 Wrong results from PQ against partitioned tables
10.1.0.4 3396223 wrong results with function based index and DECODE function
10.1.0.4 3406229 XMLTransform gives wrong results
10.1.0.4 3406611 Wrong results accessing data via a function based index
10.1.0.4 3417593 Cross platform piecewise fetch of varchar2 data can result in corrupt data
10.1.0.4 3430105 Parallel full scan of an external table may "SKIP" more rows than defined
10.1.0.4 3446722 Wrong results from CBO with constant predicates and CHAR = VARCHAR2 column
10.1.0.4 3454019 Wrong results from wildcard in CATSEARCH / CONTEXT predicate with PREFIX INDEXING
10.1.0.4 3472564 "CPU used by this session" wrong when using job queue processes
10.1.0.4 3472676 ArrayIndexOutOfBoundsException or corrupt data changing fetch size between fetches
10.1.0.4 3477460 Query rewrite can return wrong results
10.1.0.4 3491603 Wrong ORDER BY from parallel execution
10.1.0.4 3497949 Wrong results or ORA-1410 using stored outlines for CONNECT BY query
10.1.0.4 3499258 SQL functions against CHAR data return as VARCHAR2 in PLSQL
10.1.0.4 3500762 V$SYSMETRIC_HISTORY "current logons" count is wrong
10.1.0.4 3523279 Wrong results from UNION in a PLSQL block with CHAR data
10.1.0.4 3545642 Wrong result when using LEFT OUTER joins and TABLE() operator
10.1.0.4 3546774 STATS_CROSSTAB gives wrong results if there are cells with 0 frequency
10.1.0.4 3557094 "NID" leaves stale v$recovery_file_dest information
10.1.0.4 3559212 Wrong results possible from CBO with multi-table OR list
10.1.0.4 3559340 V$OSSTAT may contain no data on some platforms with large number of CPUs
10.1.0.4 3579719 Wrong data length returned selecting CHAR column over HS
10.1.0.4 3582296 UNION [all] statement in PLSQL may give wrong results
10.1.0.4 3584515 Wrong results when ANSI syntax does not trap ambiguous column with ORA-918
10.1.0.4 3585330 getDate on Ultrasearch searchlet Resultset returns null
10.1.0.4 3599966 Wrong results when multi-column SMJ used after semi-join elimination
10.1.0.4 3625392 wrong results / dump (evaopn2) with star transformation
10.1.0.4 3629771 Wrong results possible from COMPRESS KEY INDEX SCAN
10.1.0.4 3632450 TO_MULTI_BYTE/TO_SINGLE_BYTE do not work on a UTF8 database
10.1.0.4 3632504 Wrong results from EXEC SQL LOB READ from NCLOB
10.1.0.4 3637267 Varchar2 is blank padded when local DB charset is different from remote site
10.1.0.4 3637624 wrong results with DISTINCT and aggregates
10.1.0.4 3648071 NAN float data can be inserted despite event 10890
10.1.0.4 3650346 Public synonym resolution fails under certain circumstances
10.1.0.4 3652356 Wrong GMT offset using TO_CHAR with TZD or TZH:TZM
10.1.0.4 3654015 SQLLDR direct path may incorrectly reject rows (ORA-2290) with CHECK_CONSTRAINTS
10.1.0.4 3663103 getTimestamp may return truncated time value using Calendar parameter
10.1.0.4 3668084 Wrong results from nested FULL OUTER JOIN
10.1.0.4 3669074 Some V$SHARED_POOL_RESERVED contain incorrect data
10.1.0.4 3672097 Wrong results joining CHAR / NCHAR from 10g to 9i/8i over database link
10.1.0.4 3678133 Wrong result from DECODE with arguments which evaluate to NULL
10.1.0.4 3682147 Missing bytes fetching RAW OUT PLSQL parameters with JDBC Thin
10.1.0.4 3683056 Wrong results possible from nested loop join with index scan
10.1.0.4 3685171 sqlerrd(5) does not return correct value on SQL errors
10.1.0.4 3688320 Wrong result with parallel query having SMJ and inequality join
10.1.0.4 3691588 OLAP EVERY function does not loop correctly
10.1.0.4 3696879 Wrong results from ANSI query with subquery in the ON condition
10.1.0.4 3699264 Wrong results from XDK if XPATH contains start-with()
10.1.0.4 3713138 OrdHttpUploadFile.simpleFileName returns wrong filename if name contains a ']' character
10.1.0.4 3742674 Wrong results possible from ROWID access of single partition
10.1.0.4 3748199 OCCI Object cache does not support global transactions
10.1.0.4 3753308 NLS_SORT not applied implicitly to window functions
10.1.0.4 3754340 FLOAT values loose precision when selecting against a view with a UNION
10.1.0.4 3754628 Wrong results from illegal query with OUTER joined column in BETWEEN clauses
10.1.0.4 3755693 Wrong results form index skip scan for LIKE with a wildcard
10.1.0.4 3757265 OCCI getNumArrayRows next() method returns cumulative row count
10.1.0.4 3759560 Wrong result using Oracle Object Type with nested subtypes - may appear as NULL
10.1.0.4 3760380 NULL value for ROWNUM when using an OVER WINDOWING clause
10.1.0.4 3760954 OCCI::ResultSet::next(N) method can return the END_OF_FETCH when data exists
10.1.0.4 3762653 Null indicator not set when setting iters = 1 in OCIStmtExexute
10.1.0.4 3763395 Incorrect ROWCOUNT from BULK FORALL INSERT SAVE EXCEPTIONS with partitioned tables
10.1.0.4 3768069 Wrong results in subquery unnesting with semi/anti joins
10.1.0.4 3782820 Wrong results for access by ROWID for ASSM segments
10.1.0.4 3792845 MODE=ANSI client may get error 100 instead of correct error
10.1.0.4 3800215 Variable assignments not working in PLSQL loops
10.1.0.4 3801102 Column values missing in SELECT with correlated scalar subquery in outer join
10.1.0.4 3812263 Wrong results from semijoin elimination with OR expansion
10.1.0.4 3815921 Wrong results possible from predicate move around
10.1.0.4 3816946 Dump (kafger) / wrong results from table scan of compressed table
10.1.0.4 3823887 Dump / wrong results from NVL expansion
10.1.0.4 3828269 Wrong results possible when a space character is scanned with a unique index
10.1.0.4 3828598 Wrong results with unnested remote subqueries
10.1.0.4 3831897 No rows from query against nested table view column when multiply referenced
10.1.0.4 3837903 wrong results from complex view merging with correlated subquery in select list
10.1.0.4 3849938 DBMS_SPACE.UNUSED_SPACE returns wrong block_id for last extent used
10.1.0.4 3852274 Dump / wrong result from invalid AL32UTF8 character
10.1.0.4 3855809 Parallel query with OUTER JOIN and ORDER BY returns results unsorted
10.1.0.4 3858017 Array insert with "EXEC SQL FOR" gets wrong value for SQLERRD[2]
10.1.0.4 3861541 UTL_LMS.GET_MESSAGE can return wrong character set string if LANGUAGE specified
10.1.0.4 3884962 Dump [kxspoac] / wrong results possible with SQL from PLSQL
10.1.0.4 3888015 PLSQL table of records table.count is not incremented
10.1.0.4 3892220 Wrong results from OUTER join to VIEW on literal in view select list
10.1.0.4 3896119 CURRENT_UTILIZATION of V$RESOURCE_LIMIT may be too high
10.1.0.4 3896236 Wrong results with semijoin elimination with NVL-based OR expansion
10.1.0.4 3897407 Wrong results from OUTER JOIN with FUNCTIONAL INDEX when the OUTER is negated
10.1.0.4 3911544 Wrong results from select with "OR" expansion on composite partitioned table
10.1.0.4 3924156 SDO_WITHIN_DISTANCE returns false positive comparing polygons
10.1.0.4 3925069 Wrong COLUMN_TYPE returned by getProcedureColumns for a Date parameter
10.1.0.4 3941526 Wrong results from cost based predicate push into UNION/UNION ALL views
10.1.0.4 4007071 Wrong results selecting from TABLE() collection
10.1.0.4 4082974 SQL with view push predicate plan produces wrong results
10.1.0.4 4154591 Wrong results from single table joinback elimination
10.1.0.3 3376786 * Concurrent LOB updates lost - can cause inconsistent Text Query results . This bug is alerted in Note:263548.1
10.1.0.3 3094453 Wrong values possible in single table aggregate materialized view
10.1.0.3 3149380 Wrong results using stemming , fuzzy or soundex with % in a CONTAINS query
10.1.0.3 3158284 Wrong results possible joining a VARCHAR2 to a CHAR column
10.1.0.3 3168530 AQ order of messages may not be preserved
10.1.0.3 3191604 DBA_JAVA_ARGUMENTS does not show all arguments for LAST method in a CLASS
10.1.0.3 3200136 Wrong results possible from MERGE JOIN CARTESIAN with DOMAIN INDEX
10.1.0.3 3255906 DBA|ALL|USER_TABLES / DBA|ALL|USER_INDEXES views show dropped objects in the RECYCLE bin
10.1.0.3 3273109 Wrong results possible for NULL in SELECT list for PQO or remote query
10.1.0.3 3324069 Wrong results with subqueries using DECODE around aggregates
10.1.0.3 3329128 Wrong results from SQL with GROUPING SETS and IS [NOT] NULL
10.1.0.3 3352051 Using plus (+) terms in an Ultrasearch query may not return all matching documents
10.1.0.3 3363424 Wrong results from query if base table as LPAD/RPAD/LTRIM/RTRIM check constraints
10.1.0.3 3375163 Wrong results from INLIST ITERATOR with multi-column inlists
10.1.0.3 3380428 SQLLDR may report the incorrect number of rows loaded on 64bit platforms
10.1.0.3 3406157 OCISessionGet on an OCI session pool can return a session for a different user
10.1.0.3 3424515 SQLLDR may output incorrect values for some messages on 64bit systems
10.1.0.3 3433964 Wrong result with deferred check constraint when table analyzed
10.1.0.3 3437636 "servers highwater" in V$PX_PROCESS_SYSSTAT can be wrong briefly
10.1.0.3 3447383 Wrong results with parallel query and partition table join
10.1.0.3 3449245 getXML may produce incorrect hex character output
10.1.0.3 3454814 Wrong results possible from STAR TRANSFORMATION
10.1.0.3 3487660 Wrong results from SMJ with GROUP BY with multiple keys
10.1.0.3 3495537 HTML Sectioner may improperly strip spaces from documents
10.1.0.3 3497317 Wrong results with a subquery in a GROUP BY HAVING clause
10.1.0.3 3510094 Use of an analytic function skews the result from CONTEXT indextype SCORE operator
10.1.0.3 3512385 Wrong ROWID returned from SELECT over DBLINK when PREFETCH is on
10.1.0.3 3563038 Statement.getUpdateCount() returns 1 instead of -1
10.1.0.3 3618039 Wrong results as join predicate is pushed through multiple levels of views

Error May Occur

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

Fixed in Release Bug Number Description
10.1.0.4 3806172 * Logical standby apply may stop with ORA-355 / ORA-353 . This bug is alerted in Note:280832.1
10.1.0.4 2233987 ORA-1460 from 8i -> 9i SELECT when database uses AL32UTF8
10.1.0.4 2270510 IMP-58 / ORA-22337 importing evolved type object table
10.1.0.4 2391697 ORA-235 doing backup with RMAN in nocatalog mode
10.1.0.4 2708874 OERI:KGHALP1 / ORA-4030 using FORALL with SAVE EXCEPTIONS
10.1.0.4 2747350 Continual ORA-4061 after modifying PLSQL body for PLSQL called from SQL
10.1.0.4 2822740 Procobol PCB-S-00400 error while parsing SELECT CASE expression
10.1.0.4 2857330 ORA-1008 from Binds in CURSOR subqueries using WITH
10.1.0.4 2858082 False ORA-1652 in alert log when there is free space in RAC environment
10.1.0.4 2876340 ORA-904 accessing a remote object from PLSQL (remote DB < 9i)
10.1.0.4 2931779 False ORA-1555 accessing "cache read" LOBs in RAC
10.1.0.4 2965256 ORA-12714 using SQL function on NVARCHAR2/NCHAR operands
10.1.0.4 2966778 Intermittent ORA-904 errors during heavy load
10.1.0.4 3026474 ORA-20000 from DBMS_STATS importing table stats with missing column
10.1.0.4 3040464 Views defined as selecting ALIAS.* error after adding table columns
10.1.0.4 3083673 ORA-942 when selecting from another users view which uses WITH
10.1.0.4 3165930 False ORA-1436 from query with non connect by prior preceeding connect by prior
10.1.0.4 3202079 ORA-1044 binding large buffer using a dedicated connectionf
10.1.0.4 3237530 Intermittent ORA-25248 errors in alert file using AQ
10.1.0.4 3242079 Using quotation marks with PLSQL variable names can result in errors
10.1.0.4 3278020 ORA-942 creating MVIEW across dblink from 9i to 8i for object table
10.1.0.4 3320638 ORA-957 on "ALTER TYPE" not final cascade convert to substitutable
10.1.0.4 3339218 ORA-26571 performing DML on a replicated table
10.1.0.4 3352279 ORA-14093 / wrong results from subquery pruning with composite partitioned table
10.1.0.4 3372808 ORA-1265 after DROP DATABASE command
10.1.0.4 3372915 Text query with bind variables in CONTAINS may raise false parse errors
10.1.0.4 3384030 ORA-6502 on data pump export with DDL over 32k
10.1.0.4 3387352 Insert on scrollable ResultSet with ORDER BY gives ORA-1732
10.1.0.4 3394821 oracleDriver does not work in applet mode
10.1.0.4 3412553 ORA-942 during functional invocation of CONTAINs on another user's table
10.1.0.4 3412625 DBMS_METADATA cannot handle AQ queue comments over 50 characters long
10.1.0.4 3413436 Oracle Text may fail with ORA-1480 errors
10.1.0.4 3418978 ORA-1 may be thrown immediately for a deferred constraint
10.1.0.4 3430426 ORA-1459 attempting to SELECT a LONG via a database link with multibyte using JDBC
10.1.0.4 3431498 extract and existsnode may ORA-29900 with three operands
10.1.0.4 3437943 ORA-12514 if database is created using new port listener in 2nd home
10.1.0.4 3447792 Multi-table insert can fail with ORA-24335
10.1.0.4 3452566 Start / abort of multiple instances can leave ASM diskgroup unmountable
10.1.0.4 3454691 XML parser error inserting valid XML with ampersands in CDATA tag
10.1.0.4 3456977 ORA-2046 using SQL with AUTOCOMMIT for DB link between 9i/10g and 8i
10.1.0.4 3465087 ORA-905 possible from CAST() over DB link if "AT" clause is a column name
10.1.0.4 3471389 OCIBindByPos fails for PLSQL associate array bind with varchar2(4000)
10.1.0.4 3472676 ArrayIndexOutOfBoundsException or corrupt data changing fetch size between fetches
10.1.0.4 3478459 DBMS_ADVISOR.TUNE_MVIEW does not work with multibyte DB
10.1.0.4 3479073 Capture process aborts with ORA-25303 alter ALTER QUEUE TABLE changing instance
10.1.0.4 3488157 Data pump import of list-partitioned IOT returns ORA-39083 / ORA-926
10.1.0.4 3492211 ORA-23308/ora-23309 replicating pre-created tables with LOB
10.1.0.4 3497949 Wrong results or ORA-1410 using stored outlines for CONNECT BY query
10.1.0.4 3500369 OERI[kohdtf048] / ORA-21780 / Memory leak from PLSQL
10.1.0.4 3502868 ORA-39002 / ORA-439 from IMPDP in Standard Edition
10.1.0.4 3510694 ORA-29875 (ORA-1402) raised during concurrent operations on Text indexes
10.1.0.4 3527043 ORA-6502 "character string buffer too small" for 1001 char if NLS_LENGTH_SEMANTICS=CHAR
10.1.0.4 3533428 ORA-904 SYS_TBL$3$.ID running query with GROUP BY CUBE and CONNECT BY
10.1.0.4 3535712 OERI[3020] / ORA-10567 from RAC with standby in max performance mode
10.1.0.4 3536149 Element name in SQLX XmlElement() function limited to 30 characters
10.1.0.4 3540821 ORA-4020 deadlock from concurrent ANALYZE index / query compilation against a cluster
10.1.0.4 3553962 ORA-18003 rebuilding an outline for SQL with leading spaces
10.1.0.4 3554494 ALTER TABLE SPLIT PARTITION fails with ORA-604 / ORA-933
10.1.0.4 3557842 ORA-903 with UNION ALL in a view
10.1.0.4 3573951 dbms_output.enable does not honor "buffer_size" correctly
10.1.0.4 3576897 ORA-22804 inserting over a database link with select using CASE
10.1.0.4 3578503 CLOB to VARCHAR2 assignment fails in PLSQL clients (ORA-6502)
10.1.0.4 3579567 Corrupt export exporting a compressed table with direct=y (IMP-9)
10.1.0.4 3588345 Create spatial index fails with ORA-13249
10.1.0.4 3591564 ORA-1756 importing functional index with CHR(0) in its expression
10.1.0.4 3595731 PCB-S-00400 with FORMAT=TERMINAL and using DECIMAL-POINT
10.1.0.4 3596139 ORA-10632 on direct path export of IOT
10.1.0.4 3597439 ORA-1153 starting managed recovery when an RMAN backup is running
10.1.0.4 3601775 IMPDP generates invalid SQL for sequences with large maxvalue (ORA-39083 ORA-933)
10.1.0.4 3609791 SQLCODE -310 / incorrect SCALE over HS for numbers with zeroes after the decimal place
10.1.0.4 3616743 ORA-24324 in OCCI trying to set a transaction on a service context
10.1.0.4 3618700 SQL apply/alter user/role fails with ORA-28003 / ORA-28221
10.1.0.4 3627650 ORA-701 / OERI:17058 from GRANT / REVOKE select ON OBJECT_USAGE
10.1.0.4 3628621 ORA-6502 from DYNAMIC SQL in AL32UTF8
10.1.0.4 3631932 SYS_OP_PAR() fails with ORA-979
10.1.0.4 3639020 XML processing instructions in a simpletype fails validation
10.1.0.4 3643391 ORA-4043 "object does not exist" using a SYNONYM of a TYPE in JDBC
10.1.0.4 3643476 RENAME of partition/subpartition can throw ORA-54
10.1.0.4 3644243 Create MVIEW on scalar subquery in SELECT list gives ORA-22818
10.1.0.4 3646305 ORA-942 from MVIEW refresh after dropping and recreating table
10.1.0.4 3648209 BACKUP .. FOR RECOVER OF COPY fails with RMAN-600[13215]
10.1.0.4 3649839 Intermittent ORA-12805 on internode parallel create/rebuild index
10.1.0.4 3650346 Public synonym resolution fails under certain circumstances
10.1.0.4 3662892 Procobol errors for HOST VARIABLE / COLUMN NAME with multibyte character
10.1.0.4 3668572 ORA-979 when CURSOR_SHARING = force|similar with inline view and GROUP BY
10.1.0.4 3671655 ORA-22805 flushing objects in OCCI in XA environment
10.1.0.4 3684796 ORA-904 when explaining GROUPING SETS query with fine grained auditing
10.1.0.4 3696284 ORA-1457 on FETCH after odefin for packed-decimal
10.1.0.4 3716255 ORA-21500 can occur querying an XMLType table with the fix for bug 3454829
10.1.0.4 3726694 First update with a new OLS label gets ORA-28115
10.1.0.4 3732747 False ORA-1007 using DBMS_SQL.DEFINE_COLUMN
10.1.0.4 3733108 ORA-20000 in DBMS_UTILITY.COMPILE_SCHEMA/ANALYZE_SCHEMA on mixed-case object names
10.1.0.4 3733669 Ultrasearch crawl removes already crawled tokens
10.1.0.4 3747472 ORA-14642 on EXCHANGE PARTITION INCLUDING INDEXES
10.1.0.4 3761784 Capture stops while mining through upgrade/patch on primary
10.1.0.4 3766568 ORA-6502 (VALUE ERROR) during trigger execution with codepoint semantics in multibyte
10.1.0.4 3766919 DRG-10837 after upgrade of UltraSearch to 10g
10.1.0.4 3769884 Apply aborts on first DML after handler changed when ORA-4068 encountered
10.1.0.4 3776668 ORA-1478 from distributed transaction between 8i<->9i with different character sets
10.1.0.4 3787344 ORA-32321 occurs when executing fast refresh
10.1.0.4 3804250 DML to a remote table from a table with FGA fails with ORA-904/ORA-2063
10.1.0.4 3818542 PLS-907 from pre-10g PLSQL client executing package with overloaded function
10.1.0.4 3831513 Import to different character set can fail (PLS-103) if PLSQL contains a NEWLINE in quotes
10.1.0.4 3858625 Insert of long over DB link with NULL binds may ORA-24343
10.1.0.4 3861534 ORA-31076 on registering xml schema with no "schemaLocation" <import> element
10.1.0.4 3866448 Online table redefinition encounters ORA-12018,ORA-904
10.1.0.4 3896963 ORA-942 when using WITH clause and UNION ALL together
10.1.0.4 3903530 UTL_HTTP HTTPS via proxy server requiring user authentication fails with ORA-29268
10.1.0.4 3907008 VARCHAR2 IN with bind size > 31 fails with ORA-6502
10.1.0.4 3933012 ORA-904 from IN subquery with UNION ALL having co-located remote references
10.1.0.4 3941862 ORA-16132 during regular graceful failover
10.1.0.4 3946694 XA recover throws ArrayIndexOutOfBoundsException
10.1.0.4 3953131 Altering first_scn of Streams capture results in ORA-30036 / ORA-1562
10.1.0.4 3973403 ORA-1562 / ORA-1581 using system managed Undo
10.1.0.4 3975111 IMP-3 / PLS-103 when importing a job created by DBMS_SCHEDULE
10.1.0.4 3982017 ORA-3106 PLSQL SELECT across 8i-9i-8i
10.1.0.4 3992072 ORA-1461 / ORA-2005 inserting a column after setNull() in OCCI
10.1.0.4 4015165 Unexpected ORA-6502 from PLSQL using host binds when using CHAR length semantics
10.1.0.4 4033756 RMAN "transport tablespace" fails with ORA-39123 / ORA-12911
10.1.0.4 4057408 LPX-216 / dump while extracting data from schema based
10.1.0.3 3514615 * CREATE CONTROLFILE can corrupt Oracle mirrored datafiles . This bug is alerted in Note:271571.1
10.1.0.3 3564573 * ORA-1017 when 10g client connects to 8i/9i server with EBCDIC <-> ASCII connection . This bug is alerted in Note:272000.1
10.1.0.3 2325578 OCIStmtFetch may return a false ORA-1002 instead of ORA-1403
10.1.0.3 2422432 StructDescriptor.createDescriptor() does not honor definer's rights
10.1.0.3 2622681 PreparedStatement.GetParameterMetaData() throws ORA-17023
10.1.0.3 2834541 IMP-93 on import when using the TOUSER parameter
10.1.0.3 2906197 Setting savepoint and rollback to savepoint results in nullpointerexeption
10.1.0.3 2919655 LOBs may not reuse space with automatic undo management
10.1.0.3 2929556 ORA-372 ORA-1110 inserting into partition with enable PARALLEL DML set
10.1.0.3 3128975 Listener cannot call pg4asrv / pg4t4ic directly / NCR-1003
10.1.0.3 3143435 JDBC Thin connecting to server with ASO and DCD gets NegativeArraySizeException
10.1.0.3 3159124 EXP-68 even though locally managed tablespaces are not offline
10.1.0.3 3173648 Describe of TG4DRDA object from 9.2 client errors (ORA-4043 / ORA-2063)
10.1.0.3 3175001 ORA-1426 REBUILDing Text index with more than 255 partitions
10.1.0.3 3236491 ORA-32332 possible during refresh of MVIEW
10.1.0.3 3259441 ORA-28545 when trying to resolve gateway TNS alias through Oracle Names
10.1.0.3 3263671 ORA-2019 from INSERT INTO .. SELECT from remote LOB using a PUBLIC synonym
10.1.0.3 3268331 ORA-27103 errors possible when using VLM
10.1.0.3 3270717 ORA-6510 enabling BIBeans/OLAPI access on imported AW with AWM
10.1.0.3 3283151 ORA-1461 can occur in JDBC Thin 10g binding a shift sensitive string to 9.2 DB
10.1.0.3 3285447 DBMS_STORAGE_MAP.MAP_ALL returns ORA-32504 for EMC Symmetrix disks
10.1.0.3 3288625 ORA-22621 / OERI:kopuigpfx1 using LOBs in OCI Extproc
10.1.0.3 3312423 Oracle JVM ConversionBufferFullException can occur converting Strings for some NLS values
10.1.0.3 3324661 Full export/import fails with IMP-17 / ORA-2494
10.1.0.3 3325395 ORA-130 can occur if Oracle tries to contact a local listener
10.1.0.3 3333076 ORA-39014 in logfile on STOP_JOB of EXPDP or IMPDP
10.1.0.3 3345208 ORA-28502 internal communication error on heterogeneous database link
10.1.0.3 3345441 Cannot load user workloads when workload query references views only
10.1.0.3 3352413 An ORA-8102 error can occur on ATEMPIND$ during a user UPDATE with CONSTRAINTS
10.1.0.3 3354447 UTL_FILE.FGETATTR returns ORA-1426 for files larger than 2Gb
10.1.0.3 3356492 DBMS_LOB.LOADFROMFILE leaks library cache locks / shared pool "perm" memory
10.1.0.3 3358440 AQ propagation fails with ORA-942 or OERI:16622 at the remote node
10.1.0.3 3365045 Functional index on DATE column can depend on NLS_DATE_FORMAT (ORA-8102 on DML)
10.1.0.3 3376521 ORA-4067 when running user.package.proc with late binding on
10.1.0.3 3383096 Parallel DML with foreign key constraints on partitioned tables fails with ORA-12839
10.1.0.3 3385076 Complex object retrieval may fail with OCI-21700
10.1.0.3 3387554 Oracle Wallet Manager fails for some certificates
10.1.0.3 3390187 ORA-1403 on 2nd execution of PLSQL stored procedure with TABLE parameter
10.1.0.3 3393962 ORA-972 on query with UNION ALL and internally generated column name over DBLINK
10.1.0.3 3396600 ORA-274 Incorrect recovery option list during RECOVER when some files are skipped
10.1.0.3 3397811 ORA-29279 from UTL_SMTP with Stalker Internet Mail server
10.1.0.3 3398064 Sybase gateway does not work with 12.0 Sybase client library
10.1.0.3 3398224 ORA-12015 on outer join MJV with decode statements
10.1.0.3 3400991 ORA-27504 IPC error creating OSD context under stress
10.1.0.3 3404500 ORA-604/ORA-1406 with QUERY_REWRITE_ENABLE=TRUE
10.1.0.3 3427810 ORA-907 "missing right parenthesis" with inline UNION view
10.1.0.3 3430870 ALTER TYPE of self referencing type body generates PLS-565 with trailing comments
10.1.0.3 3437884 10g client cannot connect to 8.1.7.0 - 8.1.7.3 server
10.1.0.3 3447478 ORA-6502 calling PLSQL over a DBLINK with RECORD parameters with UTF8/AL32UTF8
10.1.0.3 3449951 ORA-1562 can occur on DBMS_LOGMNR_SESSION.PURGE_SESSION or DBMS_CAPTURE.ALTER_CAPTURE
10.1.0.3 3453107 ORA-16061 when archiving standby redo logs after failover
10.1.0.3 3467567 ORA-1400 importing CLOB data
10.1.0.3 3468580 ORA-29871 for ALTER INDEX ENABLE on functional DOMAIN index
10.1.0.3 3469389 SQLLDR direct path may fail with ORA-26094 / OERI[klaprs_30]
10.1.0.3 3488761 SQLException "Closed Connection" from OracleXAConnection.getConnection()
10.1.0.3 3495629 False ORA-907 possible from inline view with ORDER BY
10.1.0.3 3498845 PLS-801 [phd_get_defn:unqualified external] referencing some STANDARD extensions in PLSQL
10.1.0.3 3502727 Using a batch size more than 16383 fails in JDBC 10g driver
10.1.0.3 3511851 Upgrade to 10g may fail with ORA-942
10.1.0.3 3522502 ORA-38435 executing a query using the EVALUATE operator
10.1.0.3 3530618 JDBC Thin from Applet fails with AccessControlException "access denied"
10.1.0.3 3552655 URL link extraction can produce wrong URL with '=' leading to WKG-30008
10.1.0.3 3566478 ORA-928 can occur with star transformation with CONNECT BY
10.1.0.3 3572128 HARD storage array may report HARD errors
10.1.0.3 3588880 ORA-1461 can occur in JDBC with a null Stream value

Internal Error May Occur (ORA-600)

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

Fixed in Release Bug Number Description
10.1.0.4 3691672 + OERI[17067]/ OERI[26599] / dump (kgllkdl) from JavaVM / OERI:1100 from PMON
10.1.0.4 3566420 P* Solaris: OERI:[KSLAWE:!PWQ] can occur in 9.2.0.5 on 64bit Oracle on Solaris . This bug is alerted in Note:271084.1
10.1.0.4 2708874 OERI:KGHALP1 / ORA-4030 using FORALL with SAVE EXCEPTIONS
10.1.0.4 2901988 PMON may crash the instance with OERI [k2gcbr:2] following ORA-2051
10.1.0.4 3072094 CATSEARCH query through a view fails with OERI [20084]
10.1.0.4 3144710 OERI[526] querying V$ tables over shared server connection
10.1.0.4 3228560 OERI[qkebValidateOpn:2] / dump under qkngbAllocate from FULL OUTER JOIN
10.1.0.4 3258674 QMN process may dump or raise an internal error during DML
10.1.0.4 3264527 OERI[12310] on SELECT with LEFT OUTER JOIN
10.1.0.4 3270444 OERI[msqopnws.gsets1] for GROUPING SET queries with correlated variables
10.1.0.4 3333978 Cannot register certain schemas (OERI:qmtsAddSRef1)
10.1.0.4 3350337 OERI[17183] / OERI:17281 can occur
10.1.0.4 3365439 OERI[evapth : unexpected evaluation] using SYS_CONNECT_BY_PATH
10.1.0.4 3372217 OERI[kclfadb_5] possible in RAC
10.1.0.4 3372242 OERI[kjxbdomps2m:!survivor] possible during reconfiguration in RAC
10.1.0.4 3382648 OERI[kcrradfini.1] possible from ARCH
10.1.0.4 3384300 OERI[opixrm-1] [invalid handle] for remote mapped SQL (over DB link)
10.1.0.4 3385457 OERI [150] with event 28266
10.1.0.4 3385843 OERI [kclchkinteg_19] / crash during instance recovery in RAC (rare)
10.1.0.4 3400979 Dump of FILE_HDRS may hang or error (can result in OERI [2103])
10.1.0.4 3439552 OERI[4406] possible in SMON using automatic undo management
10.1.0.4 3440376 OERI[kclfadb_2] / LMS crashes the instance
10.1.0.4 3455402 Concurrent DROP / ALTER TABLESPACE READ ONLY can corrupt the dictionary
10.1.0.4 3471271 Dump / OERI[25012] when _old_connect_by_enabled = true
10.1.0.4 3476889 EXPDP fails with OERI[ktcsetscn-1] with large SCN value
10.1.0.4 3477524 OERI[kfgscdelete_10] after IO error in ASM
10.1.0.4 3481959 SQLX query using ROWNUM fails with OERI [15160]
10.1.0.4 3482748 LMS may die with OERI:kclfbbast_2
10.1.0.4 3488371 OERI[17113] can occur during import of materialized views
10.1.0.4 3489246 OERI[pitl1] / ORA-1498 ANALYZING table transported from 8.1.7 to 9.2.0
10.1.0.4 3492040 OERI selecting from V$LOGMNR_CONTENTS for long DDL
10.1.0.4 3500369 OERI[kohdtf048] / ORA-21780 / Memory leak from PLSQL
10.1.0.4 3505528 OERI[kjlfr_1] in LMD during startup when instance is low on memory
10.1.0.4 3525940 OERI[kkqscard-1] possible with query rewrite (ENFORCED)
10.1.0.4 3529179 OERI from "select empty_clob()" into varchar2 variable
10.1.0.4 3535712 OERI[3020] / ORA-10567 from RAC with standby in max performance mode
10.1.0.4 3537185 OERI[kfcdeadlockavoid02] adding file in ASM
10.1.0.4 3546174 OERI[kcbgtcr_1] from subquery unnesting of a subquery containing a TABLE() function
10.1.0.4 3554319 OERI[kqludp2] can occur adding a RULE to a RULESET
10.1.0.4 3557906 OERI[qctcte1] from predicate move around
10.1.0.4 3560900 OERI[kcbchg1_3] during direct path insert
10.1.0.4 3565660 OERI[kclrinit_3] from parallel recovery in RAC
10.1.0.4 3566124 OERI[insrow-1] during array insert with SAVE EXCEPTIONS and IOT
10.1.0.4 3570286 OERI[733] from high use of application context (DBMS_SESSION.SET_CONTEXT)
10.1.0.4 3572299 Tablespace recovery of offline tablespace fails with OERI[kcrrlcmp.10]
10.1.0.4 3572753 OERI[kghstack_underflow_internal_2] taking backup of controlfile via RMAN
10.1.0.4 3573149 OERI [kfcmount15] after ASM crash when remounting diskgroup
10.1.0.4 3573604 A transported bitmap index can give various OERI errors / ORA-8102
10.1.0.4 3577772 OERI[kcbgkcbcr_1] possible from PQO
10.1.0.4 3595110 OERI[12337] from multi-column INLIST with partitioned table
10.1.0.4 3607694 OERI:[15805] using PDML with array binds
10.1.0.4 3608038 OERI[kclshrshr_8] possible in RAC
10.1.0.4 3608307 OERI[7001] / dictionary corruption from upgrade/downgrade with materialized views
10.1.0.4 3610343 OERI:[ktbdchk1: bad dscn] in RAC
10.1.0.4 3612581 OERI[kpofdr-long] can occur on SELECT
10.1.0.4 3613126 ALTER DATABASE DATAFILE OFFLINE can cause OERI[kcfquewr_2] / crash in RAC
10.1.0.4 3614008 OERI[kjcs_m:2]
10.1.0.4 3615072 PMON can crash the instance with [plio.c: non-reusable inst]
10.1.0.4 3617191 OERI[qmxdmatchingchildren:overflow-1] using EXTRACT from large XML document
10.1.0.4 3621300 OERI[krvseds get obj] while handling thread enable/disable in logical standby
10.1.0.4 3627650 ORA-701 / OERI:17058 from GRANT / REVOKE select ON OBJECT_USAGE
10.1.0.4 3631915 Logical apply errors with OERI:kdogsli1 and ORA-1332
10.1.0.4 3635331 Stuck recovery (OERI:3020) / ORA-1172 on startup after a crash
10.1.0.4 3639267 Dump executing a join with a registered schema
10.1.0.4 3641398 OERI[kjbmiconsign:ds] possible in RAC
10.1.0.4 3649683 OERI:KGHALO2 / OERI:KGHALP1 on a query with large number of predicates
10.1.0.4 3649979 OERI[qesmmCValStat4] from star transformation
10.1.0.4 3657023 OERI[kcblco_1] possible from HASH joins with migratable sessions
10.1.0.4 3663357 OERI[koktrpltd1] in object type evolution
10.1.0.4 3666502 OERI[1236] can occur intermittently in a shared server
10.1.0.4 3671867 OERI[kclchkinteg_2] possible in RAC environment
10.1.0.4 3679892 Create partitioned bitmap index in parallel reports "Bad cvl" to the trace
10.1.0.4 3687456 OERI[ktspgetmyb-1] / Corrupt LOB if EXTENT size not multiple of LOB CHUNK SIZE
10.1.0.4 3687949 Logical standby may not restart properly at start of PDML/PDDL
10.1.0.4 3714207 OERI[5021] trying to migrate system tablespace to local
10.1.0.4 3722208 OERI[kjzgpoll1] from DIAG process if ocssd shuts down
10.1.0.4 3724548 OERI[kglhdunp2_2] / OERI[1100] under high load
10.1.0.4 3731315 CREATE IOT with PK constraint may throw OERI [15803]
10.1.0.4 3741962 OERIs due to incorrect buffer cache latch cleanup
10.1.0.4 3751874 OERI[25012] can occur when _old_connect_by_enabled set to true
10.1.0.4 3754474 OERI[kghfre3] possible with heavy IO workload
10.1.0.4 3754773 OERI:kcbsor_2 block recovery failure can occur
10.1.0.4 3756960 OERI[17159] / instance crash possible with EVENT:10235 set
10.1.0.4 3757136 OERI:3050 during BMR (Block Media Recovery) through a RESETLOGS
10.1.0.4 3762714 ALTER DATABASE RECOVER MANAGED STANDBY fails with OERI[3020]
10.1.0.4 3772033 OERI[ktspfmb_create1] creating a LOB in ASSM using 2k blocksize
10.1.0.4 3785459 Dump (evaopn2) when updating a view with an INSTEAD OF trigger
10.1.0.4 3788879 Streams capture process does not abort on OERI[17112]
10.1.0.4 3789406 OERI[17281][4068] when closing cursors for invalid PLSQL packages
10.1.0.4 3798917 Duplicate DEFAULT_TBS_TYPE in DBA_PROPERTIES after upgrade to 10g
10.1.0.4 3799433 OERI[1402] when running a global hanganalyze or dumping SYSTEMSTATE
10.1.0.4 3800160 Internal error / memory corruption using ASM with KST trace
10.1.0.4 3800614 OERI[12410] from SQL with analytic functions
10.1.0.4 3800634 OERI [kghstack_free1] [knlucanon:res_buf] can occur in Streams
10.1.0.4 3800644 OERI [kghstack_free1] [kniascg: cgpi_knictx] can occur in Streams
10.1.0.4 3803404 Dequeue may fail with OERI:4406
10.1.0.4 3803424 OERI:kghstack_underflow_internal_1 querying GV$ views
10.1.0.4 3803446 OERI[vopuasjct(2): Illegal Expression] can occur optimizing SQL
10.1.0.4 3812876 OERI[kwqidrdq-buf1] in RAC after buffer ownership changes
10.1.0.4 3814603 OERI[kccsbck_first] from CSS problem with split brain resolution
10.1.0.4 3815890 OERI[krccabt_last] when file expanded with block change tracking enabled
10.1.0.4 3817705 OERI[18301] / OERI[4415] from XA
10.1.0.4 3817792 OERI[6100] while coalescing an index
10.1.0.4 3819011 OERI[23050] on DML against a table with OBJECT columns in a replication group
10.1.0.4 3819836 OERI[1155] / instance crash possible
10.1.0.4 3827053 OERI[kcbzfb_4] possible if process killed
10.1.0.4 3829900 OERI[25027] possible accessing index in 10g
10.1.0.4 3832099 OERI[kcbgtcr_13] can occur in RAC
10.1.0.4 3832611 OERI[kwqpaspse:!new] scheduling propogation from non-owner instance
10.1.0.4 3833596 OERI:prssubpspec14 from ALTER MVIEW subpartition specification
10.1.0.4 3833809 Direct load with code conversion can fail with OERI[klaevc_01]
10.1.0.4 3843318 OERI[ksxpwait10] / hang possible in RAC
10.1.0.4 3851225 OERI:[kcsbcscn13] can occur under heavy load
10.1.0.4 3854034 OERI[733] optimizing SQL using bitmap indexes
10.1.0.4 3859298 Block corruption with high INITRANS or rapid ITL growth.
10.1.0.4 3865157 OERI [kkzumco2:4] using DBMS_REDEFINITION with more than 10 constraints
10.1.0.4 3872410 Corrupt PLSQL collection after copying empty collection
10.1.0.4 3873324 OERI[kslfget_pvt1] inserting XML with comments over 4k
10.1.0.4 3892704 During reconfiguration processes may fail with OERI:kjuocl1
10.1.0.4 3897017 OERI:15239 from ALTER TRIGGER .. ENABLE
10.1.0.4 3901170 False OERI [kghiexchk:ds] with event 10235 or 10501 set
10.1.0.4 3906669 LMS may fail with OERI[kjbmpclo:cvt]
10.1.0.4 3912435 OERI[kokegpinlob1] / OracleXMLSQLException from DBMS_XMLSLAVE
10.1.0.4 3913642 OERI[knlqdqm2usr:4] / incorrect data at Logical Standby
10.1.0.4 3917581 PLS-801 [23411] doing implicit conversion from NUMBER to LONG
10.1.0.4 3925815 OERI[kjccfmb:x!] possible in a RAC environment
10.1.0.4 3928828 OERI[kghfrh:ds] / memory corruption from AQ
10.1.0.4 3935714 OERI[kokax_oct_adtcbk5] while extracting data from schema based table
10.1.0.4 3936811 Rare OERI[kjbrass:2scn] after RAC reconfiguration
10.1.0.4 3938376 OERI[15160] accessing via a bitmap join index
10.1.0.4 3952778 ASM instance crash OERI[kffmxpresize] when shrinking / growing file
10.1.0.4 3953494 ASM instance may crash with OERI[kfkupdateufsreq1] after rebalance of diskgroup
10.1.0.4 3955411 OERI[kfiosubmitio07] signalled after recovering from a block corruption
10.1.0.4 3963092 OERI[qctcte1] compiling SQL with ORDER BY .. DESC
10.1.0.4 3975816 OERI[kjbrref:!ini] in RAC
10.1.0.4 3996802 "alter system kill session" can crash the instance if IO slaves used
10.1.0.4 4000840 Update can cause block corruption
10.1.0.4 4010945 OERI[qctstc2o1] from nested subquery with >= 2 levels of nesting
10.1.0.4 4011826 OERI:kfcGetPin01 on ASM instance if disk out of space
10.1.0.4 4036717 Truncate table in exception handler can causes OERI:kcbzwb_4
10.1.0.4 4066077 OERI[kwqbcgetcorr555] the failover capture with online target database
10.1.0.4 4115918 OERI[784] in ASMB
10.1.0.4 4131721 Process may fail with OERI:kjsmbesmi1 in RAC
10.1.0.4 4153253 GCS master may hold lower mode than GCS client (rare)
10.1.0.3 3123232 OERI[ksuloget4] / dump selecting from V$SESSION_LONGOPS / OERI on "long op" operations
10.1.0.3 3148830 Select over database link fails with OERI[opixmp-7] if CURSOR_SHARING=similar
10.1.0.3 3167925 XDB may dump / OERI updating an ACL
10.1.0.3 3209932 OERI[kpoblblen: pos1] during re-execute of a pl/sql block
10.1.0.3 3238383 OERI[qmhsesskeybuf] can occur during an HTTP connection to XDB
10.1.0.3 3248893 OERI [17285] possible if TABLE() function invalidate
10.1.0.3 3262648 Logical Apply may OERI[krvuffl: memsize below zero]
10.1.0.3 3288625 ORA-22621 / OERI:kopuigpfx1 using LOBs in OCI Extproc
10.1.0.3 3294293 OERI[12455],[pti:qkaqkn] on SELECT FOR UPDATE of partitioned table with WINDOW functions
10.1.0.3 3312664 OERI[kcbrbo1] after downgrade from 9.2.x or higher to 8.1
10.1.0.3 3315960 OERI:736 / dump (in kxsbndinf) re-executing SQL after an ORA-1461 failure
10.1.0.3 3326634 OERI[qertqgetcolumndef2] / OERI:15800 from parallel MERGE
10.1.0.3 3334402 OERI:kodpunp1 OERI:kope2_readstr232 can occur with large collections
10.1.0.3 3347963 OERI [6120] during compressed IOT insert
10.1.0.3 3358440 AQ propagation fails with ORA-942 or OERI:16622 at the remote node
10.1.0.3 3361118 OERI:[7999] / LOB corruption updating a LOB in a SERIALIZABLE transaction
10.1.0.3 3384299 OERI[kjbrrcon:cl] possible on buffer cache shrink in RAC
10.1.0.3 3397181 ALTER SYSTEM KILL SESSION of recovery slave causes stuck recovery
10.1.0.3 3400883 OERI[kjblconsign:md] possible in RAC
10.1.0.3 3401014 OERI[krbrrd_kgcddo_fails] restoring from backed up flash recovery area
10.1.0.3 3403305 Internal change to memory allocation (reduce memory corruption issues)
10.1.0.3 3407944 OERI[5254] / dump (ktagttl) or spin from Ctrl-C of a query
10.1.0.3 3412999 OERI[kcrfrgv_scn6] on "alter database recover ... finish"
10.1.0.3 3430832 OERI[25012] in DML after ONLINE create index against PARTITIONED table
10.1.0.3 3449174 Attempt to supplementally log LONG column can OERI/dump
10.1.0.3 3452686 OERI[ktcrsp_1: drop/truncate not comp] possible in RAC at end of reconfiguration
10.1.0.3 3468584 OERI[qctchr : bfl] possible for SQL with TABLE() and inline views
10.1.0.3 3469389 SQLLDR direct path may fail with ORA-26094 / OERI[klaprs_30]
10.1.0.3 3469775 DBMS_XMLGEN.CONVERT can fail with OERI[17112]
10.1.0.3 3475775 CKPT may fail with OERI[1621] during shutdown
10.1.0.3 3484944 OERI[kjbrclo:gq] possible if a side-channel message is processed during process death
10.1.0.3 3496324 OERI[2886] changing tablespace from "read only" to "read write" access
10.1.0.3 3503661 ASM "ALTER DISKGROUP ADD DISK" can crash database
10.1.0.3 3508674 OERI:ksmovrflow creating MVIEW in 8i/9i with 10g master table
10.1.0.3 3514664 OERI[504][ges process hash list] possible in RAC during diagnostics dump
10.1.0.3 3542633 OERI[kjbstrec] in instance recovery in RAC
10.1.0.3 3549693 OERI:[ktsircinfo_num1] during ALTER DATABASE OPEN READ ONLY
10.1.0.3 3549886 PMON may crash an instance with OERI:KSSRMP1
10.1.0.3 3552489 OERI:kjbcropen:flockp possible if RAC process killed
10.1.0.3 3610978 OERI [krvscst failure] possible during switchover
10.1.0.3 3613078 OERI[4097] from DML on TRANSPORTED tables with ASSM
10.1.0.3 3646771 OERI [KSSRMP1] can occur
10.1.0.3 4112324 OERI[16608] possible from some queries with pushed join predicates

Process May Dump / Abend / Abort

The following table lists the Process May Dump / Abend / Abort bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.1.0.4 3691672 + OERI[17067]/ OERI[26599] / dump (kgllkdl) from JavaVM / OERI:1100 from PMON
10.1.0.4 1867670 Dump when using a trigger on an ADT or TIMESTAMP column
10.1.0.4 2363758 Returning NULL from an EXTPROC callout may dump
10.1.0.4 2901149 Dump (opiomc) in killed / idle time sniped session
10.1.0.4 3085933 Semijoin elimination may dump if the subquery contains virtual column expression
10.1.0.4 3105313 Dump[strlen] when performing a domain-index search with a UNION
10.1.0.4 3228560 OERI[qkebValidateOpn:2] / dump under qkngbAllocate from FULL OUTER JOIN
10.1.0.4 3250883 Inline view using functional index can give wrong results
10.1.0.4 3258674 QMN process may dump or raise an internal error during DML
10.1.0.4 3273522 Dump (qerpxsetparttq()+588] doing select on partitioned table parallel
10.1.0.4 3315725 Dump [qmxtgGetOpqImageFromXob] when result of XMLTransform is null
10.1.0.4 3319215 TAF client may dump if failover occurs during authentication
10.1.0.4 3348585 Dump (in LNXMIN) using WINDOW functions with CASE/DECODE
10.1.0.4 3364554 Dump in kcbsacc /kcbs_free_granule_sim_buffers (rare)
10.1.0.4 3386041 RMAN list backup of spfile sometimes dumps
10.1.0.4 3387588 Dump (lnxdiv) updating partitioned table
10.1.0.4 3396792 Dump (qmxtrRewriteOpn) using XDB
10.1.0.4 3398060 The SSL Net layer may dump due to an uninitialized variable
10.1.0.4 3406609 Improved trace file dumping resilience to corruptions
10.1.0.4 3424847 OCI client code may dump during logon
10.1.0.4 3449866 Dump (opitca) from SQL with select list subquery inside a simple view
10.1.0.4 3453969 Dump (ttcc2u) with with array / null binds
10.1.0.4 3463926 Dump (evaopn2) possible from UNNEST of a subquery column
10.1.0.4 3471271 Dump / OERI[25012] when _old_connect_by_enabled = true
10.1.0.4 3476594 Dump (kokax_set_existsvec) using XMLSEQUENCE with "//"
10.1.0.4 3491172 Dump (qctset) on insert as select with a SET operator
10.1.0.4 3494888 PDML can cause apply to stop / dump
10.1.0.4 3513629 Dump (vopqbc) from query with OLS and CAST(MULTISET())
10.1.0.4 3516231 SELECT from a view with a TABLE function may dump
10.1.0.4 3543293 Dump (qmuhshge) inserting into VARRAY of SUBTYPE column inline
10.1.0.4 3553302 Dump (qmxluMoveToHead) selecting from schema with anyType stored as a CLOB
10.1.0.4 3561624 Dump possible from HASH join with large hash_area_size > about 18Mb
10.1.0.4 3564070 Split partition dumps when a local primary key index exists
10.1.0.4 3566813 Dump from CTAS with UNION and ORDER BY of CHAR columns
10.1.0.4 3569138 Dump (kdiins0) during insert/update of compressed key index or compressed IOT
10.1.0.4 3583215 Dump (qersoRowP) with complex view merging and subquery in SELECT list
10.1.0.4 3584486 Client dump possible using SNS
10.1.0.4 3586048 CRSD may crash on surviving node if OCR master node fails to access OCR disk/file
10.1.0.4 3594734 Dump when accessing HS table with over 20 indexes
10.1.0.4 3608916 Dump / ORA-21527 selecting from XDB Schema
10.1.0.4 3611945 LMS may dump processing a BAST after a cache resize operation
10.1.0.4 3625392 wrong results / dump (evaopn2) with star transformation
10.1.0.4 3628474 Select on empty table with functional index may dump in kpobav
10.1.0.4 3628622 Dump possible selecting from V$RESOURCE_LIMIT
10.1.0.4 3630053 Dump (kkfipf) querying a table using a DESC index with OUTER join
10.1.0.4 3635177 Dump [KXCCUIN] possible from DML with concurrent ONLINE index rebuild
10.1.0.4 3637788 Dump (kccdmp_block) dumping diagnostics
10.1.0.4 3648249 SQL may dump (in KKOGTP) during parse
10.1.0.4 3661254 Dump with partitioned tables and INLIST
10.1.0.4 3668077 "rollback to savepoint" in a distributed transaction dumps
10.1.0.4 3672876 Dump on execution of a MERGE statement in replication
10.1.0.4 3683056 Wrong results possible from nested loop join with index scan
10.1.0.4 3695271 Dump (kkojije) with bitmap index and multi column inlist
10.1.0.4 3697218 Dump (qecvco) from SQL referencing ROWID from a view which is key preserved
10.1.0.4 3703176 OERI[evapth : unexpected evaluation] selecting from set view using SYS_CONNECT_BY_PATH
10.1.0.4 3730394 Dump (qerixGetKey) from ANSI SQL with HAVING clause which uses a subquery
10.1.0.4 3742371 Dump (kkpapUsedInSum) possible from query on partitioned table with subquery
10.1.0.4 3753429 Dump [kkooqb] from subquery unnesting with COUNT(*) in WHERE clause
10.1.0.4 3759147 Dump in koksfoc from import of CREATE VIEW with opaque types
10.1.0.4 3765931 ALTER TABLE ... SPLIT PARTITION may dump in msqtnm()
10.1.0.4 3774546 OCILobRead may dump in kghalo() if there is character set conversion
10.1.0.4 3775570 Dump [memcpy] ORA-12805 during Logical Standby apply
10.1.0.4 3779927 Dump (under qxidmid) from INSERT INTO with a DOMAIN index
10.1.0.4 3786302 ANSI join with correlated TABLE() clause fails (ORA-904)
10.1.0.4 3800160 Internal error / memory corruption using ASM with KST trace
10.1.0.4 3804828 Dump [qmtcreatebody] on SELECT / describe of XML table
10.1.0.4 3810088 Cannot drop a table with a TYPE with associated user statistics
10.1.0.4 3811391 Updates to IOTs beyond column 255 in non-key piece can corrupt the IOT
10.1.0.4 3816946 Dump (kafger) / wrong results from table scan of compressed table
10.1.0.4 3819834 Dump (kkslflb) with literal replacement
10.1.0.4 3823887 Dump / wrong results from NVL expansion
10.1.0.4 3827085 Dump from multi-column inlist with bitmap join index
10.1.0.4 3838121 Dump calling dbms_cdc_subscribe.subscribe()
10.1.0.4 3842253 Dump (kgghash) using literal replacement
10.1.0.4 3847292 Dump (in kkeLogGetCColNDV) from pushed join predicate
10.1.0.4 3848724 Dump [kdapblkcntt] rebuilding indexes with ONLINE or COMPUTE STATISTICS
10.1.0.4 3852274 Dump / wrong result from invalid AL32UTF8 character
10.1.0.4 3854375 Dump (kxtivwt) updating a view with a trigger on it
10.1.0.4 3872722 Dump (qkaProjRwo) possible for certain SQL with OR expansion
10.1.0.4 3874825 Dump (kkoppjt) due to join predicate push down
10.1.0.4 3875155 RAC startup with SVRCTL / GSD may dump / cause connections to fail
10.1.0.4 3884912 Dump (kghalp) can occur
10.1.0.4 3884962 Dump [kxspoac] / wrong results possible with SQL from PLSQL
10.1.0.4 3889303 Dump under sprintf from JavaVM
10.1.0.4 3895546 Capture may dump after certain DDLs
10.1.0.4 3909951 Dump *kpobav) possible
10.1.0.4 3921399 ASM instance may dump (in ksfdckare) when disks go offline
10.1.0.4 3940412 PMON dump (kgllccl) cleaning up a killed process
10.1.0.4 3941443 "isSchemaValid" dump in qmxInsertNodeBefore
10.1.0.4 3948711 XA with database links may dump or perform slowly (link closed)
10.1.0.4 3949188 Dump (kopxccc) when calling a procedure over database link
10.1.0.4 3949254 Dump possible with query rewrite with GROUPING SETS
10.1.0.4 3958875 Dump / memory corruption from Text index of EMAIL with long epilogue
10.1.0.4 3962643 Dump / corruption using user defined operators
10.1.0.4 3965425 Dump / OERI selecting from DB2/400 with ISOLATION_LEVEL=RR
10.1.0.4 3983589 Dump (LdiDateFromArray) possible refreshing MV with TIMESTAMP/LOB columns
10.1.0.4 3983699 Dump (pfrdef1_get_tdo or kgicsr) with SERIALLY REUSABLE packages with ADTs
10.1.0.4 3988801 Dump (ldxsto or lxhasc) in Logical standby apply
10.1.0.4 4001799 Dump from complex Text query
10.1.0.4 4004225 Dump possible (kkpapbDCopy2) for SQL against a composite partitioned table
10.1.0.4 4016066 Extract from XMLType table dumps in kxsffir
10.1.0.3 2631217 Internal heap manager (KGH) may dump rather than signal an OERI 17xxx error
10.1.0.3 2930122 Java stored procedure may dump
10.1.0.3 3043199 Dump in lxsCnvNumStrToInt possible from TO_DATE in shift-sensitive character set
10.1.0.3 3123232 OERI[ksuloget4] / dump selecting from V$SESSION_LONGOPS / OERI on "long op" operations
10.1.0.3 3128021 Corrupt column data after EXCHANGE PARTITION with row dependencies
10.1.0.3 3167925 XDB may dump / OERI updating an ACL
10.1.0.3 3199908 Dump (in kkmmctbf) from a DELETE TRIGGER compiled in DEBUG mode
10.1.0.3 3222625 HS gateway may dump (in horsh) when doing an array fetch
10.1.0.3 3231814 Client may dump if AQ unregister fails and the subscription handle is freed
10.1.0.3 3250970 Dump (in hokbrp) inserting into a remote table via transparent gateway
10.1.0.3 3253133 Dump (in evaopn2) from queries using a FUNCTIONAL INDEX with complex view merging
10.1.0.3 3261962 Dump (in qerixGetKey) using function based indexes with a join
10.1.0.3 3265740 Corrupt column data after PARTITION maintenence with ROWDEPENDENCIES
10.1.0.3 3269146 DML RETURNING with a DATE datatype may dump in the client
10.1.0.3 3300118 Memory corruption / dump from SDO_INTERSECTION with 'WALKING'
10.1.0.3 3315960 OERI:736 / dump (in kxsbndinf) re-executing SQL after an ORA-1461 failure
10.1.0.3 3321767 Dump possible (in xtyqbcb) from CTAS with a SEQUENCE
10.1.0.3 3331075 ProCobol precompiler can dump with too many EXEC CICS in a row
10.1.0.3 3342768 Dump performing a hierarchical query on an inline view with a TABLE clause
10.1.0.3 3348437 Intermittent dump in kzrtevw() possible in OLS environment
10.1.0.3 3354470 Dump possible during "alter database rename file"
10.1.0.3 3358065 Dump (kkoiop) using bitmap join index
10.1.0.3 3368863 KVSIZE on composite btree may error / dump
10.1.0.3 3370917 Summary metadata corrupted during REFRESH if MVIEW has inline views
10.1.0.3 3376491 AQ job queue processes dump in kponcbk
10.1.0.3 3382501 OPTIMIZER_MODE=FIRST_ROWS_KK may dump in kkecdn
10.1.0.3 3407944 OERI[5254] / dump (ktagttl) or spin from Ctrl-C of a query
10.1.0.3 3411748 OCI7 SELECT FOR UPDATE over DBLINK may dump client in kpuridalo1
10.1.0.3 3414440 Query rewrite may spin in qsmg_process_sqltxt for ANSI join in a view
10.1.0.3 3418232 ProCobol application may dump at runtime using COMP1=INTEGER
10.1.0.3 3425196 Dump in sqldhb using V8 OCI XA with Precompiled code
10.1.0.3 3449174 Attempt to supplementally log LONG column can OERI/dump
10.1.0.3 3451741 Dump (gxtsnGetPar) creating Text index with THEMES=YES
10.1.0.3 3453408 Intermittent dump (in lxkLikeMBNS) possible from LIKE '%' from JDBC
10.1.0.3 3467414 LIKE operations may dump in lxklike.. functions in UTF8/multibyte
10.1.0.3 3477127 Dump (kollgsz) when OCIStmtFetch2 fetches a NULL CLOB
10.1.0.3 3512123 Dump (evaopn2) with BETWEEN predicate on PARTITIONED table
10.1.0.3 3524401 DBMS_DEBUG.GET_VALUE fails for package variables on larger packages
10.1.0.3 3532846 Dump (kditdes) / Dump (ktaftt) from concurrent SDO_RELATE operations in MTS
10.1.0.3 3545539 Dump under kgmexec->kglpnp using trusted callouts / domain indexes / Oracle Text
10.1.0.3 3555167 BMS_STATS.GATHER_FIXED_OBJECTS_STATS may dump in kqlfcc
10.1.0.3 3564337 Dump possible in kopepwlen

Task Related

The following tables list bugs in the Task Related category.

Instance Startup

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

Fixed in Release Bug Number Description
10.1.0.4 3345155 Hang reopening standby database
10.1.0.4 3458327 dbstart / dbshut do not work with ASM
10.1.0.4 3505528 OERI[kjlfr_1] in LMD during startup when instance is low on memory
10.1.0.4 3540225 Dump (ldxmfncom) during startup after "FLASHBACK DATABASE"
10.1.0.4 3612867 Database startup with ODM may fail with ORA-1115 errors
10.1.0.4 3627263 Deadlock / hang during RAC instance startup
10.1.0.4 3635331 Stuck recovery (OERI:3020) / ORA-1172 on startup after a crash
10.1.0.4 3752301 OERI:16305 at startup if unresolvable node in invited nodes list
10.1.0.4 3875155 RAC startup with SVRCTL / GSD may dump / cause connections to fail
10.1.0.3 3514615 * CREATE CONTROLFILE can corrupt Oracle mirrored datafiles . This bug is alerted in Note:271571.1
10.1.0.3 3312664 OERI[kcbrbo1] after downgrade from 9.2.x or higher to 8.1
10.1.0.3 3549693 OERI:[ktsircinfo_num1] during ALTER DATABASE OPEN READ ONLY

Migration / Upgrade / Downgrade

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

Fixed in Release Bug Number Description
10.1.0.4 3883156 I ORA-6502 from DBMS_XDBZ0.MIGRATE_PITRIG when patching to 9.2.0.5
10.1.0.4 4017275 I 10.1.0.2 CRS fails to start if CRS 10.1.0.3 running first
10.1.0.4 3431498 extract and existsnode may ORA-29900 with three operands
10.1.0.4 3608307 OERI[7001] / dictionary corruption from upgrade/downgrade with materialized views
10.1.0.4 3798917 Duplicate DEFAULT_TBS_TYPE in DBA_PROPERTIES after upgrade to 10g
10.1.0.4 3919928 Streams dictionary upgrade to 10g fails to replace partition definitions
10.1.0.4 3928367 DBUA upgrade of Spatial stops if COMPATIBLE < 10.0
10.1.0.4 3972938 ORA-39704 upgrading Spatial
10.1.0.3 3841411 *P CLOB corruption after upgrade from 10.1.0.2 to 10.1.0.3 on some platforms . This bug is alerted in Note:281209.1
10.1.0.3 3312664 OERI[kcbrbo1] after downgrade from 9.2.x or higher to 8.1
10.1.0.3 3405535 ENH: utlu101i.sql script should display any INVALID components
10.1.0.3 3430486 "catpatch" does not check the installed version of components
10.1.0.3 3462254 interMedia INVALID after upgrade from 9.2.0.1 - 9.2.0.3 to 10g
10.1.0.3 3511851 Upgrade to 10g may fail with ORA-942

Performance Monitoring

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

Fixed in Release Bug Number Description
10.1.0.4 2696924 Missing "STAT" lines in raw trace file produced by SQL_TRACE
10.1.0.4 2738493 Wrong "session connect time" / "process last non-idle time" in V$SYSSTAT
10.1.0.4 3351150 V$SQL_BIND_CAPTURE shows NULL bind names for duplicate binds
10.1.0.4 3472564 "CPU used by this session" wrong when using job queue processes
10.1.0.4 3500762 V$SYSMETRIC_HISTORY "current logons" count is wrong
10.1.0.4 3528361 "ksfd: async disk IO" waits recorded incorrectly when using ASM
10.1.0.4 3559340 V$OSSTAT may contain no data on some platforms with large number of CPUs
10.1.0.4 3584809 Shared pool advisory can give misleading information
10.1.0.4 3669074 Some V$SHARED_POOL_RESERVED contain incorrect data
10.1.0.4 3697914 awrrpt fails (ORA-6502) for SQL over 4000 characters long
10.1.0.4 3720104 Fix for BUG 2276769 can cause SQL monitoring difficulties
10.1.0.4 3770162 DBMS_MONITOR enabled traces not enabled after instance restart
10.1.0.4 3803424 OERI:kghstack_underflow_internal_1 querying GV$ views
10.1.0.4 3876475 "class slave wait" has the wrong wait classification
10.1.0.4 4137362 Idle Oracle Forms sessions incorrectly appear in Active Session History
10.1.0.3 3371796 Explain plan spins in kkorminl
10.1.0.3 3437636 "servers highwater" in V$PX_PROCESS_SYSSTAT can be wrong briefly

Recovery

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

Fixed in Release Bug Number Description
10.1.0.4 3297412 ORA-16067 during media recovery after logfile added
10.1.0.4 3382648 OERI[kcrradfini.1] possible from ARCH
10.1.0.4 3557094 "NID" leaves stale v$recovery_file_dest information
10.1.0.4 3565660 OERI[kclrinit_3] from parallel recovery in RAC
10.1.0.4 3635331 Stuck recovery (OERI:3020) / ORA-1172 on startup after a crash
10.1.0.4 3754773 OERI:kcbsor_2 block recovery failure can occur
10.1.0.4 3757136 OERI:3050 during BMR (Block Media Recovery) through a RESETLOGS
10.1.0.4 3787196 ASM archivelogs not found automatically when executeing recover database
10.1.0.4 3869643 ORA-1552 from manual TSPITR when SYSTEM tablespace is locally managed
10.1.0.4 3955411 OERI[kfiosubmitio07] signalled after recovering from a block corruption
10.1.0.3 3514615 * CREATE CONTROLFILE can corrupt Oracle mirrored datafiles . This bug is alerted in Note:271571.1
10.1.0.3 3544995 + LOB segments with "CACHE READS" generate no REDO even with the logging option
10.1.0.3 3354470 Dump possible during "alter database rename file"
10.1.0.3 3397181 ALTER SYSTEM KILL SESSION of recovery slave causes stuck recovery
10.1.0.3 3420040 Database open fails with ORA-376 if SYSAUX datafile is offline
10.1.0.3 3475932 Cross instance archive log not generated remotely
10.1.0.3 3497588 Media recovery checkpoint slow when recovering a large number of datafiles
10.1.0.3 3572128 HARD storage array may report HARD errors

SQL Commands / Features Used

The following tables list bugs in the SQL Commands / Features Used category.

ANSI Joins

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

Fixed in Release Bug Number Description
10.1.0.4 2846640 Ambiguous columns not signalled with ANSI join syntax (wrong results instead of error)
10.1.0.4 3228560 OERI[qkebValidateOpn:2] / dump under qkngbAllocate from FULL OUTER JOIN
10.1.0.4 3264527 OERI[12310] on SELECT with LEFT OUTER JOIN
10.1.0.4 3545642 Wrong result when using LEFT OUTER joins and TABLE() operator
10.1.0.4 3584515 Wrong results when ANSI syntax does not trap ambiguous column with ORA-918
10.1.0.4 3632885 In FULL OUTER JOIN a NESTED LOOPS ANTI is used when unique index exists
10.1.0.4 3668084 Wrong results from nested FULL OUTER JOIN
10.1.0.4 3696879 Wrong results from ANSI query with subquery in the ON condition
10.1.0.4 3730394 Dump (qerixGetKey) from ANSI SQL with HAVING clause which uses a subquery
10.1.0.4 3786302 ANSI join with correlated TABLE() clause fails (ORA-904)
10.1.0.4 3803446 OERI[vopuasjct(2): Illegal Expression] can occur optimizing SQL
10.1.0.3 3414440 Query rewrite may spin in qsmg_process_sqltxt for ANSI join in a view

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.1.0.4 3270444 OERI[msqopnws.gsets1] for GROUPING SET queries with correlated variables
10.1.0.4 3348585 Dump (in LNXMIN) using WINDOW functions with CASE/DECODE
10.1.0.4 3355043 The MIN analytic returns bad data when selecting from nested collection type
10.1.0.4 3533428 ORA-904 SYS_TBL$3$.ID running query with GROUP BY CUBE and CONNECT BY
10.1.0.4 3582445 Predicate on PARTITION BY clause of WINDOW function not pushed into view
10.1.0.4 3607226 No predicate pushing into UNION ALL view with analytic function/s
10.1.0.4 3684796 ORA-904 when explaining GROUPING SETS query with fine grained auditing
10.1.0.4 3753308 NLS_SORT not applied implicitly to window functions
10.1.0.4 3760380 NULL value for ROWNUM when using an OVER WINDOWING clause
10.1.0.4 3800614 OERI[12410] from SQL with analytic functions
10.1.0.4 3949254 Dump possible with query rewrite with GROUPING SETS
10.1.0.3 3294293 OERI[12455],[pti:qkaqkn] on SELECT FOR UPDATE of partitioned table with WINDOW functions
10.1.0.3 3329128 Wrong results from SQL with GROUPING SETS and IS [NOT] NULL
10.1.0.3 3510094 Use of an analytic function skews the result from CONTEXT indextype SCORE operator

Application Context

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

Fixed in Release Bug Number Description
10.1.0.4 3306667 Wrong length possible for value from SYS_CONTEXT()
10.1.0.4 3507570 SYS_CONTEXT('USERENV',<parameter>) does not respect definers rights for lower case
10.1.0.4 3570286 OERI[733] from high use of application context (DBMS_SESSION.SET_CONTEXT)

Constraint Related

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

Fixed in Release Bug Number Description
10.1.0.4 3418978 ORA-1 may be thrown immediately for a deferred constraint
10.1.0.4 3635177 Dump [KXCCUIN] possible from DML with concurrent ONLINE index rebuild
10.1.0.4 3675530 Concurrent enable of CONSTRAINTS against same base table may dump
10.1.0.4 3731315 CREATE IOT with PK constraint may throw OERI [15803]
10.1.0.3 3275424 Array insert may report false constraint violations with row triggers
10.1.0.3 3352413 An ORA-8102 error can occur on ATEMPIND$ during a user UPDATE with CONSTRAINTS
10.1.0.3 3363424 Wrong results from query if base table as LPAD/RPAD/LTRIM/RTRIM check constraints
10.1.0.3 3383096 Parallel DML with foreign key constraints on partitioned tables fails with ORA-12839
10.1.0.3 3433964 Wrong result with deferred check constraint when table analyzed

Datatypes (AnyData)

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

Fixed in Release Bug Number Description
10.1.0.4 3917532 AnyData objects with length 232/233 may become corrupt - affects Streams

Datatypes (LOBs/CLOB/BLOB/BFILE)

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

Fixed in Release Bug Number Description
10.1.0.4 2660148 LOB Index extent sizes may be larger than expected
10.1.0.4 2931779 False ORA-1555 accessing "cache read" LOBs in RAC
10.1.0.4 3219117 LOB SEGMENT uses more space with ASSM
10.1.0.4 3492211 ORA-23308/ora-23309 replicating pre-created tables with LOB
10.1.0.4 3508608 CR request retry can spin in RAC for LOB data
10.1.0.4 3529179 OERI from "select empty_clob()" into varchar2 variable
10.1.0.4 3537749 HW enqueue contention when loading lob data
10.1.0.4 3602321 Streams/logminer cannot handle partial rollback of a failed BULK BIND operation on a table with LOBS
10.1.0.4 3632504 Wrong results from EXEC SQL LOB READ from NCLOB
10.1.0.4 3639408 Apply error mining redo from CONVERT_LONG_TO_LOB_CHUNK
10.1.0.4 3686945 Long CLOB data not updated correctly with LOB buffering in multibyte DB
10.1.0.4 3772033 OERI[ktspfmb_create1] creating a LOB in ASSM using 2k blocksize
10.1.0.4 3774546 OCILobRead may dump in kghalo() if there is character set conversion
10.1.0.4 3795386 Insert as select of LOBS / XMLType across DB Link can leak memory
10.1.0.4 3890213 IMP-98 possible importing zero length Lobs with CHUNKSIZE > 32767
10.1.0.4 3900290 Excessive memory spill in Streams for DDL transactions with LOB DMLs
10.1.0.4 3918257 Streams capture misses out of line clob data with 9.2 compatibility
10.1.0.4 3957037 LOB segment with PCTVERSION may use more space than expected
10.1.0.4 3970279 LOB segment with retention configuration grow in ASSM tablespace
10.1.0.4 4063046 Latch contention due to leaked CR pins for LOB data
10.1.0.3 3376786 * Concurrent LOB updates lost - can cause inconsistent Text Query results . This bug is alerted in Note:263548.1
10.1.0.3 3841411 *P CLOB corruption after upgrade from 10.1.0.2 to 10.1.0.3 on some platforms . This bug is alerted in Note:281209.1
10.1.0.3 3544995 + LOB segments with "CACHE READS" generate no REDO even with the logging option
10.1.0.3 2919655 LOBs may not reuse space with automatic undo management
10.1.0.3 2952816 Improved version of 2919655 / No old LOB versions retained in 9204
10.1.0.3 3166756 Self deadlock (ORA-60) possible on LOB index update
10.1.0.3 3263671 ORA-2019 from INSERT INTO .. SELECT from remote LOB using a PUBLIC synonym
10.1.0.3 3288625 ORA-22621 / OERI:kopuigpfx1 using LOBs in OCI Extproc
10.1.0.3 3309296 The retention value of a partitioned LOB is always 0
10.1.0.3 3313274 Direct path load of LOBs can cause data loss/truncation in streams
10.1.0.3 3356492 DBMS_LOB.LOADFROMFILE leaks library cache locks / shared pool "perm" memory
10.1.0.3 3361118 OERI:[7999] / LOB corruption updating a LOB in a SERIALIZABLE transaction
10.1.0.3 3406644 Insert .. Select of a CLOB over a database link may truncate the CLOB value
10.1.0.3 3467567 ORA-1400 importing CLOB data
10.1.0.3 3477127 Dump (kollgsz) when OCIStmtFetch2 fetches a NULL CLOB

Datatypes (Objects/Types/Collections)

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

Fixed in Release Bug Number Description
10.1.0.4 2270510 IMP-58 / ORA-22337 importing evolved type object table
10.1.0.4 3278020 ORA-942 creating MVIEW across dblink from 9i to 8i for object table
10.1.0.4 3300215 Parse of an OUTER JOIN on nested tables spins
10.1.0.4 3320638 ORA-957 on "ALTER TYPE" not final cascade convert to substitutable
10.1.0.4 3465087 ORA-905 possible from CAST() over DB link if "AT" clause is a column name
10.1.0.4 3513629 Dump (vopqbc) from query with OLS and CAST(MULTISET())
10.1.0.4 3516231 SELECT from a view with a TABLE function may dump
10.1.0.4 3543293 Dump (qmuhshge) inserting into VARRAY of SUBTYPE column inline
10.1.0.4 3545642 Wrong result when using LEFT OUTER joins and TABLE() operator
10.1.0.4 3546174 OERI[kcbgtcr_1] from subquery unnesting of a subquery containing a TABLE() function
10.1.0.4 3643391 ORA-4043 "object does not exist" using a SYNONYM of a TYPE in JDBC
10.1.0.4 3663357 OERI[koktrpltd1] in object type evolution
10.1.0.4 3744836 ORA-4043 on SYS_PLSQL_%s_%c from DROP of a versioned object
10.1.0.4 3786302 ANSI join with correlated TABLE() clause fails (ORA-904)
10.1.0.4 3810088 Cannot drop a table with a TYPE with associated user statistics
10.1.0.4 3819011 OERI[23050] on DML against a table with OBJECT columns in a replication group
10.1.0.4 3819875 Cost-based transformation does not work with objects
10.1.0.4 3831897 No rows from query against nested table view column when multiply referenced
10.1.0.4 3876715 Cannot set a fractional portion of a TIMESTAMP in an ADT
10.1.0.4 3895546 Capture may dump after certain DDLs
10.1.0.4 3983699 Dump (pfrdef1_get_tdo or kgicsr) with SERIALLY REUSABLE packages with ADTs
10.1.0.4 4007071 Wrong results selecting from TABLE() collection
10.1.0.4 4055118 Unexpected JDBC character conversion exception for invalid characters in ADTs
10.1.0.3 3054910 ALTER TYPE does not support change of codepoint semantics
10.1.0.3 3248893 OERI [17285] possible if TABLE() function invalidate
10.1.0.3 3342768 Dump performing a hierarchical query on an inline view with a TABLE clause
10.1.0.3 3385076 Complex object retrieval may fail with OCI-21700
10.1.0.3 3430870 ALTER TYPE of self referencing type body generates PLS-565 with trailing comments
10.1.0.3 3468584 OERI[qctchr : bfl] possible for SQL with TABLE() and inline views

Datatypes (TIMESTAMP)

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

Fixed in Release Bug Number Description
10.1.0.4 3141614 TIMESTAMPs can get wrong data if fraction of seconds is >9 digits long
10.1.0.4 3222472 HS TIMESTAMP implementation does not allow fractions of a second
10.1.0.4 3663103 getTimestamp may return truncated time value using Calendar parameter
10.1.0.4 3876715 Cannot set a fractional portion of a TIMESTAMP in an ADT
10.1.0.4 3906221 JDBC binds as a TIMESTAMP when V8Compatibility is true for NULL bind values
10.1.0.3 3144878 oracle.sql.TIMESTAMP is not serializable

Direct Path Operations

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

Fixed in Release Bug Number Description
10.1.0.4 2942185 Corruption occurs on direct path load into IOT with ADDED columns
10.1.0.4 3369324 Snapshot remains stale on complete refresh after direct load on master
10.1.0.4 3461768 SQLLDR direct path may reject good rows after character to RAW conversion error
10.1.0.4 3482332 Direct path loads may fail / corrupt space information
10.1.0.4 3486366 LogMiner cannot detect tables with invalidation redo from direct path loads
10.1.0.4 3560900 OERI[kcbchg1_3] during direct path insert
10.1.0.4 3568433 Apply gets unsupported LCR or no-data found error for partitioned tables
10.1.0.4 3596139 ORA-10632 on direct path export of IOT
10.1.0.4 3654015 SQLLDR direct path may incorrectly reject rows (ORA-2290) with CHECK_CONSTRAINTS
10.1.0.4 3743445 Direct path SQLLDR may load incorrect numbers for PACKED DECIMAL data
10.1.0.4 3833809 Direct load with code conversion can fail with OERI[klaevc_01]
10.1.0.4 3866720 SQL*Loader-709 occurs during direct load on multi-CPU machine
10.1.0.3 3313274 Direct path load of LOBs can cause data loss/truncation in streams

Globalization Support (NLS)

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

Fixed in Release Bug Number Description
10.1.0.4 3878264 + Output from CTXLC corrupt on some platforms
10.1.0.4 2233987 ORA-1460 from 8i -> 9i SELECT when database uses AL32UTF8
10.1.0.4 2965256 ORA-12714 using SQL function on NVARCHAR2/NCHAR operands
10.1.0.4 3374094 Ultrasearch may throw ORA-6502 for some multibyte character sets
10.1.0.4 3411206 The default instance has wrong Ultrasearch index preference/charset for UTF8 DBs
10.1.0.4 3430426 ORA-1459 attempting to SELECT a LONG via a database link with multibyte using JDBC
10.1.0.4 3469640 Fixed width strings not blank padded over HS
10.1.0.4 3478459 DBMS_ADVISOR.TUNE_MVIEW does not work with multibyte DB
10.1.0.4 3517985 locale builder error "no toplevel tag in helpset file" on some platforms
10.1.0.4 3525717 HS errors from remote DB not translated to clients character set
10.1.0.4 3527043 ORA-6502 "character string buffer too small" for 1001 char if NLS_LENGTH_SEMANTICS=CHAR
10.1.0.4 3628621 ORA-6502 from DYNAMIC SQL in AL32UTF8
10.1.0.4 3630966 Internal NLS issue in lxiskip() for multibyte character sets
10.1.0.4 3632450 TO_MULTI_BYTE/TO_SINGLE_BYTE do not work on a UTF8 database
10.1.0.4 3632504 Wrong results from EXEC SQL LOB READ from NCLOB
10.1.0.4 3637267 Varchar2 is blank padded when local DB charset is different from remote site
10.1.0.4 3642764 PGA corruption possible with CURSOR_SPACE_FOR_TIME if NLS parameters altered
10.1.0.4 3662892 Procobol errors for HOST VARIABLE / COLUMN NAME with multibyte character
10.1.0.4 3686945 Long CLOB data not updated correctly with LOB buffering in multibyte DB
10.1.0.4 3692370 UNISTR builtin function produces incorrect results when given NCHAR input
10.1.0.4 3750885 Ultrasearch uses wrong character set for MAC database character sets
10.1.0.4 3753308 NLS_SORT not applied implicitly to window functions
10.1.0.4 3774546 OCILobRead may dump in kghalo() if there is character set conversion
10.1.0.4 3830455 Memory corruption possible for invalid ISO2022 escape sequences
10.1.0.4 3852274 Dump / wrong result from invalid AL32UTF8 character
10.1.0.4 3861541 UTL_LMS.GET_MESSAGE can return wrong character set string if LANGUAGE specified
10.1.0.4 3892672 Data inconsistency replicating between different character sets (Streams)
10.1.0.4 3913596 ORA-1461 from JDBC with multibyte data close to 4000 byte boundary
10.1.0.4 4015165 Unexpected ORA-6502 from PLSQL using host binds when using CHAR length semantics
10.1.0.4 4055118 Unexpected JDBC character conversion exception for invalid characters in ADTs
10.1.0.3 3043199 Dump in lxsCnvNumStrToInt possible from TO_DATE in shift-sensitive character set
10.1.0.3 3239634 Error message (ORA-1403) is not converted to client character set
10.1.0.3 3283151 ORA-1461 can occur in JDBC Thin 10g binding a shift sensitive string to 9.2 DB
10.1.0.3 3312423 Oracle JVM ConversionBufferFullException can occur converting Strings for some NLS values
10.1.0.3 3324287 NLS Java conversion of 4-byte AL32UTF8 characters can give wrong result
10.1.0.3 3371861 NLS_DATE_FORMAT may change when not expected
10.1.0.3 3377754 "lxinst" fails when trying to have more than 127 "special uppercase" entries
10.1.0.3 3406644 Insert .. Select of a CLOB over a database link may truncate the CLOB value
10.1.0.3 3447478 ORA-6502 calling PLSQL over a DBLINK with RECORD parameters with UTF8/AL32UTF8
10.1.0.3 3453408 Intermittent dump (in lxkLikeMBNS) possible from LIKE '%' from JDBC

Hash Join

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

Fixed in Release Bug Number Description
10.1.0.4 3561624 Dump possible from HASH join with large hash_area_size > about 18Mb
10.1.0.4 3657023 OERI[kcblco_1] possible from HASH joins with migratable sessions
10.1.0.4 3672097 Wrong results joining CHAR / NCHAR from 10g to 9i/8i over database link
10.1.0.3 3216002 HASH JOIN ANTI / SEMI can use a lot of CPU / spin

Literal Replacement (CURSOR_SHARING)

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

Fixed in Release Bug Number Description
10.1.0.4 3128363 OCIAttrGet returns wrong size when CURSOR_SHARING=SIMILAR or FORCE
10.1.0.4 3668572 ORA-979 when CURSOR_SHARING = force|similar with inline view and GROUP BY
10.1.0.4 3818541 CURSOR_SHARING=force does not work if SQL has an NVL or DECODE predicate
10.1.0.4 3819834 Dump (kkslflb) with literal replacement
10.1.0.4 3842253 Dump (kgghash) using literal replacement
10.1.0.3 3148830 Select over database link fails with OERI[opixmp-7] if CURSOR_SHARING=similar
10.1.0.3 3406977 High version count in V$SQL due to binds marked as non-data with CURSOR_SHARING=FORCE

Merge SQL (MERGE .. USING)

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

Fixed in Release Bug Number Description
10.1.0.4 3447792 Multi-table insert can fail with ORA-24335
10.1.0.4 3530612 Dynamic partition pruning may not occur on MERGE
10.1.0.4 3672876 Dump on execution of a MERGE statement in replication
10.1.0.3 3326634 OERI[qertqgetcolumndef2] / OERI:15800 from parallel MERGE

Online DDL

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

Fixed in Release Bug Number Description
10.1.0.4 3562032 Cancelled ONLINE index rebuild can deadlock with DML session
10.1.0.4 3566511 ONLINE index rebuild can cause DML sessions to hang.
10.1.0.4 3622875 False ORA-1499 from ANALYZE TABLE VALIDATE STRUCTURE CASCADE ONLINE
10.1.0.4 3635177 Dump [KXCCUIN] possible from DML with concurrent ONLINE index rebuild
10.1.0.4 3848724 Dump [kdapblkcntt] rebuilding indexes with ONLINE or COMPUTE STATISTICS
10.1.0.4 3866448 Online table redefinition encounters ORA-12018,ORA-904
10.1.0.4 4090887 Online index rebuild/create with recycle bin generates incorrect DDL redo
10.1.0.3 3315378 A blocked ONLINE index rebuild can cause other DML to hang
10.1.0.3 3430832 OERI[25012] in DML after ONLINE create index against PARTITIONED table

Optimizer

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

Fixed in Release Bug Number Description
10.1.0.4 2942560 In IO cost model functional domain index invocation uses bad costing
10.1.0.4 3026474 ORA-20000 from DBMS_STATS importing table stats with missing column
10.1.0.4 3085933 Semijoin elimination may dump if the subquery contains virtual column expression
10.1.0.4 3177513 Join not avoided using bitmap join index if UNIQUE index exists also
10.1.0.4 3177769 Wrong results OR predicates inside AND chains of OR predicates
10.1.0.4 3193835 Unnecessary partition scanning depending on predicate order
10.1.0.4 3229934 DBMS_STATS.DELETE_INDEX_STATS does not invalidate index stats previously collected
10.1.0.4 3268237 CBO may not use transitive predicates for partition keys
10.1.0.4 3352279 ORA-14093 / wrong results from subquery pruning with composite partitioned table
10.1.0.4 3436577 View merge does not occur for CTAS when it does for the SELECT
10.1.0.4 3446722 Wrong results from CBO with constant predicates and CHAR = VARCHAR2 column
10.1.0.4 3463926 Dump (evaopn2) possible from UNNEST of a subquery column
10.1.0.4 3466737 Memory corruption optimizing SQL with OR predicates
10.1.0.4 3491127 DBMS_STATS.GATHER_INDEX_STATS does not gather correct partitioned index stats
10.1.0.4 3497949 Wrong results or ORA-1410 using stored outlines for CONNECT BY query
10.1.0.4 3499674 CBO may overestimate cost of NL join with index
10.1.0.4 3535015 DBMS_STATS slow for partitioned tables with many partitions
10.1.0.4 3537086 High CPU usage during parse for bitmap plans
10.1.0.4 3540821 ORA-4020 deadlock from concurrent ANALYZE index / query compilation against a cluster
10.1.0.4 3545209 Poor performance from semi join with NL to remote table
10.1.0.4 3546174 OERI[kcbgtcr_1] from subquery unnesting of a subquery containing a TABLE() function
10.1.0.4 3553962 ORA-18003 rebuilding an outline for SQL with leading spaces
10.1.0.4 3557842 ORA-903 with UNION ALL in a view
10.1.0.4 3557906 OERI[qctcte1] from predicate move around
10.1.0.4 3559212 Wrong results possible from CBO with multi-table OR list
10.1.0.4 3566843 Optimizer may not choose best index
10.1.0.4 3567928 Suboptimal plan with range predicates on CHAR columns with numeric literals
10.1.0.4 3582445 Predicate on PARTITION BY clause of WINDOW function not pushed into view
10.1.0.4 3599966 Wrong results when multi-column SMJ used after semi-join elimination
10.1.0.4 3601653 Subquery partition pruning does not work with SYSDATE predicate/s
10.1.0.4 3607226 No predicate pushing into UNION ALL view with analytic function/s
10.1.0.4 3614289 Index range cost with predicate on descending key may be too high
10.1.0.4 3617028 CBO suboptimal plan for multiple 'or' conditions
10.1.0.4 3620168 DBMS_STATS may set AVG_ROW_LEN to 100
10.1.0.4 3622251 Redundant range predicates against CHAR columns not removed
10.1.0.4 3632885 In FULL OUTER JOIN a NESTED LOOPS ANTI is used when unique index exists
10.1.0.4 3637851 Additional "no-op" predicate can reduce CPU
10.1.0.4 3643862 OUTLINES can fail to freeze plan because some hints are not generated
10.1.0.4 3648249 SQL may dump (in KKOGTP) during parse
10.1.0.4 3649683 OERI:KGHALO2 / OERI:KGHALP1 on a query with large number of predicates
10.1.0.4 3668224 Bind peeking does not occur for predicates of the form COL <op> FUNC(:bind)
10.1.0.4 3690369 Incorrect cardinality estimation when using LIKE predicates
10.1.0.4 3695271 Dump (kkojije) with bitmap index and multi column inlist
10.1.0.4 3721832 Automatic statistics collection not performed for domain indexes
10.1.0.4 3722505 Cost based transformation join predicate push down may not occur
10.1.0.4 3723007 Predicate push down may not occur in 10g (when it did in 9i)
10.1.0.4 3731042 Optimizer may not cost sub-query unnesting correctly
10.1.0.4 3731299 Cost based transformation may choose not to push join predicate when it should
10.1.0.4 3731357 Optimizer does not push join predicate when ROWNUM exists
10.1.0.4 3737955 Long parse times for long inlists / many AND/OR terms
10.1.0.4 3742802 Full table scan possible if selectivity of BETWEEN is 0
10.1.0.4 3745580 Poor performance from SORT MERGE JOIN plan against UNION view
10.1.0.4 3746423 Sub-optimal execution plan for range partitioned table with INLIST
10.1.0.4 3755693 Wrong results form index skip scan for LIKE with a wildcard
10.1.0.4 3756797 High CPU may be used during parse of certain query forms
10.1.0.4 3768069 Wrong results in subquery unnesting with semi/anti joins
10.1.0.4 3777256 Functional indexes on CASE expressions may not be used
10.1.0.4 3780242 Query unnesting not happenning when uncorrelated subquery has ROWNUM>=1 predicate
10.1.0.4 3801102 Column values missing in SELECT with correlated scalar subquery in outer join
10.1.0.4 3803446 OERI[vopuasjct(2): Illegal Expression] can occur optimizing SQL
10.1.0.4 3810088 Cannot drop a table with a TYPE with associated user statistics
10.1.0.4 3815906 DBMS_STATS fails with ORA-909 in ntile() function
10.1.0.4 3815921 Wrong results possible from predicate move around
10.1.0.4 3819875 Cost-based transformation does not work with objects
10.1.0.4 3820801 Optimizer does not choose plan with push join predicate
10.1.0.4 3822213 Explain plan with STAR transformation may spin in qkaPobs
10.1.0.4 3823191 Unnecessary sort when access made through a local index
10.1.0.4 3823887 Dump / wrong results from NVL expansion
10.1.0.4 3825226 Push predicate does not occur for predicates with PLSQL functions
10.1.0.4 3834770 CBO may not unnest an EXISTS() subquery with a view in the FROM clause
10.1.0.4 3844049 OERI[qctcte1] from unnesting of SET query with ORDER BY clause
10.1.0.4 3847292 Dump (in kkeLogGetCColNDV) from pushed join predicate
10.1.0.4 3855006 Sub-optimal plan with or expansion due to join order control
10.1.0.4 3867374 Zero cost possible for nested loops access to table with single bitmap semijoin
10.1.0.4 3880640 Query with ALL operator make get suboptimal plan
10.1.0.4 3892220 Wrong results from OUTER join to VIEW on literal in view select list
10.1.0.4 3896236 Wrong results with semijoin elimination with NVL-based OR expansion
10.1.0.4 3896963 ORA-942 when using WITH clause and UNION ALL together
10.1.0.4 3899748 Incorrect join cardinality for lossless NVL predicates
10.1.0.4 3911544 Wrong results from select with "OR" expansion on composite partitioned table
10.1.0.4 3933012 ORA-904 from IN subquery with UNION ALL having co-located remote references
10.1.0.4 3939721 Optimizer does not push join predicates in nested SET subquery
10.1.0.4 3940507 Optimizer may not push join predicate inside views with constant columns
10.1.0.4 3940888 Sub-optimal possible with bind peeking
10.1.0.4 3941526 Wrong results from cost based predicate push into UNION/UNION ALL views
10.1.0.4 3945774 Sub optimal plan possible for query blocks with many tables
10.1.0.4 3950045 Wrong cardinality (CDN) with functional indexes
10.1.0.4 3953483 Insert as Select with correlated sub-query with MAX function slow
10.1.0.4 3958887 Incorrect NDV for index statistics with many duplicates
10.1.0.4 3975268 Deadlock possible after gathering statistics for certain SYS objects
10.1.0.4 3982803 OERI[kcbshcb_1] with DBMS_STATS.GATHER_FIXED_OBJECTS_STATS
10.1.0.4 4012809 Wrong cardinality estimate causes join predicate to not be pushed down
10.1.0.4 4042122 Excessive parse time with cost based transformation
10.1.0.4 4082974 SQL with view push predicate plan produces wrong results
10.1.0.4 4154591 Wrong results from single table joinback elimination
10.1.0.3 3239873 High CPU during parse of statements with many identical predicates
10.1.0.3 3280226 ANALYZE to collect statistics may use more memory than expected
10.1.0.3 3291402 ESTIMATE_PERCENT may not be used when calling DBMS_STATS.GATHER_INDEX_STATS
10.1.0.3 3317309 Bad plan choice due to poor selectivity for "col=:bind" or "col=expression" for single value column
10.1.0.3 3349903 Bind peeking does not work for partitioned objects with non-equality predicates
10.1.0.3 3354231 Index skip scan is sometimes estimated at very high cost
10.1.0.3 3356951 DBMS_STATS can be slow if sample size causes < 2500 rows in the sample
10.1.0.3 3380026 Suboptimal plan possible for FIRST_ROWS for SQL with ORDER BY and indexes
10.1.0.3 3382501 OPTIMIZER_MODE=FIRST_ROWS_KK may dump in kkecdn
10.1.0.3 3398205 CBO can waste CPU trying to optimize INSERT INTO .. VALUES statements
10.1.0.3 3400412 CBO may choose a more expensive HASH JOIN plan with no partition pruning
10.1.0.3 3405237 ORA-4031 / excessing SGA consumption due to large IN LIST and NOT IN list
10.1.0.3 3406977 High version count in V$SQL due to binds marked as non-data with CURSOR_SHARING=FORCE
10.1.0.3 3427995 Stored outlines not created and not used when SQL has both INSERT and a set operation
10.1.0.3 3482715 CBO costing error for plans with index filter
10.1.0.3 3485930 Slow performance of DBMS_STATS with auto sample size
10.1.0.3 3516951 Poor execution plan with merge join cartesian with temp table transformation
10.1.0.3 3521347 Suboptimal plan possible using a ROWNUM predicate
10.1.0.3 3554954 Bind peeking overides _LIKE_WITH_BIND_AS_EQUALITY selectivity
10.1.0.3 3555167 BMS_STATS.GATHER_FIXED_OBJECTS_STATS may dump in kqlfcc
10.1.0.3 3618039 Wrong results as join predicate is pushed through multiple levels of views
10.1.0.3 4112324 OERI[16608] possible from some queries with pushed join predicates

Parallel Query (PQO)

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

Fixed in Release Bug Number Description
10.1.0.4 2365168 Wrong results with PQO and partitioning
10.1.0.4 3273522 Dump (qerpxsetparttq()+588] doing select on partitioned table parallel
10.1.0.4 3318204 Parallel query gives wrong results with view
10.1.0.4 3385243 Wrong results from PQ against partitioned tables
10.1.0.4 3430105 Parallel full scan of an external table may "SKIP" more rows than defined
10.1.0.4 3491603 Wrong ORDER BY from parallel execution
10.1.0.4 3520157 Create index using FFS slower than create index from table
10.1.0.4 3533996 Using transportable tablespaces disables intra-partition PDML
10.1.0.4 3577772 OERI[kcbgkcbcr_1] possible from PQO
10.1.0.4 3605241 Enhanced diagnostic information for internode parallel query
10.1.0.4 3607694 OERI:[15805] using PDML with array binds
10.1.0.4 3649839 Intermittent ORA-12805 on internode parallel create/rebuild index
10.1.0.4 3687949 Logical standby may not restart properly at start of PDML/PDDL
10.1.0.4 3688320 Wrong result with parallel query having SMJ and inequality join
10.1.0.4 3731315 CREATE IOT with PK constraint may throw OERI [15803]
10.1.0.4 3855809 Parallel query with OUTER JOIN and ORDER BY returns results unsorted
10.1.0.4 3859342 Sort is not parallelised in a view query with MINUS (or INTERSECT)
10.1.0.3 2929556 ORA-372 ORA-1110 inserting into partition with enable PARALLEL DML set
10.1.0.3 3273109 Wrong results possible for NULL in SELECT list for PQO or remote query
10.1.0.3 3374640 Create local partitioned domain index can hang
10.1.0.3 3383096 Parallel DML with foreign key constraints on partitioned tables fails with ORA-12839
10.1.0.3 3437636 "servers highwater" in V$PX_PROCESS_SYSSTAT can be wrong briefly
10.1.0.3 3447383 Wrong results with parallel query and partition table join

Query Rewrite (Including Materialized Views)

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

Fixed in Release Bug Number Description
10.1.0.4 3894096 + Poor MView refresh performance in ASSM tablespaces
10.1.0.4 3017095 ALTER MVIEW COMPILE does not update LAST_DDL_TIME in DBA/ALL/USER_OBJECTS
10.1.0.4 3175661 Query rewrite can give wrong results for "NOT IN"
10.1.0.4 3278020 ORA-942 creating MVIEW across dblink from 9i to 8i for object table
10.1.0.4 3369324 Snapshot remains stale on complete refresh after direct load on master
10.1.0.4 3477460 Query rewrite can return wrong results
10.1.0.4 3478459 DBMS_ADVISOR.TUNE_MVIEW does not work with multibyte DB
10.1.0.4 3488371 OERI[17113] can occur during import of materialized views
10.1.0.4 3525940 OERI[kkqscard-1] possible with query rewrite (ENFORCED)
10.1.0.4 3644243 Create MVIEW on scalar subquery in SELECT list gives ORA-22818
10.1.0.4 3646305 ORA-942 from MVIEW refresh after dropping and recreating table
10.1.0.4 3654532 Spin possible from query rewrite with temp table transformation
10.1.0.4 3669454 Unexpected ORA-12034 on FAST REFRESH of MVIEW
10.1.0.4 3682068 MV log changes not recorded with complex statement
10.1.0.4 3687210 SUMDELTA$ rows never purged
10.1.0.4 3787344 ORA-32321 occurs when executing fast refresh
10.1.0.4 3794402 Dump during query rewrite with a LIKE operator
10.1.0.4 3810779 PCT REWRITE is not allowed after CONSIDER FRESH
10.1.0.4 3824149 Missing data possible from Insert as SELECT over database link
10.1.0.4 3830853 DELETE during REFRESH of MJV can have poor execution plan
10.1.0.4 3833596 OERI:prssubpspec14 from ALTER MVIEW subpartition specification
10.1.0.4 3896974 ORA-4020 creating DIMENSIONs from schemas simultaneously
10.1.0.4 3983589 Dump (LdiDateFromArray) possible refreshing MV with TIMESTAMP/LOB columns
10.1.0.3 3094453 Wrong values possible in single table aggregate materialized view
10.1.0.3 3236491 ORA-32332 possible during refresh of MVIEW
10.1.0.3 3330412 ALTER MV CONSIDER FRESH raises ORA-12003
10.1.0.3 3345441 Cannot load user workloads when workload query references views only
10.1.0.3 3355726 Create materialized view raises ORA-4021
10.1.0.3 3370917 Summary metadata corrupted during REFRESH if MVIEW has inline views
10.1.0.3 3391999 ALTER MATERIALIZED VIEW CONSIDER FRESH can change the refresh method
10.1.0.3 3395198 Query rewrite may spin after partition exchange
10.1.0.3 3398224 ORA-12015 on outer join MJV with decode statements
10.1.0.3 3404500 ORA-604/ORA-1406 with QUERY_REWRITE_ENABLE=TRUE
10.1.0.3 3414440 Query rewrite may spin in qsmg_process_sqltxt for ANSI join in a view
10.1.0.3 3508674 OERI:ksmovrflow creating MVIEW in 8i/9i with 10g master table

Star Transformation

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

Fixed in Release Bug Number Description
10.1.0.4 3188637 Wrong result with star transformation and OUTER join
10.1.0.4 3625392 wrong results / dump (evaopn2) with star transformation
10.1.0.4 3649979 OERI[qesmmCValStat4] from star transformation
10.1.0.4 3822213 Explain plan with STAR transformation may spin in qkaPobs
10.1.0.3 3412136 Poor plan (with merge join cartesian) with STAR transformation
10.1.0.3 3566478 ORA-928 can occur with star transformation with CONNECT BY

Star Transformation With Temp. Tables

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

Fixed in Release Bug Number Description
10.1.0.3 3412136 Poor plan (with merge join cartesian) with STAR transformation
10.1.0.3 3454814 Wrong results possible from STAR TRANSFORMATION
10.1.0.3 3516951 Poor execution plan with merge join cartesian with temp table transformation

Triggers

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

Fixed in Release Bug Number Description
10.1.0.4 1867670 Dump when using a trigger on an ADT or TIMESTAMP column
10.1.0.4 3527043 ORA-6502 "character string buffer too small" for 1001 char if NLS_LENGTH_SEMANTICS=CHAR
10.1.0.4 3571946 DELETE trigger does not fire on delete with index scan
10.1.0.4 3605165 Hang/deadlock between sessions concurrently loading a cursor with INVALID trigger
10.1.0.4 3717619 Deadlock/hang possible due to concurrent cursor loads referencing same INVALID trigger
10.1.0.4 3739622 DBMS_UTILITY.COMPILE_SCHEMA throws ORA-20000 if schema as TRIGGERS in Recycle bin
10.1.0.4 3766568 ORA-6502 (VALUE ERROR) during trigger execution with codepoint semantics in multibyte
10.1.0.4 3785459 Dump (evaopn2) when updating a view with an INSTEAD OF trigger
10.1.0.4 3854375 Dump (kxtivwt) updating a view with a trigger on it
10.1.0.4 3897017 OERI:15239 from ALTER TRIGGER .. ENABLE
10.1.0.3 3199908 Dump (in kkmmctbf) from a DELETE TRIGGER compiled in DEBUG mode
10.1.0.3 3275424 Array insert may report false constraint violations with row triggers

Truncate

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

Fixed in Release Bug Number Description
10.1.0.4 3852108 Concurrent truncates on global temporary table cause library cache lock waits
10.1.0.4 3966709 Range/object reuse prematurely (ORA-8103)
10.1.0.4 4036717 Truncate table in exception handler can causes OERI:kcbzwb_4
10.1.0.3 3338673 TRUNCATE does not reset the NEXT_EXTENT value of a locally managed table migrated from dictionary managed

How Things Are Stored / Defined

The following tables list bugs in the How Things Are Stored / Defined category.

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.1.0.4 3771668 + Poor INSERT performance with ASSM
10.1.0.4 3894096 + Poor MView refresh performance in ASSM tablespaces
10.1.0.4 3219117 LOB SEGMENT uses more space with ASSM
10.1.0.4 3687456 OERI[ktspgetmyb-1] / Corrupt LOB if EXTENT size not multiple of LOB CHUNK SIZE
10.1.0.4 3782820 Wrong results for access by ROWID for ASSM segments
10.1.0.4 3849938 DBMS_SPACE.UNUSED_SPACE returns wrong block_id for last extent used
10.1.0.4 3853023 False ORA-8103 from EXPDP exporting an ASSM managed IOT
10.1.0.4 3970279 LOB segment with retention configuration grow in ASSM tablespace
10.1.0.3 3329096 Free space may not be used in an AUTO SPACE MANAGED segment
10.1.0.3 3430832 OERI[25012] in DML after ONLINE create index against PARTITIONED table
10.1.0.3 3613078 OERI[4097] from DML on TRANSPORTED tables with ASSM

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.1.0.4 3452566 Start / abort of multiple instances can leave ASM diskgroup unmountable
10.1.0.4 3454934 EM Standby redo log creation improperly assigns an actual file name to the SRL
10.1.0.4 3458327 dbstart / dbshut do not work with ASM
10.1.0.4 3473576 OERI[kfcdel67] during PMON cleanup in ASM
10.1.0.4 3477524 OERI[kfgscdelete_10] after IO error in ASM
10.1.0.4 3520103 ASM instance hang on "DFS lock handle"
10.1.0.4 3528361 "ksfd: async disk IO" waits recorded incorrectly when using ASM
10.1.0.4 3537185 OERI[kfcdeadlockavoid02] adding file in ASM
10.1.0.4 3573149 OERI [kfcmount15] after ASM crash when remounting diskgroup
10.1.0.4 3582798 Synchronous IO to ASM files may be issued as asynchronous calls
10.1.0.4 3591633 ORA-1115 / OERI:[kfkOsmUpdReq] possible with ASM if process interrupted
10.1.0.4 3597683 OERI [kfgscunregister_1] interrupt occurs while mounting diskgroups
10.1.0.4 3631330 ASM disk drop does not work properly
10.1.0.4 3644481 ASM instance hang (wait for DD enqueue)
10.1.0.4 3679713 OS kill of a process performing ASM IO crahses instance with OERI[kffmrequestfree_1]
10.1.0.4 3682288 Dump (skgfrdscdevs) ASM terminates using default discovery
10.1.0.4 3695999 SYSOPER unable to startup database instance using ASM (ORA-1013)
10.1.0.4 3701082 ORA-12240 / OERI:kffmReqFree_1 using ASM
10.1.0.4 3748702 ASM unable to re-add user alias after doing a DROP DIRECTORY on it
10.1.0.4 3751057 ALTER DISKGROUP DROP DIRECTORY FORCE removes system aliases
10.1.0.4 3764557 ASM LGWR / DBWR do not release disk after it is dropped
10.1.0.4 3787196 ASM archivelogs not found automatically when executeing recover database
10.1.0.4 3800160 Internal error / memory corruption using ASM with KST trace
10.1.0.4 3811822 OERI:kfgscrefresh_0 from rebalance of redundancy diskgroup
10.1.0.4 3816094 Host disk groups space status shows as UNKNOWN in EM
10.1.0.4 3825357 RMAN with ASM can overwrite the wrong file
10.1.0.4 3840682 kfiorqsetprepare02 when db instance cannot open disks in asm diskgroup.
10.1.0.4 3854622 OERI[kfcckptmount05] possible in ASM instance
10.1.0.4 3857822 OERI:kfuitrninit_1 possible in ASMB when using ASM
10.1.0.4 3859258 ASM max file size is limited to 2.4Tb (rather than 12Tb)
10.1.0.4 3867815 ASM instance recovery may hang
10.1.0.4 3890089 Cannot create database due to ORA-15040 with ASM
10.1.0.4 3903314 Crash due to OERI[kfkOsmUpdReq] with ASM after IO error
10.1.0.4 3917670 ASM 'dismount all' with force gets OERI:kfgsoCheckAcquireLevel
10.1.0.4 3921399 ASM instance may dump (in ksfdckare) when disks go offline
10.1.0.4 3937881 OERI:kfdpDta_isPartSymmetric04 possible with ASM
10.1.0.4 3952778 ASM instance crash OERI[kffmxpresize] when shrinking / growing file
10.1.0.4 3952939 EM ASM pages visible even if not licenced
10.1.0.4 3953494 ASM instance may crash with OERI[kfkupdateufsreq1] after rebalance of diskgroup
10.1.0.4 3973485 Disk groups space on Host homepage are wrong
10.1.0.4 3990235 Deadlock in disk drop and instance recovery in ASM
10.1.0.4 3992425 OERI:kfgsoCheckAcquireLevel during remount after drop disk
10.1.0.4 4011826 OERI:kfcGetPin01 on ASM instance if disk out of space
10.1.0.4 4014162 ASM alias containing "." should not be allowed
10.1.0.4 4017051 Identical disk names not allowed in multiple diskgroups (ORA-15020)
10.1.0.4 4115918 OERI[784] in ASMB
10.1.0.3 3503661 ASM "ALTER DISKGROUP ADD DISK" can crash database

BIGFILE Tablespaces

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

Fixed in Release Bug Number Description
10.1.0.4 3370649 IOT partitions in bigfile tablespaces do not show in DBA_TAB_PARTITIONS

Bitmap Indexes

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

Fixed in Release Bug Number Description
10.1.0.4 3183084 Performance hit / OERI for index maintenance if TEMPORARY blocksize < index blocksize
10.1.0.4 3573604 A transported bitmap index can give various OERI errors / ORA-8102
10.1.0.4 3617574 Transport of bitmap index gives errors at transported to site
10.1.0.4 3622875 False ORA-1499 from ANALYZE TABLE VALIDATE STRUCTURE CASCADE ONLINE
10.1.0.4 3695271 Dump (kkojije) with bitmap index and multi column inlist
10.1.0.4 3747472 ORA-14642 on EXCHANGE PARTITION INCLUDING INDEXES
10.1.0.4 3827085 Dump from multi-column inlist with bitmap join index
10.1.0.4 3854034 OERI[733] optimizing SQL using bitmap indexes
10.1.0.4 3867374 Zero cost possible for nested loops access to table with single bitmap semijoin
10.1.0.4 3938376 OERI[15160] accessing via a bitmap join index
10.1.0.3 3358065 Dump (kkoiop) using bitmap join index

Compressed Data Storage

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

Fixed in Release Bug Number Description
10.1.0.4 3579567 Corrupt export exporting a compressed table with direct=y (IMP-9)
10.1.0.4 3816946 Dump (kafger) / wrong results from table scan of compressed table
10.1.0.3 3262424 ALTER TABLE NOCOMPRESS does not work for partitioned tables

Compressed Key Index / IOT

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

Fixed in Release Bug Number Description
10.1.0.4 3569138 Dump (kdiins0) during insert/update of compressed key index or compressed IOT
10.1.0.4 3629771 Wrong results possible from COMPRESS KEY INDEX SCAN
10.1.0.3 3347963 OERI [6120] during compressed IOT insert

Domain Indexes

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

Fixed in Release Bug Number Description
10.1.0.4 2942560 In IO cost model functional domain index invocation uses bad costing
10.1.0.4 3105313 Dump[strlen] when performing a domain-index search with a UNION
10.1.0.4 3194997 DDL against domain indexes can use lots of memory
10.1.0.4 3225530 DBMS_METADATA fails to generate complete definition for a domain index
10.1.0.4 3779927 Dump (under qxidmid) from INSERT INTO with a DOMAIN index
10.1.0.4 3962643 Dump / corruption using user defined operators
10.1.0.3 2893444 Internal SQL in the extensible optimizer does not always use bind variables
10.1.0.3 3200136 Wrong results possible from MERGE JOIN CARTESIAN with DOMAIN INDEX
10.1.0.3 3347339 Stored outline has "NO_ACCESS" instead of "INDEX" hint for domain index access
10.1.0.3 3374640 Create local partitioned domain index can hang
10.1.0.3 3468580 ORA-29871 for ALTER INDEX ENABLE on functional DOMAIN index
10.1.0.3 3545539 Dump under kgmexec->kglpnp using trusted callouts / domain indexes / Oracle Text

External Tables

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

Fixed in Release Bug Number Description
10.1.0.4 3357740 Wrong results from external table in subquery
10.1.0.4 3430105 Parallel full scan of an external table may "SKIP" more rows than defined
10.1.0.4 3748283 Small PGA memory leak in kpodscn for long running PLSQL against external tables

Function Based Index (Including DESC Indexes)

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

Fixed in Release Bug Number Description
10.1.0.4 3250883 Inline view using functional index can give wrong results
10.1.0.4 3396223 wrong results with function based index and DECODE function
10.1.0.4 3406611 Wrong results accessing data via a function based index
10.1.0.4 3591564 ORA-1756 importing functional index with CHR(0) in its expression
10.1.0.4 3628474 Select on empty table with functional index may dump in kpobav
10.1.0.4 3630053 Dump (kkfipf) querying a table using a DESC index with OUTER join
10.1.0.4 3777256 Functional indexes on CASE expressions may not be used
10.1.0.4 3897407 Wrong results from OUTER JOIN with FUNCTIONAL INDEX when the OUTER is negated
10.1.0.4 3950045 Wrong cardinality (CDN) with functional indexes
10.1.0.3 3253133 Dump (in evaopn2) from queries using a FUNCTIONAL INDEX with complex view merging
10.1.0.3 3261962 Dump (in qerixGetKey) using function based indexes with a join
10.1.0.3 3365045 Functional index on DATE column can depend on NLS_DATE_FORMAT (ORA-8102 on DML)

Index Only Tables (IOT)

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

Fixed in Release Bug Number Description
10.1.0.4 2942185 Corruption occurs on direct path load into IOT with ADDED columns
10.1.0.4 3370649 IOT partitions in bigfile tablespaces do not show in DBA_TAB_PARTITIONS
10.1.0.4 3488157 Data pump import of list-partitioned IOT returns ORA-39083 / ORA-926
10.1.0.4 3556601 Logical standby cannot handle CTAS of an IOT with a mapping table
10.1.0.4 3566124 OERI[insrow-1] during array insert with SAVE EXCEPTIONS and IOT
10.1.0.4 3566361 DBMS_IOT.NUMBER_TO_UROWID is slow
10.1.0.4 3569138 Dump (kdiins0) during insert/update of compressed key index or compressed IOT
10.1.0.4 3596139 ORA-10632 on direct path export of IOT
10.1.0.4 3731315 CREATE IOT with PK constraint may throw OERI [15803]
10.1.0.4 3785333 DROP COLUMN may drop wrong columns in an IOT with OVERFLOW
10.1.0.4 3811391 Updates to IOTs beyond column 255 in non-key piece can corrupt the IOT
10.1.0.4 3853023 False ORA-8103 from EXPDP exporting an ASSM managed IOT
10.1.0.4 3953458 Array insert to IOT with supplemental logging can corrupt the IOT
10.1.0.3 3347963 OERI [6120] during compressed IOT insert

Oracle Disk Manager

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

Fixed in Release Bug Number Description
10.1.0.4 3612867 Database startup with ODM may fail with ORA-1115 errors

Partitioned Tables

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

Fixed in Release Bug Number Description
10.1.0.4 2365168 Wrong results with PQO and partitioning
10.1.0.4 3193835 Unnecessary partition scanning depending on predicate order
10.1.0.4 3268237 CBO may not use transitive predicates for partition keys
10.1.0.4 3273522 Dump (qerpxsetparttq()+588] doing select on partitioned table parallel
10.1.0.4 3352279 ORA-14093 / wrong results from subquery pruning with composite partitioned table
10.1.0.4 3370649 IOT partitions in bigfile tablespaces do not show in DBA_TAB_PARTITIONS
10.1.0.4 3377931 SAVE EXCEPTIONS does not work reliably with a partitioned table
10.1.0.4 3385243 Wrong results from PQ against partitioned tables
10.1.0.4 3387588 Dump (lnxdiv) updating partitioned table
10.1.0.4 3488157 Data pump import of list-partitioned IOT returns ORA-39083 / ORA-926
10.1.0.4 3530612 Dynamic partition pruning may not occur on MERGE
10.1.0.4 3554494 ALTER TABLE SPLIT PARTITION fails with ORA-604 / ORA-933
10.1.0.4 3564070 Split partition dumps when a local primary key index exists
10.1.0.4 3595110 OERI[12337] from multi-column INLIST with partitioned table
10.1.0.4 3601653 Subquery partition pruning does not work with SYSDATE predicate/s
10.1.0.4 3643476 RENAME of partition/subpartition can throw ORA-54
10.1.0.4 3661254 Dump with partitioned tables and INLIST
10.1.0.4 3742371 Dump (kkpapUsedInSum) possible from query on partitioned table with subquery
10.1.0.4 3742674 Wrong results possible from ROWID access of single partition
10.1.0.4 3746423 Sub-optimal execution plan for range partitioned table with INLIST
10.1.0.4 3747472 ORA-14642 on EXCHANGE PARTITION INCLUDING INDEXES
10.1.0.4 3763395 Incorrect ROWCOUNT from BULK FORALL INSERT SAVE EXCEPTIONS with partitioned tables
10.1.0.4 3765931 ALTER TABLE ... SPLIT PARTITION may dump in msqtnm()
10.1.0.4 3782820 Wrong results for access by ROWID for ASSM segments
10.1.0.4 3823191 Unnecessary sort when access made through a local index
10.1.0.4 3833596 OERI:prssubpspec14 from ALTER MVIEW subpartition specification
10.1.0.4 3848724 Dump [kdapblkcntt] rebuilding indexes with ONLINE or COMPUTE STATISTICS
10.1.0.4 3911544 Wrong results from select with "OR" expansion on composite partitioned table
10.1.0.4 3996053 Inefficient dynamic partition pruning SQL
10.1.0.4 4004225 Dump possible (kkpapbDCopy2) for SQL against a composite partitioned table
10.1.0.3 2929556 ORA-372 ORA-1110 inserting into partition with enable PARALLEL DML set
10.1.0.3 3128021 Corrupt column data after EXCHANGE PARTITION with row dependencies
10.1.0.3 3175001 ORA-1426 REBUILDing Text index with more than 255 partitions
10.1.0.3 3262424 ALTER TABLE NOCOMPRESS does not work for partitioned tables
10.1.0.3 3265740 Corrupt column data after PARTITION maintenence with ROWDEPENDENCIES
10.1.0.3 3281907 Export / import of a composite partitioned table can appear to spin during IMPORT
10.1.0.3 3294293 OERI[12455],[pti:qkaqkn] on SELECT FOR UPDATE of partitioned table with WINDOW functions
10.1.0.3 3309296 The retention value of a partitioned LOB is always 0
10.1.0.3 3349903 Bind peeking does not work for partitioned objects with non-equality predicates
10.1.0.3 3374640 Create local partitioned domain index can hang
10.1.0.3 3383096 Parallel DML with foreign key constraints on partitioned tables fails with ORA-12839
10.1.0.3 3395198 Query rewrite may spin after partition exchange
10.1.0.3 3400412 CBO may choose a more expensive HASH JOIN plan with no partition pruning
10.1.0.3 3424721 Hang/deadlock from ALTER INDEX REBUILD on partition with concurrent SQL
10.1.0.3 3430832 OERI[25012] in DML after ONLINE create index against PARTITIONED table
10.1.0.3 3512123 Dump (evaopn2) with BETWEEN predicate on PARTITIONED table

Space Management

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

Fixed in Release Bug Number Description
10.1.0.4 2660148 LOB Index extent sizes may be larger than expected
10.1.0.4 2858082 False ORA-1652 in alert log when there is free space in RAC environment
10.1.0.4 3516451 ALTER TABLE x SHRINK CASCADE does not shrink indexes

Space Management (Locally Managed Tablespaces)

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

Fixed in Release Bug Number Description
10.1.0.4 3714207 OERI[5021] trying to migrate system tablespace to local
10.1.0.4 3772033 OERI[ktspfmb_create1] creating a LOB in ASSM using 2k blocksize
10.1.0.3 3159124 EXP-68 even though locally managed tablespaces are not offline
10.1.0.3 3338673 TRUNCATE does not reset the NEXT_EXTENT value of a locally managed table migrated from dictionary managed

System Managed Undo (SMU)

The following table lists the System Managed Undo (SMU) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.1.0.4 3439552 OERI[4406] possible in SMON using automatic undo management
10.1.0.4 3973403 ORA-1562 / ORA-1581 using system managed Undo
10.1.0.3 2919655 LOBs may not reuse space with automatic undo management
10.1.0.3 2952816 Improved version of 2919655 / No old LOB versions retained in 9204
10.1.0.3 3422329 Lots of alert messages for online/offline of SMU rollback segments

Net / Connectivity / Authentication / Distributed

The following tables list bugs in the Net / Connectivity / Authentication / Distributed category.

Advanced / Secure Networking

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

Fixed in Release Bug Number Description
10.1.0.4 1916142 Step up functionality does not work for SSL
10.1.0.4 3387739 Kerberos replay cache errors connecting between 32 / 64 bit instances on same host
10.1.0.4 3398060 The SSL Net layer may dump due to an uninitialized variable
10.1.0.4 3553251 User certificates with "Extended Key Usage" can fail
10.1.0.4 3555800 Cannot connect 10g client to server on different platform with AES256
10.1.0.4 3584486 Client dump possible using SNS
10.1.0.4 3731578 Support already HSM provisioned credentials
10.1.0.4 3889519 Errors on data transfer via SSL with security alert #68 installed
10.1.0.4 3906430 SSL enterprise users should not require certificate DN to match OID dn
10.1.0.4 4003382 IllegalArgumentException when two JDBC Thin connections made using LDAP over SSL
10.1.0.3 3143435 JDBC Thin connecting to server with ASO and DCD gets NegativeArraySizeException
10.1.0.3 3257198 Direct handoff does not work for shared server connections over SSL

Database Link / Distributed

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

Fixed in Release Bug Number Description
10.1.0.4 2876340 ORA-904 accessing a remote object from PLSQL (remote DB < 9i)
10.1.0.4 3081127 View for remote table with CHECK OPTION never reports ORA-1402
10.1.0.4 3278020 ORA-942 creating MVIEW across dblink from 9i to 8i for object table
10.1.0.4 3384300 OERI[opixrm-1] [invalid handle] for remote mapped SQL (over DB link)
10.1.0.4 3430426 ORA-1459 attempting to SELECT a LONG via a database link with multibyte using JDBC
10.1.0.4 3456977 ORA-2046 using SQL with AUTOCOMMIT for DB link between 9i/10g and 8i
10.1.0.4 3458438 Update a long >4k that affects more than 1 record over DB link hangs
10.1.0.4 3465087 ORA-905 possible from CAST() over DB link if "AT" clause is a column name
10.1.0.4 3545209 Poor performance from semi join with NL to remote table
10.1.0.4 3571263 Excessive build-up of distributed transaction locks (DX locks)
10.1.0.4 3576897 ORA-22804 inserting over a database link with select using CASE
10.1.0.4 3637267 Varchar2 is blank padded when local DB charset is different from remote site
10.1.0.4 3647829 Cursor is not always closed when database link closed (ORA-1000)
10.1.0.4 3668077 "rollback to savepoint" in a distributed transaction dumps
10.1.0.4 3672097 Wrong results joining CHAR / NCHAR from 10g to 9i/8i over database link
10.1.0.4 3673561 READ_SCN may not advance even when there is no eager transaction
10.1.0.4 3676676 Ctrl-C/interrupt ignored for query over DB link
10.1.0.4 3700058 Rollback to a savepoint with a DB link can result in a full rollback
10.1.0.4 3776668 ORA-1478 from distributed transaction between 8i<->9i with different character sets
10.1.0.4 3795386 Insert as select of LOBS / XMLType across DB Link can leak memory
10.1.0.4 3804250 DML to a remote table from a table with FGA fails with ORA-904/ORA-2063
10.1.0.4 3824149 Missing data possible from Insert as SELECT over database link
10.1.0.4 3828598 Wrong results with unnested remote subqueries
10.1.0.4 3858625 Insert of long over DB link with NULL binds may ORA-24343
10.1.0.4 3929805 Slow execution for insert as Select over DB Link with NULL in select list
10.1.0.4 3933012 ORA-904 from IN subquery with UNION ALL having co-located remote references
10.1.0.4 3949188 Dump (kopxccc) when calling a procedure over database link
10.1.0.4 3982017 ORA-3106 PLSQL SELECT across 8i-9i-8i
10.1.0.3 2932269 Sessions hang on "resmgr:waiting in end wait" while session tries to connect over DBLINK
10.1.0.3 3148830 Select over database link fails with OERI[opixmp-7] if CURSOR_SHARING=similar
10.1.0.3 3263671 ORA-2019 from INSERT INTO .. SELECT from remote LOB using a PUBLIC synonym
10.1.0.3 3273109 Wrong results possible for NULL in SELECT list for PQO or remote query
10.1.0.3 3393962 ORA-972 on query with UNION ALL and internally generated column name over DBLINK
10.1.0.3 3406644 Insert .. Select of a CLOB over a database link may truncate the CLOB value
10.1.0.3 3411748 OCI7 SELECT FOR UPDATE over DBLINK may dump client in kpuridalo1
10.1.0.3 3447478 ORA-6502 calling PLSQL over a DBLINK with RECORD parameters with UTF8/AL32UTF8
10.1.0.3 3512385 Wrong ROWID returned from SELECT over DBLINK when PREFETCH is on

Gateways / Heterogeneous Services

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

Fixed in Release Bug Number Description
10.1.0.4 3217204 Internal HS fix
10.1.0.4 3222472 HS TIMESTAMP implementation does not allow fractions of a second
10.1.0.4 3469640 Fixed width strings not blank padded over HS
10.1.0.4 3525717 HS errors from remote DB not translated to clients character set
10.1.0.4 3579719 Wrong data length returned selecting CHAR column over HS
10.1.0.4 3594734 Dump when accessing HS table with over 20 indexes
10.1.0.4 3609791 SQLCODE -310 / incorrect SCALE over HS for numbers with zeroes after the decimal place
10.1.0.4 3896254 CBO used with default statistics used when DB2STATS = FALSE
10.1.0.3 3222625 HS gateway may dump (in horsh) when doing an array fetch
10.1.0.3 3250970 Dump (in hokbrp) inserting into a remote table via transparent gateway
10.1.0.3 3259441 ORA-28545 when trying to resolve gateway TNS alias through Oracle Names
10.1.0.3 3296914 Using binds from 8i instance to a 9i instance to a 9i Gateway can hang
10.1.0.3 3345208 ORA-28502 internal communication error on heterogeneous database link

Gateways / Procedural Gateway For APPC

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

Fixed in Release Bug Number Description
10.1.0.3 3128975 Listener cannot call pg4asrv / pg4t4ic directly / NCR-1003
10.1.0.3 3343210 Internal fix to Procedural Gateway
10.1.0.3 3462278 PG4TCPMAP errors unless trace level / log destination set in init.ora file

Gateways / Transparent Gateway For DRDA

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

Fixed in Release Bug Number Description
10.1.0.4 3130329 TG4DRDA spins if QRWTSRVR job killed while gateway is in gdjcrcv
10.1.0.4 3650803 Memory leak in G4DRSRV Gateway process
10.1.0.4 3709345 ORA-28500 / SQLCODE-310 using PACKED DECIMAL DB2 columns
10.1.0.4 3882675 TG4DRDA ORA-28511 errors with g4drsrvd
10.1.0.4 3965425 Dump / OERI selecting from DB2/400 with ISOLATION_LEVEL=RR
10.1.0.4 4013463 Garbage / NullPointerException in JDBC processing error messages from TG4DRDA
10.1.0.4 4065600 SQLException (invalid character) in JDBC for some DB2 errors
10.1.0.3 3173648 Describe of TG4DRDA object from 9.2 client errors (ORA-4043 / ORA-2063)
10.1.0.3 3514233 Setting DRDA_OPTIMIZE_QUERY=TRUE does not generate table stats
10.1.0.3 3586679 ENH: Add DB2/UDB stored procedure support
10.1.0.3 3610131 TG4DRDA gateway may not return the correct index statistics

Gateways / Transparent Gateway For Informix

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

Fixed in Release Bug Number Description
10.1.0.3 3298136 Invalid table name data returned on describes with TG4IFMX
10.1.0.3 3541407 Incorrectly remote table cardinality for TG4IFMX

Gateways / Transparent Gateway For Sybase

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

Fixed in Release Bug Number Description
10.1.0.3 3398064 Sybase gateway does not work with 12.0 Sybase client library
10.1.0.3 3621398 Describe returns incorrect data when two tables exist with same mixed case names

Interoperability (Between Releases)

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

Fixed in Release Bug Number Description
10.1.0.4 3940324 I ultraSearch 9.0.4 midtier is not compatible with 10.1.0.3 backend
10.1.0.4 2233987 ORA-1460 from 8i -> 9i SELECT when database uses AL32UTF8
10.1.0.4 2876340 ORA-904 accessing a remote object from PLSQL (remote DB < 9i)
10.1.0.4 3417593 Cross platform piecewise fetch of varchar2 data can result in corrupt data
10.1.0.4 3456977 ORA-2046 using SQL with AUTOCOMMIT for DB link between 9i/10g and 8i
10.1.0.4 3489246 OERI[pitl1] / ORA-1498 ANALYZING table transported from 8.1.7 to 9.2.0
10.1.0.4 3672097 Wrong results joining CHAR / NCHAR from 10g to 9i/8i over database link
10.1.0.4 3776668 ORA-1478 from distributed transaction between 8i<->9i with different character sets
10.1.0.4 3818542 PLS-907 from pre-10g PLSQL client executing package with overloaded function
10.1.0.4 3982017 ORA-3106 PLSQL SELECT across 8i-9i-8i
10.1.0.3 3564573 * ORA-1017 when 10g client connects to 8i/9i server with EBCDIC <-> ASCII connection . This bug is alerted in Note:272000.1
10.1.0.3 3173648 Describe of TG4DRDA object from 9.2 client errors (ORA-4043 / ORA-2063)
10.1.0.3 3283151 ORA-1461 can occur in JDBC Thin 10g binding a shift sensitive string to 9.2 DB
10.1.0.3 3296914 Using binds from 8i instance to a 9i instance to a 9i Gateway can hang
10.1.0.3 3437884 10g client cannot connect to 8.1.7.0 - 8.1.7.3 server
10.1.0.3 3508674 OERI:ksmovrflow creating MVIEW in 8i/9i with 10g master table

Network

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

Fixed in Release Bug Number Description
10.1.0.4 3543974 PROGRAM name may have a NULL value in Net connection packets
10.1.0.4 3560191 "netca" HELP does not work on EBCDIC platforms
10.1.0.4 3592772 ORA-12699 / client cannot connect with NTS authentication
10.1.0.4 3752301 OERI:16305 at startup if unresolvable node in invited nodes list
10.1.0.4 3908058 Memory leak when using protocol.ora validnode_checking
10.1.0.3 2627085 Remote listeners do not deregister when the node supporting the service fails
10.1.0.3 3003104 Instance may not auto register with listener with multiple IP addresses
10.1.0.3 3408829 TNS listener leaks memory if remote listener specified in LOCAL_LISTENER
10.1.0.3 3507883 Uneven connection distribution when PREFER_LEAST_LOADED_NODE is set to OFF
10.1.0.3 3636602 Memory leak in Net

Network (Connection Manager)

The following table lists the Network (Connection Manager) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.1.0.4 3224546 ORA-12564 from CMAN in a RAC with listener load balancing

Oracle Names

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

Fixed in Release Bug Number Description
10.1.0.3 3259441 ORA-28545 when trying to resolve gateway TNS alias through Oracle Names
10.1.0.3 3387491 Oracle Names LDAP proxy process leaks memory leak on reload

Security ( Authentication / Privileges / Auditing )

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

Fixed in Release Bug Number Description
10.1.0.4 3450991 FGA does not work if SQL is run by the SYS user
10.1.0.4 3627650 ORA-701 / OERI:17058 from GRANT / REVOKE select ON OBJECT_USAGE
10.1.0.4 3786271 Audit DML not working with DBMS_JOB / DBMS_SCHEDULER
10.1.0.3 3400967 IMP-17 / ORA-6550 importing a wrapped password verification function

Transparent Application Failover

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

Fixed in Release Bug Number Description
10.1.0.4 3319215 TAF client may dump if failover occurs during authentication
10.1.0.4 3404604 After failover service_names has both active and preconnect service
10.1.0.3 3224506 XA client using TAF may not failover correctly
10.1.0.3 3428146 For XA with JDBC in an RAC environment ensure we are synchronized before recover
10.1.0.3 3507464 XA rollback / commit do not handle RAC failover transparently

XA / Distributed Transactions

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

Fixed in Release Bug Number Description
10.1.0.4 3647829 Cursor is not always closed when database link closed (ORA-1000)
10.1.0.4 3702868 XA trace file does not start a new trace file every day
10.1.0.4 3748199 OCCI Object cache does not support global transactions
10.1.0.4 3817705 OERI[18301] / OERI[4415] from XA
10.1.0.4 3946694 XA recover throws ArrayIndexOutOfBoundsException
10.1.0.4 3948711 XA with database links may dump or perform slowly (link closed)
10.1.0.3 3566945 + ENH: No block level locking for externally co-ordinated prepared transactions
10.1.0.3 3224506 XA client using TAF may not failover correctly
10.1.0.3 3287202 Server trace file is produced if ORA-24767 is encountered in JDBC/XA
10.1.0.3 3425196 Dump in sqldhb using V8 OCI XA with Precompiled code
10.1.0.3 3428146 For XA with JDBC in an RAC environment ensure we are synchronized before recover
10.1.0.3 3488761 SQLException "Closed Connection" from OracleXAConnection.getConnection()
10.1.0.3 3507464 XA rollback / commit do not handle RAC failover transparently

Database Options / Major Features

The following tables list bugs in the Database Options / Major Features category.

Physical Standby Database / Dataguard

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

Fixed in Release Bug Number Description
10.1.0.4 3345155 Hang reopening standby database
10.1.0.4 3533351 FAL does not check available logs if some logs are not found
10.1.0.4 3535712 OERI[3020] / ORA-10567 from RAC with standby in max performance mode
10.1.0.4 3572299 Tablespace recovery of offline tablespace fails with OERI[kcrrlcmp.10]
10.1.0.4 3596262 Add DATAFILE on primary can cause standby to raise ORA-1274
10.1.0.4 3597439 ORA-1153 starting managed recovery when an RMAN backup is running
10.1.0.4 3697821 Dataguard standby cascading FAL may be slow
10.1.0.4 3762714 ALTER DATABASE RECOVER MANAGED STANDBY fails with OERI[3020]
10.1.0.4 3905430 SMON reports ORA-604/ORA-16000 errors when standby DB is opened read only on RAC
10.1.0.4 3922760 STANDBY_FILE_MANAGEMENT=auto does not auto-create sub-directories
10.1.0.4 3941862 ORA-16132 during regular graceful failover
10.1.0.4 3948384 ORA-4031 possible using LGWR ASYNC for archiving
10.1.0.4 3967914 Dataguard DELAY is incorrectly based on log receive time at standby
10.1.0.4 4035155 Timeout errors possible from LGWR ASYNC / SYNC around midnight on 30th of month
10.1.0.3 3412999 OERI[kcrfrgv_scn6] on "alter database recover ... finish"
10.1.0.3 3453107 ORA-16061 when archiving standby redo logs after failover

Advanced Queuing

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

Fixed in Release Bug Number Description
10.1.0.4 3237530 Intermittent ORA-25248 errors in alert file using AQ
10.1.0.4 3258674 QMN process may dump or raise an internal error during DML
10.1.0.4 3412625 DBMS_METADATA cannot handle AQ queue comments over 50 characters long
10.1.0.4 3554319 OERI[kqludp2] can occur adding a RULE to a RULESET
10.1.0.4 3588250 Do not report resignalled errors in AQ
10.1.0.4 3611423 PGA memory leak in AQ propagation process(J000)
10.1.0.4 3656306 JMS application may throw "UnsatisfiedLinkError: ociinit"
10.1.0.4 3803404 Dequeue may fail with OERI:4406
10.1.0.4 3803440 OERI [[kwqidorefetch:err] [3113] possible from dequeue
10.1.0.4 3804515 "kwqicaclcur" writes trace file entries for ORA-1013 and ORA-3113
10.1.0.4 3812876 OERI[kwqidrdq-buf1] in RAC after buffer ownership changes
10.1.0.4 3830460 Prevent reporting of certain errors to AQ trace files
10.1.0.4 3830972 DBMS_AQ.LISTEN on RAC cluster may not see new enqueue messages
10.1.0.4 3832611 OERI[kwqpaspse:!new] scheduling propogation from non-owner instance
10.1.0.4 3843277 Extraneous trace files produced by AQ
10.1.0.4 3928828 OERI[kghfrh:ds] / memory corruption from AQ
10.1.0.4 4066077 OERI[kwqbcgetcorr555] the failover capture with online target database
10.1.0.3 3122154 AQ JMS receive(wait_time) does not return after wait_time
10.1.0.3 3168530 AQ order of messages may not be preserved
10.1.0.3 3231814 Client may dump if AQ unregister fails and the subscription handle is freed
10.1.0.3 3336594 High CPU use in QMON scanning DEF$ tables needlessly
10.1.0.3 3358440 AQ propagation fails with ORA-942 or OERI:16622 at the remote node
10.1.0.3 3376491 AQ job queue processes dump in kponcbk
10.1.0.3 3456044 Poor AQ performance from multiple dequeuers performing rollback

Change Data Capture

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

Fixed in Release Bug Number Description
10.1.0.4 3838121 Dump calling dbms_cdc_subscribe.subscribe()
10.1.0.4 3895340 DBMS_CDC_PUBLISH fails with ora-1422

Flashback

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

Fixed in Release Bug Number Description
10.1.0.4 3540225 Dump (ldxmfncom) during startup after "FLASHBACK DATABASE"
10.1.0.4 3850163 EXPDP fails with ORA-8180 in tables with flashback enabled

JavaVM / JSP / Corba etc..

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

Fixed in Release Bug Number Description
10.1.0.4 3691672 + OERI[17067]/ OERI[26599] / dump (kgllkdl) from JavaVM / OERI:1100 from PMON
10.1.0.4 2825723 JavaVM problems generating random numbers on some platforms
10.1.0.4 3218825 Memory leak when Java Stored Procedure executed from PLSQL
10.1.0.4 3362575 Hang possible resolving classes in the JVM
10.1.0.4 3472450 Exception not seen using Client.invoke() for Java Stored Procedure
10.1.0.4 3517854 External call from a Java procedure sometimes fails
10.1.0.4 3889303 Dump under sprintf from JavaVM
10.1.0.4 3964487 Java stored procedure can corrupt memory in MTS
10.1.0.4 3982127 Dump (eoa_get_dedicated_ctx) using Java from multiple sessions in same process
10.1.0.3 2422432 StructDescriptor.createDescriptor() does not honor definer's rights
10.1.0.3 2930122 Java stored procedure may dump
10.1.0.3 3191604 DBA_JAVA_ARGUMENTS does not show all arguments for LAST method in a CLASS
10.1.0.3 3253770 ORA-4021 / "library cache pin" waits on RAC executing Java stored procedures
10.1.0.3 3312423 Oracle JVM ConversionBufferFullException can occur converting Strings for some NLS values

Job Queues

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

Fixed in Release Bug Number Description
10.1.0.4 3333863 DBA_JOBS.LAST_DATE is set even if the job runs with failures
10.1.0.4 3472564 "CPU used by this session" wrong when using job queue processes

LogMiner

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

Fixed in Release Bug Number Description
10.1.0.4 3456259 V$LOGMNR_CONTENTS can get duplicate transaction start records for the same id
10.1.0.4 3492040 OERI selecting from V$LOGMNR_CONTENTS for long DDL
10.1.0.4 3602321 Streams/logminer cannot handle partial rollback of a failed BULK BIND operation on a table with LOBS
10.1.0.4 3617406 Partial dictionary dump in redo stream considered complete
10.1.0.4 3733268 Streams / Logminer has problems resolving redo for rolled back incomplete row changes

Oracle Label Security

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

Fixed in Release Bug Number Description
10.1.0.4 3513629 Dump (vopqbc) from query with OLS and CAST(MULTISET())
10.1.0.4 3514937 SA_SYSDBA.DROP_POLICY does not drop the RLS policies
10.1.0.4 3721652 ALTER_LABEL() function converts datalabel to userlabel if NEW_DATA_LABEL null
10.1.0.4 3726694 First update with a new OLS label gets ORA-28115
10.1.0.4 3936531 Incorrect schema for OLS validation procedure
10.1.0.3 3218678 Using bad syntax for SA_POLICY_ADMIN.apply_table_policy can lead to ORA-4098 errors
10.1.0.3 3221661 SA_POLICY_ADMIN.enable_table_policy does not re-enable a previously disabled policy
10.1.0.3 3348437 Intermittent dump in kzrtevw() possible in OLS environment
10.1.0.3 3419794 INSERT / UPDATE DML less efficient than needed in OLS
10.1.0.3 3423843 ENH: Small OLS performance improvement
10.1.0.3 3445982 Performance overhead using OLS insert_control with no labelling function
10.1.0.3 3517129 Small performance overhead for DML in OLS with check_control
10.1.0.3 3551597 User sessions cannot determine if OLS database is OID enabled or not
10.1.0.3 3568528 ENH: Increase maximum OLS predicate length to 4000 bytes

Oracle OLAP

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

Fixed in Release Bug Number Description
10.1.0.4 3443451 obj(disksize) shows bad result for all NA variable in AW
10.1.0.4 3631932 SYS_OP_PAR() fails with ORA-979
10.1.0.4 3667108 Excessive memory allocated when constructing mdm model
10.1.0.4 3691588 OLAP EVERY function does not loop correctly
10.1.0.4 3756701 OLAP "allstat" does not honor AW attached first
10.1.0.4 3810586 Rolap query performance degrades after many passes in same connection
10.1.0.3 3270717 ORA-6510 enabling BIBeans/OLAPI access on imported AW with AWM
10.1.0.3 3315495 Some DIMENSION values not recoginised
10.1.0.3 3320365 import of eif file never completes
10.1.0.3 3322849 Drill operation on Beans Crosstab object can use a lot of memory
10.1.0.3 3322883 OLAP revalidate() uses more memory than needed
10.1.0.3 3368863 KVSIZE on composite btree may error / dump
10.1.0.3 3369114 OLAP Enabler sets wrong Express object type of ID
10.1.0.3 3379172 In AW selecting ancestors of value at level throws exception
10.1.0.3 3380940 "asym" selection on value based geography dim throws exception
10.1.0.3 3380981 asym query on aw value based measure hangs
10.1.0.3 3392405 Solved AQ Time Dimension sorts alphabetically (instead of by end date)
10.1.0.3 3409449 Multiple deletes can cause 'xscbtlookup01' assert on parent node of compressed btree
10.1.0.3 3449423 OLAP may deadlock (ORA-60)
10.1.0.3 3454824 Highheight cannot allocate memory for very large input
10.1.0.3 3485491 AWS can use excessive space
10.1.0.3 3497649 Frequent deletion of AWS causes tablespace fragmentation
10.1.0.3 3498177 Dump in Geneva forecasting method 521
10.1.0.3 3498231 It is not possible to import eif file containing alias
10.1.0.3 3504463 sortDescending with nulls last ignores for top total measure case
10.1.0.3 3540228 AGGMAP ADD model sometimes gets incorrect results
10.1.0.3 3545392 Updating OLAP expression query dumps
10.1.0.3 3614873 Server may dump after several aw calc queries

Oracle Text (Formerly interMedia Text)

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

Fixed in Release Bug Number Description
10.1.0.4 3878264 + Output from CTXLC corrupt on some platforms
10.1.0.4 3072094 CATSEARCH query through a view fails with OERI [20084]
10.1.0.4 3225530 DBMS_METADATA fails to generate complete definition for a domain index
10.1.0.4 3298019 Unreliable results with new_german_spelling enabled
10.1.0.4 3305543 Periods ('.') are not accepted in XPATH names
10.1.0.4 3324698 Wrong tokens produced using numjoin and numgroup
10.1.0.4 3372915 Text query with bind variables in CONTAINS may raise false parse errors
10.1.0.4 3412553 ORA-942 during functional invocation of CONTAINs on another user's table
10.1.0.4 3413436 Oracle Text may fail with ORA-1480 errors
10.1.0.4 3454019 Wrong results from wildcard in CATSEARCH / CONTEXT predicate with PREFIX INDEXING
10.1.0.4 3475827 CATSEARCH with wildcard (%) may dump
10.1.0.4 3510694 ORA-29875 (ORA-1402) raised during concurrent operations on Text indexes
10.1.0.4 3657757 CTX_DOC.MARKUP produces incorrect offsets for XML with CDATA tags
10.1.0.4 3746612 DRG-100[50600][drlu.c] for long queries using USER_LEXER
10.1.0.4 3750008 Mail filter fails on long headers and does not index all RFC822 fields
10.1.0.4 3917948 Dump (drljtkn) from CTX_DDL.SYNC_INDEX with Japanese lexer
10.1.0.4 3926376 Subheader fields in RFC822 submessages are not text indexed
10.1.0.4 3940410 Cursor leak (ORA-1000) from DML if concurrent session is creating a Text index ONLINE
10.1.0.4 3958875 Dump / memory corruption from Text index of EMAIL with long epilogue
10.1.0.4 3984442 Transactional text query raises indexing errors on unsync'ed documents
10.1.0.4 4001799 Dump from complex Text query
10.1.0.3 3376786 * Concurrent LOB updates lost - can cause inconsistent Text Query results . This bug is alerted in Note:263548.1
10.1.0.3 3149380 Wrong results using stemming , fuzzy or soundex with % in a CONTAINS query
10.1.0.3 3175001 ORA-1426 REBUILDing Text index with more than 255 partitions
10.1.0.3 3200136 Wrong results possible from MERGE JOIN CARTESIAN with DOMAIN INDEX
10.1.0.3 3331617 LPX-229 echoed to STDERR uring CTXXPATH index creation for rows with a NULL XMLType
10.1.0.3 3353657 Internal problem with some CTXSYS packages
10.1.0.3 3408192 Heavy concurrent DML scenarios can cause $R table to contain deleted rowids
10.1.0.3 3451741 Dump (gxtsnGetPar) creating Text index with THEMES=YES
10.1.0.3 3495537 HTML Sectioner may improperly strip spaces from documents
10.1.0.3 3510094 Use of an analytic function skews the result from CONTEXT indextype SCORE operator
10.1.0.3 3545539 Dump under kgmexec->kglpnp using trusted callouts / domain indexes / Oracle Text

RAC (Real Application Clusters) / OPS

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

Fixed in Release Bug Number Description
10.1.0.4 2858082 False ORA-1652 in alert log when there is free space in RAC environment
10.1.0.4 2883177 Additional diagnotics for RAC "slowsend" problems
10.1.0.4 2931779 False ORA-1555 accessing "cache read" LOBs in RAC
10.1.0.4 3224546 ORA-12564 from CMAN in a RAC with listener load balancing
10.1.0.4 3372217 OERI[kclfadb_5] possible in RAC
10.1.0.4 3372242 OERI[kjxbdomps2m:!survivor] possible during reconfiguration in RAC
10.1.0.4 3385843 OERI [kclchkinteg_19] / crash during instance recovery in RAC (rare)
10.1.0.4 3440376 OERI[kclfadb_2] / LMS crashes the instance
10.1.0.4 3476477 RAC session can hang
10.1.0.4 3482748 LMS may die with OERI:kclfbbast_2
10.1.0.4 3505528 OERI[kjlfr_1] in LMD during startup when instance is low on memory
10.1.0.4 3508608 CR request retry can spin in RAC for LOB data
10.1.0.4 3509265 SHUTDOWN may hang with "waiting for instances to leave: N"
10.1.0.4 3535712 OERI[3020] / ORA-10567 from RAC with standby in max performance mode
10.1.0.4 3565660 OERI[kclrinit_3] from parallel recovery in RAC
10.1.0.4 3575858 OERI[kcleafn_1] from ORADEBUG LKDEBUG for a BL
10.1.0.4 3588448 Waits for 'global cache cr request' on RAC if UDP overflow occurs
10.1.0.4 3588633 Manual shrinking of the buffer cache takes a long time
10.1.0.4 3605241 Enhanced diagnostic information for internode parallel query
10.1.0.4 3608038 OERI[kclshrshr_8] possible in RAC
10.1.0.4 3610343 OERI:[ktbdchk1: bad dscn] in RAC
10.1.0.4 3611945 LMS may dump processing a BAST after a cache resize operation
10.1.0.4 3613126 ALTER DATABASE DATAFILE OFFLINE can cause OERI[kcfquewr_2] / crash in RAC
10.1.0.4 3614008 OERI[kjcs_m:2]
10.1.0.4 3615004 Corrupt backup / ORA-19675 using RMAN PROXY backup in RAC environment
10.1.0.4 3621300 OERI[krvseds get obj] while handling thread enable/disable in logical standby
10.1.0.4 3625370 CGS nested reconfiguration may hang
10.1.0.4 3626272 DLM can allocate too many message buffers when CLUSTER_DATABASE=false
10.1.0.4 3626463 Hang possible on 'ges inquiry response' after reconfiguration
10.1.0.4 3627263 Deadlock / hang during RAC instance startup
10.1.0.4 3630273 Apply may hang during initialization with RAC primary
10.1.0.4 3632400 LMS may hang in kslges() waiting for a post
10.1.0.4 3641398 OERI[kjbmiconsign:ds] possible in RAC
10.1.0.4 3641819 Undetected deadlock possible in RAC
10.1.0.4 3646162 False deadlock (ORA-60) in a RAC environment / TM lock mode change
10.1.0.4 3649839 Intermittent ORA-12805 on internode parallel create/rebuild index
10.1.0.4 3671867 OERI[kclchkinteg_2] possible in RAC environment
10.1.0.4 3698501 Reconfiguration may reuse an old incarnation number
10.1.0.4 3722208 OERI[kjzgpoll1] from DIAG process if ocssd shuts down
10.1.0.4 3724485 Enqueue waits may occur with no obvious holder in RAC
10.1.0.4 3777178 TA / US enqueue deadlock during transaction recovery in RAC
10.1.0.4 3798843 UTL_RECOMP on RAC runs all recompilation jobs on the initiating node
10.1.0.4 3799470 RAC LMD crashes instance with dump in kjddgmak
10.1.0.4 3801483 Instance hang possible in RAC
10.1.0.4 3812876 OERI[kwqidrdq-buf1] in RAC after buffer ownership changes
10.1.0.4 3830972 DBMS_AQ.LISTEN on RAC cluster may not see new enqueue messages
10.1.0.4 3832099 OERI[kcbgtcr_13] can occur in RAC
10.1.0.4 3832611 OERI[kwqpaspse:!new] scheduling propogation from non-owner instance
10.1.0.4 3843318 OERI[ksxpwait10] / hang possible in RAC
10.1.0.4 3851225 OERI:[kcsbcscn13] can occur under heavy load
10.1.0.4 3857050 LMON leaks memory when another instance leaves or join the cluster
10.1.0.4 3857903 LMS not posted by LGWR when hot current block requires a log flush during BAST
10.1.0.4 3875155 RAC startup with SVRCTL / GSD may dump / cause connections to fail
10.1.0.4 3885860 Latch contention form concurrent reconfiguration and SYSTEMSTATE dump
10.1.0.4 3889123 DB_FILE_MULTIBLOCK_READ_COUNT higher than 16 blocks has no effect in RAC
10.1.0.4 3892704 During reconfiguration processes may fail with OERI:kjuocl1
10.1.0.4 3905430 SMON reports ORA-604/ORA-16000 errors when standby DB is opened read only on RAC
10.1.0.4 3906669 LMS may fail with OERI[kjbmpclo:cvt]
10.1.0.4 3925815 OERI[kjccfmb:x!] possible in a RAC environment
10.1.0.4 3936811 Rare OERI[kjbrass:2scn] after RAC reconfiguration
10.1.0.4 3951017 Sessions hang with 'gc cr multi block request' / UDP overload
10.1.0.4 3975816 OERI[kjbrref:!ini] in RAC
10.1.0.4 4020000 Capture aborts with OERI[kwqbcgetcorr555] after a failover
10.1.0.4 4131721 Process may fail with OERI:kjsmbesmi1 in RAC
10.1.0.4 4153253 GCS master may hold lower mode than GCS client (rare)
10.1.0.3 3253770 ORA-4021 / "library cache pin" waits on RAC executing Java stored procedures
10.1.0.3 3268802 Additional diagnostics for deadlock in RAC environment
10.1.0.3 3312874 USE_STORED_OUTLINES causes increased "library cache lock" requests in RAC
10.1.0.3 3316345 ENH: Enhance checks on interconnect blocks by a check for the correct DBA
10.1.0.3 3342182 Instance hang on startup possible in RAC
10.1.0.3 3384299 OERI[kjbrrcon:cl] possible on buffer cache shrink in RAC
10.1.0.3 3400883 OERI[kjblconsign:md] possible in RAC
10.1.0.3 3420610 RAC "BAST" leak can lead to instance hang
10.1.0.3 3428146 For XA with JDBC in an RAC environment ensure we are synchronized before recover
10.1.0.3 3432427 Dump possible in LGWR (in ksliwat) in RAC mode
10.1.0.3 3452686 OERI[ktcrsp_1: drop/truncate not comp] possible in RAC at end of reconfiguration
10.1.0.3 3475932 Cross instance archive log not generated remotely
10.1.0.3 3484944 OERI[kjbrclo:gq] possible if a side-channel message is processed during process death
10.1.0.3 3507464 XA rollback / commit do not handle RAC failover transparently
10.1.0.3 3507703 V$DB_CACHE_ADVICE . ESTD_PHYSICAL_READ_FACTOR is incorrect on RAC
10.1.0.3 3514664 OERI[504][ges process hash list] possible in RAC during diagnostics dump
10.1.0.3 3542633 OERI[kjbstrec] in instance recovery in RAC
10.1.0.3 3544142 It is possible for a process to be FROZEN while holding a latch
10.1.0.3 3552489 OERI:kjbcropen:flockp possible if RAC process killed
10.1.0.3 3625803 Node failure during reconfig may cause cascading node failures

Recycle Bin

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

Fixed in Release Bug Number Description
10.1.0.4 3739622 DBMS_UTILITY.COMPILE_SCHEMA throws ORA-20000 if schema as TRIGGERS in Recycle bin
10.1.0.4 3749025 Internal errors performing operations on objects in RECYCLE BIN
10.1.0.4 3761763 SDO_GEOMETRY invalid during install if object in recycle bin
10.1.0.4 4090887 Online index rebuild/create with recycle bin generates incorrect DDL redo
10.1.0.3 3255906 DBA|ALL|USER_TABLES / DBA|ALL|USER_INDEXES views show dropped objects in the RECYCLE bin

Replication

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

Fixed in Release Bug Number Description
10.1.0.4 3339218 ORA-26571 performing DML on a replicated table
10.1.0.4 3492211 ORA-23308/ora-23309 replicating pre-created tables with LOB
10.1.0.4 3672876 Dump on execution of a MERGE statement in replication
10.1.0.4 3819011 OERI[23050] on DML against a table with OBJECT columns in a replication group

Row Level Security / FGA

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

Fixed in Release Bug Number Description
10.1.0.4 3554126 ORA-39135 from datapump export with FGAC
10.1.0.4 3665042 SQL does not error if FGA with user declared handler raises an EXCEPTION
10.1.0.4 3684796 ORA-904 when explaining GROUPING SETS query with fine grained auditing
10.1.0.4 3804250 DML to a remote table from a table with FGA fails with ORA-904/ORA-2063
10.1.0.4 3945630 RLS policies attempt to create before tables during import using IMPDP

Shared Server (formerly MTS)

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

Fixed in Release Bug Number Description
10.1.0.4 3144710 OERI[526] querying V$ tables over shared server connection
10.1.0.4 3666502 OERI[1236] can occur intermittently in a shared server
10.1.0.4 3802873 LDAP connections can not be established from MTS dispatchers
10.1.0.4 3964487 Java stored procedure can corrupt memory in MTS
10.1.0.3 3325395 ORA-130 can occur if Oracle tries to contact a local listener
10.1.0.3 3532846 Dump (kditdes) / Dump (ktaftt) from concurrent SDO_RELATE operations in MTS

Spatial Data

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

Fixed in Release Bug Number Description
10.1.0.4 2727824 SDO_WITHIN_DISTANCE fails with 2D window against 3D data indexed 2D
10.1.0.4 3440387 ordsys types are exported in transportable tablespace mode
10.1.0.4 3608345 Wrong answer from VALIDATE_GEOMETRY_WITH_CONTEXT with LRS geometry
10.1.0.4 3761763 SDO_GEOMETRY invalid during install if object in recycle bin
10.1.0.4 3819074 SDO_GEOM.SDO_MAX_MBR_ORDINATE may error
10.1.0.4 3837774 False ORA-13351 from VALIDATE_GEOMETRY_WITH_CONTEXT
10.1.0.4 3878351 SDO_TOPO_GEOMETRY.GET_GEOMETRY returns invalid geometry
10.1.0.4 3923253 SDO_GEOM.RELATE result 'disjoint' / 'overlapbdyintersect' depends on tolerance
10.1.0.4 3924156 SDO_WITHIN_DISTANCE returns false positive comparing polygons
10.1.0.4 3928367 DBUA upgrade of Spatial stops if COMPATIBLE < 10.0
10.1.0.4 3972938 ORA-39704 upgrading Spatial
10.1.0.4 3997272 ORA-13236, ORA-942 inserting data into spatial table
10.1.0.4 4036555 GET_GEOMETRY does not work for a different schema to the topology owner (ORA-942)
10.1.0.4 4106843 Invalid geometry may dump in mdgcvtgmadt
10.1.0.3 3202348 ALL_SDO_GEOM_METADATA has PUBLIC update access
10.1.0.3 3300118 Memory corruption / dump from SDO_INTERSECTION with 'WALKING'
10.1.0.3 3532846 Dump (kditdes) / Dump (ktaftt) from concurrent SDO_RELATE operations in MTS
10.1.0.3 3630522 SDO_VALIDATE may report false duplicates

Spatial RTREE

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

Fixed in Release Bug Number Description
10.1.0.4 3588345 Create spatial index fails with ORA-13249

Streams / Logical Standby

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

Fixed in Release Bug Number Description
10.1.0.4 3806172 * Logical standby apply may stop with ORA-355 / ORA-353 . This bug is alerted in Note:280832.1
10.1.0.4 2766894 Logical standby apply gives "no data found" if PK not enforced with index
10.1.0.4 3124406 Logical standby will not replicate DLL issued by DBMS_SQL
10.1.0.4 3347567 Wrong results from V$SGASTAT for STREAMS_POOL
10.1.0.4 3427396 Logical standby apply may dump (kkttrex)
10.1.0.4 3443509 Large or PDML CTAS may be followed by logical standby apply 1403 failure
10.1.0.4 3465760 OBJECT_OWNER of some DDLs are not captured (eg: dimension, operator, library)
10.1.0.4 3479073 Capture process aborts with ORA-25303 alter ALTER QUEUE TABLE changing instance
10.1.0.4 3486366 LogMiner cannot detect tables with invalidation redo from direct path loads
10.1.0.4 3494888 PDML can cause apply to stop / dump
10.1.0.4 3540137 Logical standby apply may run slowly
10.1.0.4 3556601 Logical standby cannot handle CTAS of an IOT with a mapping table
10.1.0.4 3568433 Apply gets unsupported LCR or no-data found error for partitioned tables
10.1.0.4 3599816 Propagation ACKS not received when flow control signalled from target database
10.1.0.4 3602321 Streams/logminer cannot handle partial rollback of a failed BULK BIND operation on a table with LOBS
10.1.0.4 3611423 PGA memory leak in AQ propagation process(J000)
10.1.0.4 3617406 Partial dictionary dump in redo stream considered complete
10.1.0.4 3618700 SQL apply/alter user/role fails with ORA-28003 / ORA-28221
10.1.0.4 3621300 OERI[krvseds get obj] while handling thread enable/disable in logical standby
10.1.0.4 3630273 Apply may hang during initialization with RAC primary
10.1.0.4 3631915 Logical apply errors with OERI:kdogsli1 and ORA-1332
10.1.0.4 3633226 Real time apply can be turned on even when there are no SRLs
10.1.0.4 3639408 Apply error mining redo from CONVERT_LONG_TO_LOB_CHUNK
10.1.0.4 3673561 READ_SCN may not advance even when there is no eager transaction
10.1.0.4 3687949 Logical standby may not restart properly at start of PDML/PDDL
10.1.0.4 3697371 Logical standby apply may fail with OERI:knaslod:ipoc
10.1.0.4 3731546 Logical standby does not handle transient duplicates in heap-organized tables
10.1.0.4 3733268 Streams / Logminer has problems resolving redo for rolled back incomplete row changes
10.1.0.4 3741999 RMAN may remove the archived logs needed by Streams capture to restart
10.1.0.4 3751202 Streams capture fails to enqueue after restart
10.1.0.4 3761784 Capture stops while mining through upgrade/patch on primary
10.1.0.4 3764009 Streams writes too many Axxx process messages to the alert log
10.1.0.4 3769884 Apply aborts on first DML after handler changed when ORA-4068 encountered
10.1.0.4 3775570 Dump [memcpy] ORA-12805 during Logical Standby apply
10.1.0.4 3779568 Bad CTAS marker when more than 2 redos generated for column information
10.1.0.4 3785754 Logminer does not maintain LOGMNR_COL$ properly (ORA-2437 on upgrade)
10.1.0.4 3788879 Streams capture process does not abort on OERI[17112]
10.1.0.4 3800634 OERI [kghstack_free1] [knlucanon:res_buf] can occur in Streams
10.1.0.4 3800644 OERI [kghstack_free1] [kniascg: cgpi_knictx] can occur in Streams
10.1.0.4 3802111 Streams capture memory leak
10.1.0.4 3812064 Excessive "krvx warning" errors in trace files with Streams
10.1.0.4 3816572 False warning errors in alert log
10.1.0.4 3831971 Streams Qxxx processes may spin when there is no load
10.1.0.4 3840917 Multiple logminer warning messages in alert log
10.1.0.4 3850163 EXPDP fails with ORA-8180 in tables with flashback enabled
10.1.0.4 3854166 Allow correction of MVDD corruption due to bug 3785754
10.1.0.4 3865227 Default value for new Streams parameters not set after upgrade
10.1.0.4 3880023 ORA-4043 on remove_streams_configuration
10.1.0.4 3881099 ORA-1280 diagnostic enhancement
10.1.0.4 3892672 Data inconsistency replicating between different character sets (Streams)
10.1.0.4 3893337 Streams downstream capture hotmining has problems
10.1.0.4 3895546 Capture may dump after certain DDLs
10.1.0.4 3897623 Logminer attempts to open an invalid logfile for upstream capture
10.1.0.4 3900290 Excessive memory spill in Streams for DDL transactions with LOB DMLs
10.1.0.4 3903218 RFS takes wrong enqueue for downstream capture (ORA-3xx errors)
10.1.0.4 3903913 Streams spill data hard to decode
10.1.0.4 3913642 OERI[knlqdqm2usr:4] / incorrect data at Logical Standby
10.1.0.4 3917532 AnyData objects with length 232/233 may become corrupt - affects Streams
10.1.0.4 3918228 OERI [krvuam1] in capture parallel processes
10.1.0.4 3918257 Streams capture misses out of line clob data with 9.2 compatibility
10.1.0.4 3919928 Streams dictionary upgrade to 10g fails to replace partition definitions
10.1.0.4 3926395 Apply execute error fails on very large transactions
10.1.0.4 3928153 "alter database [stop | abort] logical standby apply" hangs
10.1.0.4 3934198 Logical bystanders are not junked on a logical failover
10.1.0.4 3941723 Streams apply may use a lot of CPU with no messages
10.1.0.4 3945264 Dump (knaspd) in apply process for mismatched column
10.1.0.4 3953131 Altering first_scn of Streams capture results in ORA-30036 / ORA-1562
10.1.0.4 3957178 Cursor leak on error in apply (ORA-1000)
10.1.0.4 3960844 Switch to logical standby may not see active PLSQL changes (data missing)
10.1.0.4 3988801 Dump (ldxsto or lxhasc) in Logical standby apply
10.1.0.4 3990005 Unsupported LCR if logminer restarts in middle of a merge group
10.1.0.4 4002681 Log apply terminates due to corrupt redo log block header
10.1.0.4 4020000 Capture aborts with OERI[kwqbcgetcorr555] after a failover
10.1.0.4 4026166 Capture process discards MVDD info for renamed tables
10.1.0.4 4066077 OERI[kwqbcgetcorr555] the failover capture with online target database
10.1.0.4 4070668 Error exceptions lost if EXECUTE_ERROR or EXECUTE_ALL_ERRORS caught
10.1.0.4 4090887 Online index rebuild/create with recycle bin generates incorrect DDL redo
10.1.0.3 3256816 Streams capture has no warnings for long running / large transactions
10.1.0.3 3262648 Logical Apply may OERI[krvuffl: memsize below zero]
10.1.0.3 3269297 Allow apply to skip a transaction
10.1.0.3 3313274 Direct path load of LOBs can cause data loss/truncation in streams
10.1.0.3 3370235 Corrupt data possible in logical standby
10.1.0.3 3382229 Reset of capture SCN after destination incomplete recovery does not work
10.1.0.3 3390021 PGA memory leak in apply server
10.1.0.3 3401065 Logmnr may spill unnecessarily impacting performance
10.1.0.3 3445164 ORA-1722 (invalid number) starting Logical Standby Apply
10.1.0.3 3449174 Attempt to supplementally log LONG column can OERI/dump
10.1.0.3 3449951 ORA-1562 can occur on DBMS_LOGMNR_SESSION.PURGE_SESSION or DBMS_CAPTURE.ALTER_CAPTURE
10.1.0.3 3464629 LOGMNR_SPILL$ table grows in an unbounded fashion
10.1.0.3 3465718 Logical Standby may not honour SKIP commands for objects repeatedly created on the primary
10.1.0.3 3489316 Unnecessary tracing/debug calls occur during capture
10.1.0.3 3517698 Logical standby cannot support mining through application of a Patch Set
10.1.0.3 3553331 Unnecessary trace overhead in Streams apply
10.1.0.3 3565109 Logminer may not be able to resolve log files with multiple archive destinations
10.1.0.3 3610978 OERI [krvscst failure] possible during switchover

Transportable Tablespaces

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

Fixed in Release Bug Number Description
10.1.0.4 3440387 ordsys types are exported in transportable tablespace mode
10.1.0.4 3489246 OERI[pitl1] / ORA-1498 ANALYZING table transported from 8.1.7 to 9.2.0
10.1.0.4 3533996 Using transportable tablespaces disables intra-partition PDML
10.1.0.4 3573604 A transported bitmap index can give various OERI errors / ORA-8102
10.1.0.4 3617574 Transport of bitmap index gives errors at transported to site
10.1.0.4 3641963 Transport of a table with LONG RAW and added columns is corrupt at target
10.1.0.4 3941862 ORA-16132 during regular graceful failover
10.1.0.4 4033756 RMAN "transport tablespace" fails with ORA-39123 / ORA-12911
10.1.0.3 3613078 OERI[4097] from DML on TRANSPORTED tables with ASSM

XDB

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

Fixed in Release Bug Number Description
10.1.0.4 3883156 I ORA-6502 from DBMS_XDBZ0.MIGRATE_PITRIG when patching to 9.2.0.5
10.1.0.4 3315725 Dump [qmxtgGetOpqImageFromXob] when result of XMLTransform is null
10.1.0.4 3333978 Cannot register certain schemas (OERI:qmtsAddSRef1)
10.1.0.4 3374251 copyEvolve() does not reset modification date
10.1.0.4 3396792 Dump (qmxtrRewriteOpn) using XDB
10.1.0.4 3431498 extract and existsnode may ORA-29900 with three operands
10.1.0.4 3476594 Dump (kokax_set_existsvec) using XMLSEQUENCE with "//"
10.1.0.4 3481959 SQLX query using ROWNUM fails with OERI [15160]
10.1.0.4 3487029 Java method dbms_xslprocessor.setParam does not process parameter properly
10.1.0.4 3536149 Element name in SQLX XmlElement() function limited to 30 characters
10.1.0.4 3553302 Dump (qmxluMoveToHead) selecting from schema with anyType stored as a CLOB
10.1.0.4 3575797 XMLSchemas and types are not exported in table and tablespace mode export
10.1.0.4 3608916 Dump / ORA-21527 selecting from XDB Schema
10.1.0.4 3617191 OERI[qmxdmatchingchildren:overflow-1] using EXTRACT from large XML document
10.1.0.4 3639020 XML processing instructions in a simpletype fails validation
10.1.0.4 3639267 Dump executing a join with a registered schema
10.1.0.4 3669661 Spin possible registering certain XSD
10.1.0.4 3716255 ORA-21500 can occur querying an XMLType table with the fix for bug 3454829
10.1.0.4 3787833 ORA-4030 / excess memory use when an XML schema is registered
10.1.0.4 3804828 Dump [qmtcreatebody] on SELECT / describe of XML table
10.1.0.4 3807995 ORA-31161 when register XML schema with cyclic definition
10.1.0.4 3841861 LPX-225 after using DBMS_XMLGEN.CONVERT(...ENTITY_DECODE)
10.1.0.4 3861534 ORA-31076 on registering xml schema with no "schemaLocation" <import> element
10.1.0.4 3873324 OERI[kslfget_pvt1] inserting XML with comments over 4k
10.1.0.4 3876987 Namespace error when many prefixes map to the same namespace
10.1.0.4 3905855 Decimal element type in XML errors for exponential notation
10.1.0.4 3926149 XDB queries can show worse performance in 10.1.0.3 (to 10.1.0.2)
10.1.0.4 3927681 Duplicate text when a node is split by a processing instruction
10.1.0.4 3927850 XMLDB shifts text when node over 8k in length
10.1.0.4 3935714 OERI[kokax_oct_adtcbk5] while extracting data from schema based table
10.1.0.4 3941443 "isSchemaValid" dump in qmxInsertNodeBefore
10.1.0.4 4016066 Extract from XMLType table dumps in kxsffir
10.1.0.4 4057408 LPX-216 / dump while extracting data from schema based
10.1.0.3 3167925 XDB may dump / OERI updating an ACL
10.1.0.3 3238383 OERI[qmhsesskeybuf] can occur during an HTTP connection to XDB
10.1.0.3 3327427 Schema-based instance cannot have text() split across PI's ORA-30931
10.1.0.3 3362205 OCI-21500 [kohfrm505] inserting an XML document with invalid characters
10.1.0.3 3397689 SQL/XML rewrite does not take place with XMLAGG and XPATH
10.1.0.3 3421087 Memory leak can occur when using DBMS_XMLGEN
10.1.0.3 3449245 getXML may produce incorrect hex character output
10.1.0.3 3469775 DBMS_XMLGEN.CONVERT can fail with OERI[17112]
10.1.0.3 3518909 Session (UGA) memory not released after using DBMS_XMLPARSER
10.1.0.3 3522502 ORA-38435 executing a query using the EVALUATE operator

interMedia (Image)

The following table lists the interMedia (Image) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.1.0.4 3546019 Cursor leak from interMedia image matching index inserts and updates
10.1.0.4 3713138 OrdHttpUploadFile.simpleFileName returns wrong filename if name contains a ']' character
10.1.0.4 3903243 IMG-703 when loading JPEG image
10.1.0.4 4012790 ORA-2940 error converting image from TARGA to JPEG
10.1.0.3 3319287 ordimage.getproperties spins for particular images (JFIF)
10.1.0.3 3462254 interMedia INVALID after upgrade from 9.2.0.1 - 9.2.0.3 to 10g
10.1.0.3 3539130 IMG-705 when processing a TIFF image with fillorder lsb-to-msb

Programming Languages

The following tables list bugs in the Programming Languages category.

JDBC

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

Fixed in Release Bug Number Description
10.1.0.4 2055862 OracleCachedRowSet.getRow() returns wrong value after last()
10.1.0.4 3387352 Insert on scrollable ResultSet with ORDER BY gives ORA-1732
10.1.0.4 3394821 oracleDriver does not work in applet mode
10.1.0.4 3398272 oracleXMLSave setautocommit(false) fails for Sybase if autocommit state is false
10.1.0.4 3430426 ORA-1459 attempting to SELECT a LONG via a database link with multibyte using JDBC
10.1.0.4 3472450 Exception not seen using Client.invoke() for Java Stored Procedure
10.1.0.4 3472676 ArrayIndexOutOfBoundsException or corrupt data changing fetch size between fetches
10.1.0.4 3487029 Java method dbms_xslprocessor.setParam does not process parameter properly
10.1.0.4 3571017 SqlWarning (ORA-17110) is returned even if stmt.clearWarnings() is used
10.1.0.4 3585808 JDBC deadlock possible between threads
10.1.0.4 3597388 OS authentication does not work with 10g JDBC OCI driver
10.1.0.4 3624510 JDBC deadlock between oracleConnection / scrollableResultSet
10.1.0.4 3631763 Bug 3283151 not fixed for japanese characterset JA16EUC
10.1.0.4 3636909 OCINewPassword does not work in JDBC OCI 10g
10.1.0.4 3643277 NullPointerException on commit/close after bind which errors
10.1.0.4 3643391 ORA-4043 "object does not exist" using a SYNONYM of a TYPE in JDBC
10.1.0.4 3656306 JMS application may throw "UnsatisfiedLinkError: ociinit"
10.1.0.4 3658525 StackOverflowError binding a stream over 4k to ScrollableResultSet bind
10.1.0.4 3663103 getTimestamp may return truncated time value using Calendar parameter
10.1.0.4 3676337 Wrong data inserted into column when setxxx() called twice with different types
10.1.0.4 3682147 Missing bytes fetching RAW OUT PLSQL parameters with JDBC Thin
10.1.0.4 3691179 oracle.sql.TIMESTAMP.dateValue() etc not implemented
10.1.0.4 3713138 OrdHttpUploadFile.simpleFileName returns wrong filename if name contains a ']' character
10.1.0.4 3735938 ORA-1003 from JDBC with invalidated PLSQL
10.1.0.4 3741829 NullPointerException in UTFToString for the 0xFFFD character
10.1.0.4 3747708 OracleResultSetCache is not public in 10g JDBC
10.1.0.4 3756847 ORA-1461 from JDBC binding to a LONG
10.1.0.4 3757722 Closing oracleCachedRowSet object closes the connection as well
10.1.0.4 3759560 Wrong result using Oracle Object Type with nested subtypes - may appear as NULL
10.1.0.4 3776702 ORA-17148 executing a PLSQL block from a PreparedStatement in JDBC
10.1.0.4 3794122 registerOutParameter() may throw SQLException "parameter type conflict"
10.1.0.4 3823379 Data corruption inserting with 10g JDBC OCI drivers to UTF8 database using batching
10.1.0.4 3826792 JDBC OCI leaks client side memory when calling PLSQL with REF CURSOR OUT bind
10.1.0.4 3876715 Cannot set a fractional portion of a TIMESTAMP in an ADT
10.1.0.4 3906221 JDBC binds as a TIMESTAMP when V8Compatibility is true for NULL bind values
10.1.0.4 3913596 ORA-1461 from JDBC with multibyte data close to 4000 byte boundary
10.1.0.4 3913663 ORA-1461 when inserting non-ascii string with retainV9LongBindBehavior=true
10.1.0.4 3925069 Wrong COLUMN_TYPE returned by getProcedureColumns for a Date parameter
10.1.0.4 3946694 XA recover throws ArrayIndexOutOfBoundsException
10.1.0.4 4003382 IllegalArgumentException when two JDBC Thin connections made using LDAP over SSL
10.1.0.4 4013463 Garbage / NullPointerException in JDBC processing error messages from TG4DRDA
10.1.0.4 4025276 Bind corruption with Thin driver binding NULL OracleTypes.FIXED_CHAR
10.1.0.4 4045268 JDBC connection pool not notified to close connections when public interconnect lost
10.1.0.4 4055118 Unexpected JDBC character conversion exception for invalid characters in ADTs
10.1.0.4 4065600 SQLException (invalid character) in JDBC for some DB2 errors
10.1.0.4 4072741 JDBC DMS trace data includes recursive SQL statement fetches
10.1.0.3 2284660 OracleConnectionCacheImpl may get incorrect count of opened connections
10.1.0.3 2622681 PreparedStatement.GetParameterMetaData() throws ORA-17023
10.1.0.3 3122154 AQ JMS receive(wait_time) does not return after wait_time
10.1.0.3 3143435 JDBC Thin connecting to server with ASO and DCD gets NegativeArraySizeException
10.1.0.3 3144878 oracle.sql.TIMESTAMP is not serializable
10.1.0.3 3192557 JDBC Thin with CallableStatement consumes/leaks database UGA memory
10.1.0.3 3283151 ORA-1461 can occur in JDBC Thin 10g binding a shift sensitive string to 9.2 DB
10.1.0.3 3287202 Server trace file is produced if ORA-24767 is encountered in JDBC/XA
10.1.0.3 3320782 JDBC describe does not work for SYNONYM of an object type
10.1.0.3 3328542 JDBC OCI slower than Thin for LONG RAW data
10.1.0.3 3347676 Deadlock in JDBC connection pool between getConnection() and close()
10.1.0.3 3428146 For XA with JDBC in an RAC environment ensure we are synchronized before recover
10.1.0.3 3437870 Java thread deadlocks sharing OracleOCIConnectionPool connections between threads
10.1.0.3 3466818 Poor performance of Java class TIMESTAMPLTZ toDate() method
10.1.0.3 3479558 Break/SetQueryTimeout can cause JDBC client to hang
10.1.0.3 3488761 SQLException "Closed Connection" from OracleXAConnection.getConnection()
10.1.0.3 3502727 Using a batch size more than 16383 fails in JDBC 10g driver
10.1.0.3 3528069 JDBC Thin Net sockets not closed if an error occurs during the Net close operation
10.1.0.3 3530618 JDBC Thin from Applet fails with AccessControlException "access denied"
10.1.0.3 3554090 JDBC can throw AccessControlException when running as an Applet
10.1.0.3 3563038 Statement.getUpdateCount() returns 1 instead of -1
10.1.0.3 3588880 ORA-1461 can occur in JDBC with a null Stream value

NCOMP

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

Fixed in Release Bug Number Description
10.1.0.4 3884983 Dump (pfrust) from Ctrl-C during execution of NCOMPed PLSQL
10.1.0.4 3941104 OERI[skkxerrp] / [skkxdllload] / [slfaccess] with NCOMPed PLSQL
10.1.0.4 4022622 OERI[peplm.c:null libunit root] using NCOMP if PLSQL_NATIVE_LIBRARY_DIR is full

OCCI

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

Fixed in Release Bug Number Description
10.1.0.4 3630538 Memory leak on PObject::pin() in OCCI client
10.1.0.4 3671655 ORA-22805 flushing objects in OCCI in XA environment
10.1.0.4 3748199 OCCI Object cache does not support global transactions
10.1.0.4 3757265 OCCI getNumArrayRows next() method returns cumulative row count
10.1.0.4 3760954 OCCI::ResultSet::next(N) method can return the END_OF_FETCH when data exists
10.1.0.4 3853332 OCCI client memory leak using statement::setString()
10.1.0.4 3924164 OCCI using collections with array insert may dump (ttca2p)
10.1.0.4 3946819 OCCI definition of THREADED_UNMUTEXED is wrong
10.1.0.4 3992072 ORA-1461 / ORA-2005 inserting a column after setNull() in OCCI

OCI

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

Fixed in Release Bug Number Description
10.1.0.4 3417593 Cross platform piecewise fetch of varchar2 data can result in corrupt data
10.1.0.4 3424847 OCI client code may dump during logon
10.1.0.4 3453969 Dump (ttcc2u) with with array / null binds
10.1.0.4 3471389 OCIBindByPos fails for PLSQL associate array bind with varchar2(4000)
10.1.0.4 3529179 OERI from "select empty_clob()" into varchar2 variable
10.1.0.4 3696284 ORA-1457 on FETCH after odefin for packed-decimal
10.1.0.4 3756908 OCI client memory leak with End-to-End tracing enabled
10.1.0.4 3762653 Null indicator not set when setting iters = 1 in OCIStmtExexute
10.1.0.4 3774546 OCILobRead may dump in kghalo() if there is character set conversion
10.1.0.4 3796771 Server spin in multibyte from DESCRIBE operation
10.1.0.3 2325578 OCIStmtFetch may return a false ORA-1002 instead of ORA-1403
10.1.0.3 3224506 XA client using TAF may not failover correctly
10.1.0.3 3269146 DML RETURNING with a DATE datatype may dump in the client
10.1.0.3 3385076 Complex object retrieval may fail with OCI-21700
10.1.0.3 3406157 OCISessionGet on an OCI session pool can return a session for a different user
10.1.0.3 3411748 OCI7 SELECT FOR UPDATE over DBLINK may dump client in kpuridalo1
10.1.0.3 3477127 Dump (kollgsz) when OCIStmtFetch2 fetches a NULL CLOB

PL/SQL

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

Fixed in Release Bug Number Description
10.1.0.4 1867670 Dump when using a trigger on an ADT or TIMESTAMP column
10.1.0.4 2708874 OERI:KGHALP1 / ORA-4030 using FORALL with SAVE EXCEPTIONS
10.1.0.4 2747350 Continual ORA-4061 after modifying PLSQL body for PLSQL called from SQL
10.1.0.4 2876340 ORA-904 accessing a remote object from PLSQL (remote DB < 9i)
10.1.0.4 2966778 Intermittent ORA-904 errors during heavy load
10.1.0.4 3218825 Memory leak when Java Stored Procedure executed from PLSQL
10.1.0.4 3242079 Using quotation marks with PLSQL variable names can result in errors
10.1.0.4 3258390 V$SESSION.SCHEMANAME may return wrong value in PLSQL of another user
10.1.0.4 3258467 High memory consumption from sessions using very many PLSQL packages
10.1.0.4 3279416 Dump / OERI calling a function that does a return replace of an XMLType
10.1.0.4 3377931 SAVE EXCEPTIONS does not work reliably with a partitioned table
10.1.0.4 3471389 OCIBindByPos fails for PLSQL associate array bind with varchar2(4000)
10.1.0.4 3499258 SQL functions against CHAR data return as VARCHAR2 in PLSQL
10.1.0.4 3500369 OERI[kohdtf048] / ORA-21780 / Memory leak from PLSQL
10.1.0.4 3507570 SYS_CONTEXT('USERENV',<parameter>) does not respect definers rights for lower case
10.1.0.4 3523279 Wrong results from UNION in a PLSQL block with CHAR data
10.1.0.4 3562142 Enhancement - improved performance of utlip / utlrcmp
10.1.0.4 3566124 OERI[insrow-1] during array insert with SAVE EXCEPTIONS and IOT
10.1.0.4 3573951 dbms_output.enable does not honor "buffer_size" correctly
10.1.0.4 3578503 CLOB to VARCHAR2 assignment fails in PLSQL clients (ORA-6502)
10.1.0.4 3582296 UNION [all] statement in PLSQL may give wrong results
10.1.0.4 3602321 Streams/logminer cannot handle partial rollback of a failed BULK BIND operation on a table with LOBS
10.1.0.4 3615072 PMON can crash the instance with [plio.c: non-reusable inst]
10.1.0.4 3628621 ORA-6502 from DYNAMIC SQL in AL32UTF8
10.1.0.4 3637267 Varchar2 is blank padded when local DB charset is different from remote site
10.1.0.4 3663846 PLS-123 "program too large error" in 10g
10.1.0.4 3673014 Client PLSQL: ref cursor always returned as null when called from client
10.1.0.4 3682147 Missing bytes fetching RAW OUT PLSQL parameters with JDBC Thin
10.1.0.4 3692370 UNISTR builtin function produces incorrect results when given NCHAR input
10.1.0.4 3711648 The ORA-6500 'storage error' error message is not very informative.
10.1.0.4 3720104 Fix for BUG 2276769 can cause SQL monitoring difficulties
10.1.0.4 3735785 Pro code with SQL_CURSOR array fetch uses single row fetches and no prefetch
10.1.0.4 3744836 ORA-4043 on SYS_PLSQL_%s_%c from DROP of a versioned object
10.1.0.4 3748283 Small PGA memory leak in kpodscn for long running PLSQL against external tables
10.1.0.4 3763395 Incorrect ROWCOUNT from BULK FORALL INSERT SAVE EXCEPTIONS with partitioned tables
10.1.0.4 3766568 ORA-6502 (VALUE ERROR) during trigger execution with codepoint semantics in multibyte
10.1.0.4 3768052 PLSQL Commit / Rollback wastes cursors and is slower than 8i
10.1.0.4 3800215 Variable assignments not working in PLSQL loops
10.1.0.4 3801347 PLSQL cursors may not get closed on exceptions (ORA-6511)
10.1.0.4 3818542 PLS-907 from pre-10g PLSQL client executing package with overloaded function
10.1.0.4 3831513 Import to different character set can fail (PLS-103) if PLSQL contains a NEWLINE in quotes
10.1.0.4 3872410 Corrupt PLSQL collection after copying empty collection
10.1.0.4 3884962 Dump [kxspoac] / wrong results possible with SQL from PLSQL
10.1.0.4 3884983 Dump (pfrust) from Ctrl-C during execution of NCOMPed PLSQL
10.1.0.4 3888015 PLSQL table of records table.count is not incremented
10.1.0.4 3907008 VARCHAR2 IN with bind size > 31 fails with ORA-6502
10.1.0.4 3917581 PLS-801 [23411] doing implicit conversion from NUMBER to LONG
10.1.0.4 3931444 Client PLSQL loads Diana for STANDARD in client runtime environments
10.1.0.4 3941104 OERI[skkxerrp] / [skkxdllload] / [slfaccess] with NCOMPed PLSQL
10.1.0.4 3983699 Dump (pfrdef1_get_tdo or kgicsr) with SERIALLY REUSABLE packages with ADTs
10.1.0.4 3987798 OERI[15212] when bind variable from SQL in PLSQL is rebound < 4000 bytes
10.1.0.4 4011806 Performance degradation in PLSQL loop in 10g
10.1.0.4 4015165 Unexpected ORA-6502 from PLSQL using host binds when using CHAR length semantics
10.1.0.4 4022622 OERI[peplm.c:null libunit root] using NCOMP if PLSQL_NATIVE_LIBRARY_DIR is full
10.1.0.4 4036717 Truncate table in exception handler can causes OERI:kcbzwb_4
10.1.0.3 2928563 Using large collections with EXTPROC can return 0 size collection
10.1.0.3 3134518 Memory leak on "bind var" heap from invalidated PLSQL cursor
10.1.0.3 3209932 OERI[kpoblblen: pos1] during re-execute of a pl/sql block
10.1.0.3 3248628 PLSQL EXCEPTION block may not be interrupted with ALTER SYSTEM KILL SESSION or Ctrl-C
10.1.0.3 3275045 PLSQL calling USERENV leaks memory within the PLSQL user call
10.1.0.3 3315960 OERI:736 / dump (in kxsbndinf) re-executing SQL after an ORA-1461 failure
10.1.0.3 3327553 No error raised on REPLACE() in PLSQL for NCHAR when the result is over 32767 bytes
10.1.0.3 3345089 Incorrect line / column number of the error in DBA_ERRORS
10.1.0.3 3376521 ORA-4067 when running user.package.proc with late binding on
10.1.0.3 3390187 ORA-1403 on 2nd execution of PLSQL stored procedure with TABLE parameter
10.1.0.3 3447478 ORA-6502 calling PLSQL over a DBLINK with RECORD parameters with UTF8/AL32UTF8
10.1.0.3 3498845 PLS-801 [phd_get_defn:unqualified external] referencing some STANDARD extensions in PLSQL
10.1.0.3 3524401 DBMS_DEBUG.GET_VALUE fails for package variables on larger packages

PL/SQL (DBMS Packages)

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

Fixed in Release Bug Number Description
10.1.0.4 3225530 DBMS_METADATA fails to generate complete definition for a domain index
10.1.0.4 3330599 DBMS_METADATA produces unusable output
10.1.0.4 3412625 DBMS_METADATA cannot handle AQ queue comments over 50 characters long
10.1.0.4 3447032 DBMS_STATS.SET_COLUMN_STATS can be slow (affects IMPORT)
10.1.0.4 3478459 DBMS_ADVISOR.TUNE_MVIEW does not work with multibyte DB
10.1.0.4 3491127 DBMS_STATS.GATHER_INDEX_STATS does not gather correct partitioned index stats
10.1.0.4 3506588 UTL_MAIL sends mails with subject including the character-set details
10.1.0.4 3535015 DBMS_STATS slow for partitioned tables with many partitions
10.1.0.4 3566361 DBMS_IOT.NUMBER_TO_UROWID is slow
10.1.0.4 3620168 DBMS_STATS may set AVG_ROW_LEN to 100
10.1.0.4 3643552 DBMS_ALERT.WAITONE / DBMS_LOCK.SLEEP timeout parameters not accurate
10.1.0.4 3732747 False ORA-1007 using DBMS_SQL.DEFINE_COLUMN
10.1.0.4 3733108 ORA-20000 in DBMS_UTILITY.COMPILE_SCHEMA/ANALYZE_SCHEMA on mixed-case object names
10.1.0.4 3739622 DBMS_UTILITY.COMPILE_SCHEMA throws ORA-20000 if schema as TRIGGERS in Recycle bin
10.1.0.4 3741516 DBMS_METADATA inherits session-level parameters incorrectly
10.1.0.4 3798843 UTL_RECOMP on RAC runs all recompilation jobs on the initiating node
10.1.0.4 3815906 DBMS_STATS fails with ORA-909 in ntile() function
10.1.0.4 3826012 UTL_MAIL.SEND ignores CC and BCC parameters
10.1.0.4 3841447 UTL_MAIL sent mails do not force IANA recognized character sets for header fields
10.1.0.4 3849938 DBMS_SPACE.UNUSED_SPACE returns wrong block_id for last extent used
10.1.0.4 3861541 UTL_LMS.GET_MESSAGE can return wrong character set string if LANGUAGE specified
10.1.0.4 3865157 OERI [kkzumco2:4] using DBMS_REDEFINITION with more than 10 constraints
10.1.0.4 3903530 UTL_HTTP HTTPS via proxy server requiring user authentication fails with ORA-29268
10.1.0.3 3285447 DBMS_STORAGE_MAP.MAP_ALL returns ORA-32504 for EMC Symmetrix disks
10.1.0.3 3291402 ESTIMATE_PERCENT may not be used when calling DBMS_STATS.GATHER_INDEX_STATS
10.1.0.3 3323709 Hang on execution of DBMS_REDEFINITION.START_REDEF_TABLE and concurrent insert to same table
10.1.0.3 3354447 UTL_FILE.FGETATTR returns ORA-1426 for files larger than 2Gb
10.1.0.3 3356951 DBMS_STATS can be slow if sample size causes < 2500 rows in the sample
10.1.0.3 3397811 ORA-29279 from UTL_SMTP with Stalker Internet Mail server
10.1.0.3 3485930 Slow performance of DBMS_STATS with auto sample size
10.1.0.3 3555167 BMS_STATS.GATHER_FIXED_OBJECTS_STATS may dump in kqlfcc

PL/SQL External Procedures (EXTPROC)

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

Fixed in Release Bug Number Description
10.1.0.4 2363758 Returning NULL from an EXTPROC callout may dump
10.1.0.4 3964817 Memory leak in external procedure for OBJECT arguments
10.1.0.3 2928563 Using large collections with EXTPROC can return 0 size collection
10.1.0.3 3145754 Calling EXTPROC can leak memory if there is no listener
10.1.0.3 3288625 ORA-22621 / OERI:kopuigpfx1 using LOBs in OCI Extproc

Pro* Precompiler

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

Fixed in Release Bug Number Description
10.1.0.4 2822740 Procobol PCB-S-00400 error while parsing SELECT CASE expression
10.1.0.4 3331794 False ORA-2100 errors possible from precompiled code
10.1.0.4 3453969 Dump (ttcc2u) with with array / null binds
10.1.0.4 3555959 Procobol generates wrong source with unnecessary period
10.1.0.4 3592636 Procobol precompiler errors using REDEFINED item as a host variable
10.1.0.4 3595731 PCB-S-00400 with FORMAT=TERMINAL and using DECIMAL-POINT
10.1.0.4 3632504 Wrong results from EXEC SQL LOB READ from NCLOB
10.1.0.4 3662892 Procobol errors for HOST VARIABLE / COLUMN NAME with multibyte character
10.1.0.4 3685171 sqlerrd(5) does not return correct value on SQL errors
10.1.0.4 3717576 ProCob produces incorrect .cob file for format=terminal
10.1.0.4 3735785 Pro code with SQL_CURSOR array fetch uses single row fetches and no prefetch
10.1.0.4 3737547 Client memory corruption when fetching NULL data
10.1.0.4 3742778 Undefined symbol "SQLORAT" in procobol application using threads=yes
10.1.0.4 3792845 MODE=ANSI client may get error 100 instead of correct error
10.1.0.4 3796771 Server spin in multibyte from DESCRIBE operation
10.1.0.4 3858017 Array insert with "EXEC SQL FOR" gets wrong value for SQLERRD[2]
10.1.0.4 3858625 Insert of long over DB link with NULL binds may ORA-24343
10.1.0.4 3864781 SQLGLMT does not return error message with run time contexts in Pro Cobol
10.1.0.4 4067938 Multi-threaded ProC client may dump when using connection pooling
10.1.0.4 4082618 EXEC SQL ARRAYLEN does not work for length 0
10.1.0.3 3224506 XA client using TAF may not failover correctly
10.1.0.3 3331075 ProCobol precompiler can dump with too many EXEC CICS in a row
10.1.0.3 3369243 ProC Precompiler may sometimes dump on EBCDIC platforms
10.1.0.3 3373446 Invalid code generated when precompiling with COMP1=INTEGER
10.1.0.3 3390187 ORA-1403 on 2nd execution of PLSQL stored procedure with TABLE parameter
10.1.0.3 3418232 ProCobol application may dump at runtime using COMP1=INTEGER
10.1.0.3 3425196 Dump in sqldhb using V8 OCI XA with Precompiled code
10.1.0.3 3458334 scdemo1.c may dump

SQLJ

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

Fixed in Release Bug Number Description
10.1.0.3 2906197 Setting savepoint and rollback to savepoint results in nullpointerexeption

XDK

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

Fixed in Release Bug Number Description
10.1.0.4 3113334 Empty result from oracle.xml.jaxp.jxtransformer.transform DOMsource to DOMresult
10.1.0.4 3242885 schemaValidate fails with LSX-213 for XML documents with a 'choice' tag
10.1.0.4 3375952 orajaxb may fail with XML-32009
10.1.0.4 3398272 oracleXMLSave setautocommit(false) fails for Sybase if autocommit state is false
10.1.0.4 3406229 XMLTransform gives wrong results
10.1.0.4 3454691 XML parser error inserting valid XML with ampersands in CDATA tag
10.1.0.4 3582780 Schema processor complains about valid default value if type is union
10.1.0.4 3615794 Standalone XML node creation allocates more memory than needed
10.1.0.4 3654742 XML parser throws XMLDOMException "implementation does not support the object requested"
10.1.0.4 3694615 node.getParentNode returns the wrong node after an adoptNode()
10.1.0.4 3698450 cloneNode does not return an instance of the subclass
10.1.0.4 3699264 Wrong results from XDK if XPATH contains start-with()
10.1.0.4 3722072 XMLElement() constructor missing
10.1.0.4 3757711 XDK does not support '-' between two parts of an extension function method call
10.1.0.4 3781853 XML parser does not allow parameters containing simple quotes (XML-1026)
10.1.0.4 3785167 JXDocumentBuilderFactory.isNamespaceAware always returns true
10.1.0.4 3801495 LSx-333 for multiple brackets in xsd pattern expressions
10.1.0.4 3810133 LPX-234 'namespace prefix "xmlns" is not declared' using XDK
10.1.0.4 3850317 XSU inserts fail with XA or EJB in OC4J
10.1.0.4 3858350 LSX-172 using xsd:restriction with substitutiongroup
10.1.0.4 3867413 LSX-171 when registering certain XSD
10.1.0.4 3871004 XML parser fails with NoSuchMethodError with Weblogic / Websphere
10.1.0.4 3876508 elementFormDefault which is qualified is treated as invalid
10.1.0.4 3876785 XML Parser hangs when processing with multiple threads
10.1.0.4 3881301 XMLAttr.setValue() does not throw events if owning object is imported
10.1.0.4 3897320 Schema processor complains about fixed value
10.1.0.4 3912435 OERI[kokegpinlob1] / OracleXMLSQLException from DBMS_XMLSLAVE
10.1.0.4 3919585 Small memory leak due to oracle.xml.util.qxnamehash$weakvalue references
10.1.0.3 1516368 Improper XML generation can occur
10.1.0.3 3247004 dbms_xmlsave.propagateoriginalexception does not work for some cases
10.1.0.3 3331641 XDK may signal a false LPX-106 error if duplicate attributes exist in different namespaces
10.1.0.3 3440776 XML entity does not support relative paths

XML

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

Fixed in Release Bug Number Description
10.1.0.4 3575797 XMLSchemas and types are not exported in table and tablespace mode export
10.1.0.4 3657757 CTX_DOC.MARKUP produces incorrect offsets for XML with CDATA tags
10.1.0.4 3804828 Dump [qmtcreatebody] on SELECT / describe of XML table
10.1.0.3 1516368 Improper XML generation can occur
10.1.0.3 2852123 XSU "Invalid column type" for put to XMLType column with NULLs
10.1.0.3 2968077 OracleXMLUtil.convertXMLObject may fail with NullPointerException
10.1.0.3 3331617 LPX-229 echoed to STDERR uring CTXXPATH index creation for rows with a NULL XMLType

Product Related

The following tables list bugs in the Product Related category.

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.1.0.4 4017275 I 10.1.0.2 CRS fails to start if CRS 10.1.0.3 running first
10.1.0.4 3590881 P Linux: CRSD may dump in/under CaaGetResAttrList
10.1.0.4 3391940 CRSD may shutdown an instance not started by CRS
10.1.0.4 3455036 crsd may not start on reboot
10.1.0.4 3584146 PRKR-1008 adding instance to CRS via SRVCTL
10.1.0.4 3586048 CRSD may crash on surviving node if OCR master node fails to access OCR disk/file
10.1.0.4 3626461 CRS hang after reboot on master node
10.1.0.4 3640947 CRS addnode may crash existing instances
10.1.0.4 3677589 OCR automatic backup does not work on Windows platforms
10.1.0.4 3686010 Delay up to minutes between CSS post and node death receipt
10.1.0.4 3758115 Enhanced diagnostics for CRS eviction with vendor clusterware
10.1.0.4 3764216 CRS resources may be restarted when they had not failed
10.1.0.4 3777747 CRS activity hangs across entire cluster with multiple node failures
10.1.0.4 3779593 CRSD may crash on a surviving node after communication error with a failed node
10.1.0.4 3799097 CRS may hang / error if peer node shutdown ungracefully
10.1.0.4 3814603 OERI[kccsbck_first] from CSS problem with split brain resolution
10.1.0.4 3823031 Changing the CSS oracle home using localconfig script does not work
10.1.0.4 3843632 "ocrconfig -upgrade" may dump
10.1.0.4 3923542 Additional PCW diagnostics
10.1.0.4 3942568 node crashing when heartbeat cable is pulled on other (master) node
10.1.0.4 3943254 Long elapsed time for CSS to detect a node failure
10.1.0.4 3946952 OCRCONFIG -BACKUPLOC does not work on some platforms
10.1.0.4 3992673 CRS/GM reconfiguration can hang
10.1.0.4 4007007 OCR daemon does not use new backup location from "OCRCONFIG -BACKUPLOC"
10.1.0.4 4029071 Enhancement: Allow CRS startup to be detached from DB instance startup
10.1.0.4 4045268 JDBC connection pool not notified to close connections when public interconnect lost
10.1.0.3 3394085 CRS may hang after node hard shutdown / node disconnect
10.1.0.3 3413846 CRS install can fail installing CRS on a system with 9.2 RAC present

DBVerify Utility

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

Fixed in Release Bug Number Description
10.1.0.4 3571244 dbverify does not report "marked corrupt" blocks in its summary
10.1.0.3 3457571 Enhancement to DBV to show highest SCN in a file / show blocks above an SCN

Database Configuration Assistant

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

Fixed in Release Bug Number Description
10.1.0.4 3437943 ORA-12514 if database is created using new port listener in 2nd home
10.1.0.4 3599172 DBCA does not handle periods as part of the username (ORA-922)
10.1.0.4 3986091 DBCA cannot create EXAMPLE tablespace on ASSM
10.1.0.3 3361262 DBCA cannot configure an existing database in silent mode
10.1.0.3 3463825 DBCA pops an error message window without for invalid locale
10.1.0.3 3482308 Database creation fails with DBCA scripts in a RAC environment
10.1.0.3 3596075 DBCA does not handle mixed case values for node names

Database Upgrade Assistant

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

Fixed in Release Bug Number Description
10.1.0.4 3466979 rdbmsup.xml file overwritten on each upgrade by DBUA
10.1.0.4 3742634 DBUA fails if DISPLAY is not set in silent mode

Datapump Export/Import

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

Fixed in Release Bug Number Description
10.1.0.4 3384030 ORA-6502 on data pump export with DDL over 32k
10.1.0.4 3476889 EXPDP fails with OERI[ktcsetscn-1] with large SCN value
10.1.0.4 3488157 Data pump import of list-partitioned IOT returns ORA-39083 / ORA-926
10.1.0.4 3502868 ORA-39002 / ORA-439 from IMPDP in Standard Edition
10.1.0.4 3554126 ORA-39135 from datapump export with FGAC
10.1.0.4 3601775 IMPDP generates invalid SQL for sequences with large maxvalue (ORA-39083 ORA-933)
10.1.0.4 3604507 IMPDP has a 30 minute timeout
10.1.0.4 3699688 ORA-39094 with EXPDP and parallel=1 from Standard Edition database
10.1.0.4 3713578 Wildcard in tables parameter of expdp and impdp give "UDE-14: invalid value"
10.1.0.4 3800792 EXPDP may fail with ORA-1555
10.1.0.4 3827736 LPX-225 during datapump import with statistics
10.1.0.4 3850163 EXPDP fails with ORA-8180 in tables with flashback enabled
10.1.0.4 3853023 False ORA-8103 from EXPDP exporting an ASSM managed IOT
10.1.0.4 3945630 RLS policies attempt to create before tables during import using IMPDP
10.1.0.4 3955213 EXPDP may not export all private SYNONYMs
10.1.0.3 3333076 ORA-39014 in logfile on STOP_JOB of EXPDP or IMPDP

Export/Import

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

Fixed in Release Bug Number Description
10.1.0.4 2270510 IMP-58 / ORA-22337 importing evolved type object table
10.1.0.4 2660473 Export of a renamed table leaves the trigger pointing to the old tablename
10.1.0.4 3447032 DBMS_STATS.SET_COLUMN_STATS can be slow (affects IMPORT)
10.1.0.4 3488371 OERI[17113] can occur during import of materialized views
10.1.0.4 3575797 XMLSchemas and types are not exported in table and tablespace mode export
10.1.0.4 3579567 Corrupt export exporting a compressed table with direct=y (IMP-9)
10.1.0.4 3591564 ORA-1756 importing functional index with CHR(0) in its expression
10.1.0.4 3596139 ORA-10632 on direct path export of IOT
10.1.0.4 3831513 Import to different character set can fail (PLS-103) if PLSQL contains a NEWLINE in quotes
10.1.0.4 3890213 IMP-98 possible importing zero length Lobs with CHUNKSIZE > 32767
10.1.0.4 3975111 IMP-3 / PLS-103 when importing a job created by DBMS_SCHEDULE
10.1.0.3 2834541 IMP-93 on import when using the TOUSER parameter
10.1.0.3 3159124 EXP-68 even though locally managed tablespaces are not offline
10.1.0.3 3281907 Export / import of a composite partitioned table can appear to spin during IMPORT
10.1.0.3 3324661 Full export/import fails with IMP-17 / ORA-2494
10.1.0.3 3400967 IMP-17 / ORA-6550 importing a wrapped password verification function
10.1.0.3 3467567 ORA-1400 importing CLOB data

Intelligent Agent

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

Fixed in Release Bug Number Description
10.1.0.4 3127087 EM agent does not support proxy that requires username and password
10.1.0.4 3264706 Error when try stop blackout via command line
10.1.0.4 3389452 alertlog.pl may run for hours
10.1.0.4 3427734 Clone operation does not handle non-central inventory
10.1.0.4 3545436 Agent runs 100's of ifsprocessinfo.pl scripts
10.1.0.4 3563413 nmupm bootTime may dump
10.1.0.4 3650411 Central agent may use excessive CPU
10.1.0.4 3653856 Agents with large data upload times block data processing for all agents
10.1.0.4 3772840 ORACLE_HOME for listener is incorrectly discovered by agentca
10.1.0.4 3779716 Job system running command in jobs multiple times
10.1.0.4 3799646 Host preferred credentials errors for connection to host as user oracle
10.1.0.4 3900139 SNMP Agent may fail top communicate with Master Agent in host cluster environment
10.1.0.4 3961599 10g agent unable to secure against OMS

LDAP / Oracle Internet Directory

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

Fixed in Release Bug Number Description
10.1.0.4 3175851 ldapmodify fails with "undefined attribute" error for a binary attr
10.1.0.4 3264021 New DBMS_LDAP interface needed for large binary attributes
10.1.0.4 3588307 DBMS_LDAP_UTL.get_group_membership ignores groups based on groupOfNames
10.1.0.4 3648468 On some platforms a valid LDAP URL may parse as invalid
10.1.0.4 3789117 Util.getGroupMembership may not return all groups the user is member of.
10.1.0.4 3802873 LDAP connections can not be established from MTS dispatchers
10.1.0.4 3868521 10g client does try all DIRECTORY_SERVERS in ldap.ora
10.1.0.4 3906430 SSL enterprise users should not require certificate DN to match OID dn
10.1.0.4 4003382 IllegalArgumentException when two JDBC Thin connections made using LDAP over SSL
10.1.0.3 3018805 Some characters cannot be included in a DN even if escaped
10.1.0.3 3412164 LDAPADD fails loading > 1999 bytes to a binary attribute
10.1.0.3 3416051 LDAP ACI processing is not working as expected

Oracle Enterprise Manager

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

Fixed in Release Bug Number Description
10.1.0.4 2819028 users in the same role cannot manage blackouts created by other role members
10.1.0.4 3346036 "emctl secure oms" changes the console's upload port
10.1.0.4 3356702 ORA-4020 from EM Management Errors tab
10.1.0.4 3359683 discard state on non-existant target is retried forever
10.1.0.4 3377171 Storage Manager does not ignore AWR invalid objects
10.1.0.4 3454934 EM Standby redo log creation improperly assigns an actual file name to the SRL
10.1.0.4 3467825 Metric browser UserAudit can throw MetricException
10.1.0.4 3488335 Cannot configure ASM notifications in DBConsole mode
10.1.0.4 3492516 BLACKOUTS may not work properly
10.1.0.4 3516732 ORACLE_EMREP alerts not being set correctly
10.1.0.4 3528216 ORA-20221 using MODIFY_TARGET to change monitoring credential
10.1.0.4 3569961 Editing threshold causes ORA-1 on OEM web console
10.1.0.4 3574238 Retry of jobs with command blocks fails with ORA-1
10.1.0.4 3574400 Remove of a target by a user with full privilege fails (ORA-20221)
10.1.0.4 3588773 DataGuard 'Customize' screen 'file locations: ' accepts only 10 filenames
10.1.0.4 3596036 Clone Oracle wizard can not clone a 9.2.0.5/6 ORACLE_HOME
10.1.0.4 3610162 OMS ping does not close connections when it checks an agent
10.1.0.4 3639863 EM may show listeners as DOWN when they are UP
10.1.0.4 3647470 APIs to start/stop blackout on targets synchronously
10.1.0.4 3647538 EM cannot add/configure database targets across a firewall
10.1.0.4 3669601 metric collection error for metric "feature usage"
10.1.0.4 3678854 Console Home Page and Deployments Page can be slow
10.1.0.4 3688594 EM SSO setup does not take username with @ sign in it
10.1.0.4 3719280 Cannot upload large patches to Patch Cache
10.1.0.4 3729742 Deadlock on MGMT_METRICS when loading metadata
10.1.0.4 3734600 EM SMS Notification does not send all information
10.1.0.4 3736103 EM shows job owner as SYSMAN
10.1.0.4 3738242 The "total table scan" metrics do not work
10.1.0.4 3741673 "Overflow Exception" on Top SQL page
10.1.0.4 3744911 EM "Parallel Execution Downgraded (per second)" metric not available
10.1.0.4 3748762 EM user context not used properly in EM APIs
10.1.0.4 3754162 EM check for privileges should check for SELECT ANY DICTIONARY for >= 9i DB only
10.1.0.4 3772945 MGMT_E2E_SQL_CONN conn_string column only allows 256 chars
10.1.0.4 3774886 False warning on objects not being able to extend for auto extend tablespace
10.1.0.4 3784302 Editing schedule of future suspended job does not work
10.1.0.4 3785480 ECM changes can cause OMS file backlog
10.1.0.4 3796806 Duplicate records of lock information in EM
10.1.0.4 3798065 EM shows RAC database status as "pending" when all members up
10.1.0.4 3813865 "unlimitedFailedLoginAttempts" does not limit the resultset
10.1.0.4 3816094 Host disk groups space status shows as UNKNOWN in EM
10.1.0.4 3816985 EM repository ping jobs keep rerunning
10.1.0.4 3824132 Indefinite blackout may be sent to agent
10.1.0.4 3847862 ECM keeps collecting data for automount filesystems
10.1.0.4 3849061 EM region queries can be slow
10.1.0.4 3851644 emctl -nodelevel blackout only blacks out the host
10.1.0.4 3855806 "expected name instead of ..." when collecting host configuration
10.1.0.4 3879246 Some ECM queries are slow
10.1.0.4 3883355 EM delete from MGMT_SQL_PLAN is slow
10.1.0.4 3887239 ECM Policy Select is slow
10.1.0.4 3892350 Metadata files generated by the agent are too big to get uploaded
10.1.0.4 3906692 OMS threadpools do not pool threads
10.1.0.4 3919243 EM API MGMT_TARGET_MEMBERSHIPS can fail with ORA-1403
10.1.0.4 3952939 EM ASM pages visible even if not licenced
10.1.0.4 3953162 EM deadlock on MGMT_FLAT_TARGET_MEMBERSHIPS / MGMT_USER_CONTEXT
10.1.0.4 3964121 Poor error when setCollection is disabled
10.1.0.4 3965714 EM "Disk Groups Usage" page for ASM fails
10.1.0.4 3970778 ORA-1476 when clicking on Administration tab
10.1.0.4 3973485 Disk groups space on Host homepage are wrong
10.1.0.4 3978089 "emctl status oms" returns wrong status
10.1.0.4 4016266 Unable to patch large number of hosts using EM
10.1.0.4 4018344 EM MetalinkRefresh holds database resources while making call to Metalink
10.1.0.3 3103102 Create webapp fails on second attempt if agent is down on 1st attempt
10.1.0.3 3353645 Archiving shows as disabled incorrectly on Enterprise Manager home page
10.1.0.3 3383621 No response from "show results" button when play transaction in French browser
10.1.0.3 3413025 EM may report agents as unreachable when they are up
10.1.0.3 3451473 RepManager may not start if LD_LIBRARY_PATH (or equivalent) is not set
10.1.0.3 3456232 EMCA may give misleading errors
10.1.0.3 3468529 EMCA does not set SHLIB_PATH/LIBPATH
10.1.0.3 3480003 Cannot submit certain jobs to UTF8 database
10.1.0.3 3507821 EM jobs remain in 'running' status
10.1.0.3 3565227 'Invalid date format' error when creating a partitioned table via DBCONSOLE

Oracle Type Translator

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

Fixed in Release Bug Number Description
10.1.0.3 2042712 OTT reports a SYNTAX error parsing INTYPE with HFILE option in quotes

Oracle Univeral Installer

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

Fixed in Release Bug Number Description
10.1.0.3 3580691 I Response files for Custom Install do not install all selected products (10g OUI)

RMAN (Recovery Manager)

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

Fixed in Release Bug Number Description
10.1.0.4 3664004 * RMAN "backup recovery files" command skips image copy backups . This bug is alerted in Note:278631.1
10.1.0.4 2391697 ORA-235 doing backup with RMAN in nocatalog mode
10.1.0.4 3372808 ORA-1265 after DROP DATABASE command
10.1.0.4 3386041 RMAN list backup of spfile sometimes dumps
10.1.0.4 3412646 RMAN restore controlfile using current controlfile name looses controlfile
10.1.0.4 3520255 RMAN should give preference to recovery area archivelogs during backup/recover.
10.1.0.4 3572747 "Report obsolete" does not include archives if "KEEP" used on backup
10.1.0.4 3572753 OERI[kghstack_underflow_internal_2] taking backup of controlfile via RMAN
10.1.0.4 3597439 ORA-1153 starting managed recovery when an RMAN backup is running
10.1.0.4 3615004 Corrupt backup / ORA-19675 using RMAN PROXY backup in RAC environment
10.1.0.4 3648209 BACKUP .. FOR RECOVER OF COPY fails with RMAN-600[13215]
10.1.0.4 3710656 ORA-6502 from RMAN CONVERT with max length DB/tablespace name
10.1.0.4 3718483 RMAN DUPLICATE fails when file is created during recovery
10.1.0.4 3741999 RMAN may remove the archived logs needed by Streams capture to restart
10.1.0.4 3825357 RMAN with ASM can overwrite the wrong file
10.1.0.4 3844804 RMAN DELETE .. BACKED UP n TIMES can delete an archivelog not yet backed up
10.1.0.4 3857039 RMAN may fail with ORA-6502 for REPORT OBSOLETE
10.1.0.4 3922878 V$BACKUP_PIECE omits media id for each tape when piece spans multiple medias
10.1.0.4 3992314 Non SYSTEM temporary tablespace causes problems for RMAN DUPLICATE
10.1.0.4 4033756 RMAN "transport tablespace" fails with ORA-39123 / ORA-12911
10.1.0.3 3396600 ORA-274 Incorrect recovery option list during RECOVER when some files are skipped
10.1.0.3 3401014 OERI[krbrrd_kgcddo_fails] restoring from backed up flash recovery area
10.1.0.3 3572128 HARD storage array may report HARD errors

SQL*Loader

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

Fixed in Release Bug Number Description
10.1.0.4 2942185 Corruption occurs on direct path load into IOT with ADDED columns
10.1.0.4 3461768 SQLLDR direct path may reject good rows after character to RAW conversion error
10.1.0.4 3482332 Direct path loads may fail / corrupt space information
10.1.0.4 3534299 SQLLDR may load corrupt NUMBER data for invalid ZONED DECIMAL data
10.1.0.4 3654015 SQLLDR direct path may incorrectly reject rows (ORA-2290) with CHECK_CONSTRAINTS
10.1.0.4 3697185 Index maintenance printed only for first table when loading multiple tables
10.1.0.4 3743437 Corrupt packed decimal data loaded by SQLLDR conventional path
10.1.0.4 3743445 Direct path SQLLDR may load incorrect numbers for PACKED DECIMAL data
10.1.0.4 3823608 Conventional path load may load incorrect scale/precision for numbers
10.1.0.4 3833809 Direct load with code conversion can fail with OERI[klaevc_01]
10.1.0.4 3866720 SQL*Loader-709 occurs during direct load on multi-CPU machine
10.1.0.3 3313274 Direct path load of LOBs can cause data loss/truncation in streams
10.1.0.3 3380428 SQLLDR may report the incorrect number of rows loaded on 64bit platforms
10.1.0.3 3424515 SQLLDR may output incorrect values for some messages on 64bit systems
10.1.0.3 3469389 SQLLDR direct path may fail with ORA-26094 / OERI[klaprs_30]
10.1.0.3 3549647 SQLLDR with SILENT=FEEDBACK and DIRECT=TRUE still shows "Save data point reached" messages

SQL*Plus

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

Fixed in Release Bug Number Description
10.1.0.4 3572558 SQLPLUS incorrectly appends .LST to spool filenames with environment variable
10.1.0.4 3679879 iSqlplus service hangs with "connection refused"
10.1.0.4 3703864 Logging off Windows shuts down iSqlplus
10.1.0.4 3908083 SQLPLUS COPY truncates long data with gateway connections
10.1.0.4 3948880 iSqlPlus dumps if "logout" while processing large query
10.1.0.3 2725777 COLUMN, BREAK and COMPUTE do not recognize lowercase accented characters

Ultra Search

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

Fixed in Release Bug Number Description
10.1.0.4 3940324 I ultraSearch 9.0.4 midtier is not compatible with 10.1.0.3 backend
10.1.0.4 3359224 Ultrasearch "runall.bat" does not lauch rmu subsystem
10.1.0.4 3374094 Ultrasearch may throw ORA-6502 for some multibyte character sets
10.1.0.4 3411206 The default instance has wrong Ultrasearch index preference/charset for UTF8 DBs
10.1.0.4 3554127 Ultrasearch searchlet cannot configure via OID / service registry
10.1.0.4 3554690 Add Ultrasearch install support for OCS 9.0.5
10.1.0.4 3554697 Add Ultrasearch upgrade support for OCS 9.0.5
10.1.0.4 3585330 getDate on Ultrasearch searchlet Resultset returns null
10.1.0.4 3585654 Incorrect Ultrasearch privileges for JDBC launcher user
10.1.0.4 3588054 Ultrasearch UI validation does not allow '&' in display URL
10.1.0.4 3588876 Cache deletion should be NO by default
10.1.0.4 3636007 Crawler can not follow URLs containing '&amp;'
10.1.0.4 3718274 Create Ultrasearch instance fails when using user defined preferences
10.1.0.4 3733669 Ultrasearch crawl removes already crawled tokens
10.1.0.4 3749450 Web crawler may not index dynamic web page
10.1.0.4 3750885 Ultrasearch uses wrong character set for MAC database character sets
10.1.0.4 3766919 DRG-10837 after upgrade of UltraSearch to 10g
10.1.0.4 3767087 Cannot enter text index preference name with more than 20 characters
10.1.0.4 3838020 Resource leak when crawling table source with temporary LOB content column
10.1.0.4 3929865 Left-truncated wildcard query give inconsistent error
10.1.0.4 3936668 Ultrasearch validation procedure schema incorrect
10.1.0.4 3998789 Forced recrawl may not reindex all of document
10.1.0.3 3175155 The "Delete query group/search attribute" has no confirmation page
10.1.0.3 3352051 Using plus (+) terms in an Ultrasearch query may not return all matching documents
10.1.0.3 3353729 CRAWLING throughput can degrade over time for large source
10.1.0.3 3379694 Wrong results using "usearch.jsp" with European characters in keywords
10.1.0.3 3456056 WKG-30027 does not print out the full URL
10.1.0.3 3552655 URL link extraction can produce wrong URL with '=' leading to WKG-30008
10.1.0.3 3576794 Ultrasearch has no tool to remove entries from OID and the Database

Wallet Manager

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

Fixed in Release Bug Number Description
10.1.0.4 3604730 OWM cannot import certain valid intermediate root CA
10.1.0.4 3636588 OWM unable to import trusted certifcate having no value for authKeyID
10.1.0.4 3924904 OWM cannot import certain certificates
10.1.0.4 4017351 NoClassDefFoundError error running orapki utility to add trustpoint to a wallet
10.1.0.3 3387554 Oracle Wallet Manager fails for some certificates
10.1.0.3 3473291 Importing a certificate to Wallet Manager may fail if "PATHLEN" set

Miscellaneous

The following tables list bugs in the Miscellaneous category.

Large File / Memory Issues (Eg: 2Gb)

The following table lists the Large File / Memory Issues (Eg: 2Gb) bugs addressed in this patch set:

Fixed in Release Bug Number Description
10.1.0.3 3354447 UTL_FILE.FGETATTR returns ORA-1426 for files larger than 2Gb

NUMA Related

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

Fixed in Release Bug Number Description
10.1.0.4 3802438 OERI[17148] / SGA heap corruption with NUMA pools

Miscellaneous

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

Fixed in Release Bug Number Description
10.1.0.4 3515760 TS enqueue may be gotten in wrong mode for ALTER TABLESPACE commands
10.1.0.4 3552759 Unexpected trace output shown for dynamic optimization
10.1.0.4 3566813 Dump from CTAS with UNION and ORDER BY of CHAR columns
10.1.0.4 3634252 PMON unable to acquire latch when JOB_QUEUE_PROCESSES altered
10.1.0.4 3639594 PMON clean up of an in-progress "alter system set parameter"
10.1.0.4 3814658 Library cache is dumped everytime process signals OERI[kksfbc-reparse-infinite-loop]
10.1.0.4 3817792 OERI[6100] while coalescing an index
10.1.0.4 3829900 OERI[25027] possible accessing index in 10g
10.1.0.3 No Bug# 10.1.0.3 Internal Fixes
10.1.0.3 3268331 ORA-27103 errors possible when using VLM
10.1.0.3 3293155 ENH: Diagnostic enhancement to help investigate memory corruptions/leaks
10.1.0.3 3407944 OERI[5254] / dump (ktagttl) or spin from Ctrl-C of a query
10.1.0.3 3415971 "process queue reference" latch held too long / PMON fails to acquire latch on qref
10.1.0.3 3425352 PMON may take a while to clean up a process marked as DEAD
10.1.0.3 3432304 "utlip" should COMMIT after deletes from the IDL tables
10.1.0.3 3485636 "cannot find libocci10.a" during make of client_sharedlib
10.1.0.3 3552923 "FIPS" requires HMAC SHA-1 is used to compute digest

Bugs Fixed in this Patch Set in Numeric Order

This section lists the bugs fixed in this patch set in descending numerical order.


Note:

This list of fixed bugs was current at the time of the patch set. Information on these fixed bugs may be revised after release of the patch set. Refer to the Patch Set section of OracleMetaLink document 263719.1 for any post-release updates.

The following table describes the symbols and abbreviations used in the bug listings:

Symbol or Abbreviation Description
*
Indicates that the issue has been alerted.
+
Indicates that the issue is particularly notable.
OERI Indicates ORA-600 bugs. For example OERI:729 is an abbreviation of ORA-600 [729].