10.2.0.3 Patch Set - List of Bug Fixes by Problem Type

Subject:	10.2.0.3 Patch Set - List of Bug Fixes by Problem Type
	Doc ID:	Note:391116.1	Type:	README
	Last Revision Date:	07-NOV-2006	Status:	PUBLISHED

Bugs fixed in the 10.2.0.3 Patch Set

See Note 316900.1 for Support Status and Alerts affecting 10.2.0 releases.
This note lists the bugs expected to be fixed in the 10.2.0.3 Patch Set and as such provides an indication of bugs which are known to affect 10.2.0.2 . However, there will also be bugs which affect 10.2.0.2 which were discovered too late to include in 10.2.0.3 - such bugs are not listed here . Bugs are listed by product. RDBMS (Server) bugs are listed under significant headings relating to either a feature or a characteristic of the bug. Some bugs are listed in more than one section. Each bug number is hyperlinked to a Support Bug Description.

'*' against a bug indicates that an alert exists for that issue.
'+' indicates a particularly notable bug.
'P' indicates a port specific bug.
"OERI:nnnnn is used as shorthand for ORA-600 [nnnnn].
The term "Undocumented" is used to indicate bug fixes for which there is no published description of the issue/fix.

Notable exceptions and omissions

Enterprise Manager / Database Control fixes are NOT listed.
Port specific bug fixes are not usually listed .

Security Alert Issues fixed in the 10.2.0.3 Patch Set

Fixed Bug# Security Alert# Document Summary

10.2.0.3 Bug Fixes by Category

Oracle Server

ANSI Joins

4433936 ORA-907 from FULL / LEFT OUTER joins

4582764 Wrong results from ANSI OUTER join with inline view

4615392 Join elimination not working with ANSI join syntax

4625102 Wrong results using ANSI join when NL join is performed

4932843 Wrong results from full outer join with TABLE() function

5005052 OERI:voprsla1 from ANSI query with TABLE() and domain index

ASSM Space Management (Bitmap Managed Segments)

3279497 Interupted (Ctrl-C) TRUNCATE can corrupt ASSM table

3610777 Excessive CPU from INDEX insert into ASSM index segment

4055634 TRUNCATE table has to much overhead when operating on empty segments

4188324 Wasted space possible in ASSM segments

4475314 DELETE then INSERT without commit on ASSM segment can be slow

4660718 Allow choice between space / performance for ASSM segments

4694312 Index inserts to ASSM segments can be slow

4887955 Unnecessary extent allocated in locally managed ASSM tablespace in RAC

5034679 Hang / errors making ASSM tablespace read only with concurrent DML

5349632 Poor performance for ASSM insert after large DELETE

Advanced Queuing

4515626 AQ enqueue option visibility=DBMS_AQ.IMMEDIATE does not work for ENQUEUE_ARRAY

4527173 AQ$_JMS_TEXT_MESSAGE.SET_TEXT method does not work correctly with multi-byte character sets

4543871 High CPU use by Qxxx proceses when using RETENTION

4640637 OERI[kwqidorefetch:err][3135] from AQ

4730389 ORA-30757 on propagation from 10.2 -> 8i

4752021 Dump (kpoaqeqopp) on AQ propagation from 8i to 10.2

4756409 High latency in AQ OCI notifications

5001358 Dump (kwqppay2aqe) on propagation of a transformed message

5178202 RAC AQ dequeue on different instance to enqueue is slow

Analytic SQL (Windowing etc..)

5055892 Wrong results from NVL with analytic function in HAVING clause

Automatic Storage Management (ASM)

3811904 Rebalance can fail if there is one full disk

3885499 ASM hang possible

4229751 CONVERT TABLESPACE fails to create file with DB_FILE_NAME_CONVERT on ASM

4450268 ASM disk mounts are serialized

4466433 Restoring current controlfile on ASM creates a file with "backup" string

4561867 ASMB may exit prematurely causing OERI in client

4671721 OERI [kfcInitDlocn02] possible in ASM instance

4691191 Failure during file grow may leak ASM disk space

4709210 ASM LMS OERI[504] on [kfcl le freelist] latch

4709214 ASM may crash with OERI[kfclGetLock40]

4752481 Skewed ASM disk allocation when single file resized many times

4865736 ASM resource should not have dependency on VIP

4872617 Dump (kfclDumpLe) in ASM

4883032 ASM fails with ORA-15096 during crash or instance recovery

4886660 ASMB can fail with OERI:kffmAllocate_1

4907496 Processes hang after adding disk back to ASM diskgroup using force option

4943406 LMON needs to message SMON to start recovery in ASM instance

4960705 ASM waits longer than necessary during reconfiguration

4966352 OERI[unsorted_pins_4] possible on ASM

4967266 DB recovery blocked by ASM recovery

5012099 ASM rebalance problems

5024639 ASM hangs if private interface down on a surviving node

5039964 ASM disks show as provisioned although kfed shows valid disk header

5089630 Dump (kfncInitSlavePool) / ORA-15012 from Log Miner / Streams against LOGs on ASM

5090822 OERI[17092] / ORA-10382 when ASM IO completes concurrently with DISKGROUP dismount

5134663 OERI[2103] with ASM

5226903 OERI:[kfcDeadlockAvoid01] when running "check all repair"

5360719 ASM and database instances hang when disk array gets disconnected

5515492 Data corruption when ASM failgroup removed

Bitmap Indexes

4475125 Wrong results with join of FULL INDEX SCAN (MIN/MAX) with bitmap index

4533389 ANALYZE INDEX VALIDATE STRUCTURE does not update INDEX_STATS for bitmap indexes

4615091 Wrong result using bitmap index on partition table with INLIST

5015557 Dump under kkoNewExtractedBMKey or qerixGetKey with bitmap plan and function based index

5078743 Dump (in qkabxo) using bitmap access path in FIRST K ROWS

Change Data Capture

4380175 Orphaned segment left by DBMS_CDC_PUBLISH.PURGE

5024710 CDC queue tables always end up in SYSTEM or SYSAUX tablespace

Cluster Ready Services / Parallel Server Management

4707711P Solaris: 'cluvfy' fails on Solaris (Sparc-64bit)

5022314P CRS has wrong LD_LIBRARY_PATH on Solaris X86-64

4127644 CSS not set in high/fixed priority class using CRSCTL SET CSS PRIORITY

4230367 nodedown event slow to appear after public network failure

4437727 VIPCA fails complaining that interface is not public

4459961 "crsctl debug log css COMMCRS / COMMNS" commands fail

4462367 CRS starts instance with too low file limit

4493093 PRKH-1001 from "srvctl add nodeapps"

4556878 CRSD may dump at cls_thrmxunlock()

4667776 clscfg -downgrade fails

4669874 RLB event delivery stops after instance restart

4689845 OPROCD log is not set up in RUN mode

4702263 CRSD failure is not handled in the init script

4716107 CVU fails if central inventory contains a deinstalled CRS home

4723189 Veritas Cluster Software not supported properly on some platforms

4726670 Total space of OCR is reported as 0 while executing root102.sh

4728396 DBCA does not change the parameter REQUIRED_RESOURCES for using ASM

4734413 OCR read from local cache blocked by writer working on different key

4739742 CLWS CRSD dump in prou_check_tag<-procr_close_key

4748946 CRSD aborts with OCR errors

4755275 CLWS CRSD aborts: fail to start monitor thread, comm failure

4756170 CRS/OCR delay before CRS recovery starts

4759984 root102 has wrong "rc" directories

4769197 Clients hang if a node goes down

4772904 PRKR-1007 / PROC-5 from srvctl

4865736 ASM resource should not have dependency on VIP

4870952 CLWS racgimon may dump

4879951 CLWS CRSD dump in eventutil::set_context

4883916 stop crs resource may be slow for shutdown abort

4890793 ASM resource depends on VIP even after removing required_resources

4893560 clscselect does not handle timeout = 0 correctly

4919514 CSSD does not fail when vendor clusterware present and skgxnreg fails

4925962 Problem with rootdelete.sbs, rootupgrade.sbs and localconfig.sbs

4926814 CLWS EVMD aborts in reconfiguration

4936206 CSS clients fail when vendor skgxn returns 0 for skgxntpshl

4936950 root and init scripts do not support SunCluster on Solaris X86 properly

4937400 GSD should not attempt to be started on Solaris x86 platforms

4945458 CSS group reconfiguration may not wait long enough to establish connections

4946339 CRS trace level cannot be modified via ocrlog.ini

4951958 CSSD reports graceful shutdown on private network cable pull

4967761 1.6s - 2.0s "gap" in CRSD before crs starts recovering resources

4997470 CSS startup terminates when another node comes up during reconfig

5004962 CRS may not be able to relocate a resource when no required resources

5007623 Dump in clssgmfmtdatareqresp causing node reboot

5011915 Split-brain resolution can be slow

5015469 OPROCD reboots node when system date goes backwards

5037858 OPROCD may report no reason for reboot

5037871 Clearer CSSD logging needed giving reasons for reboot

5052569 Wait for 'reboottime' after the kill echo on some platforms

5071602 Need a patch utility / key editor for diagnosis/repair of OCR corruptions

5077218 CSS asserts in clssnmhandlevoteinfo, clssnm.c 2224, node rebooted

5092622 oclsomon uses the wrong timeout value

5092725 crsctl debug does not accept a dash - ( hyphen )

5136712 ocrdump prints out no value for a keys with large value

5163409 "srvctl modify database" fails with PRKH-1014

5187351 Many clscNN.log files created - can affect performance

5252605 CSS reconfig starts before <misscount> seconds have elapsed

5350302 Unexpected node reboot after 'oracle cssd shell script failure'

Code Improvement

4229751 CONVERT TABLESPACE fails to create file with DB_FILE_NAME_CONVERT on ASM

4323868 INDEX hints can lead to INDEX SCAN FULL

4435036 RAC diagnostics can be slow

4482737 FGA does not record binds of type TIMESTAMP in FGA_LOG$

4669305 Enhancement: Add diagnostics for OERI[12333]

4995640 Diagnostics for RAC OERI[kjucll1]

5037858 OPROCD may report no reason for reboot

5037871 Clearer CSSD logging needed giving reasons for reboot

5071602 Need a patch utility / key editor for diagnosis/repair of OCR corruptions

5117888 Collection split rewrite not enabled by default

Compressed Data Storage

4378206 Direct load of compressed table can load duplicate rows

Constraint Related

4742679 ORA-604 / ORA-28133 enabling constraints on table with FGA

5126551 Dump (kkdcacr) from query on tables with FK constraint

Corrupt/Bad Backup

5380055* ORA-1555 / corruption if switch to Standby then back to Primary. This bug is alerted in Note 386830.1

5212539+ LOB corruption for NOCACHE LOBs (ORA-1555/ORA-22924)

5032964 ORA-19731 whilst recovering plugged in file

Corruption

3279497 Interupted (Ctrl-C) TRUNCATE can corrupt ASSM table

4655520 Block corrupted during write not noticed

5017007 MVIEW LOB content incorrect after refresh

Corruption (Dictionary)

4380175 Orphaned segment left by DBMS_CDC_PUBLISH.PURGE

4748597 Moving a LOB in a partitioned table fails to update IND$

5040222 OERI[4823] from drop partition table after merge with update indexes

Corruption (Index)

5380055* ORA-1555 / corruption if switch to Standby then back to Primary. This bug is alerted in Note 386830.1

5253271 Wrong sort ordering for zeroes

Corruption (Logical)

5458753* SQL may execute in wrong schema. This bug is alerted in Note 392673.1

4335615 ORA-1403 / data corruption in logical standby

4378206 Direct load of compressed table can load duplicate rows

4627859 IOT corruption possible when OVERFLOW columsn exist

4711857 Exp/Imp of table with LONG swaps COMMENTS metadata

4717280 NULL may be inserted by INSERT with a TRIGGER for NUMBER columns

4771052 INSTEAD-OF trigger does not update tables correctly over dblink

4775068 Deferred transactions not applied in the correct order when using parallel propagation

4952018 OCI direct path API allows invalid data for NUMBER(p,s) fields

4955701 Incorrect data possible from INSERT .. VALUES with correlated subquery

4963106 SQLLDR SKIP skips wrong number of records

5049941 Direct path merge records incorrect information in ALL_SUMDELTA

5223223 Wrong results / bad MV content after direct load

Corruption (Physical)

5212539+ LOB corruption for NOCACHE LOBs (ORA-1555/ORA-22924)

4411228 Block corruption with mixture of file system and RAW files

4637668 IMU transactions can produce out-of-order redo (OERI [3020] on recovery)

5061091 Block recovery corrupts undo header when log_parallelism > 1

5515492 Data corruption when ASM failgroup removed

Database Configuration Assistant

4728396 DBCA does not change the parameter REQUIRED_RESOURCES for using ASM

Database Link / Distributed

4254094 OERI[QERRMOBND1][932] possible for queries over DB links

4321119 ALTER MATERIALIZED VIEW causes ORA-32337 after DML via database link

4496339 RECO dumps in lxsCpStr causing instance crash

4627237 autonomous_transaction with DB link to shared server can self deadlock on DX

4637725 ORA-918 for remote DML

4703253 Wrong results from remote colocated join

4708037 ORA-904, ORA-2063 from query that uses TIME ZONE as a cast

4771052 INSTEAD-OF trigger does not update tables correctly over dblink

4904454 Wrong results from queries using remote colocated joins

4957217 ORA-2019 from REF cursor from procedure that uses a private dblink

4964703 OERI[opixrb-4] [1036] from SELECT over DBLINK with trailing :N or :Q bind names

4968994 Poor plan using SYSDATE in predicate over dblink

4996080 Wrong results from remote join

5012796 DUmp (in kglhdgsc) using distributed transactions

5037103 Dump (qerrmOieb) when selecting view across dblink

5040303 Dump (expepr) from distributed insert into VIEW

5043975 OERI[opixrm-1] [invalid handle] for remote cursor

5136454 Distributed statement using a synonym fails with ORA-904

5550824 Select SYSDATE over a database link increments SYSDATE

Database Upgrade Assistant

4864648 DBUA can not upgrade database with dictionary managed temporary tablespace

Datatypes (LOBs/CLOB/BLOB/BFILE)

5212539+ LOB corruption for NOCACHE LOBs (ORA-1555/ORA-22924)

4271217 OERI:kpolcsc1 / OERI:12333 from JDBC setCharacterStream() for CLOB data

4748597 Moving a LOB in a partitioned table fails to update IND$

4867884 Lob HW lock contention with space reclaimation

5011764 OERI[ktsircinfo_num1] accessing a LOB

5017007 MVIEW LOB content incorrect after refresh

5110062 Wrong results from INSTR for CLOB for multibyte charactersets

Datatypes (Objects/Types/Collections)

4242649 Object views are slower than they need be

4308089 Dump / OERI on MOVE / SPLIT partition of table with ADT column/s

4440681 Dump from REGEXP_REPLACE referring to table expression

4451506 Wrong results from SQL using TABLE() constructs

4583177 Poor performance inserting subtype constructor into polymorphic column

4644048 Oracle type evolution can fail with ORA-932

4744859 OERI[kkbncre:sq_len3] can occur

4860003 Sqlplus dump / OCI-21500 [koxsihread1]

4886383 Dump possible unpickling images from TABLE() function

4917666 OERI[kcbgcur_9] from type constructor

4928321 Pickle of opaque type results in bad image size

4932843 Wrong results from full outer join with TABLE() function

4959569 OERI[kdic_create_journal_table_1] rebuilding REF index ONLINE

4990803 Dump after type evolution

4992856 Collection view is not merged in DML

5005052 OERI:voprsla1 from ANSI query with TABLE() and domain index

5068565 Wrong results from pipelined table funciton with prefetch enabled (default)

5084961 Dump (qerncRowP) from PQ with nested cursor query

5130670 Wrong results with CURSOR query on complex view with collection objects

Datatypes (TIMESTAMP)

4272872 TIMESTAMPTZ is not affected by setSessionTimeZone

4460775 TIMESTAMP types may not exist in migrated database

4482737 FGA does not record binds of type TIMESTAMP in FGA_LOG$

4689959 Version 3 TIMEZONE files

4690953 Conversion of the TIMESTAMP WITH LOCAL TZ from Oracle type in Java fails

4708037 ORA-904, ORA-2063 from query that uses TIME ZONE as a cast

4776636 Wrong value for TIMESTAMP WITH TIME ZONE when NLS_CALENDAR set

4914281 TIMESTAMP WITH TIMEZONE values before 1800 corrupted

5055175 Dump [kkslpkp] using literal replacement with timezone literals

5075470 JVM timezone changes for Commonwealth games 2006

5218433 OERI[qmximv_maptype] select an XMLType table with TIMESTAMP types

Deadlock

4627237 autonomous_transaction with DB link to shared server can self deadlock on DX

4699610 CKPT can self deadlock waiting for MTTR state object which it holds

4732503 Self-deadlock on TT enqueue

4765374 Create table with XML schema causes ORA-4020

4876140 ORA-4020 on registering XML schemas using recursive references

4913415 Global deadlock not reported in RAC

5012368 Undetected deadlock in RAC

5363031 deadlock on broker metadata lock when FSFO is enabled

5386881 ORA-60 deadlock from terminal recovery

Direct Path Operations

4378206 Direct load of compressed table can load duplicate rows

4639659 SQLLDR direct load of IOT gets OERI[iot_gtab_mr_rcnt_mismatch]

4952018 OCI direct path API allows invalid data for NUMBER(p,s) fields

5049941 Direct path merge records incorrect information in ALL_SUMDELTA

5068048 SQL*loader hang on direct path load on multi CPU machine

5223223 Wrong results / bad MV content after direct load

Domain Indexes

3652491 Error for parallel query with ORDER BY and DOMAIN index

4134994 Extensible optimizer may use default costs

5005052 OERI:voprsla1 from ANSI query with TABLE() and domain index

5173194 Errors from partition range scan of LOCAL DOMAIN index

Excessive CPU Usage

3610777 Excessive CPU from INDEX insert into ASSM index segment

4543871 High CPU use by Qxxx proceses when using RETENTION

4685163 Merge SQL uses more CPU in 10.2 than 10.1

4900129 High CPU consumption during parse for unused CHECK constraints

5131645 10g hard parse CPU regression [ appopd->qksfrochild ]

Export/Import

4383811 OERI:qerxtAgentOpen_911 during datapump import

4634712 EXPDP errors ORA-39125 ORA-22814 ORA-6512

4656020 Export / import of schema based XMLType table fails

4671082 IMPDP fails with ORA-2421

4693439 ORA-1406 from FULL export with auditing

4704626 User level import export with SB XMLTYPE table does not preserve scope

4711857 Exp/Imp of table with LONG swaps COMMENTS metadata

4736134 IMP-61 on import due to hashcode mismatch

4744469 IMPDP grants all roles to user creating them exceeding max enabled roles ORA-316

4758949 ORA-6550 error importing statistics

4868804 DBMS_METADATA / datapump export does not handle indexes on Materialized Views

4869987 ORA-39167 from EXPDP

4898699 Reverse key index with system generated name is not exported

4963080 Datapump export/import fails for partitioned table

5031489 ORA-1455 during full database export

5120417 EXPDP does not export procact_instance objects if obj#1 does not exist

5151960 IMPDP via NETWORK_LINK EXCLUDE/INCLUDE filters execute on wrong DB

Expression Filters / Rules

5030164 ADD_ELEMENTARY_ATTRIBUTE can fail with ORA-12899

5078837 ORA-41661 from DBMS_RLMGR with NLS_NUMERIC_CHARACTERS using "," for the decimal point

External Tables

4715572 Wrong results / errors from select from external table with FIXED recordsize

Flashback

4874986 OERI[2142] while using flashback feature

5104579 Flashback query results on RAC inconsistent after rebooting 1 instance

5106952 Flashback log space not being reclaimed

Function Based Index (Including DESC Indexes)

5092688+ Wrong results if function based index exists

4376021 Wrong results from INLIST involving function based index

4767699 Spin in qcsjFindFroInQbc for query with join and functional index

4871743 OERI [kkfi.qbcvfr] creating view which uses ROWID of another view

4939157 Dump (evaopn2) using a functional index

5005939 OERI[qkssao2s1] during DBMS_SQLTUNE

5015557 Dump under kkoNewExtractedBMKey or qerixGetKey with bitmap plan and function based index

5045474 Optimizer may not use function based index with NLSSORT of a CHAR column

Gateways / Heterogeneous Services

4516151 SQLServer streams gives error if DML has nulls for date column

4629856 Wrong results selecting a LONG and a NULL over HS

4739749 Gateway returns ORA-28500 when it cannot process schemaname

4995320 Memory corruption / OERI[17114] from HS

5155213 Excessive memory use for ARRAY operations over HS

Global Temporary Tables

3889156 OERI[kcblibr_1] using global temporary table if client disconnected

Globalization Support (NLS)

4527173 AQ$_JMS_TEXT_MESSAGE.SET_TEXT method does not work correctly with multi-byte character sets

4598613 ORA-2248 from 10.2/10.1.0.5 client with NLS_LANG set to territory SWITZERLAND

4627522 ORA-1407 updating VARCHAR2 in AL32UTF8 database

4657575 CONVERT may dump converting ISO2022-JP data

4679879 ls/dir does show file information correctly on XDB FTP if NLS_LANGUAGE=JAPANESE

4689959 Version 3 TIMEZONE files

4950241 DBMS_APPLY_ADM.EXECUTE_ALL_ERRORS() fails with ORA-1403

4964703 OERI[opixrb-4] [1036] from SELECT over DBLINK with trailing :N or :Q bind names

5033218 ORA-6502 if TRIGGER modifies column value with >= 1001 character value

5045474 Optimizer may not use function based index with NLSSORT of a CHAR column

5075470 JVM timezone changes for Commonwealth games 2006

5078837 ORA-41661 from DBMS_RLMGR with NLS_NUMERIC_CHARACTERS using "," for the decimal point

5110062 Wrong results from INSTR for CLOB for multibyte charactersets

5253271 Wrong sort ordering for zeroes

5333814 OraSimpleDateFormat::parse on date with "pm" incorrectly becomes "am"

5345437 Intermittent wrong data / NLS errors (eg ORA-1801)

Hang (Involving Shared Resource)

3885499 ASM hang possible

4672266 LMS hang waiting for 'kjc: wait for msg sends to complete' during shutdown

4699610 CKPT can self deadlock waiting for MTTR state object which it holds

4732503 Self-deadlock on TT enqueue

5016142 SMON rollback of large transactions blocks other actions

5024639 ASM hangs if private interface down on a surviving node

5151675 Cannot archive redo.log in spite of good multiple log members

5208973 RAC may hang due to deadlock between LMS / MMAN latching

5360719 ASM and database instances hang when disk array gets disconnected

Hang (Process Hang)

4390868 Contention on DC_SEGMENTS due to small cache size on SYS.AUDSES$

4558970 RMAN RECOVER compilation can be slow

4602661 Adding a datafile hangs other sessions and new connections with resource manager

4627237 autonomous_transaction with DB link to shared server can self deadlock on DX

4725679 Switchover to logical standby hangs

4752179 Hang when calling extproc and killing client application

4755405 Excessive waits for "gcs drm freeze in enter server mode" in gsiat

4872999 RAC instance cannot get global enqueue

4882834 Excessive SS and TS contention in RAC

4907496 Processes hang after adding disk back to ASM diskgroup using force option

4956243 ALTER DATABASE BEGIN BACKUP hangs if other instance is mounted

5034679 Hang / errors making ASSM tablespace read only with concurrent DML

5068048 SQL*loader hang on direct path load on multi CPU machine

5117717 DG broker must disable/enable threads for logical switchover and failover

5143296 Reinstate of old primary hangs when old primary is disabling itself

5181800 Async LNS holds CF enqueue while issuing network calls rfsopen/rfsclose

Hang (Process Spins)

3610777 Excessive CPU from INDEX insert into ASSM index segment

4370351 High parse CPU (in qksfroInit) for large queries

4627203 tuxedo server process spins holding transaction branch allocation latch

4767699 Spin in qcsjFindFroInQbc for query with join and functional index

5131645 10g hard parse CPU regression [ appopd->qksfrochild ]

5162241 Dump / spin from query using "WITH" subquery with aggregation or DISTINCT

Hash Join

4604970+ Wrong results with 'hash group by' aggregation enabled

Index Only Tables (IOT)

4627859 IOT corruption possible when OVERFLOW columsn exist

4639659 SQLLDR direct load of IOT gets OERI[iot_gtab_mr_rcnt_mismatch]

4726573 Secondary index on global partitioned IOT is not used

4763768 OERI[17056] during analyze table compute stats on IOT

4925342 OERI [25027] / OERI [25012] on IOT analyze estimate statistics

4996133 OERI[kcbgtcr_5] updating an IOT in RAC environment

5074814 Dump (kkofmx) from DBMS_ADVISOR.EXECUTE_TASK for some IOT tables

5095700 Partition pruning does not occur DBMS_STATS for partitioned IOTs

5115350 ORA-932 during ALTER TABLE MOVE with nested tables IOTs

Instance May Crash

3291723 DBWR may crash instance if shared pool memory low

4339429 RAC instance crash with OERI:[kclbla_2] / dump (skgxpimprp)

4393878 OERI[kclchkping_2] in shared server / PMON

4496339 RECO dumps in lxsCpStr causing instance crash

4637008 Frequent ORA-379 can occur

4704890 OERI[kslgetl:1] after adding CPU using dynamic reconfiguration

4709210 ASM LMS OERI[504] on [kfcl le freelist] latch

4709214 ASM may crash with OERI[kfclGetLock40]

4859002 PMON crash cleaning up serially_reusable PLSQL

4863048 LMS OERI[kjbmpocr:dsb] / instance crash with RAC

4903532 RAC instance may be evicted as LMS may not process messages quickly enough

4997495 Instance crash with OERI[504][mostly latch-free SCN]

5007623 Dump in clssgmfmtdatareqresp causing node reboot

5015469 OPROCD reboots node when system date goes backwards

5031173 Instance terminated by LMON ORA-602

5036588 LMD0 process dump (kewmuprbsm_update_rbsm)

5068253 LGWR crashes instance with OERI[kcrfw_redo_write_lwn_len]

5134663 OERI[2103] with ASM

5183472 Crash due to ORA-453 against DIAG

Instance Startup

4452690 ORA-67 / LMON crash during startup

5032921 ORA-3700 in LGWR after 'alter database activate standby database'

5039964 ASM disks show as provisioned although kfed shows valid disk header

5095940 OERI[kcvent_internal_2] during database open

Interoperability (Between Releases)

4730389 ORA-30757 on propagation from 10.2 -> 8i

4752021 Dump (kpoaqeqopp) on AQ propagation from 8i to 10.2

4998752 SA_SESSION.SET_ROW_LABEL returnS ORA-1400 on ("lbacsys"."sessinfo"."key")

5000380 OCIAttrget(..., OCI_ATTR_PARAM_COUNT, ...) fails against 8i server

JDBC

4271217 OERI:kpolcsc1 / OERI:12333 from JDBC setCharacterStream() for CLOB data

4272872 TIMESTAMPTZ is not affected by setSessionTimeZone

4689781 JDBC client failover using FAN ONS does not handle site failures

5021340 OJMS generates unsharable dequeue SQL

5127944 PLS-103 from oracle.sql.TRANSDUMP.getTransitions()

5333814 OraSimpleDateFormat::parse on date with "pm" incorrectly becomes "am"

JavaVM / JSP / Corba etc..

4655283 Dump (in joe_run_vm) running Java stored procedure

4924174 Performance degradation in JavaVM

5035666 OERI:16363 opening Java socket from a migratable session

5075470 JVM timezone changes for Commonwealth games 2006

5151518 Dump under AccessControlContext executing stored Java

Job Queues

5095398 Dump (in LdiDateDateSubtract) in RAC when stopping a chain Job

5102834 "restartable" job attribute does not work for detached or remote jobs

LDAP / Oracle Internet Directory

4673628 ORA-12154 attempting to use Instant Client with OID / LDAP

5122955 Enterprise user login can be slow with very many user groups

Latch Contention

4770693PI+ Intel Solaris: Unnecessary latch sleeps by default

4742607 "cache buffer chains" latch contention from concurrent index range scans

4758819 Latch contention possible on buffer cache hash latches

5060485 Latch contention on "logminer workarea:krvxasr" during SQL Apply

Leak (Memory Leak / Growth)

4434887 MMON UGA memory leak

4694045 Insert of XML doc takes up large amount of memory

4726645 MMON has a slow memory leak ("koh-kghu sessi")

4746146 Pro client memory leak reexecuting SQL after ORA-1422

4924174 Performance degradation in JavaVM

4941173 RSM and DMON memory leak

4970079 SMON fails with ORA-4030 during clean up of non-existent objects

5003119 UGA memory leak by repeating DBMS_REFRESH.REFRESH in PLSQL

5004782 Memory leak on repeated connect/disconnect

5128946 Memory leak due to DDL reparse

5155213 Excessive memory use for ARRAY operations over HS

Leak (Resources Eg: File Handles)

5077897+P Windows: Server side handle leak

5053820 OCITransRollback() with non-blocking mode leaks cursors

Literal Replacement (CURSOR_SHARING)

4200541 Parse error when CURSOR_SHARING=FORCE|SIMILAR with user binds

4254094 OERI[QERRMOBND1][932] possible for queries over DB links

4607460 Dump [opipls] when CURSOR_SHARING = SIMILAR | FORCE

4698156 ORA-12850 querying GV$ views when CURSOR_SHARING=FORCE

5055175 Dump [kkslpkp] using literal replacement with timezone literals

LogMiner

4758632 Logminer reader consumes too much CPU when idle

5041103 Memory corruption from Log Miner

5057629 Dump (krvdtln) / ORA-1294 from DBMS_LOGMNR.start_logmnr

5089630 Dump (kfncInitSlavePool) / ORA-15012 from Log Miner / Streams against LOGs on ASM

5090574 Log Miner very slow processing rolled back DDL

5096921 Wrong results returned when using Log Miner SCN range

5117361 Capture process aborts with OERI[krvxgctasi:array size]/ORA-1280

Memory Corruption

5114396+ PGA corruption / dumps from session switching with shared servers

5388136PI The fix for bug 5033218 can cause triggers to dump (pfrust) with NVARCHAR2/NCHAR :OLD/:NEW values

4380928 ALTER MATERIALIZED VIEW LOG add filter columns may dump

4900807 Process private memory corruption / dump in LMD0

4995320 Memory corruption / OERI[17114] from HS

5041103 Memory corruption from Log Miner

5261264 Random memory corruptions during FAL archiving

Merge SQL (MERGE .. USING)

4644798 Dump (kkmups) using MERGE SQL

4685163 Merge SQL uses more CPU in 10.2 than 10.1

5049941 Direct path merge records incorrect information in ALL_SUMDELTA

Migration / Upgrade / Downgrade

5383828PI The fix for bug 5033218 can cause ORA-604 / ORA-1405 compiling triggers

4380942 ORA-6502 from catjava.sql when upgrading from 8i to 10g

4460775 TIMESTAMP types may not exist in migrated database

4594030 10g optimizer cannot use the outline created by lower version

4638550 OERI[dmlsrvColLenChk_2:dty] during upgrade from 9.2 to 10.2

4719372 RMAN configuration lost after upgrade of recovery catalog

4860003 Sqlplus dump / OCI-21500 [koxsihread1]

Multi Table Insert SQL

4944292 Multi-table insert may dump (koklgolx)

Network

4297024 sqlnet.ora not loaded

OCCI

4618016 OCCI applicaton dump / OCI-21500 in StatementImpl::doOCIExecute

OCI

4554284 ORA-3106 can occur with row shipping on a non blocking OCI connection

4627522 ORA-1407 updating VARCHAR2 in AL32UTF8 database

4644880 Client dump using dynamic XA registration

4666849 Client OCI tracing dumps for long queries (EVENT_10842)

4952018 OCI direct path API allows invalid data for NUMBER(p,s) fields

5004782 Memory leak on repeated connect/disconnect

5037807 ociap.h uses the "text" in oratypes.h which conflicts with fstream.h on some platforms

5053820 OCITransRollback() with non-blocking mode leaks cursors

Online DDL

4959569 OERI[kdic_create_journal_table_1] rebuilding REF index ONLINE

Optimizer

4323868 INDEX hints can lead to INDEX SCAN FULL

4370351 High parse CPU (in qksfroInit) for large queries

4376021 Wrong results from INLIST involving function based index

4475125 Wrong results with join of FULL INDEX SCAN (MIN/MAX) with bitmap index

4483286 OPTIMIZER_INDEX_COST_ADJ is not used for INDEX FAST FULL SCAN

4492467 Dump(kkquhcus) from cost based query transformation

4573396 CBO does not account for chained rows

4594030 10g optimizer cannot use the outline created by lower version

4595987 DELETE SQL costs are incorrect

4599763 DBMS_STATS fails with OERI:qospgtbc

4615392 Join elimination not working with ANSI join syntax

4639977 OERI[kkqcby: qbcfkkc not zero] from CONNECT BY query

4648181 OERI [15160] possible from pushed predicates

4711525 Parsing of bitmapped plans can be slow

4743096 Dump (in vopqbc) from SQL with complex view

4763768 OERI[17056] during analyze table compute stats on IOT

4772145 Gathering statistics on large indexes is slow

4892211 DBMS_STATS does not recognise lower case / special characters in column names

4900129 High CPU consumption during parse for unused CHECK constraints

4904838 INDEX_SS hint may not be honoured and skip scan costing wrong

4908162 Suboptimal plan possible for partitioned table with many joins

4968994 Poor plan using SYSDATE in predicate over dblink

4969029 Query optimization may dump [in kkoijg]

5005866 NULL first element is left in multicolumn inlist

5014836 INSERT as SELECT plan can differ from SELECT plan

5015214 UNION ALL predicate puhdown does not work for more than 2 way join

5015557 Dump under kkoNewExtractedBMKey or qerixGetKey with bitmap plan and function based index

5036879 Dump (kkoajt) during parse

5043097 OERI [15160] during query optimization

5078743 Dump (in qkabxo) using bitmap access path in FIRST K ROWS

5083297 Poor parsing performance with deeply nested view references

5094204 Wrong results from SORT-MERGE with UNUSABLE index

5095700 Partition pruning does not occur DBMS_STATS for partitioned IOTs

5104624 Explain plan fails with ORA-928

5109749 Wrong results / ORA-1428 from SQL using functional index with subquery unnesting

5162241 Dump / spin from query using "WITH" subquery with aggregation or DISTINCT

Oracle Data Mining

4772951 SVM build fails with ORA-40102: invalid input name for data mining operation

4864912 Cannot rebuild AR model reusing a previously used name results

Oracle Disk Manager

4637591 OERI:ksfd_dbuf1 possible using ODM with VLM

4671499 ORA-17500 ODM error

4945389 ORA-1114 write error on file header when tablespace is READ ONLY

Oracle Label Security

4998752 SA_SESSION.SET_ROW_LABEL returnS ORA-1400 on ("lbacsys"."sessinfo"."key")

Oracle Text (Formerly interMedia Text)

3652491 Error for parallel query with ORDER BY and DOMAIN index

5173194 Errors from partition range scan of LOCAL DOMAIN index

PL/SQL

4752541+ Intermittent PLS-306 / ORA-1722 / ORA-1858 under load

4502755 Accessing DBMS_XMLDOM.DOMDocument in PLSQL can dump

4557554 ORA-3106 dynamically executing PLSQL with many bind variables

4859002 PMON crash cleaning up serially_reusable PLSQL

5018738 CONVERT function fails in PLSQL with ORA-1482

5136454 Distributed statement using a synonym fails with ORA-904

PL/SQL (DBMS Packages)

4552927 DBMS_CRYPTO.ENCRYPT throws ORA-28233 when encrypting NULL data

4599763 DBMS_STATS fails with OERI:qospgtbc

4707226 ORA-20000 from AUTO_SPACE_ADVISOR_JOB if tablespace dropped

4766532 OERI[kesqsmakesql:phv] from DBMS_SQLTUNE

4772145 Gathering statistics on large indexes is slow

4868804 DBMS_METADATA / datapump export does not handle indexes on Materialized Views

4892211 DBMS_STATS does not recognise lower case / special characters in column names

5005939 OERI[qkssao2s1] during DBMS_SQLTUNE

5074814 Dump (kkofmx) from DBMS_ADVISOR.EXECUTE_TASK for some IOT tables

5086622 Double encryption error

5095700 Partition pruning does not occur DBMS_STATS for partitioned IOTs

PL/SQL External Procedures (EXTPROC)

4752179 Hang when calling extproc and killing client application

Parallel Query (PQO)

3652491 Error for parallel query with ORDER BY and DOMAIN index

4257187 Dump (qkkisojkey) from PQ with OUTER JOIN and ORDER BY / GROUP BY

4502270 OERI [pxtmpalo_pkey] / wrong results can occur executing parallel queries

4691657 OERI[kxfprdp:1] if PQ slave session is killed

4771672 DBA_SEGMENTS.BLOCKS wrong after parallel create index

4951307 PMON cannot delete process queue state object

4960265 Wrong results using BLOOM filter in internode PQ

5020831 FGA reports ORA-604, ORA-12801 ORA-10382 errors for PQ slaves

5084961 Dump (qerncRowP) from PQ with nested cursor query

5140532 wrong results from PQ with hash distribution with fixed CHAR join keys

Partitioned Tables

4308089 Dump / OERI on MOVE / SPLIT partition of table with ADT column/s

4461334 Index subpartitions do not inherit index level logging attribute

4540140 Dump (qkkMatchPrefix2) from INLIST with subpartitions

4615091 Wrong result using bitmap index on partition table with INLIST

4639101 False ORA-904 when adding partition to partitioned XMLType table

4726573 Secondary index on global partitioned IOT is not used

4748597 Moving a LOB in a partitioned table fails to update IND$

4888264 Wrong results from select on partitioned table with NULL in multicolumn inlist

4908162 Suboptimal plan possible for partitioned table with many joins

5011764 OERI[ktsircinfo_num1] accessing a LOB

5040222 OERI[4823] from drop partition table after merge with update indexes

5095700 Partition pruning does not occur DBMS_STATS for partitioned IOTs

5173194 Errors from partition range scan of LOCAL DOMAIN index

5228983 Wrong results from SQL with correlation on partition key

5349632 Poor performance for ASSM insert after large DELETE

Performance Affected (General)

4373733 Streams apply performing synchronous redo writes

4390868 Contention on DC_SEGMENTS due to small cache size on SYS.AUDSES$

4758819 Latch contention possible on buffer cache hash latches

4867884 Lob HW lock contention with space reclaimation

4868650 Bursty writes from DBWR with small FAST_START_MTTR_TARGET

4894027 Poor SQL apply performance in RAC

4924174 Performance degradation in JavaVM

5001975 Multiple remote destinations shipped serially in local_first setup

5016142 SMON rollback of large transactions blocks other actions

5021340 OJMS generates unsharable dequeue SQL

5065930 "log file sync" timeouts can occur

5075434 Small performance overhead in RAC (waits for "KJC: Wait for msg sends to complete")

5095887 Foreground waits too long before exiting server mode after instance recovery

5187351 Many clscNN.log files created - can affect performance

5448588 Slow LGWR sync performance for large redo write sizes

Performance Monitoring

4008133 Dump (skgslsgf) selecting from V$LOCK related views

4237613 Wrong V$SGASTAT values for "ASM extent pointer array"

4417285 Duplicate "direct path write temp" wait events

4533389 ANALYZE INDEX VALIDATE STRUCTURE does not update INDEX_STATS for bitmap indexes

4698156 ORA-12850 querying GV$ views when CURSOR_SHARING=FORCE

4942939 Very high values for ODM/ASM readtim/writetim in V$FILESTAT

Performance Of Certain Operations Affected

4151363 Drop / truncate slow in RAC

4411462 Poor fast refresh performance due to hints

4583177 Poor performance inserting subtype constructor into polymorphic column

4597354 DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE() is resource intensive

4722900 Incremental MV refresh can be slow

5080775 ALTER SYSTEM KILL SESSION IMMEDIATE slow

5090574 Log Miner very slow processing rolled back DDL

5122955 Enterprise user login can be slow with very many user groups

5158711 Parsing XML using DBMS_XMLGEN / DBMS_XMLDOM can be slow

5178202 RAC AQ dequeue on different instance to enqueue is slow

5349632 Poor performance for ASSM insert after large DELETE

Performance Of Query/ies Affected

4969880+ Allow the fix for bug 3646162 to be disabled

4055634 TRUNCATE table has to much overhead when operating on empty segments

4134994 Extensible optimizer may use default costs

4242649 Object views are slower than they need be

4475314 DELETE then INSERT without commit on ASSM segment can be slow

4483286 OPTIMIZER_INDEX_COST_ADJ is not used for INDEX FAST FULL SCAN

4573396 CBO does not account for chained rows

4595987 DELETE SQL costs are incorrect

4694312 Index inserts to ASSM segments can be slow

4711525 Parsing of bitmapped plans can be slow

4726573 Secondary index on global partitioned IOT is not used

4763057 XMLTable can get a suboptimal re-write

4768040 CTAS different to the SELECT statement plan

4772145 Gathering statistics on large indexes is slow

4900129 High CPU consumption during parse for unused CHECK constraints

4908162 Suboptimal plan possible for partitioned table with many joins

4968994 Poor plan using SYSDATE in predicate over dblink

4992856 Collection view is not merged in DML

5002720 Queries against V$STANDBY_LOG can be slow - slows down logical standby queries

5005866 NULL first element is left in multicolumn inlist

5015214 UNION ALL predicate puhdown does not work for more than 2 way join

5045474 Optimizer may not use function based index with NLSSORT of a CHAR column

5083297 Poor parsing performance with deeply nested view references

5084239 FACT hint forces suboptimal plan with star transformation

5095700 Partition pruning does not occur DBMS_STATS for partitioned IOTs

5129233 Poor execution plan with complex expression in a partition pruning predicate

5131645 10g hard parse CPU regression [ appopd->qksfrochild ]

5195882 Queries in FGAC use full table scan instead of index access

5218128 No rewrite for updateXML() when target is out of line

5353622 XQuery not always rewritten completely

Physical Standby Database / Dataguard

5380055* ORA-1555 / corruption if switch to Standby then back to Primary. This bug is alerted in Note 386830.1

5212539+ LOB corruption for NOCACHE LOBs (ORA-1555/ORA-22924)

4395779 ORA-16086 error when recovery area not used for redo logs

4676659 ORA-16009 in alert log with standby and LGWR ASYNC

4725406 Dataguard clients may get routed back to a dead primary

4941173 RSM and DMON memory leak

4953737 RAC hangs at arc shutdown accessing standby

5002448 Terminal recovery may purge SRL's for threads incorrectly

5010182 RAC instance recovery remote archival problem causes switchover to hang

5011019 OERI[2103] on bystander standby during target standby failover

5032921 ORA-3700 in LGWR after 'alter database activate standby database'

5095577 DMON process never starts (dump rfm_get_opaque)

5117717 DG broker must disable/enable threads for logical switchover and failover

5143296 Reinstate of old primary hangs when old primary is disabling itself

5146287 Data guard potential false gap request must be restricted

5181800 Async LNS holds CF enqueue while issuing network calls rfsopen/rfsclose

5196220 Reinstate of a physical standby database does not work

5209063 Logical standby gap fetch broken on RAC when one thread is disabled

5215729 An inopportune ping can cause gap in archivals after switchover at a bystander

5261264 Random memory corruptions during FAL archiving

5363031 deadlock on broker metadata lock when FSFO is enabled

5386881 ORA-60 deadlock from terminal recovery

5448588 Slow LGWR sync performance for large redo write sizes

Pro* Precompiler

4644880 Client dump using dynamic XA registration

4746146 Pro client memory leak reexecuting SQL after ORA-1422

4918154 Pro "unsafe_null = yes" returns wrong results

Query Rewrite (Including Materialized Views)

3945479 Bad materialized view metadata is definition uses "WITH"

4321119 ALTER MATERIALIZED VIEW causes ORA-32337 after DML via database link

4380928 ALTER MATERIALIZED VIEW LOG add filter columns may dump

4411462 Poor fast refresh performance due to hints

4499307 SUMDELTA$ rows not always purged for complex materialized views

4722900 Incremental MV refresh can be slow

4744972 ORA-942 on join with table associated with an MVIEW in a different schema

4747312 ORA-911 using DECLARE_REWRITE_EQUIVALENCE

4868804 DBMS_METADATA / datapump export does not handle indexes on Materialized Views

5003119 UGA memory leak by repeating DBMS_REFRESH.REFRESH in PLSQL

5004076 MVIEWS have INVALID status after migration to 64 bit

5017007 MVIEW LOB content incorrect after refresh

5049941 Direct path merge records incorrect information in ALL_SUMDELTA

5052568 Query rewrite does not work for SQL with LIKE clause

5223223 Wrong results / bad MV content after direct load

5276400 Wrong results with query rewrite

RAC (Real Application Clusters) / OPS

4339429 RAC instance crash with OERI:[kclbla_2] / dump (skgxpimprp)

4393878 OERI[kclchkping_2] in shared server / PMON

4435036 RAC diagnostics can be slow

4452690 ORA-67 / LMON crash during startup

4479323 OPEN RESETLOGS can fail with OERI[3705] in RAC

4602169 ORA-29702 during shutdown in RAC

4639236 OERI [kclcls_5] possible in RAC recreating an object

4672087 Delay in LMON during nested reconfiguration

4672266 LMS hang waiting for 'kjc: wait for msg sends to complete' during shutdown

4679094 In RAC a transaction may get stuck in prepare mode (ORA-1591)

4682574 Delay between end of CSS reconfig and LMON recovery

4689781 JDBC client failover using FAN ONS does not handle site failures

4690794 "error in kqlmbivg see lck trace file" messages

4709210 ASM LMS OERI[504] on [kfcl le freelist] latch

4737607 vips do not failover when IP is down

4750469 OERI:kjrfr7 can occur in RAC

4755405 Excessive waits for "gcs drm freeze in enter server mode" in gsiat

4766586 CGS reconfig timeout due to long time to capture diagnostics

4773318 "tossing bad MUPD msg pid XX" during reconfiguration

4863048 LMS OERI[kjbmpocr:dsb] / instance crash with RAC

4865820 LMS dump (kclnrembg)

4872999 RAC instance cannot get global enqueue

4874273 SMON waits in "ges enter server mode" > 1s before first pass

4882834 Excessive SS and TS contention in RAC

4887955 Unnecessary extent allocated in locally managed ASSM tablespace in RAC

4894027 Poor SQL apply performance in RAC

4900807 Process private memory corruption / dump in LMD0

4903532 RAC instance may be evicted as LMS may not process messages quickly enough

4913415 Global deadlock not reported in RAC

4928371 Connections still possible to aborting instance in RAC

4933038 _FAST_START_INSTANCE_RECOVERY_TARGET problem

4943406 LMON needs to message SMON to start recovery in ASM instance

4943839 RMAN restore can fail in RAC if backups not shared between nodes

4953737 RAC hangs at arc shutdown accessing standby

4956243 ALTER DATABASE BEGIN BACKUP hangs if other instance is mounted

4960265 Wrong results using BLOOM filter in internode PQ

4960705 ASM waits longer than necessary during reconfiguration

4960746 Dynamic remastering slower than necessary

4963850 Failover blocked - service start waits on second pass recovery to acquire UL

4967266 DB recovery blocked by ASM recovery

4995640 Diagnostics for RAC OERI[kjucll1]

4996133 OERI[kcbgtcr_5] updating an IOT in RAC environment

4997495 Instance crash with OERI[504][mostly latch-free SCN]

4998752 SA_SESSION.SET_ROW_LABEL returnS ORA-1400 on ("lbacsys"."sessinfo"."key")

5010182 RAC instance recovery remote archival problem causes switchover to hang

5012368 Undetected deadlock in RAC

5022093 OERI:[kjsbstat:unknownmaster] possible in RAC

5031173 Instance terminated by LMON ORA-602

5036588 LMD0 process dump (kewmuprbsm_update_rbsm)

5061068 RAC using "broadcast on commit" can see delayed commit times

5071492 LMS crash with OERI[kclastf_1]

5075434 Small performance overhead in RAC (waits for "KJC: Wait for msg sends to complete")

5095398 Dump (in LdiDateDateSubtract) in RAC when stopping a chain Job

5095887 Foreground waits too long before exiting server mode after instance recovery

5104579 Flashback query results on RAC inconsistent after rebooting 1 instance

5117717 DG broker must disable/enable threads for logical switchover and failover

5170699 Allow _lm_dd_interval=0 to minimize deadlock detection time in RAC

5178202 RAC AQ dequeue on different instance to enqueue is slow

5183472 Crash due to ORA-453 against DIAG

5208973 RAC may hang due to deadlock between LMS / MMAN latching

5209063 Logical standby gap fetch broken on RAC when one thread is disabled

5360719 ASM and database instances hang when disk array gets disconnected

RMAN (Recovery Manager)

4229751 CONVERT TABLESPACE fails to create file with DB_FILE_NAME_CONVERT on ASM

4466433 Restoring current controlfile on ASM creates a file with "backup" string

4558970 RMAN RECOVER compilation can be slow

4578844 MAXSETSIZE creates backupsets of size greater than MAXSETSIZE.

4590425 RMAN exit status is 0 when validate errors

4654856 ORA-17502 making RMAN duplexed backupsets to ASM diskgroup

4719372 RMAN configuration lost after upgrade of recovery catalog

4754328 RMAN resync catalog fails with ORA-1 (TS_P unique constraint violated)

4755799 RMAN-20070 error on primary after dataguard switchover

4759016 OERI [kghfrf1] doing RMAN backup

4941096 CATALOG BACKUPPIECE with backup controlfile does not populate the RMAN catalog

4943839 RMAN restore can fail in RAC if backups not shared between nodes

5082607 OERI:[kutyxtt_convert_b2_01] on convert datafile from Tru64 to AIX

Recovery

4479323 OPEN RESETLOGS can fail with OERI[3705] in RAC

4637668 IMU transactions can produce out-of-order redo (OERI [3020] on recovery)

5001975 Multiple remote destinations shipped serially in local_first setup

5077208 MRP may fail with OERI[kcpcvc3] after a tablespace drop

Regular Expressions

4440681 Dump from REGEXP_REPLACE referring to table expression

5351519 Dump using REGEXP_REPLACE() operator

Replication

4698119 Trace files are created for every replicated dml

4775068 Deferred transactions not applied in the correct order when using parallel propagation

Resource Manager

3448940 OERI[kskbind:!unb&!uinit] using resource manager with shared server connections

4602661 Adding a datafile hangs other sessions and new connections with resource manager

Row Level Security / FGA

4482737 FGA does not record binds of type TIMESTAMP in FGA_LOG$

4742679 ORA-604 / ORA-28133 enabling constraints on table with FGA

5020831 FGA reports ORA-604, ORA-12801 ORA-10382 errors for PQ slaves

5040303 Dump (expepr) from distributed insert into VIEW

5195882 Queries in FGAC use full table scan instead of index access

SQL*Loader

4639659 SQLLDR direct load of IOT gets OERI[iot_gtab_mr_rcnt_mismatch]

4955701 Incorrect data possible from INSERT .. VALUES with correlated subquery

4963106 SQLLDR SKIP skips wrong number of records

5068048 SQL*loader hang on direct path load on multi CPU machine

5223223 Wrong results / bad MV content after direct load

5226671 SQLLDR cannot load CLOBs larger than 20mb (READSIZE limit too low)

Security ( Authentication / Privileges / Auditing )

4447168 Dump (kghalp) with auditing enabled

4600757 ORA-9817 when AUDIT_TRAIL=XML and AUDIT_SYS_OPERATIONS=TRUE

4693439 ORA-1406 from FULL export with auditing

4926541 REVOKE ALL PRIVILEGES does not revoke UNLIMITED TABLESPACE privilege

5122955 Enterprise user login can be slow with very many user groups

Shared Pool Affected

4994956 Number of configured shared pool subpools not correct

5345437 Intermittent wrong data / NLS errors (eg ORA-1801)

Shared Server (formerly MTS)

5114396+ PGA corruption / dumps from session switching with shared servers

3448940 OERI[kskbind:!unb&!uinit] using resource manager with shared server connections

4361163 It is not possible to have > 1000 shared servers on some platforms

4627237 autonomous_transaction with DB link to shared server can self deadlock on DX

Star Transformation

5084239 FACT hint forces suboptimal plan with star transformation

5104624 Explain plan fails with ORA-928

5169712 Wrong results with star transformation , rownum and semijoin

5172444 OERI[15160] on complex query with joinback elimination

Storage Space Usage Affected

4188324 Wasted space possible in ASSM segments

4499307 SUMDELTA$ rows not always purged for complex materialized views

4660718 Allow choice between space / performance for ASSM segments

4691191 Failure during file grow may leak ASM disk space

4752481 Skewed ASM disk allocation when single file resized many times

4872898 Migrated-row created when chained row within a block updates

4887955 Unnecessary extent allocated in locally managed ASSM tablespace in RAC

5106952 Flashback log space not being reclaimed

Streams / Logical Standby

4335615 ORA-1403 / data corruption in logical standby

4373733 Streams apply performing synchronous redo writes

4379765 Streams has extra propagation tracing

4446613 Apply in DROP PARTITION state for long time

4461688 OERI[qkaPobs1] during instance startup of logical standby

4516151 SQLServer streams gives error if DML has nulls for date column

4725679 Switchover to logical standby hangs

4758632 Logminer reader consumes too much CPU when idle

4894027 Poor SQL apply performance in RAC

4950241 DBMS_APPLY_ADM.EXECUTE_ALL_ERRORS() fails with ORA-1403

5041103 Memory corruption from Log Miner

5060485 Latch contention on "logminer workarea:krvxasr" during SQL Apply

5089630 Dump (kfncInitSlavePool) / ORA-15012 from Log Miner / Streams against LOGs on ASM

5090574 Log Miner very slow processing rolled back DDL

5104430 ORA-1309 from PURGE_SESSION

5117361 Capture process aborts with OERI[krvxgctasi:array size]/ORA-1280

5359321 Streams capture fails OERI[krvxalfs: non unique entries in]

Transparent Application Failover

4689781 JDBC client failover using FAN ONS does not handle site failures

4737607 vips do not failover when IP is down

4963850 Failover blocked - service start waits on second pass recovery to acquire UL

Transparent Data Encryption

4748222 Update column with TDE gets OERI:[ztsmdwl failed] if there is a trigger

Transportable Tablespaces

5082607 OERI:[kutyxtt_convert_b2_01] on convert datafile from Tru64 to AIX

5152323 IMPDP fails during TTS import of partitioned table with XMLTYPE STORE AS CLOB

5186784 OERI[ktecgetsh-inc] from DML against transported tablespace

Triggers

5383828PI The fix for bug 5033218 can cause ORA-604 / ORA-1405 compiling triggers

5388136PI The fix for bug 5033218 can cause triggers to dump (pfrust) with NVARCHAR2/NCHAR :OLD/:NEW values

4712729 ORA-21780 can get raised for a table with a BEFORE ROW trigger on it.

4717280 NULL may be inserted by INSERT with a TRIGGER for NUMBER columns

4748222 Update column with TDE gets OERI:[ztsmdwl failed] if there is a trigger

4771052 INSTEAD-OF trigger does not update tables correctly over dblink

4908068 ORA-1400 from BEFORE INSERT trigger using INSERT with SUBQUERY in VALUES clause

5033218 ORA-6502 if TRIGGER modifies column value with >= 1001 character value

5033476 Dump executing a DML which uses a CONNECT BY when there is a trigger

Truncate

3279497 Interupted (Ctrl-C) TRUNCATE can corrupt ASSM table

4055634 TRUNCATE table has to much overhead when operating on empty segments

4151363 Drop / truncate slow in RAC

Workload repository / reporting

4359124 AWR errors with ORA-1 (on SYS.WRH$_SQLTEXT_PK) kewrafm1 error=13509

4597354 DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE() is resource intensive

4950024 ORA-39083/PLS-302 during import of metric threshold settings

Wrong Results

5458753* SQL may execute in wrong schema. This bug is alerted in Note 392673.1

4604970+ Wrong results with 'hash group by' aggregation enabled

5092688+ Wrong results if function based index exists

4237613 Wrong V$SGASTAT values for "ASM extent pointer array"

4272872 TIMESTAMPTZ is not affected by setSessionTimeZone

4376021 Wrong results from INLIST involving function based index

4451506 Wrong results from SQL using TABLE() constructs

4475125 Wrong results with join of FULL INDEX SCAN (MIN/MAX) with bitmap index

4502270 OERI [pxtmpalo_pkey] / wrong results can occur executing parallel queries

4568043 XMLDOM.SUBSTRINGDATA dump / wrong result for offset >= 4000

4580399 ORA-942 from "'" in text node with DBMS_XMLSTORE.INSERTXML()

4582764 Wrong results from ANSI OUTER join with inline view

4610323 Wrong node order accessing SCHEMA BASED XML via HTTP

4615091 Wrong result using bitmap index on partition table with INLIST

4622729 Wrong results from NOT IN subquery

4625102 Wrong results using ANSI join when NL join is performed

4629856 Wrong results selecting a LONG and a NULL over HS

4679879 ls/dir does show file information correctly on XDB FTP if NLS_LANGUAGE=JAPANESE

4685811 V$FILESPACE_USAGE.USED_SPACE wrong when rollback segments have been shrunk

4689959 Version 3 TIMEZONE files

4703253 Wrong results from remote colocated join

4704594 CAST NULL / TO_DATE(NULL) in a SELECT can return incorrect column size

4713210 extract() can return erroneous namespace

4715104 ORA-22835 / truncated data from USER/ALL/DBA_EXTERNAL_TABLES

4715572 Wrong results / errors from select from external table with FIXED recordsize

4769762 Wrong results from base-uri() and docuemnt-uri() handling doc() and collection()

4771672 DBA_SEGMENTS.BLOCKS wrong after parallel create index

4776636 Wrong value for TIMESTAMP WITH TIME ZONE when NLS_CALENDAR set

4888264 Wrong results from select on partitioned table with NULL in multicolumn inlist

4904454 Wrong results from queries using remote colocated joins

4911954 V$RECOVERY_FILE_DEST SPACE_USED / NUMBER_OF_FILES are wrong

4914205 Query/update using bind variable with existsnode returns the same row

4914281 TIMESTAMP WITH TIMEZONE values before 1800 corrupted

4918154 Pro "unsafe_null = yes" returns wrong results

4928321 Pickle of opaque type results in bad image size

4932843 Wrong results from full outer join with TABLE() function

4949257 Unnested subquery returns wrong result

4950942 Wrong describe information for VIEW over a NUMBER datatype with FLOAT

4960265 Wrong results using BLOOM filter in internode PQ

4996080 Wrong results from remote join

5055892 Wrong results from NVL with analytic function in HAVING clause

5068565 Wrong results from pipelined table funciton with prefetch enabled (default)

5089814 Wrong results "col(+) = NULL" with an OUTER JOIN

5094204 Wrong results from SORT-MERGE with UNUSABLE index

5096921 Wrong results returned when using Log Miner SCN range

5104579 Flashback query results on RAC inconsistent after rebooting 1 instance

5109749 Wrong results / ORA-1428 from SQL using functional index with subquery unnesting

5110062 Wrong results from INSTR for CLOB for multibyte charactersets

5130670 Wrong results with CURSOR query on complex view with collection objects

5140532 wrong results from PQ with hash distribution with fixed CHAR join keys

5162069 Wrong results from XMLAgg with GROUP BY

5169712 Wrong results with star transformation , rownum and semijoin

5191781 CONNECT BY query returns rows in different order

5228983 Wrong results from SQL with correlation on partition key

5253271 Wrong sort ordering for zeroes

5276400 Wrong results with query rewrite

5333814 OraSimpleDateFormat::parse on date with "pm" incorrectly becomes "am"

5345437 Intermittent wrong data / NLS errors (eg ORA-1801)

5550824 Select SYSDATE over a database link increments SYSDATE

XA / Distributed Transactions

4627203 tuxedo server process spins holding transaction branch allocation latch

4627237 autonomous_transaction with DB link to shared server can self deadlock on DX

4644880 Client dump using dynamic XA registration

4679094 In RAC a transaction may get stuck in prepare mode (ORA-1591)

4891103 OERI[4442] using XA

XDB

3365793 OERI[qmxtgrenumpredrewriteprocess] with out of line elements from another schema

3703236 Transfer of files to XDB may fail before the timeout is reached

4172384 Dump using DBMS_XMLDOM with shared servers or session migration

4500235 Whitespace not preserved with xml:space or DTD mixed content

4502755 Accessing DBMS_XMLDOM.DOMDocument in PLSQL can dump

4537877 XDB should only accept 'true','false',1,0 for xs:boolean

4568043 XMLDOM.SUBSTRINGDATA dump / wrong result for offset >= 4000

4580399 ORA-942 from "'" in text node with DBMS_XMLSTORE.INSERTXML()

4584239 Dump during a cross join query using XMLSEQUENCE

4587607 ORA-31187 hit when uploading an XML instance

4587761 XMLType.getNamespace() returns NULL for non schema based documents

4610323 Wrong node order accessing SCHEMA BASED XML via HTTP

4612208 Cannot export/import SCH-XT table into different user

4639101 False ORA-904 when adding partition to partitioned XMLType table

4656020 Export / import of schema based XMLType table fails

4675505 Dump (koxss2gpage) using XMLTYPE in updates

4679879 ls/dir does show file information correctly on XDB FTP if NLS_LANGUAGE=JAPANESE

4694045 Insert of XML doc takes up large amount of memory

4699502 xmldom.setAttribute() and removeAttribute() behave incorrectly

4704626 User level import export with SB XMLTYPE table does not preserve scope

4713210 extract() can return erroneous namespace

4728105 ORA-19276 with XMLTable()

4751888 Registration of schema including blockdefault="substitution" gives ORA-31038

4759183 Corrupt XML values from XMLAgg()

4763057 XMLTable can get a suboptimal re-write

4765374 Create table with XML schema causes ORA-4020

4766097 Unable to extract contents from XMLType after insert - ORA-31167

4769762 Wrong results from base-uri() and docuemnt-uri() handling doc() and collection()

4866544 OERI [qmxtrBuildPdAcc:toid] selecting from USER_XML_SCHEMAS

4876140 ORA-4020 on registering XML schemas using recursive references

4912961 False ORA-19026 with simpletype and enumeration

4914205 Query/update using bind variable with existsnode returns the same row

4924933 No rewrite during update of simpletype

4928321 Pickle of opaque type results in bad image size

4955476 DTD reference removed after parsing XML using parseClob

4963080 Datapump export/import fails for partitioned table

4965973 ORA-31079 when insert / select on a schema based XMLType table with "xsi:type"

4970030 XSL processor ignores new line characters

5004612 updateXML does not work updating attribute value with a CLOB

5019081 Update of schema based XML resource fails with unique constraint on nested table

5021540 ORA-30937 while inserting substitutiongroup elem imported from schema with no ns

5038284 OERI[qmtsGetCompilationContext1] / ORA-31079 from schema registration

5114306 Dump (qmuhshget_internal) from DBMS_XMLStore.insertXML

5115350 ORA-932 during ALTER TABLE MOVE with nested tables IOTs

5117888 Collection split rewrite not enabled by default

5152323 IMPDP fails during TTS import of partitioned table with XMLTYPE STORE AS CLOB

5158711 Parsing XML using DBMS_XMLGEN / DBMS_XMLDOM can be slow

5162069 Wrong results from XMLAgg with GROUP BY

5174023 Dump registering XML schema with attrgroup refs

5212798 "xsd:dateTime" cannot be mapped to TIMESTAMP WITH TIME ZONE

5218128 No rewrite for updateXML() when target is out of line

5218433 OERI[qmximv_maptype] select an XMLType table with TIMESTAMP types

5353622 XQuery not always rewritten completely

XML

4172384 Dump using DBMS_XMLDOM with shared servers or session migration

4568043 XMLDOM.SUBSTRINGDATA dump / wrong result for offset >= 4000

4580399 ORA-942 from "'" in text node with DBMS_XMLSTORE.INSERTXML()

Error May Occur

5380055* ORA-1555 / corruption if switch to Standby then back to Primary. This bug is alerted in Note 386830.1

5458753* SQL may execute in wrong schema. This bug is alerted in Note 392673.1

4752541+ Intermittent PLS-306 / ORA-1722 / ORA-1858 under load

5212539+ LOB corruption for NOCACHE LOBs (ORA-1555/ORA-22924)

5383828PI The fix for bug 5033218 can cause ORA-604 / ORA-1405 compiling triggers

3652491 Error for parallel query with ORDER BY and DOMAIN index

4200541 Parse error when CURSOR_SHARING=FORCE|SIMILAR with user binds

4321119 ALTER MATERIALIZED VIEW causes ORA-32337 after DML via database link

4343398 Alert log reports ORA-2097 / ORA-439 on 10.1.0.4 Standard Edition

4361163 It is not possible to have > 1000 shared servers on some platforms

4380942 ORA-6502 from catjava.sql when upgrading from 8i to 10g

4395779 ORA-16086 error when recovery area not used for redo logs

4433936 ORA-907 from FULL / LEFT OUTER joins

4460775 TIMESTAMP types may not exist in migrated database

4516151 SQLServer streams gives error if DML has nulls for date column

4523125 ORA-3106 if cursor flushed between executions

4527173 AQ$_JMS_TEXT_MESSAGE.SET_TEXT method does not work correctly with multi-byte character sets

4552927 DBMS_CRYPTO.ENCRYPT throws ORA-28233 when encrypting NULL data

4554284 ORA-3106 can occur with row shipping on a non blocking OCI connection

4557554 ORA-3106 dynamically executing PLSQL with many bind variables

4587607 ORA-31187 hit when uploading an XML instance

4598613 ORA-2248 from 10.2/10.1.0.5 client with NLS_LANG set to territory SWITZERLAND

4602169 ORA-29702 during shutdown in RAC

4627522 ORA-1407 updating VARCHAR2 in AL32UTF8 database

4637008 Frequent ORA-379 can occur

4637725 ORA-918 for remote DML

4639101 False ORA-904 when adding partition to partitioned XMLType table

4644048 Oracle type evolution can fail with ORA-932

4654856 ORA-17502 making RMAN duplexed backupsets to ASM diskgroup

4671499 ORA-17500 ODM error

4673628 ORA-12154 attempting to use Instant Client with OID / LDAP

4676659 ORA-16009 in alert log with standby and LGWR ASYNC

4693439 ORA-1406 from FULL export with auditing

4698156 ORA-12850 querying GV$ views when CURSOR_SHARING=FORCE

4704626 User level import export with SB XMLTYPE table does not preserve scope

4707226 ORA-20000 from AUTO_SPACE_ADVISOR_JOB if tablespace dropped

4708037 ORA-904, ORA-2063 from query that uses TIME ZONE as a cast

4712729 ORA-21780 can get raised for a table with a BEFORE ROW trigger on it.

4715104 ORA-22835 / truncated data from USER/ALL/DBA_EXTERNAL_TABLES

4715572 Wrong results / errors from select from external table with FIXED recordsize

4722189 Instant client libraries may be used from a FULL ORACLE_HOME

4727556 ORA-3117 on describe of packages

4730389 ORA-30757 on propagation from 10.2 -> 8i

4736134 IMP-61 on import due to hashcode mismatch

4739749 Gateway returns ORA-28500 when it cannot process schemaname

4742679 ORA-604 / ORA-28133 enabling constraints on table with FGA

4744469 IMPDP grants all roles to user creating them exceeding max enabled roles ORA-316

4744972 ORA-942 on join with table associated with an MVIEW in a different schema

4747312 ORA-911 using DECLARE_REWRITE_EQUIVALENCE

4754328 RMAN resync catalog fails with ORA-1 (TS_P unique constraint violated)

4755799 RMAN-20070 error on primary after dataguard switchover

4758949 ORA-6550 error importing statistics

4772904 PRKR-1007 / PROC-5 from srvctl

4864912 Cannot rebuild AR model reusing a previously used name results

4869987 ORA-39167 from EXPDP

4908068 ORA-1400 from BEFORE INSERT trigger using INSERT with SUBQUERY in VALUES clause

4937225 ORA-22 from OCIStmtExecute after OCISessionBegin

4945389 ORA-1114 write error on file header when tablespace is READ ONLY

4950024 ORA-39083/PLS-302 during import of metric threshold settings

4950241 DBMS_APPLY_ADM.EXECUTE_ALL_ERRORS() fails with ORA-1403

4956438 ORA-1404 when altering a table

4957217 ORA-2019 from REF cursor from procedure that uses a private dblink

4963080 Datapump export/import fails for partitioned table

4965973 ORA-31079 when insert / select on a schema based XMLType table with "xsi:type"

4970079 SMON fails with ORA-4030 during clean up of non-existent objects

4994956 Number of configured shared pool subpools not correct

5000380 OCIAttrget(..., OCI_ATTR_PARAM_COUNT, ...) fails against 8i server

5004612 updateXML does not work updating attribute value with a CLOB

5008142 Select from V$SGA_TARGET_ADVICE can fail with ORA-1476

5018738 CONVERT function fails in PLSQL with ORA-1482

5031489 ORA-1455 during full database export

5032921 ORA-3700 in LGWR after 'alter database activate standby database'

5033218 ORA-6502 if TRIGGER modifies column value with >= 1001 character value

5057629 Dump (krvdtln) / ORA-1294 from DBMS_LOGMNR.start_logmnr

5076617 Cannot drop datafile using alter tablespace (ORA-3263)

5078837 ORA-41661 from DBMS_RLMGR with NLS_NUMERIC_CHARACTERS using "," for the decimal point

5084109 Create view may dump (in qcsjgcn) or fail with ORA-918

5086622 Double encryption error

5104430 ORA-1309 from PURGE_SESSION

5104624 Explain plan fails with ORA-928

5115350 ORA-932 during ALTER TABLE MOVE with nested tables IOTs

5117361 Capture process aborts with OERI[krvxgctasi:array size]/ORA-1280

5127944 PLS-103 from oracle.sql.TRANSDUMP.getTransitions()

5136454 Distributed statement using a synonym fails with ORA-904

5151675 Cannot archive redo.log in spite of good multiple log members

5151960 IMPDP via NETWORK_LINK EXCLUDE/INCLUDE filters execute on wrong DB

5152323 IMPDP fails during TTS import of partitioned table with XMLTYPE STORE AS CLOB

5173194 Errors from partition range scan of LOCAL DOMAIN index

5260370 Intermittent ORA-904

5345437 Intermittent wrong data / NLS errors (eg ORA-1801)

Internal Error May Occur (ORA-600)

5380055* ORA-1555 / corruption if switch to Standby then back to Primary. This bug is alerted in Note 386830.1

3279497 Interupted (Ctrl-C) TRUNCATE can corrupt ASSM table

3448940 OERI[kskbind:!unb&!uinit] using resource manager with shared server connections

3889156 OERI[kcblibr_1] using global temporary table if client disconnected

4254094 OERI[QERRMOBND1][932] possible for queries over DB links

4271217 OERI:kpolcsc1 / OERI:12333 from JDBC setCharacterStream() for CLOB data

4308089 Dump / OERI on MOVE / SPLIT partition of table with ADT column/s

4339429 RAC instance crash with OERI:[kclbla_2] / dump (skgxpimprp)

4383811 OERI:qerxtAgentOpen_911 during datapump import

4393878 OERI[kclchkping_2] in shared server / PMON

4461688 OERI[qkaPobs1] during instance startup of logical standby

4479323 OPEN RESETLOGS can fail with OERI[3705] in RAC

4502270 OERI [pxtmpalo_pkey] / wrong results can occur executing parallel queries

4502755 Accessing DBMS_XMLDOM.DOMDocument in PLSQL can dump

4528339 OERI [12406] from CONNECT BY query with subqueries

4557725 OERI:qkaAddSibling from SQL using bitmap index

4561867 ASMB may exit prematurely causing OERI in client

4581871 OERI[kslpspr1] can occur

4599763 DBMS_STATS fails with OERI:qospgtbc

4627203 tuxedo server process spins holding transaction branch allocation latch

4637591 OERI:ksfd_dbuf1 possible using ODM with VLM

4638550 OERI[dmlsrvColLenChk_2:dty] during upgrade from 9.2 to 10.2

4639236 OERI [kclcls_5] possible in RAC recreating an object

4639659 SQLLDR direct load of IOT gets OERI[iot_gtab_mr_rcnt_mismatch]

4639977 OERI[kkqcby: qbcfkkc not zero] from CONNECT BY query

4640637 OERI[kwqidorefetch:err][3135] from AQ

4648181 OERI [15160] possible from pushed predicates

4671721 OERI [kfcInitDlocn02] possible in ASM instance

4682861 OERI[kfcnullconvert20] in ASM instance

4686191 OERI[kpnxppce-1] using row shipping with hash cluster

4690953 Conversion of the TIMESTAMP WITH LOCAL TZ from Oracle type in Java fails

4691657 OERI[kxfprdp:1] if PQ slave session is killed

4704890 OERI[kslgetl:1] after adding CPU using dynamic reconfiguration

4709210 ASM LMS OERI[504] on [kfcl le freelist] latch

4735795 OERI:qctcte1 with UNION in an "and exists" subselect

4741394 OERI [12406] from CONNECT BY query

4744859 OERI[kkbncre:sq_len3] can occur

4748222 Update column with TDE gets OERI:[ztsmdwl failed] if there is a trigger

4750469 OERI:kjrfr7 can occur in RAC

4759016 OERI [kghfrf1] doing RMAN backup

4763768 OERI[17056] during analyze table compute stats on IOT

4766532 OERI[kesqsmakesql:phv] from DBMS_SQLTUNE

4859002 PMON crash cleaning up serially_reusable PLSQL

4860003 Sqlplus dump / OCI-21500 [koxsihread1]

4863048 LMS OERI[kjbmpocr:dsb] / instance crash with RAC

4866544 OERI [qmxtrBuildPdAcc:toid] selecting from USER_XML_SCHEMAS

4871743 OERI [kkfi.qbcvfr] creating view which uses ROWID of another view

4874986 OERI[2142] while using flashback feature

4886660 ASMB can fail with OERI:kffmAllocate_1

4890281 OERI[KGHALO4] can occur under qesblGetFilter

4891103 OERI[4442] using XA

4917666 OERI[kcbgcur_9] from type constructor

4925342 OERI [25027] / OERI [25012] on IOT analyze estimate statistics

4940513 OERI[kturrur11] can occur with multi block undo

4952782 OERI:qernsRowP from GROUP BY with ORDER BY DESC

4959569 OERI[kdic_create_journal_table_1] rebuilding REF index ONLINE

4964703 OERI[opixrb-4] [1036] from SELECT over DBLINK with trailing :N or :Q bind names

4966352 OERI[unsorted_pins_4] possible on ASM

4995320 Memory corruption / OERI[17114] from HS

4996133 OERI[kcbgtcr_5] updating an IOT in RAC environment

4997495 Instance crash with OERI[504][mostly latch-free SCN]

5005052 OERI:voprsla1 from ANSI query with TABLE() and domain index

5005939 OERI[qkssao2s1] during DBMS_SQLTUNE

5011019 OERI[2103] on bystander standby during target standby failover

5011764 OERI[ktsircinfo_num1] accessing a LOB

5022093 OERI:[kjsbstat:unknownmaster] possible in RAC

5035666 OERI:16363 opening Java socket from a migratable session

5040222 OERI[4823] from drop partition table after merge with update indexes

5043097 OERI [15160] during query optimization

5043975 OERI[opixrm-1] [invalid handle] for remote cursor

5061952 OERI[kmgsb_resize_sga_target_1] when SGA_TARGET is changed

5068253 LGWR crashes instance with OERI[kcrfw_redo_write_lwn_len]

5071492 LMS crash with OERI[kclastf_1]

5077208 MRP may fail with OERI[kcpcvc3] after a tablespace drop

5078743 Dump (in qkabxo) using bitmap access path in FIRST K ROWS

5082607 OERI:[kutyxtt_convert_b2_01] on convert datafile from Tru64 to AIX

5089217 OERI:[qkacon:NFswrwo] when using CONNECT BY with ORDER SIBLINGS

5090822 OERI[17092] / ORA-10382 when ASM IO completes concurrently with DISKGROUP dismount

5095940 OERI[kcvent_internal_2] during database open

5117361 Capture process aborts with OERI[krvxgctasi:array size]/ORA-1280

5118147 OERI[kssadpm: null parent] can occur

5134663 OERI[2103] with ASM

5156031 Select from GV$AQ can report OERI[kwqldqs: invalid state][8]

5172444 OERI[15160] on complex query with joinback elimination

5186784 OERI[ktecgetsh-inc] from DML against transported tablespace

5218433 OERI[qmximv_maptype] select an XMLType table with TIMESTAMP types

5226903 OERI:[kfcDeadlockAvoid01] when running "check all repair"

5359321 Streams capture fails OERI[krvxalfs: non unique entries in]

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

5114396+ PGA corruption / dumps from session switching with shared servers

5388136PI The fix for bug 5033218 can cause triggers to dump (pfrust) with NVARCHAR2/NCHAR :OLD/:NEW values

3945479 Bad materialized view metadata is definition uses "WITH"

4008133 Dump (skgslsgf) selecting from V$LOCK related views

4257187 Dump (qkkisojkey) from PQ with OUTER JOIN and ORDER BY / GROUP BY

4308089 Dump / OERI on MOVE / SPLIT partition of table with ADT column/s

4380928 ALTER MATERIALIZED VIEW LOG add filter columns may dump

4417341 SKIP LOCKED mishandles fetch out of sequence errors

4440681 Dump from REGEXP_REPLACE referring to table expression

4447168 Dump (kghalp) with auditing enabled

4492467 Dump(kkquhcus) from cost based query transformation

4496339 RECO dumps in lxsCpStr causing instance crash

4540140 Dump (qkkMatchPrefix2) from INLIST with subpartitions

4597692 Dump [qksdsExeStmt] using SQL tuning advisor for long query

4607460 Dump [opipls] when CURSOR_SHARING = SIMILAR | FORCE

4627203 tuxedo server process spins holding transaction branch allocation latch

4644798 Dump (kkmups) using MERGE SQL

4644880 Client dump using dynamic XA registration

4655283 Dump (in joe_run_vm) running Java stored procedure

4657575 CONVERT may dump converting ISO2022-JP data

4666849 Client OCI tracing dumps for long queries (EVENT_10842)

4675505 Dump (koxss2gpage) using XMLTYPE in updates

4739742 CLWS CRSD dump in prou_check_tag<-procr_close_key

4743096 Dump (in vopqbc) from SQL with complex view

4748946 CRSD aborts with OCR errors

4752021 Dump (kpoaqeqopp) on AQ propagation from 8i to 10.2

4865820 LMS dump (kclnrembg)

4870952 CLWS racgimon may dump

4872617 Dump (kfclDumpLe) in ASM

4891103 OERI[4442] using XA

4904890 Dump (upduaw) from UPDATE

4939157 Dump (evaopn2) using a functional index

4944292 Multi-table insert may dump (koklgolx)

4954651 Dump [evacssr] from view with select list subquery with CASE expression

4969029 Query optimization may dump [in kkoijg]

4990803 Dump after type evolution

5001358 Dump (kwqppay2aqe) on propagation of a transformed message

5007623 Dump in clssgmfmtdatareqresp causing node reboot

5011764 OERI[ktsircinfo_num1] accessing a LOB

5012796 DUmp (in kglhdgsc) using distributed transactions

5015557 Dump under kkoNewExtractedBMKey or qerixGetKey with bitmap plan and function based index

5033476 Dump executing a DML which uses a CONNECT BY when there is a trigger

5036588 LMD0 process dump (kewmuprbsm_update_rbsm)

5036879 Dump (kkoajt) during parse

5037103 Dump (qerrmOieb) when selecting view across dblink

5040303 Dump (expepr) from distributed insert into VIEW

5055175 Dump [kkslpkp] using literal replacement with timezone literals

5057629 Dump (krvdtln) / ORA-1294 from DBMS_LOGMNR.start_logmnr

5074814 Dump (kkofmx) from DBMS_ADVISOR.EXECUTE_TASK for some IOT tables

5084109 Create view may dump (in qcsjgcn) or fail with ORA-918

5084961 Dump (qerncRowP) from PQ with nested cursor query

5089039 Select with bind variables can dump in ttcfopr()

5089630 Dump (kfncInitSlavePool) / ORA-15012 from Log Miner / Streams against LOGs on ASM

5095398 Dump (in LdiDateDateSubtract) in RAC when stopping a chain Job

5095577 DMON process never starts (dump rfm_get_opaque)

5099167 MMNL dump under kewa_sample_session

5103658 Dump (ksxpfixcb) from select against V$CONFIGURED_INTERCONNECTS

5114306 Dump (qmuhshget_internal) from DBMS_XMLStore.insertXML

5116402 A dump can occur in ksxpfixcb

5126551 Dump (kkdcacr) from query on tables with FK constraint

5151518 Dump under AccessControlContext executing stored Java

5162241 Dump / spin from query using "WITH" subquery with aggregation or DISTINCT

5174023 Dump registering XML schema with attrgroup refs

5176312 MMON dumps in kswsgetosstat

5351519 Dump using REGEXP_REPLACE() operator

Miscellaneous

4940262P Allow 2.7Gb SGA on 32bit Linux

3603160 AWR should recompile SYS views after purge operation drops partitions

4522561 Alert log grows fast in an archiver stuck situation - ORA-19504

4624398 "SELECT FOR UPDATE WAIT" lock timeout may be longer than specified

4670363 Repeated "LGWR: Archivelog for thread" trace messages

4883174 Archive produces to many log entries "kcrrwkx: nothing to do (end)"

4998064 Event 10298 trace should not be enabled for any level

5098050 Log writer does not close a stale log member until max errors is reached.

5099908 SELECT FOR UPDATE WAIT X timeout may be longer than specified

5228464 genezi executable not included in instant client package

Undocumented Oracle Server

3260512 3628715 3773132 4068937 4137677 4148561 4148588 4178980 4180235 4233154 4277536 4299184 4317759 4334787 4375555 4395120 4416063 4423459 4429113 4429582 4429903 4433321 4438647 4441008 4446899 4449818 4450223 4452976 4455368 4455997 4458752 4459737 4466438 4477829 4491971 4496816 4502275 4517854 4524043 4524109 4532130 4533519 4537276 4537278 4545809 4548630 4555742 4555922 4565939 4566937 4569190 4583061 4590811 4595396 4598696 4599505 4600710 4613169 4614053 4617862 4623932 4625453 4626518 4628853 4631530 4632494 4635392 4635633 4636470 4640646 4649733 4650416 4650432 4656575 4656634 4658617 4658627 4661343 4661911 4663618 4668393 4670961 4671982 4672267 4676933 4682542 4685070 4687386 4688940 4693222 4695173 4695271 4695456 4696810 4702993 4703206 4708135 4708434 4708558 4710706 4710753 4712199 4713132 4714731 4717368 4718976 4721018 4722903 4730798 4733210 4734289 4737566 4741766 4742803 4743518 4746976 4754065 4755212 4759798 4760592 4765679 4766884 4767808 4772453 4773684 4774170 4775286 4775439 4777987 4778209 4778371 4862218 4866000 4867200 4867955 4870719 4870817 4871662 4873677 4874527 4877068 4880255 4885785 4887607 4889165 4889681 4890646 4893198 4894019 4894547 4898685 4899260 4902660 4906807 4908350 4910862 4911093 4914921 4917529 4918021 4918044 4925227 4928496 4930688 4930898 4933032 4935842 4936257 4940388 4942782 4942935 4944941 4947132 4948935 4948950 4949582 4949671 4951213 4951251 4955555 4957601 4958015 4958715 4963493 4966320 4969610 4970222 4991922 4993362 4993953 4997476 4999297 5002193 5004138 5004693 5005534 5005888 5010243 5010671 5012069 5012720 5012775 5013856 5014039 5015492 5017352 5017490 5018696 5020495 5020694 5021707 5027346 5029614 5029701 5030617 5035329 5037927 5038730 5041498 5043377 5044170 5044487 5046709 5049009 5049440 5052431 5053898 5055490 5056200 5056259 5058772 5069212 5069298 5074229 5074509 5079616 5079815 5081743 5082492 5085735 5085794 5086089 5086802 5087485 5087948 5088985 5090123 5092593 5093393 5095739 5095956 5098103 5101403 5102914 5103041 5103637 5103682 5104004 5105587 5106907 5108627 5108992 5109019 5111258 5112531 5115034 5117356 5121849 5122100 5124749 5127240 5127611 5128721 5128944 5129279 5131403 5134359 5135472 5135907 5136189 5136206 5136703 5140931 5143234 5147809 5149677 5149778 5152325 5158529 5159154 5159857 5160019 5163289 5163569 5167186 5167370 5170963 5171189 5172852 5178521 5179210 5181567 5183903 5184359 5184547 5186650 5187311 5187646 5188103 5196300 5198643 5203628 5206567 5209859 5217880 5218245 5219311 5227050 5230361 5232356 5232652 5234788 5234936 5236955 5237733 5237945 5239611 5246630 5249491 5249918 5251964 5252145 5254063 5254203 5255529 5257019 5257277 5257704 5262341 5279016 5279185 5286388 5287568 5303483 5313735 5331574 5337517 5343900 5350987 5356526 5360374 5368567 5378742 5384061 5386863 5389796 5390336 5399528 5402089 5404858 5410680 5456144 5457288 5460288 5464537 5466886 5473945 5480507 5484561 5496033 5505337 5520598 5521962 5525040 5547266 5554695 5557851

PL/SQL

PL/SQL

4326946 OERI[15431] / memory leak from PLSQL

4444429 ORA-6550 and PLS-801 from remote synonym translation via DB LINK

4643322 ORA-22167 possible from BULK DML RETURNING INTO

4654321 UTL_MAIL malforms message body for certain email clients

4661687 Dump under pitcbrv_recv from UTL_HTTP

4698207 ORA-22922 getting CLOB when CURSOR_SPACE_FOR_TIME set to TRUE

4705928 Memory leak using small VARRAYs in a callout

4768178 Dump (pfrdef1_get_tdo) passing ADT to PLSQL

4864649 ORA-1001 from REF cursor

4872783 No space-pad in comparing with concatinated variables

4889301 Regular expressions on CLOBS fails if destination CLOB = input CLOB

4906932 Dump (in pfrfln) using native PLSQL pipelined function

5102847 DBMS_UTLITY.FORMAT_CALL_STACK returns nothing when called via an RPC

5118748 ORA-4030 / memory leak using PLSQL with collections ("pmucp2upkl korfp")

5249253 Dump in diu_node_use_statistics

Undocumented PL/SQL

4656254 4666372 4714030 4930956 5016987 5131768 5131869 5136941 5167202 5197724 5521304

Oracle Transparent Gateway for IBM DRDA

Oracle Transparent Gateway for IBM DRDA

5024716 FLOAT column not converted correctly over TG4DRDA

5373604 Memory leak using block fethcing over HS with hs_fds_fetch_rows > 1

Undocumented Oracle Transparent Gateway for IBM DRDA

5111602 5215753 5217119

SQL*Plus

SQL*Plus

4510978 Sqlplus SPOOL output much slower in 10g than 8i

4878869 Stack space of sqlplus process grows during startup

Undocumented SQL*Plus

3662585 4656061 5112831

Precompilers

Precompilers

3559326 Pro C errors for "naked" type declarations

3698018 Enhancement - add ProC/C++ OCI level statement caching (STMT_CACHE)

4639508 Precompile dumps when SQLCHECK=FULL if code references remote objects

4889483 Procobol PCB-400 from EXEC SQL INCLUDE without a period

5009280 Scrolling cursors do not work when on XA connection in Pro

5128494 Pro connection pool signals ORA-18 using CONTEXT ALLOCATE and FREE repeatedly

Undocumented Precompilers

4878219

Oracle Net Services

Oracle Net Services

3306350 Client connections using NAMES do not close the connection

3807408 Cannot externally authenticate user with quote in username

3934729 Random dumps (nstimexp) using DCD with shared servers

4114966 TNSPING dumps when names.no_persistent_resources=true is set in sqlnet.ora

4279598 Change to default behaviour for keeping LDAP client connections open

4531069 ORA-3113 using pool=on when sqlnet.expire_time is set

4610806 Executables may dump under nnflfrm

4769781 Client hangs on 2nd connect using LDAP directory server

4933023 Bequeath connections fail if SQLNET.OUTBOUND_CONNECT_TIMEOUT is set

4944639 ORA-4052 from using LDAP named dblink in PLSQL

5123958 ORA-12571/ORA-12536 with sqlnet.outbound_connect_timeout set

5368791 outbound_connect_timeout needs to be at address level, not connect level

Undocumented Oracle Net Services

4142391 4370503 4405452 4518309 4579928 4584509 4605829 4723660 4733434 4900013 4931700 4991478 5008316 5129187 5261386 5404278 5466700 5469455

Oracle interMedia

Oracle interMedia

4886281 IMG-703 uploading a large jpeg file

4939295 updatetime is not updated after putmetadata

Undocumented Oracle interMedia

4695009

Oracle Text

Oracle Text

3879892 Filtering may fail on certain Ichitaro documents (DRG-11207)

4359997 Dump / spin Text indexing Chinese/Japanese with wrong NLS setting

4366444 Cursor leak using SYNC(on commit) with Text

4465964 Dump using CTX_DOC.THEMES with NLS_LENGTH_SEMANTICS=CHAR

4541137 umlaut character in token not stored correctly in Text index in UTF8

4589659 CTX_DOC.MARKUP incorrect using Japanese VGram lexer

4742903 Text query expansion results in too many terms

4776116 Dump Text indexing PDF with certain Korean characters

4898338 worldlexer fails for some characters (DRG-50857)

4925189 CTXCAT query may return wrong result when using multi-colum index

4957634 Text Index creation with worldlexer can dump (drlwtkn)

5005469 There is no script to assist with migration from korean_lexer to korean_morph_lexer

5014128 Context index optimize with rebuild option takes long time

5036380 worldlexer index creation can dump (drlwtkn)

5060137 Progessive relaxation returns no hits although it should

5079472 ORA-54 when doing optimize_index with rebuild option and sync simultaneously

5095220 Parallel Optimize Index Rebuild does not run in parallel

5150177 Create Text index on master detail datastore is slow

5220353 No error returned when indexing fails on a BFILE column in a multicolumn datastore

5233309 ORA-1426 possible creating Text index

Undocumented Oracle Text

4312200 4507857 4614553 4716815 4725922 5046136 5057216 5456132

Advanced Networking Option

Advanced Networking Option

5141966 ORA-1041 on Kerberos authenticated connections to an AIX RDBMS from a Windows

Undocumented Advanced Networking Option

4436949 5114330 5354247

Oracle Database Configuration Assistant

Oracle Database Configuration Assistant

4714878 DBCA cannot use or delete DBA templates

Undocumented Oracle Database Configuration Assistant

4690433 5052501 5109473

Oracle ODBC Driver

Oracle ODBC Driver

4150034 Some ODBC API catalogue functions can be slow

4371966 ODBC "input string too long, limit 4096" if long string has CR / LF

4735799 ODBC driver can truncate data retrieved with SQLFetchScroll()

4878228 ODBC dump

4878372 ODBC memory leak

4878377 ODBC memory leak

4880062 Calling SQLBindCol after SQLColumns returns 0 as the datatype

4886344 ODBC uninitialized memory read

4886366 ODBC uninitialized memory read

4961312 ODBC memory leak vor SQLBulkOperations

5015342 ODBC sqlcolumns() does not return correct values for all datatypes

5220440 ODBC driver truncates CLOB against unicode database

Undocumented Oracle ODBC Driver

4309867 4546618 4608183 4612520 4622561 4727495 4878347 5147229 5202570

JPublisher

JPublisher

4607523 JPUB ORA-19011 when the return type (XMLTYPE) is over certain

Undocumented JPublisher

4316058 4676455 4681517 4694405 4956599

Oracle Spatial

Oracle Spatial

4211810 Spatial does not work for usernames containing a \ backslash

4450497 Upgrade 9.0 to 10g causes SDO_INDEX_METADATA null fetch errors

4571717 UNION of two valid geometries returns ORA-13350

4607533 Wrong results from SDO_INTERSECTION

4692886 Spatial function sdo_lrs.offset_geom_segment has problems with Arcs

4707623 SDO_INTERSECTION returns wrong results for different tolerances

4723914 ORA-6502 / EXP-78 when exporting function based spatial indexes

4742014 Wrong result from SDO_INTERSECTION

4745776 Incomplete results for spatial query

4752108 Domain index opererator applied to all UNION ALL branches

4919879 GeoRasterViewer fails with java.lang.NoClassDefFoundError

5019846 sdo_geor.getcellvalue() wrongly raises ORA-13457

5037707 sdo_geom.relate determine returns unknown mask: 010011011

5055754 Dump [mdgoplun] when the result of SDO_DIFFERENCE is a null geometry

5092335 SDO_NN query using SDO_BATCH_SIZE performs badly

5115096 ALL_SDO_NETWORK_CONSTRAINTS is missing OWNER and CLASS columns

5152407 CHANGEFORMATCOPY returns wrong result when only compression ratio is changed

5175219 Wrong results from SDO_INTERSECTION

5210128 R-Tree metadata reads do not use bind variables

5243019 Memory leak in SDO_GEOM.WITHIN_DISTANCE, SDO_WITHIN_DISTANCE, SDO_NN

5247178 Wrong SDO_INTERSECTION respective SDO_AREA results depending on tolerance

5375259 Wrong results from SDO_RELATE

5487727 SDO_ANYINTERACT can be slow

Undocumented Oracle Spatial

4488214 4663558 4693687 4861328 4900030 5043731 5068723 5127599 5136353 5139145 5155950 5193129 5275754 5277928 5453881

Oracle Ultra Search

Oracle Ultra Search

4191512 URL result by Ultrasearch does not work if there is a SPACE

4663819 "max size" of "temporary directory location and size" does not work

4760824 ORA-1422 when same document is crawled in two file datasources

Undocumented Oracle Ultra Search

4411587 4606682 4991308

Oracle Procedural Gateway for APPC

Undocumented Oracle Procedural Gateway for APPC

4752914

Oracle Database Upgrade Assistant

Undocumented Oracle Database Upgrade Assistant

3883839 5467397

SQLJ

Undocumented SQLJ

4911257 4931418

JDBC

JDBC

4272639 JDBC returns XAER_RMERR in xa_commit

4398431 Hang when retrieving a connection from the implicit connection cache

4426058 First end-to-end metrics after start of VM are not sent to server

4507211 Thin JDBC connection properties terminal not reflected in V$SESSION

4509540 NullPointerException from omitting registerOutParameter() when calling PLSQL

4551798 JDBC clients can get OERI[12333] on cancel from second thread

4566966 ORA-1460 binding NCHAR to a CALL statement in JDBC

4580690 JDBC returns wrong date from a TIMESTAMPTZ column

4638698 JDBC getDate returns wrong value for a specific dates

4670851 Binding CustomDatum for a CHAR fails

4688040 JDBC does not support batch size > 65535 in 10g

4688156 NullPointerException possible if network error occurs

4714537 Named WHERE clause parameter must be surrounded by spaces

4732343 Type evolution not fully supported by JDBC

4736325 JDBC does not handle space between ":" and bind name

4751145 ArrayOutOfBoundsException when fetchsize is changed

4768476 ArrayOutOfBoundsException with many NCHAR OUT binds

4880797 Enhancement: Add JDBC support for Albanian and Macedonian Locales

4891464 NCHAR literal binds parsed incorrectly in JDBC

4896035 removeCache does not have an abort option

4904415 ORA-1459 with 2 PlsqlIndexTable binds in JDBC

4904868 JDBC deadlock using Scrollable ResultSet

4915735 getProcedures() returns duplicate rows

4931235 Dump (lxgu2t) / memory corruption from stored Java using String binds

4958448 JDBC XA cannot end a suspended transaction when using 2 connections

4963720 JDBC Statement cache holding more memory than expected

4998582 JDBC OCI throws exception executing PLSQL with OUT parameters using CALL

5019367 racle.net.CONNECT_TIMEOUT does not work when server / listener is hanging

5021342 Connection errors occur when interupting network with JDBC Thin

5045849 TIMESTAMP value incorrect when retrieved using getTimestamp with Calendar object

5058024 ArrayOutOfBoundsException executing SQL with using binds and ScrollableResultSet

5071674 handleAbandonedConnection() callback method does not work

5111887 Java thread deadlock registering OUT parameter concurrent with closing connection

5139924 OutOfMemoryError when getString is used against a Clob column

5157526 JDBC driver is not able connect using service_name and JNDI of J2EE servers

5174701 SQLException fetching Timestamp through getTimestamp()

5246867 V$SESSION.PROGRAM is not populated properly for JDBC Thin

Undocumented JDBC

4331845 4723590 4725994 5003681 5484862

Oracle Security Service

Oracle Security Service

4082155 JVM may dump in SSL code under load (rare)

4555795 Certificate mapping - fetch value from Subject Alt Name

4700543 SSL sessions can fail during negotiation

4715022 OWM unable to save a wallet after importing trusted certficate

4892623 Import of trusted CA cert in OWM can fail

5055442 SSL connections fail when running in FIPS mode.

Undocumented Oracle Security Service

4341874 4430537 4634401 4968975 5074035

Oracle XML Developers Kit

Oracle XML Developers Kit

4563343 Classes generated by Jaxb Class Generator fail with exception

4638391 Wrong output from concat of XSL variable or attributes with normal strings

4662345 TRANSX Java API is slow

4680398 XSL Processor can leak memory when transforming stylesheet

4736248 XDK fails to compile an XSL file if baseuri contains a space character

4744317 XSLT transform fails when tag contains '_' at beginning

4760148 JAXP transform does not keep output escaping

4760744 Wrong result when value of an attribute is same as its name

4891220 XSLProcess() can allocate a lot of memory

5012135 domsample using xdk new C++ api leaks memory

5099703 ISSCHEMAVALID very slow for certain documents

Undocumented Oracle XML Developers Kit

5002265

Oracle XML SQL Utility (XSU)

Oracle XML SQL Utility (XSU)

5082904 JDBC Thin NullPointerException in OracleXMLQuery.setSkipRows()

Net Configuration Assistant - NetCA

Net Configuration Assistant - NetCA

4536817 NETMGR unable to create a NET entry with a service_name longer than 8 characters

Oracle OLAP

Oracle OLAP

4291719 ADVISE_CUBE() does not produce different valuesets for different precompute %

4554310 Closing connection with open cursormanager causes OERI:xsenter

4592645 Dump (lxowrichar) from OLAP

4594651 DBMS_ODM reports ORA-6533 subscript beyond count

4652142 OLAP import fails if export EIF DB charset is different

4689285 UGA memory leak and AW corrupt after maintenance

4692633 Poor performance of last descendant queries

4693369 OLAP dump in xsxeq running aggregate

4722589 Wrong results joining two active catalog OLAP table function views

4745026 Wrong results against value-based hierarchy with depth=20

4768374 Dump in OLAPI - broken pipe using EPB ownership DIMS

4768531 Allocate fails with protect and negative source value

4775129 OLAP DML function AW(ACQUIRED) does not work

4864556 Compile a model in an AW can dump

4919367 OLAP cannot add value to cube

4938850 divide-by-zero exception in geneva forecasting

4969277 OLAP assign trigger on a QDR variable reports wrong value

5079963 delete/clear data does not work when using compressed composites

5117953 OLAP build log can show the wrong log

5123809 Error adding a measvalstep - ORA-932 "inconsistent datatypes"

5141255 oracle.AWXML.AWException error creating an index

5154963 Partial eif export followed by an import does not finish

5203715 Excessive OLAP process memory allocation

5243313 CWM2_OLAP_AW_ACCESS invalid after upgrade to 10.2.0.2

Undocumented Oracle OLAP

4432693 4460501 4584979 4590676 4645527 4665476 4690562 4699148 4699360 4712167 4717032 4728166 4730603 4742322 4746178 4771880 4772061 4862379 4870750 4879952 4898763 4924445 4933017 4938794 4947974 4956458 4959563 4962657 4966052 4969274 4991717 4996452 5004195 5013154 5013558 5018732 5024307 5027211 5038173 5040587 5046525 5048896 5049247 5052145 5060916 5065034 5065108 5071458 5081934 5082680 5087329 5087348 5093087 5105620 5105776 5124413 5127122 5127704 5128870 5128890 5132279 5132712 5146721 5148774 5172351 5176148 5192392 5192998 5198063 5198106 5199304 5212607 5214806 5218397 5223100 5223558 5224176 5226451 5229472 5231109 5234051 5234843 5236963 5240493 5241238 5246299 5250995 5258975 5259599 5259646

Oracle Globalization Development Kit

Oracle Globalization Development Kit

4643021 orai18n.jar should not depend on the Oracle XML parser

Undocumented Oracle Globalization Development Kit

4691422 4712473 5103710

4433936	ORA-907 from FULL / LEFT OUTER joins
4582764	Wrong results from ANSI OUTER join with inline view
4615392	Join elimination not working with ANSI join syntax
4625102	Wrong results using ANSI join when NL join is performed
4932843	Wrong results from full outer join with TABLE() function
5005052	OERI:voprsla1 from ANSI query with TABLE() and domain index

3279497	Interupted (Ctrl-C) TRUNCATE can corrupt ASSM table
3610777	Excessive CPU from INDEX insert into ASSM index segment
4055634	TRUNCATE table has to much overhead when operating on empty segments
4188324	Wasted space possible in ASSM segments
4475314	DELETE then INSERT without commit on ASSM segment can be slow
4660718	Allow choice between space / performance for ASSM segments
4694312	Index inserts to ASSM segments can be slow
4887955	Unnecessary extent allocated in locally managed ASSM tablespace in RAC
5034679	Hang / errors making ASSM tablespace read only with concurrent DML
5349632	Poor performance for ASSM insert after large DELETE

4515626	AQ enqueue option visibility=DBMS_AQ.IMMEDIATE does not work for ENQUEUE_ARRAY
4527173	AQ$_JMS_TEXT_MESSAGE.SET_TEXT method does not work correctly with multi-byte character sets
4543871	High CPU use by Qxxx proceses when using RETENTION
4640637	OERI[kwqidorefetch:err][3135] from AQ
4730389	ORA-30757 on propagation from 10.2 -> 8i
4752021	Dump (kpoaqeqopp) on AQ propagation from 8i to 10.2
4756409	High latency in AQ OCI notifications
5001358	Dump (kwqppay2aqe) on propagation of a transformed message
5178202	RAC AQ dequeue on different instance to enqueue is slow

3811904	Rebalance can fail if there is one full disk
3885499	ASM hang possible
4229751	CONVERT TABLESPACE fails to create file with DB_FILE_NAME_CONVERT on ASM
4450268	ASM disk mounts are serialized
4466433	Restoring current controlfile on ASM creates a file with "backup" string
4561867	ASMB may exit prematurely causing OERI in client
4671721	OERI [kfcInitDlocn02] possible in ASM instance
4691191	Failure during file grow may leak ASM disk space
4709210	ASM LMS OERI[504] on [kfcl le freelist] latch
4709214	ASM may crash with OERI[kfclGetLock40]
4752481	Skewed ASM disk allocation when single file resized many times
4865736	ASM resource should not have dependency on VIP
4872617	Dump (kfclDumpLe) in ASM
4883032	ASM fails with ORA-15096 during crash or instance recovery
4886660	ASMB can fail with OERI:kffmAllocate_1
4907496	Processes hang after adding disk back to ASM diskgroup using force option
4943406	LMON needs to message SMON to start recovery in ASM instance
4960705	ASM waits longer than necessary during reconfiguration
4966352	OERI[unsorted_pins_4] possible on ASM
4967266	DB recovery blocked by ASM recovery
5012099	ASM rebalance problems
5024639	ASM hangs if private interface down on a surviving node
5039964	ASM disks show as provisioned although kfed shows valid disk header
5089630	Dump (kfncInitSlavePool) / ORA-15012 from Log Miner / Streams against LOGs on ASM
5090822	OERI[17092] / ORA-10382 when ASM IO completes concurrently with DISKGROUP dismount
5134663	OERI[2103] with ASM
5226903	OERI:[kfcDeadlockAvoid01] when running "check all repair"
5360719	ASM and database instances hang when disk array gets disconnected
5515492	Data corruption when ASM failgroup removed

4475125	Wrong results with join of FULL INDEX SCAN (MIN/MAX) with bitmap index
4533389	ANALYZE INDEX VALIDATE STRUCTURE does not update INDEX_STATS for bitmap indexes
4615091	Wrong result using bitmap index on partition table with INLIST
5015557	Dump under kkoNewExtractedBMKey or qerixGetKey with bitmap plan and function based index
5078743	Dump (in qkabxo) using bitmap access path in FIRST K ROWS

4380175	Orphaned segment left by DBMS_CDC_PUBLISH.PURGE
5024710	CDC queue tables always end up in SYSTEM or SYSAUX tablespace

4707711P	Solaris: 'cluvfy' fails on Solaris (Sparc-64bit)
5022314P	CRS has wrong LD_LIBRARY_PATH on Solaris X86-64
4127644	CSS not set in high/fixed priority class using CRSCTL SET CSS PRIORITY
4230367	nodedown event slow to appear after public network failure
4437727	VIPCA fails complaining that interface is not public
4459961	"crsctl debug log css COMMCRS / COMMNS" commands fail
4462367	CRS starts instance with too low file limit
4493093	PRKH-1001 from "srvctl add nodeapps"
4556878	CRSD may dump at cls_thrmxunlock()
4667776	clscfg -downgrade fails
4669874	RLB event delivery stops after instance restart
4689845	OPROCD log is not set up in RUN mode
4702263	CRSD failure is not handled in the init script
4716107	CVU fails if central inventory contains a deinstalled CRS home
4723189	Veritas Cluster Software not supported properly on some platforms
4726670	Total space of OCR is reported as 0 while executing root102.sh
4728396	DBCA does not change the parameter REQUIRED_RESOURCES for using ASM
4734413	OCR read from local cache blocked by writer working on different key
4739742	CLWS CRSD dump in prou_check_tag<-procr_close_key
4748946	CRSD aborts with OCR errors
4755275	CLWS CRSD aborts: fail to start monitor thread, comm failure
4756170	CRS/OCR delay before CRS recovery starts
4759984	root102 has wrong "rc" directories
4769197	Clients hang if a node goes down
4772904	PRKR-1007 / PROC-5 from srvctl
4865736	ASM resource should not have dependency on VIP
4870952	CLWS racgimon may dump
4879951	CLWS CRSD dump in eventutil::set_context
4883916	stop crs resource may be slow for shutdown abort
4890793	ASM resource depends on VIP even after removing required_resources
4893560	clscselect does not handle timeout = 0 correctly
4919514	CSSD does not fail when vendor clusterware present and skgxnreg fails
4925962	Problem with rootdelete.sbs, rootupgrade.sbs and localconfig.sbs
4926814	CLWS EVMD aborts in reconfiguration
4936206	CSS clients fail when vendor skgxn returns 0 for skgxntpshl
4936950	root and init scripts do not support SunCluster on Solaris X86 properly
4937400	GSD should not attempt to be started on Solaris x86 platforms
4945458	CSS group reconfiguration may not wait long enough to establish connections
4946339	CRS trace level cannot be modified via ocrlog.ini
4951958	CSSD reports graceful shutdown on private network cable pull
4967761	1.6s - 2.0s "gap" in CRSD before crs starts recovering resources
4997470	CSS startup terminates when another node comes up during reconfig
5004962	CRS may not be able to relocate a resource when no required resources
5007623	Dump in clssgmfmtdatareqresp causing node reboot
5011915	Split-brain resolution can be slow
5015469	OPROCD reboots node when system date goes backwards
5037858	OPROCD may report no reason for reboot
5037871	Clearer CSSD logging needed giving reasons for reboot
5052569	Wait for 'reboottime' after the kill echo on some platforms
5071602	Need a patch utility / key editor for diagnosis/repair of OCR corruptions
5077218	CSS asserts in clssnmhandlevoteinfo, clssnm.c 2224, node rebooted
5092622	oclsomon uses the wrong timeout value
5092725	crsctl debug does not accept a dash - ( hyphen )
5136712	ocrdump prints out no value for a keys with large value
5163409	"srvctl modify database" fails with PRKH-1014
5187351	Many clscNN.log files created - can affect performance
5252605	CSS reconfig starts before <misscount> seconds have elapsed
5350302	Unexpected node reboot after 'oracle cssd shell script failure'

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

4742679	ORA-604 / ORA-28133 enabling constraints on table with FGA
5126551	Dump (kkdcacr) from query on tables with FK constraint

5380055*	ORA-1555 / corruption if switch to Standby then back to Primary. This bug is alerted in Note 386830.1
5212539+	LOB corruption for NOCACHE LOBs (ORA-1555/ORA-22924)
5032964	ORA-19731 whilst recovering plugged in file

3279497	Interupted (Ctrl-C) TRUNCATE can corrupt ASSM table
4655520	Block corrupted during write not noticed
5017007	MVIEW LOB content incorrect after refresh

4380175	Orphaned segment left by DBMS_CDC_PUBLISH.PURGE
4748597	Moving a LOB in a partitioned table fails to update IND$
5040222	OERI[4823] from drop partition table after merge with update indexes

5380055*	ORA-1555 / corruption if switch to Standby then back to Primary. This bug is alerted in Note 386830.1
5253271	Wrong sort ordering for zeroes

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

5212539+	LOB corruption for NOCACHE LOBs (ORA-1555/ORA-22924)
4411228	Block corruption with mixture of file system and RAW files
4637668	IMU transactions can produce out-of-order redo (OERI [3020] on recovery)
5061091	Block recovery corrupts undo header when log_parallelism > 1
5515492	Data corruption when ASM failgroup removed

4254094	OERI[QERRMOBND1][932] possible for queries over DB links
4321119	ALTER MATERIALIZED VIEW causes ORA-32337 after DML via database link
4496339	RECO dumps in lxsCpStr causing instance crash
4627237	autonomous_transaction with DB link to shared server can self deadlock on DX
4637725	ORA-918 for remote DML
4703253	Wrong results from remote colocated join
4708037	ORA-904, ORA-2063 from query that uses TIME ZONE as a cast
4771052	INSTEAD-OF trigger does not update tables correctly over dblink
4904454	Wrong results from queries using remote colocated joins
4957217	ORA-2019 from REF cursor from procedure that uses a private dblink
4964703	OERI[opixrb-4] [1036] from SELECT over DBLINK with trailing :N or :Q bind names
4968994	Poor plan using SYSDATE in predicate over dblink
4996080	Wrong results from remote join
5012796	DUmp (in kglhdgsc) using distributed transactions
5037103	Dump (qerrmOieb) when selecting view across dblink
5040303	Dump (expepr) from distributed insert into VIEW
5043975	OERI[opixrm-1] [invalid handle] for remote cursor
5136454	Distributed statement using a synonym fails with ORA-904
5550824	Select SYSDATE over a database link increments SYSDATE

5212539+	LOB corruption for NOCACHE LOBs (ORA-1555/ORA-22924)
4271217	OERI:kpolcsc1 / OERI:12333 from JDBC setCharacterStream() for CLOB data
4748597	Moving a LOB in a partitioned table fails to update IND$
4867884	Lob HW lock contention with space reclaimation
5011764	OERI[ktsircinfo_num1] accessing a LOB
5017007	MVIEW LOB content incorrect after refresh
5110062	Wrong results from INSTR for CLOB for multibyte charactersets

4242649	Object views are slower than they need be
4308089	Dump / OERI on MOVE / SPLIT partition of table with ADT column/s
4440681	Dump from REGEXP_REPLACE referring to table expression
4451506	Wrong results from SQL using TABLE() constructs
4583177	Poor performance inserting subtype constructor into polymorphic column
4644048	Oracle type evolution can fail with ORA-932
4744859	OERI[kkbncre:sq_len3] can occur
4860003	Sqlplus dump / OCI-21500 [koxsihread1]
4886383	Dump possible unpickling images from TABLE() function
4917666	OERI[kcbgcur_9] from type constructor
4928321	Pickle of opaque type results in bad image size
4932843	Wrong results from full outer join with TABLE() function
4959569	OERI[kdic_create_journal_table_1] rebuilding REF index ONLINE
4990803	Dump after type evolution
4992856	Collection view is not merged in DML
5005052	OERI:voprsla1 from ANSI query with TABLE() and domain index
5068565	Wrong results from pipelined table funciton with prefetch enabled (default)
5084961	Dump (qerncRowP) from PQ with nested cursor query
5130670	Wrong results with CURSOR query on complex view with collection objects

4272872	TIMESTAMPTZ is not affected by setSessionTimeZone
4460775	TIMESTAMP types may not exist in migrated database
4482737	FGA does not record binds of type TIMESTAMP in FGA_LOG$
4689959	Version 3 TIMEZONE files
4690953	Conversion of the TIMESTAMP WITH LOCAL TZ from Oracle type in Java fails
4708037	ORA-904, ORA-2063 from query that uses TIME ZONE as a cast
4776636	Wrong value for TIMESTAMP WITH TIME ZONE when NLS_CALENDAR set
4914281	TIMESTAMP WITH TIMEZONE values before 1800 corrupted
5055175	Dump [kkslpkp] using literal replacement with timezone literals
5075470	JVM timezone changes for Commonwealth games 2006
5218433	OERI[qmximv_maptype] select an XMLType table with TIMESTAMP types

4627237	autonomous_transaction with DB link to shared server can self deadlock on DX
4699610	CKPT can self deadlock waiting for MTTR state object which it holds
4732503	Self-deadlock on TT enqueue
4765374	Create table with XML schema causes ORA-4020
4876140	ORA-4020 on registering XML schemas using recursive references
4913415	Global deadlock not reported in RAC
5012368	Undetected deadlock in RAC
5363031	deadlock on broker metadata lock when FSFO is enabled
5386881	ORA-60 deadlock from terminal recovery

Bugs fixed in the 10.2.0.3 Patch Set

Notable exceptions and omissions

Security Alert Issues fixed in the 10.2.0.3 Patch Set

10.2.0.3 Bug Categories

10.2.0.3 Bug Fixes by Category

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

3652491	Error for parallel query with ORDER BY and DOMAIN index
4134994	Extensible optimizer may use default costs
5005052	OERI:voprsla1 from ANSI query with TABLE() and domain index
5173194	Errors from partition range scan of LOCAL DOMAIN index

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

5030164	ADD_ELEMENTARY_ATTRIBUTE can fail with ORA-12899
5078837	ORA-41661 from DBMS_RLMGR with NLS_NUMERIC_CHARACTERS using "," for the decimal point

4874986	OERI[2142] while using flashback feature
5104579	Flashback query results on RAC inconsistent after rebooting 1 instance
5106952	Flashback log space not being reclaimed

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

4516151	SQLServer streams gives error if DML has nulls for date column
4629856	Wrong results selecting a LONG and a NULL over HS
4739749	Gateway returns ORA-28500 when it cannot process schemaname
4995320	Memory corruption / OERI[17114] from HS
5155213	Excessive memory use for ARRAY operations over HS

4527173	AQ$_JMS_TEXT_MESSAGE.SET_TEXT method does not work correctly with multi-byte character sets
4598613	ORA-2248 from 10.2/10.1.0.5 client with NLS_LANG set to territory SWITZERLAND
4627522	ORA-1407 updating VARCHAR2 in AL32UTF8 database
4657575	CONVERT may dump converting ISO2022-JP data
4679879	ls/dir does show file information correctly on XDB FTP if NLS_LANGUAGE=JAPANESE
4689959	Version 3 TIMEZONE files
4950241	DBMS_APPLY_ADM.EXECUTE_ALL_ERRORS() fails with ORA-1403
4964703	OERI[opixrb-4] [1036] from SELECT over DBLINK with trailing :N or :Q bind names
5033218	ORA-6502 if TRIGGER modifies column value with >= 1001 character value
5045474	Optimizer may not use function based index with NLSSORT of a CHAR column
5075470	JVM timezone changes for Commonwealth games 2006
5078837	ORA-41661 from DBMS_RLMGR with NLS_NUMERIC_CHARACTERS using "," for the decimal point
5110062	Wrong results from INSTR for CLOB for multibyte charactersets
5253271	Wrong sort ordering for zeroes
5333814	OraSimpleDateFormat::parse on date with "pm" incorrectly becomes "am"
5345437	Intermittent wrong data / NLS errors (eg ORA-1801)

3885499	ASM hang possible
4672266	LMS hang waiting for 'kjc: wait for msg sends to complete' during shutdown
4699610	CKPT can self deadlock waiting for MTTR state object which it holds
4732503	Self-deadlock on TT enqueue
5016142	SMON rollback of large transactions blocks other actions
5024639	ASM hangs if private interface down on a surviving node
5151675	Cannot archive redo.log in spite of good multiple log members
5208973	RAC may hang due to deadlock between LMS / MMAN latching
5360719	ASM and database instances hang when disk array gets disconnected

4390868	Contention on DC_SEGMENTS due to small cache size on SYS.AUDSES$
4558970	RMAN RECOVER compilation can be slow
4602661	Adding a datafile hangs other sessions and new connections with resource manager
4627237	autonomous_transaction with DB link to shared server can self deadlock on DX
4725679	Switchover to logical standby hangs
4752179	Hang when calling extproc and killing client application
4755405	Excessive waits for "gcs drm freeze in enter server mode" in gsiat
4872999	RAC instance cannot get global enqueue
4882834	Excessive SS and TS contention in RAC
4907496	Processes hang after adding disk back to ASM diskgroup using force option
4956243	ALTER DATABASE BEGIN BACKUP hangs if other instance is mounted
5034679	Hang / errors making ASSM tablespace read only with concurrent DML
5068048	SQL*loader hang on direct path load on multi CPU machine
5117717	DG broker must disable/enable threads for logical switchover and failover
5143296	Reinstate of old primary hangs when old primary is disabling itself
5181800	Async LNS holds CF enqueue while issuing network calls rfsopen/rfsclose