Tips: DBA Tools | Oracle DUL? | AUL License | AUL Example | DBDiff | Text Unload | DB Monitor

Subject: 9.2.0.4 Patch Set - List of Bug Fixes by Problem Type
  Doc ID: Note:245758.1 Type: README
  Last Revision Date: 11-AUG-2005 Status: PUBLISHED

Bugs fixed in the 9.2.0.4 Patch Set

This note lists the bugs fixed in the 9.2.0.4 Patch Set over and above those fixed in 9.2.0.3 or 9.2.0.2. The 9.2.0.4 Patch Set itself is cumulative and includes all fixes in 9.2.0.2 and 9.2.0.3 in addition to the fixes listed in this document. 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.

Notable exceptions and omissions

Security Alert Issues fixed in the 9.2.0.4 Patch Set

Fixed Bug# Security Alert# Document Summary
9.2.0.4 3058991 Sec. Alert#58 Note 246202.1 Buffer Overflow vulnerabilities in the XML Database
9.2.0.4 2716764 / 2988114 Sec. Alert#57 Note 244523.1 Extproc overflow vulnerability

9.2.0.4 Bug Categories



9.2.0.4 Bug Fixes by Category



Symptom


Corruption (Corrupt Export)
2746788+ Export does not error on DISK FULL conditions (IMP-9 on import)
2862818 Bad export of NESTED table in LOCALLY managed tablespace - ORA-25150 / ORA-942 on import

Corruption (Dictionary)
2702410 ORA-8104 / ORA-8106 occur on ALTER MOVE / REBUILD ONLINE
2781500 Dictionary corruption possible if DBMS_RULE_ADM.DROP_RULE / DROP_EVALUATION_CONTEXT errors
2809130 Queue import can corrupt dictionary metadata if queue pre-exists
2897947 Dictionary (COL$.PROPERTY) does not contain INSERTABLE FLAG when CTAS uses UPPER function
2909084 RENAME of a VIEW with CHAR column can cause wrong results for subsequent SQL
2976763 Failed DROP MVIEW can leave corrupt dictionary data - subsequent ORA-30382

Corruption (Incorrect / missing corruption checks)
2551000 False ORA-1410 / ORA-8103 possible from ANALYZE COMPUTE/ESTIMATE STATISTICS
2870048 False corrupt block messages in alert log

Corruption (Index)
2909160 OERI[6122] / index corruption for DML against AUTO space managed indexes

Corruption (Logical)
2797392+ Streams / logical standby does not replicate DDL from PLSQL "EXECUTE IMMEDIATE"
2886004+ Reverse default behaviour for blank trimming of Control characters
2511699 Silent data truncation inserting char literal into NVARCHAR2 column
2594726 JDBC Array insert > 65535 elements may product NULL rows / fail with ORA-6531
2679297 Non numeric characters can be inserted into a NUMBER column in HS
2708284 Loader misreads secondary datafiles for VARRAYs / Nested Tables
2767857 SQLLOAD of NULL LOB loads previous LOB value

Corruption (Physical)
2914002P* VMS: Corruption / crash using RAC on VMS with TCPIP interconnect
This bug is alerted in Note 244940.1
2431450 SMU Undo corruption possible on instance crash
2537604 RAC graceful failover may result in corrupt new primary database
2742254 In RAC a transaction can use an offline rollback segment causing corruption
2798239 Block corruption possible on rollback of segment merge
2967417 OERI:KCOAPL_BLKCHECK may occur using Auto managed segment

Deadlock
1994858 False deadlock / undetected deadlock in XA
2516513 ORA-60 from concurrent PDML on same table
2554861 ORA-60 in RMAN BACKUP during RESYNC (DBMS_RCVCAT.SANITYCHECK)
2629434 Self DEADLOCK possible on HW enqueue using SMU
2670550 ORA-4020 while refreshing a MATERIALIZED VIEW
2746688 ORA-4020 possible from DDL or TRUNCATE in PLSQL
2799097 DEADLOCK possible on concurrent EXCHANGE PARTITION (DC_TABLESPACE_QUOTAS)
2864094 ORA-60 in SQL apply with multiple apply servers with rollback operations
2930352 Deadlock from concurrent setFetchSize and commit in JDBC
2938982 Deadlock using VARRAY in JDBC
2976372 Creating a PLSQL object intermittently fails with ORA-4021 in RAC

Excessive CPU usage
2740472 Shared servers burn CPU executing Java "wait()" call
2785102 Query involving many partitions (>1000) has high CPU/memory use
2834669 JDBC 9.2 thin uses more CPU (in client) than 8.1
2842026 SQL APPLY coordinator can use excessive CPU
2858886 LCK process may use excessive CPU

Feature Unusable
2945011 VLM (USE_INDIRECT_DATA_BUFFERS=TRUE) does not work on Standard Edition Oracle

Fix is considered an enhancement
2602197 ENH: XDB should support LDAP groups within ACLs
2702947 Enhance ABN rules output
2782926 Diagnostic for when PMON cannot get ROW CACHE enqueue
2784301 ENH: Add support for OCCI in Visual C++ V7
2799028 ENH: Remove Functional Index need for QUERY_REWRITE / QUERY_REWRITE_ENABLED
2801367 Diagnostic fix to dump more information on OERI:[skgxprrgn2]
2814565 Diagnostic to improve ENQUEUE block dump
2864687 ENH: Increase NAMES.MAX_OPEN_CONNECTIONS upper limit
2905433 Enhanced diagnostics for out of memory conditions during checkpoint

Hang - Involving shared resource
2727744 Foreground processes / SMON may hang waiting for row cache lock (rare)
2742518 Accessing X$GLOBALCONTEXT may fail with OERI:525 / hangs the DB
2828026 Interrupted sessions may fail with ORA-600[1158] / DB can hang
2840233 OERI[510] .. [SHARED POOL] can occur / latch related DB hang possible

Hang - Process hang
2817427P HPUX: Shadow process may hang on KSLEEP(PTH_MUTEX_OBJECT)
2818390P Win: Hang scenario possible due to mutexing issue
2470696 Logical Standby apply process may hang (logical standby cache latch)
2661516 SHOW MARKUP may hang in SQLPLUS
2706634 MANY PROCESS SLOW DOWN WHEN 240 SESSION INSERT AT THE SAME TIME
2738120 "SHUTDOWN IMMEDIATE" may hang due to PQ activity
2741185 Fast refresh of MV on remote LOB columns may hang
2759170 Simultaneous DBMS_LOGMNR_D.BUILD may hang
2797571 SQL may hang from 7.3->8i/9i if SELECT expression > 960 characters long
2912869 Sessions hang on "library cache lock" during ALTER TABLE .. MODIFY PARTITION .. REBUILD ..

Hang - Process spins
2397300 CPU Spin from concurrent AQ dequeue of same message without commit/rollback
2588348 Particular multibyte sequences can spin in PLSQL compilation
2598547 PLSQL may hang/spin if there are a huge number of IF THEN .. ENDIF statements
2599336 CTXHX may hang/spin if a segmentation fault occurs
2627570 RPAD(str,n,CHR(0)) spins using multi-byte character set
2676447 SQLPLUS may spin if it sees invalid multibyte data
2798620 ISQL*PLUS spins for some SELECTs in certain character sets
2928676 CREATE MVIEW using LAG with PARTITION clause may spin in JA16SJIS
2937108 DELETE CASCADE may spin in RAC

Instance may crash
2747111P Tru64: RAC instance may crash with OERI:[SKGXPIODONE17] / DBWR dies with OERI:KCBZPB_1
2914002P* VMS: Corruption / crash using RAC on VMS with TCPIP interconnect
This bug is alerted in Note 244940.1
2329767 OERI:106 setting diagnostic EVENT against PMONs session
2444568 Instance CRASH with OERI[2886] if ALTER .. READ ONLY dumps
2529847 OERI [KCBVMAP] possible with VLM enabled
2534240 PMON / Instance crash possible cleaning up dead process
2621133 OERI:kjbconsign:wip2 after block recovery during instance recovery
2726601 OERI[4406] possible in SMON using automatic undo management
2760836 PMON cleanup of dead shared servers/dispatchers can crash instance (OERI:26599 / OERI:1115)
2761238 Primary may crash if log cannot be transported to standby
2780642 LMD may dump (in KJDDOPT / KJDDGMAK)
2783981 LGWR may CRASH if an exception occurs when killing the network server
2793038 Session may die with ORA-4031 if shared pool exhausted when storing object level statistics
2866612 Internal errors using JavaVM within shared server connections
2872299 OERI:2103 / instance crash can occur if foreground hits data/index internal error
2886505 Create database link may fail with ORA-32591
3042342 Create database link may fail with ORA-32591

Leak - Memory leak / Growth
2378009 PGA memory leak from APPLY servers when using LOBS
2441734 Win: Setting SQLNET.EXPIRE_TIME wastes stack memory
2523297 PGA JavaVM memory leak using many large objects
2544186 OCCI memory leak using toText() for number to string conversion
2562972 HS agent may leak memory with mixed character sets
2667235 High memory consumption parsing bitmap access with many OR predicates
2686584 PGA memory leak in PQ Query coordinator
2688989 Client memory leak calling SQLALD with size=0
2707096 Server memory leak on long running select over HS in PLSQL block
2707731 Memory leak (in EXTPROC) from CTX_DOC.IFILTER
2763219 Client memory leak using OCIStmtPrepare with TAF connection
2769514 Memory leak calling a TABLE() function / pipeline function in a loop
2786968 Shared pool memory leak / ORA-4031 on repeated invalidate/execute of cursors
2791857 Memory leak / ORA-4030 using Deflator class in Java stored procedure
2805249 SGA shrink may not release memory back to the O/S on Solaris
2810557 PRO client can leak memory when NLS_LOCAL=YES
2817728 Shared pool memory leak / ORA-4031 when collecting segment statistics
2821420 Client memory using CURSOR in JDBC with OCI driver
2823100 OracleConnectionCacheImpl over OCI driver leaks memory fetching Objects
2869329 Memory leak constructing XMLTypes from CLOBS or Strings
2875058 Repeat calls to JSP from PLSQL can leak PGA memory
2880427 Client side memory leak using OCIXMLType APIs
2883743 Pipelined functions leak memory for parameters with default values
2884131 Client memory leak when a REF CURSOR is selected but not used (no getXXX call)
2890022 Memory leak from XML queries within PLSQL
2901439 Memory leak using XDK for C in multithreaded application
2908182 XMLType.transform() leaks memory
2916024 PGA memory leak possible using OUTER JOIN with CONTAINS
2947010 PROCESSCOPY method does not release memory on completion
2958718 Memory leak if schema based document used on client side for printing / DOM operations
2972701 Memory growth executing SQL/XML repeatedly in PL/SQL
2980596 PLSQL FOR LOOP performance hit & memory leak using implicit cursors
3013905 JVM calls can cause PGA growth (in 4Mb chunks)

Leak - Resources eg: File handles
2095311 ORA-1000 / cursor leak doing getXML() with a CURSOR() expression and setSkipRows()
2479112 Oracle OLEDB transaction abort leaks cursors
2747582 TEMPORARY LOB LEAK on PLSQL <collection>.DELETE or assignment
2754938 SQLPLUS leaks TEMP LOBS if SELECTing >1 LOB
2847512 Temp LOB leak in DBURITYPE.GETBLOB()
2848826 JDBC OCI file handle leak on failed login
2859225 XDB file handle leak possible opening LPXUS.MSB
2866576 JDBC OCI file handle leak on failed Connection attempts
2871030 JMS leaks a cursor for each AQOracleQueueTable
2994706 CRAWLER filtering may leak file descriptors

Memory Corruption
2208113 Dump / memory corruption possible using USER FILTER for 10K document
2662683 Heap corruption from schema name overwriting memory in PLSQL
2789595 PGA memory corruption from INDEX SKIP SCAN
2867563 OERI:KSMFRFG2 / memory corruption selecting from an EXTERNAL TABLE

Performance affected (General)
2186174 Excessive REDO generation from parallel rollback
2379350 Unnecessary delays waiting on 'log file sync' (wait for timeout)
2726042 STATSPACK report omits segments created after the BEGIN snapshot

Performance of Query/ies affected
2336663 Slow Parallel execution - Nested Loops with partitioned right table
2496699 Poor performance selecting from OBJECT TABLE with REFS
2670946 Performance of queries using DBA_SEGMENTS may be poor
2671550 JMS getQueue() and getTopic() are slow with many queues in the DB
2691172 Incorrect cost computations for MERGE statements
2721432 UTL_HTTP has poor performance in 9i
2735033 OLS READ_CONTROL degrades SNAPSHOT REFRESH performance
2740281 Transitive predicate not generated for RPAD()
2747605 Poor "Enqueue" performance of non-persistent queue
2754410 Multi-row insert SLOW with multiple FK constraints
2786506 DBA_LOGSTDBY_PROGRESS view is slow
2787239 Suboptimal plan possible from TABLE / VIEW join with nullable table column
2790432 Bad plan as INDEX SKIP SCAN cost LOWER than INDEX RANGE SCAN
2860984 Bad plan possible with collection iterator (table/Cast)
2871645 Complex view merging does not occur for recursive SQL > depth 1
2910437 Inefficient plans on rewrite of SQL with GROUPING SETS and CASE expressions
2923299 CBO may reject index access for remote non-Oracle table

Security or Service denial vulnerability
2716764* Extproc overflow vulnerability
This bug is alerted in Note 244523.1
3058991* Buffer Overflow vulnerabilities in the XML Database
This bug is alerted in Note 246202.1

Shared Pool affected
2748963+ USE_STORED_OUTLINE may not share SQL / PLSQL anonymous blocks
2760217 Cursors not shared when CREATE_STORED_OUTLINES set to a category
2786968 Shared pool memory leak / ORA-4031 on repeated invalidate/execute of cursors
2798851 ORA-4031 possible rfom SMON during SHUTDOWN or STARTUP
2805335 Excessive shared pool memory use for parse of certain statments using functional indexes
2817728 Shared pool memory leak / ORA-4031 when collecting segment statistics
2953931 ORA-4031 parsing query with numerous groupings

Storage Space Usage Affected
2869489 DBMS_STATS.GATHER_TABLE_STATS does not free TEMP extents
2893261 Index cluster space may grow unexpectedly as free space not used
2919655 LOBs may not reuse space with automatic undo management

Wrong Results
2723141+ Wrong results from NOT EXIST with subquery which has constant FALSE predicate
2726305P AIX: Incorrect DATE conversion with PLSQL when DCE is installed
1934372 SOUNDEX / FUZZY text queries give wrong results on EBCDIC platforms
1951123 No error when PLSQL copies multibyte CHAR into BIND which is too small
2186092 No data from TABLE (PLSQL function) if function returns large collection
2379769 Wrong results possible with composite BTREE BITMAP plan if there are trailing NULLS
2400243 Lengths retrieved for VARCHAR array fetch not always ZERO for NULLs
2404927 ORA-1858 / wrong results from PREDICATE_MOVE_AROUND
2414581 V$SQL_PLAN may return an incomplete plan
2425679 Wrong results possible from select over DBLINK
2446423 Wrong results from buffered PREFETCH with AND-EQUAL
2516097 Wrong results from multiple aggregations on constant outer join view columns
2586586 Values after decimal place are shifted converting String to PACKED DECIMAL over HS
2610331 OCCI getString() can return invalid values for NUMBER columns
2630331 Wrong results with BASELETTER and ALTERNATE SPELLING used together
2635664 VPD policy groups may not respond to the driving application context
2651760 PLSQL LENGTH/LENGTH2/LENGTH4/LENGTHC sometimes count BYTES not CHARACTERS
2663465 Wrong results from CHECK CONSTRAINTS on OUTER JOINED table
2679062 Wrong results possible from multi-column INLIST
2681037 FOR UPDATE with non-mergeable view in IN-subquery can return duplicate rows
2683540 Wrong results from INDEX RANGE SCAN (MAX/MIN) with a join
2685869 Wrong results using PQO with OLS/VPD which uses application context
2687687 Wrong results from TEMP TABLE transformation if same DIMENSION tables joined to multiple FACT columns
2688053 Wrong results using GROUPING SETS
2690677 OERI / wrong results from STAR TRANSFORMATION with VIEW as FACT table
2700474 Wrong results from complex view merging of correlated subquery with GROUP BY
2712141 Wrong results from HASH join of view on remote query block
2726276 Wrong SCORE() for plans with Text index below a HASH JOIN
2726517 Unusual values in V$SGASTAT "miscellaneous" row
2727212 Wrong results from HASH join between CHAR column and VIEW column based on a BIND variable
2727446 Wrong results or ORA-904 from ANSI join between remote tables
2739068 Wrong results comparing CONSTANTS with SUBQUERIES using COUNT()
2747052 Wrong results from queries with bitmap index access with large OR-chains
2747643 Wrong results from MAX/MIN on IOT with GROUP BY
2753856 Wrong results possible from PQ partition query with GROUP BY
2757568 V$TRANSACTION may not show all active transactions
2758545 NLS_LENGTH_SEMANTICS is not supported in JDBC
2763009 Wrong results possible from QUERY REWRITE
2767303 Wrong results from TEMP TABLE STAR TRANSFORMATION
2773831 Wrong results possible from GROUPING SETS with OUTER JOIN
2778506 Wrong results from optimizer mode FIRST_ROWS_XX
2787377 Wrong results possible in RAC when MAX_COMMIT_PROPOGATION_DELAY=0
2789620 Wrong results when DISTINCT list contains a functional index expression
2793768 getString() on ROWID column gets wrong data on EBCDIC platforms
2803772 V$SESSION_WAIT.SECONDS_IN_WAIT resets each time SEQ# is incremented
2808431 Wrong results from PQ with OUTER JOIN
2816978 Wrong results using secondary index on IOT to fetch OVERFLOW columns
2818459 Text "FUZZY" query gets wrong results when using PREFIX INDEXING
2823907 Wrong results from STAR query with inlist predicate
2829723 Wrong results from ANSI OUTER JOIN when join condition does not reference both sides
2853688 Wrong results from Multi-column SORT/MERGE JOIN if Semi-join eliminated
2854146 Query with Sort-Merge-Join can produce wrong results
2859263 DBA_TEMP_FILES / X$KTFTHC can return wrong results
2861866 Wrong results from STAR transformation with WINDOW functions
2888719 Wrong results from colocated remote tables with OUTER join
2899532 SDO_NN_DISTANCE with two points and LAYER_GTYPE=POINT is different to DISTANCE
2903059 DBMS_XMLDOM.WRITETOCLOB/WRITETOBUFFER returns incorrect data
2907128 DELETE using an INDEX ONLY path may delete the wrong number of rows
2909084 RENAME of a VIEW with CHAR column can cause wrong results for subsequent SQL
2920925 Wrong results from queries with single OR predicate which is not null safe
2924041 No rows may be returned when VIEW column is defined on CAST / MULTISET
2963556 Wrong results from SQL using table lookup prefetch with >64k rows in child row source
2980405 SDO_UNION of two valid GEOMETRIES may give wrong results
3011800 Definition of ALL_SDO_INDEX_INFO is incorrect - can give wrong results

Error may occur
2757441* AQ problems Upgrading AQ / Applications DB from 8i to 9i
This bug is alerted in Note 231074.1
2746788+ Export does not error on DISK FULL conditions (IMP-9 on import)
2368369P Win: False ORA-3126 possible in OCI client on Windows using BEQ/IPC
2715935P Tru64: 'SWAP FULL' event test fails with NMS-1005
2747111P Tru64: RAC instance may crash with OERI:[SKGXPIODONE17] / DBWR dies with OERI:KCBZPB_1
2820871P Linux: Abrupt time adjustments can crash instance with ORA-29740
2861550P Linux: GSD may fail with PRKR-1064
2982601P Solaris: "libsecurity" errors followed by ORA-29702
809293 ORA-4071 during IMPORT of trigger with SPACES in definition
1266208 DML locking does not allow full partition independence - Unexpected ORA-54
1472845 ORA-1401 handling multiple items in one call to PGAXFER
1615764 ORA-22922 accessing TEMP LOB in a REF CURSOR returned from PLSQL
1758854 ORA-22922 accessing CLOB attribute of ADT in AnyData
1834732 JDBC thin fails with ORA-3115 while trying to fetch a UROWID
1841512 JDBC/THIN does not handle ORA-1403 correctly
1847587 ORA-2047 executing procedures against READ ONLY gateways
1853035 ORA-28528 / PGA-20936 instead of PGA-20938
1994858 False deadlock / undetected deadlock in XA
2088612 Incorrect ORA-1401 over PG4APPC
2095311 ORA-1000 / cursor leak doing getXML() with a CURSOR() expression and setSkipRows()
2117638 ORA-2063 / ORA-1445 possible from outer join over DB link with NULL sensitive predicates
2212991 ORA-932 from Explain plan of TABLE(CAST(:BIND AS ...) constructs
2217374 ORA-16132 on 'FORCE FAILOVER' after failed 'GRACEFUL FAILOVER'
2233987 ORA-1460 from 8i -> 9i SELECT when database uses AL32UTF8
2329274 ORA-12839 / spurious errors from heavily concurrent DDL with partitioning or PQO
2363698 ORA-1793 creating functional index on XML (or object) columns
2370438 Media recovery with concurrent V$ select may fail with ORA-1157
2387878 NAMESCTL may error after a 'STATUS' command (NNC-405 / TNS-12593)
2403965 ORA-1760 from DBMS_STATS gather stats against function based index on IOT
2404927 ORA-1858 / wrong results from PREDICATE_MOVE_AROUND
2421734 ORA-12518 connecting to 8i shared server through 9.2 listener
2433679 ORA-28511 possible with PG4APPC
2441859 XDK does not support DATETIME containing a timezone
2442346 ORA-2019 from REF cursor in invokers rights procedure
2449247 ORA-4080 from XDB commiting changes in a distributed transaction
2451999 ORA-2332 creating TEXT index on XDBURITYPE / URITYPE / HTTPURITYPE column
2452711 Graceful failover fails with ORA-16139
2474818 ORA-3117 pushing a transaction using TIMESTAMP(0) WITH LOCAL TIME ZONE
2479112 Oracle OLEDB transaction abort leaks cursors
2480339 ORA-32734 can occur sending long ORADEBUG commands to remote nodes
2501799 ORA-934 from Query Rewrite of GROUPING SETS
2511699 Silent data truncation inserting char literal into NVARCHAR2 column
2516513 ORA-60 from concurrent PDML on same table
2518508 ORA-6502 / ORA-1460 calling PLQSL function directly from SQL
2526424 PLS-215 from 9i->8i PLSQL reference to view with zero length character column/s
2529365 "VNI-4031: INVALID LISTENER NAME" registering net up/down event
2540242 ORA-31011 during SYS.XMLTYPE.TRANSFORM
2551000 False ORA-1410 / ORA-8103 possible from ANALYZE COMPUTE/ESTIMATE STATISTICS
2554178 CURRENT_SCHEMA signals ORA-1017 when the underlying object uses a DBLINK
2554861 ORA-60 in RMAN BACKUP during RESYNC (DBMS_RCVCAT.SANITYCHECK)
2556295 SDO_INTERSECTION fails with large GEOMETRIES (ORA-21779)
2558807 ORA-19026 CDATA invalid possible from extractValue
2559022 ORA-372 selecting from ASSM segment in READ ONLY tablespace / DB
2560740 XML Parser throws incorrect error on UTF8 database
2564599 Various errors using SDO_AGGR_UNION
2577016 ORA-938 from CASE expressions with NULL arguments
2579935 CREATE QUEUE fails (ORA-904) if user owns table called "ALL_RULES"
2588505 OERI:[QESMMCVALSTAT4] on DELETE with PGA_AGGREGATE_TARGET set
2588590 OERI[525] possible while growing the cursor hash table
2592075 ORA-29270 possible importing media from HTTP sources
2593570 TNS-12564 / TNS-12520 possible with CONNECTION LOAD BALANCING
2594726 JDBC Array insert > 65535 elements may product NULL rows / fail with ORA-6531
2595839 ORA-2070 can occur using SYS_CONTEXT in an RLS policy function
2597075 ORA-372 on direct load into PARTITION with an empty READ ONLY partition
2619013 OERI:KCBRLS_1 can occur in ktuServiceNTP under load
2621669 ORA-30036 possible in high concurrency with SMU
2631450 IMP-17 / ORA-6550 possible on exp/imp of large rule sets
2640192 JDBC may not work with TIMESTAMP data correctly if server version is 8i
2643723 ORA-1555 possible using AUTO space managed LOB segments
2646480 ORA-97 from DBMS_MVIEW.refresh if MVIEW name > 22 characters long
2647811 ORA-14401 possible from OR expansion with PDML
2652886 ORA-25402 can occur on ROLLBACK after failover
2664277 ORA-12157 possible over TCPS (SSL)
2666465 ORA-19653 possible during BACKUP CONTROLFILECOPY
2669565 ORA-24345 possible on COMPLETE REFRESH if character sets differ
2670550 ORA-4020 while refreshing a MATERIALIZED VIEW
2671151 ORA-7455 [EVAOPN2] querying PARTITIONED table with functional index
2672970 EXP-10 if username contains ".", ":" or "%"
2673096 XMLTYPE.CREATEXML rejects documents with XML namespace (LPX-233)
2678726 PLS-399 possible from SUM / AVG / STDDEV / VARIANCE
2681037 FOR UPDATE with non-mergeable view in IN-subquery can return duplicate rows
2685035 Select from DB2 table with >= 250 columns fails with ORA-28511 using TG4DRDA
2685696 ORA-1422 from Export in package XDB.DBMS_XDBUTIL_INT
2688197 ORA-1408 adding UNIQUE / PK CONSTRAINT with COMPRESSED KEY index
2691119 ORA-6510 possible using PGATRAC
2695242 ORA-22 OERI[18260] using MTS with shared DB links
2699203 ORA-24371 possible on execute/fetch after failover
2702410 ORA-8104 / ORA-8106 occur on ALTER MOVE / REBUILD ONLINE
2706685 ORA-932 from PUSH_JOIN_UNION_VIEW with bind variables an UNION ALL view
2707250 After propogation is dropped DBMS_STREAMS_ADM.REMOVE_RULE does not remove the rule
2708441 ORA-22275 using RETURNING CLAUSE for UPDATE of LOB
2711197 DBMS_METADATA returns wrong DDL for INDEX on LIST PARTITIONED table
2714596 DBMS_STATS may fail with ORA-6533 on ANALYZE of partitioned table
2715794 Intermittent ORA-19575 from RMAN doing BACKUP during file RESIZE
2717694 FROM-clause subqueries using ANSI OUTER JOIN can fail with ORA-1792
2719863 RMAN may fail with ORA-1422 doing RESYNC CATALOG
2721063 DBMS_LOGSTDBY.SKIP_TRANSACTION fails with OERI:KNAHSPX11 / ORA-1403
2724548 ORA-1172 stuck recovery possible
2727120 OERI:[13009] possible from SELECT FOR UPDATE of a LONG
2727446 Wrong results or ORA-904 from ANSI join between remote tables
2727522 DG loader can fail with ODG-5113
2728408 False ORA-8177 possible SELECTING data with SERIALIZABLE
2731243 False ORA-979 from scoped REFS in GROUP BY / ORDER BY
2737581 interMedia install fails creating OrdSourceSvr
2740454 Export of statistics may write bad details to the .DMP file
2743995 QSM-502 / ORA-1426 from summary advisor
2744066 Heavy load can lead to ORA-29740 in RAC
2744236 ORA-29957 creating a locally partitioned TEXT index on XMLType
2744635 Multi-consumer DROP_QUEUE_TABLE fails if datafile inaccessible / DROP TABLESPACE fails with ORA-24008
2744760 Unexpected ORA-604/ORA-904 possible using GROUPING SETS clause
2746688 ORA-4020 possible from DDL or TRUNCATE in PLSQL
2748160 PLS-306 possible from logical standby
2750878 IMPORT does not work for Schema based XMLTable in multibyte
2751460 ORA-3106 when 8i client selects from 9.2 AL32UTF8 database
2755063 Database may cause TNS-1181 in the listener
2756637 ORA-911 / ORA-936 inserting into OLS protected table
2757099 ORA-1403 when Dataguard Manager tries to create a Logical Standby
2757906 Block or crash recovery redo causes ORA-1403 in STREAMS/LOGICAL STANDBY APPLY
2762475 DIRECT PATH LOAD not replicated by streams / logical standby apply
2763009 Wrong results possible from QUERY REWRITE
2763115 MRP0 may get ORA-365 after graceful switchover with seconday standby
2763235 IMG-860 possible on generate signature
2764565 ORA-21500 [17112] possible after failover
2766270 ORA-1001 possible after failover
2767356 PLS-382 from client PLSQL referencing TIMESTAMP in higher DB version
2774988 ORA-1457 selecing NUMBER with SCALE/PRECISION over gateway
2775021 DRG-10528 occurs text indexing a table with a RAW primary key
2777612 ORA-22922 getting length of temporary LOB on client
2777812 NMS-312/NMS-1005 registering "Buffer Cache Hit %" / "In Memory Sort %" in RAC
2782196 ORA-3106 / OERI:729 after CTRL-C of INSERT..SELECT via a DBLINK
2782919 ORA-904 from DBMS_STATS to estimate statistics for a table with a functional index
2783153 %ROWTYPE including UROWID column may dump / ORA-6544 [PFRRUN.C:BREAK]
2783519 JDBC XA throws ORA-24762 instead of ORA-24756
2783899 PIPE ROW inside CURSOR FOR LOOP gives PLS-707 (in old SQL FE only)
2784688 False ORA-2051 on concurrent xa_end / xa_prepare of tightly coupled transaction branches
2786968 Shared pool memory leak / ORA-4031 on repeated invalidate/execute of cursors
2788481 ORA-1537 in STANDBY with STANDBY_FILE_MANAGEMENT=AUTO
2791857 Memory leak / ORA-4030 using Deflator class in Java stored procedure
2792142 ORA-6502 possible from PLSQL with RAW/LONG/CHAR binds
2793038 Session may die with ORA-4031 if shared pool exhausted when storing object level statistics
2793750 ORA-31011 / ORA-19202 / server dump from JDBC setObject(XMLType)
2798239 Block corruption possible on rollback of segment merge
2798851 ORA-4031 possible rfom SMON during SHUTDOWN or STARTUP
2800779 OERI:[kolaHashFind:hash table] / ORA-21500 from OCILobLocatorAssign
2801315 Fast refresh gets ORA-1401 with pre-9i Master with differing national character set
2801371 IMP-58 / ORA-19007 importing XMLType table with XML schema
2802515 ORA-31496 on DROP USER CASCADE on CDC publisher
2804724 Out of memory in JAVA POOL shows an ORA-4031 "shared pool" message
2805335 Excessive shared pool memory use for parse of certain statments using functional indexes
2805491 JMS-120 / PLS-306 using older JMS client (AQAPI.JAR) to 9.2 server
2805798 APPLY process aborts with ORA-1426 during "no progress" checking
2806236 Inefficient plan possible with TEXT query against PARTITIONED table
2810543 Create MVIEW may ORA-12054 in JA16SJIS if tablename contains '@' byte in a character
2816677 ORA-30391 from UpdateXML to replace node on schema based document
2817728 Shared pool memory leak / ORA-4031 when collecting segment statistics
2821096 OERI[711] / ORA-13276 for valid SDO polygon
2830288 DROP_PROPAGATION fails with ORA-24010 if QUEUES already dropped
2831947 ORA-31160 registering schema document with > 1000 subst elements
2832116 ORA-1422 possible from ADD_MASTER_DATABASE if database has transported or numerous datafiles
2832147 ORA-31099 can occur parsing large XML document
2841983 ORA-1089 on TAF connection after SHUTDOWN IMMEDIATE
2842368 MRP may fail with ORA-365 on secondary standby after graceful switchover
2844585 Intermittent ORA-23474 on replication objects
2854856 ORA-911 can occur importing a trigger in a mixed case SCHEMA name
2857178 ORA-1000 from multi-threaded JMS client doing object enqueue/dequeue
2862067 ORA-29913 from ZONED DATA TYPE in EXTERNAL TABLE
2862818 Bad export of NESTED table in LOCALLY managed tablespace - ORA-25150 / ORA-942 on import
2864094 ORA-60 in SQL apply with multiple apply servers with rollback operations
2866419 ORA-1461 from SQL over DB link between different character sets
2871030 JMS leaks a cursor for each AQOracleQueueTable
2875360 CRAWLER ROBOT EXCLUSION does not work
2876379 False ORA-24347 from INSERT over DB LINK between releases
2878338 INSERT into HASH PARTITION may fail with false ORA-2291
2879970 ORA-16040 occurs with > 2 cross-instance archival destinations
2881958 ORA-19012 using XMLType.TOOBJECT()
2882923 ORA-1031 importing Queue table
2883734 Many OERI:15212 if exception occurs when loading a child cursor
2884286 CREATE SPATIAL INDEX fails with ORA-13249: [MDIDXRBD]
2884797 TEMP table star transformation with INDEX JOIN can fail with ORA-1733
2886505 Create database link may fail with ORA-32591
2887504 ORA-2348 on CREATE TABLE with XMLType and VARRAY with CLOBs
2890818 ORA-31154 validating a valid XML document against SCHEMA
2892787 MDSYS.SDO_TUNE.EXTENT_OF fails with ORA-13364
2894277 OERI[17200] accessing 9i -> 8i remote object with BFILE column from PLSQL
2899221 ORA-338 - standby redo log corruption
2900891 8i Export from 9.2 DB fails with EXP-8 ORA-904
2901331 ORA-1785 from PQ ORDER BY <CONSTANT> which is not in select list
2905667 Instance terminated by CKPT due to ORA-1110 during shutdown in RAC
2910579 Invalid ORA-30937 on UpdateXML
2914264 SQL-2116 from 64bit ProCobol application
2918098 ORA-29353 from transportable tablespace export with numerous tablespaces
2918820 ORA-911 can occur on SELECT using OUTLINES
2919457 Create Unique index can cause ORA-1403 during apply of DML
2919570 ORA-1403 during apply after ADD or DROP COLUMN
2919655 LOBs may not reuse space with automatic undo management
2929778 OERI[QKSWCCRW:1] possible
2934427 ORA-12805 on long running PQ when IDLE TIME set
2936628 Improve error reporting for ORA-13249 errors
2939959 Queries on XDB on 64 bit platforms may fail with an ORA-904 error.
2942624 Data loss possible at APPLY
2950715 XML-116 entity already defined possible
2952255 Unexpected ORA-1445 during unnest of a subquery with ROWID column
2953931 ORA-4031 parsing query with numerous groupings
2961849 XSQL-018 NullPointerException starting STYLESHEET pool under load
2974471 ORA-603 / OERI[17271] on instance startup with SQL_TRACE=TRUE and CURSOR_SPACE_FOR_TIME=TRUE
2976372 Creating a PLSQL object intermittently fails with ORA-4021 in RAC
2976763 Failed DROP MVIEW can leave corrupt dictionary data - subsequent ORA-30382
3018475 Gateway may fail with ORA-28500 accessing tables with large number of rows
3042342 Create database link may fail with ORA-32591

Internal Error may occur (ORA-600)
2420930P Linux: OERI[KSXPMPRP1] during startup in RAC mode with >10GB of buffers
2747111P Tru64: RAC instance may crash with OERI:[SKGXPIODONE17] / DBWR dies with OERI:KCBZPB_1
2220413 ORA-600 [qmtcolcb_nomatch] possible in XDB
2280512 OERI:KOKVXSQL1 OERI:4814 on CREATE OR REPLACE of package with PIPELINED function
2329767 OERI:106 setting diagnostic EVENT against PMONs session
2392885 Direct path load may fail with OERI:kcbgcur_9 / OERI:ktfduedel2
2419335 OERI:[qks3tInit] possible from STAR transformation
2444568 Instance CRASH with OERI[2886] if ALTER .. READ ONLY dumps
2475002 OERI:kxwphTTGet1 deleting from transactional TEMP table from PLSQL AUTONOMOUS transaction
2478181 OERI:[KPOSCWR2] / OERI:[KPOSCF10] using OCIStmtFetch2 on big-endian platforms
2520911 OERI[QKAPIDSQKN1] from partition wise join with NL join
2523462 OERI[KNALSEMTE-2] possible instantiating a new DB or table in STREAMS
2529847 OERI [KCBVMAP] possible with VLM enabled
2547402 OERI[KDIC_CREATE_JOURNAL_TABLE_1] from REBUILD index ONLINE of TIMESTAMP key column
2559269 OERI[KOHDTF048] / memory growth from large INSERT as SELECT with spatial data
2576404 OERI[723] in RFS from logical standby database switchover
2588505 OERI:[QESMMCVALSTAT4] on DELETE with PGA_AGGREGATE_TARGET set
2588590 OERI[525] possible while growing the cursor hash table
2614728 OERI[KOLSLNK509] possible with very large PLSQL VARRAY index
2619013 OERI:KCBRLS_1 can occur in ktuServiceNTP under load
2621133 OERI:kjbconsign:wip2 after block recovery during instance recovery
2621310 OERI:504 possible selecting from shared pool fixed tables in MTS
2627306 OERI:[evapth : unexpected evaluation] using SYS_CONNECT_BY_PATH()
2628232 ORA-600's from CR served block from a plugged in tablespace
2662683 Heap corruption from schema name overwriting memory in PLSQL
2665478 OERI[RWORUPO.1] from INSERT .. SELECT over DBLINK with ADT column
2669199 OERI:711 from SQL on PARTITIONED table with SUBQUERY pruning
2677954 OERI:KJUHL1 can occur when MAX_COMMIT_PROPOGATION_DELAY <= 700
2688545 ORA-600 [QERNSROWP] from NOSORT with CHECK constraint/s
2695242 ORA-22 OERI[18260] using MTS with shared DB links
2697589 OERI:[kdiblbout:rowidIllegal] on INSERT into IOT with BITMAP indexes
2712584 OERI:QMXP_BADARRAYTYPE from XDB operations with enumerations on > 255 elements
2716265 OERI[16608] can occur on SELECT using STAR transformation with RLS
2718937 OERI:6033 from SELECT on IOT with COMPRESSED PRIMARY KEY
2721063 DBMS_LOGSTDBY.SKIP_TRANSACTION fails with OERI:KNAHSPX11 / ORA-1403
2721812 OERI:KCCCHB_3 / stale value block possible
2722809 OERI:kcbgcur_9 on direct load into AUTO space managed segment
2725925 ORADEBUG "HANGANALYZE -G DEF" fails with OERI[KSDXREQ_0]
2726398 OERI:kokegPinLob1 from VIEW with EXPRESSION on a CLOB column
2726601 OERI[4406] possible in SMON using automatic undo management
2727120 OERI:[13009] possible from SELECT FOR UPDATE of a LONG
2733904 ORA-600[KTSPNEXTL1:4] after interrupted TRUNCATE with automatic space management
2742518 Accessing X$GLOBALCONTEXT may fail with OERI:525 / hangs the DB
2745940 Fix for BUG 2622690 missing from Oracle 9.2
2746855 OERI:EXPCMO_STRDEF1 from PUSH JOIN PREDICATE
2747978 OERI[KCBNEW_3] after resize of locally managed tablespace
2749361 Create DOMAIN INDEX fails on SUBTYPED OBJECT
2758770 OERI:504 from Dispatcher/s when using TCP DB LINKS
2759173 OERI[KJBCLRSUSPECT:!SUS] possible as reconfiguration
2760836 PMON cleanup of dead shared servers/dispatchers can crash instance (OERI:26599 / OERI:1115)
2762306 OERI:KCLFBAST_1 / OERI:KJMSM_EPC possible in RAC
2762817 OERI:[17092] [10388] possible when interrupting (Ctrl-C) a Parallel Query
2763032 OERI:[KPOSCWS0] possible from OCIStmtFetch2()
2767486 ORA-600[PMUOCON2#1: INVALID CDS] when returning NULL ADT/collection through a JAVA callout
2767505 OERI[KDISLE:NROWS] possible on DELETE from table with BITMAP index
2768278 OERI[KCBNEW_3] possible after DROP of 8i segment in locally managed tablespace
2768310 OERI[KJBRRCLAIM:DS] after cluster reconfiguration
2770025 OERI[KWQPFDPSE:QNAME] on SHUTDOWN of STREAMS database
2774331 OERI:[KCCWNC_RECTYPE][23] can occur during database open
2782196 ORA-3106 / OERI:729 after CTRL-C of INSERT..SELECT via a DBLINK
2787622 OERI[6034] on ALTER INDEX REBUILD SUBPARTITION
2787823 LOGICAL STANDBY APPLY may fail with OERI:15714
2796802 OERI[QKAJOI:1] from SQL using WITH clause with query rewrite
2796951 OERI:[KCBBINIT_5] on STARTUP with DBWR_IO_SLAVES on NUMA
2799826 OERI:549 possible
2800779 OERI:[kolaHashFind:hash table] / ORA-21500 from OCILobLocatorAssign
2801367 Diagnostic fix to dump more information on OERI:[skgxprrgn2]
2803588 OERI[20083] using DBMS_STATS.GATHER_TABLE_STATS on table with bitmapped functional index
2807799 OERI:[KJBRCHKINTEG:W] can occur when STALE conver is processed
2808374 OERI:[qmxarElemAt2] on insert of schema based XMLType
2808665 ORA-600[KKFI.QBCVFR] from predicate move around
2821096 OERI[711] / ORA-13276 for valid SDO polygon
2823031 OERI[KLAPRS_30] possible from direct load if there are data conversion errors
2828026 Interrupted sessions may fail with ORA-600[1158] / DB can hang
2834337 ORA-600 [KNGOLCPY] in CAPTURE process with external LOBS
2836690 ROLLUP over DBLINK may fail with OERI:qks3tinit
2839099 OERI:[QKSOPOPTASJLF1] during parse of ANTI/SEMI join with NVL/DECODE in correlation predicate
2840233 OERI[510] .. [SHARED POOL] can occur / latch related DB hang possible
2840439 Resource manager can fail with ORA-600 [KGSKTHREXIT2]
2843570 OERI:2103 possible on PRIMARY if secondary errors
2843749 OERI[12455][PTI QKAQKN] during SELECT FOR UPDATE on PARTITIONED table
2856711 OERI[KDDIOTDCA] during ALTER TABLE DROP COLUMN on IOT with MAPPING table
2866612 Internal errors using JavaVM within shared server connections
2867563 OERI:KSMFRFG2 / memory corruption selecting from an EXTERNAL TABLE
2869421 ORA-600 [12869] on COMPLETE REFRESH of SNAPSHOT on PREBUILT table
2871237 OERI:KOKSCCD1 can occur CREATING a MATERIALIZED VIEW with object column
2872299 OERI:2103 / instance crash can occur if foreground hits data/index internal error
2873045 OERI:[KCLCHKBLK_2] possible in RAC
2879257 OERI[16609] selecting from PARTITIONED table with CONSTRAINTS
2881035 OERI:17158 possible selecting from V$LOGMNR_CONTENTS
2881164 OER:19491 / OERI:KOCTXIN700 / OERI:19490 upgrading pre 9i to 9i/later
2881337 OERI:17011 on ALTER TABLE RENAME with user defined type column
2882140 OERI:knacdc2 in LSP0 during PDML rollback
2882279 OERI[KTSSPAD_SEGMENT1] during ALTER IOT MOVE ONLINE OVERFLOW
2883634 OERI[2006] during UPDATE with SUPPLEMENTAL LOGGING and trailing nulls
2883643 OERI[KPOTCPRC: UGA DEPTH EXCEEDED] from XML queries
2883659 SELECT with TABLE FUNCTION from Oracle8.0 client fails with OERI [KOKEEAFI1]
2883734 Many OERI:15212 if exception occurs when loading a child cursor
2884469 OERI[729] possible using literal replacement
2886292 RFS at logical standby may fail with OERI[KCRRULFH.12.2]
2894277 OERI[17200] accessing 9i -> 8i remote object with BFILE column from PLSQL
2897119 JDBC OCI heap error 17112 with setNativeXA(TRUE)
2901457 OERI:ktcdso-1 from XA read only branch with commit time callback
2905850 OERI[qkaRmtView20] possible from SELECT over DBLINK with local PLSQL function
2908135 OERI:[QMXIWRITEXOBINT21] / Dump using incompatible SQLTypes in substitution groups
2909160 OERI[6122] / index corruption for DML against AUTO space managed indexes
2912596 OERI:[KNLLXANYTS2XML:2] using TIMESTAMPs with Streams
2923463 OERI:qmxiCreateR1 if schema / document has out-of-line & substitutable elements
2929778 OERI[QKSWCCRW:1] possible
2950375 OERI[2103] in RAC if LMD0 is producing a dump
2954560 OERI:KCBRLS_1 can occur in kteuPropagateTime() using SMU
2967417 OERI:KCOAPL_BLKCHECK may occur using Auto managed segment
2974471 ORA-603 / OERI[17271] on instance startup with SQL_TRACE=TRUE and CURSOR_SPACE_FOR_TIME=TRUE
2984331 Streams capture cannot startup on RAC after failover
2990546 OERI:KCLFUSFAKE_4 possible in LMS process

Process may Dump / Abend / Abort
Bug 2358062*P HPUX: ORA-7445 Signalled from Different Functions on 64-bit HP-UX
This bug is alerted in Note 241160.1
2687315+ Parallel range scan of DESC index may dump (under QERPXSTART/QERPX_START/EVAOPN2)
2845571P Tru64: ORA-7445 error message does not include failing function name
2217233 ORA-7445 [kdtiGetRow] on buffered INSERT of NULL key into an IOT
2300229 Dump (in KQSADJP) using query rewrite
2386460 ORA-7445 calling SYS.STANDARD functions directly from SQL
2420679 Multithreaded client may dump due to non thread safe functions in LIBCLNTST9
2471756 Dump inserting NULL into NOT NULL IOT column with CURSOR_SPACE_FOR_TIME=TRUE
2474232 Dump in kksmal0 selecting object and rowid data
2523131 Dump parsing XML <?PI ... > element
2579935 CREATE QUEUE fails (ORA-904) if user owns table called "ALL_RULES"
2588285 ALTER TABLE MOVE of table containing REFs may dump
2624852 ORA-7445 [ksfd_odmbio] possible on IO error with ODM
2643579 ORA-7445 [kxspoac] using CURSOR_SHARING=FORCE (or similar)
2646966 OIDLDAPD may dump (in gslfcfRLoadVerifierProfiles) during LDAPMODIFY
2649238 Resource manager may dump (in kmmpis)
2656634 Dump (qerpxStart) from temp table transformation with HAVING clause
2660095 ORA-7445[kkpamDInfo] possible from query on partitioned table
2662683 Heap corruption from schema name overwriting memory in PLSQL
2670659 DBMS_XMLDOM.CLONE may dump in QMXCLONEXOB
2671151 ORA-7455 [EVAOPN2] querying PARTITIONED table with functional index
2673203 Dump (kpudsaattrg) from OCIParamGet after describe or procedure with zero parameters
2689051 ORA-7445 [gxqnUnknownTokens] using CONTAINS and ABOUT together
2705892 ORA-7445[qesaPackCols] using functional bitmap indexes
2710266 ORA-7445 [KKXMIXCX] with EXTERNAL TABLE in a subquery
2713652 Dump (under kghrsc) possible from SELECT from V$SHARED_POOL_RESERVED
2721462 ORA-7445 [KOPXCCC] from PLSQL RPC over DB LINK
2722510 ORA-7445 on DEQUEUE after database upgrade from 8i
2737882 CATSEARCH template query with NEAR and PHRASE dumps
2739444 ORA-7445 [qximirew] from SPATIAL query on PARTITIONED table
2754014 LDAPADDMT may dump if the LDIF file contains an error
2754203 SDO_INTERSECTION may dump in mdgopmf()
2755889 ORA-7445[KWREVAS1] dropping LOGADMIN user with STREAMS
2758168 ORA-7445 [KOKEIS] on REFRESH of remote MVIEW with VARRAY and TRIGGER
2763473 Dump (in kcopre / kdddcp) on UPDATE of row in PARTITIONED table with ROW MOVEMENT
2773781 Dump in vopscv with STAR transformation
2774862 Dump (under ktspfpblk) can occur when writing to a LOB
2780642 LMD may dump (in KJDDOPT / KJDDGMAK)
2783569 ROW_CACHE diagnostic output may dump (in ksdfmw)
2786391 Diagnostic ERRORSTACK may dump (in kghalf)
2791172 Select from V$SQL_PLAN may dump (in msqopnws)
2791967 ORA-7445 [EVAFSTLST] possible using DENSE_RANK with FIRST/LAST function
2804951 Exchange PARTITION on table with XMLType and TEXT index dumps
2805382 Dump (kodpsloc) passing OBJECT with LOB to PLSQL
2808055 ORA-7445 [zfmamatch] possible using Text SOUNDEX operator (!)
2809828 Dump (in krvuprlcr) from AGE-UNSPILL
2815379 ORA-7445 [LXYVALID] can occur creating TEXT index on a UTF8 document
2818699 NLS code may try to read memory past the end of a string (dump)
2835542 REBUILD INDEX PARTITION ONLINE sometimes dumps in KDICRWS
2843541 FULL JOIN with set operator may dump (eg: UNION)
2852652 ORA-7445[dredrseek] with many ACCUM functions in text query
2866612 Internal errors using JavaVM within shared server connections
2882484 DROP evaluation context FORCE does not invalidate dependents - dumps / OERI possible
2886182 ORA-7445[JOE_FINALIZE_SOME_OBJECTS] possible in Java VM
2888413 DBMS_XMLDOM.FREEDOCUMENT may dump
2892870 SQL using PLSQL functions may dump
2898021 Net Trace calls in client interrupt handler not async signal safe
2901586 LOGMINER / Streams apply of CTAS with > 122 columns dumps
2908135 OERI:[QMXIWRITEXOBINT21] / Dump using incompatible SQLTypes in substitution groups
2908284 Dump in EVAOPN2 using DESCENDING functional index
2913866 ORA-7445 [KWQAPAQN] when EVENT 10862 is set
2930188 Dump possible using Star transformation with index joins
2930301 SQL may dump in ktadmct
2938564 Dump under mdgopmf on SDO_DIFFERENCE query
2939697 ORA-7445 [qerwnWriteToDisk] using duplicate analytic window functions
2940270 Dump under LpxPrefixToURI possible
2951740 Dump possible with fix for bug 2667235
2970738 ORA-7445 [STRCMP] under LsxFindSchemaByName registering a schema
3001947 Capture dumps transforming out of line LOB



Task Related


Instance startup
2420930P Linux: OERI[KSXPMPRP1] during startup in RAC mode with >10GB of buffers
2774331 OERI:[KCCWNC_RECTYPE][23] can occur during database open
2796951 OERI:[KCBBINIT_5] on STARTUP with DBWR_IO_SLAVES on NUMA
2798851 ORA-4031 possible rfom SMON during SHUTDOWN or STARTUP
2825306 Instances may not start when configured nodes missing from cluster
2974471 ORA-603 / OERI[17271] on instance startup with SQL_TRACE=TRUE and CURSOR_SPACE_FOR_TIME=TRUE
2999004 OLS policy admin should not be allowed in database startup session

Migration / Upgrade / Downgrade
2757441* AQ problems Upgrading AQ / Applications DB from 8i to 9i
This bug is alerted in Note 231074.1
2449740 REGISTRY$ not updated properly upgrading OLS to 9.2
2722510 ORA-7445 on DEQUEUE after database upgrade from 8i
2759147 "Warning:Type altered with compilation errors" on interMedia upgrade
2798855 AQ rules views may become INVALID after upgrade to 9.2
2881018 EXP/IMP of Queues after DB upgrade to 9.2 fails
2881164 OER:19491 / OERI:KOCTXIN700 / OERI:19490 upgrading pre 9i to 9i/later
2949941 Rules engine objects may become invalid after upgrade

Performance Monitoring
2843192+ Change to "NULL EVENT" in V$SESSION_WAIT
2803772 V$SESSION_WAIT.SECONDS_IN_WAIT resets each time SEQ# is incremented
2988097 "buffer busy waits" segment statistics overestimates buffer busy waits

Recovery
2370438 Media recovery with concurrent V$ select may fail with ORA-1157
2504480 Archive trace file generated for every log switch
2724548 ORA-1172 stuck recovery possible
2879970 ORA-16040 occurs with > 2 cross-instance archival destinations



SQL commands / features used


ANSI Joins
2717694 FROM-clause subqueries using ANSI OUTER JOIN can fail with ORA-1792
2829723 Wrong results from ANSI OUTER JOIN when join condition does not reference both sides
2843541 FULL JOIN with set operator may dump (eg: UNION)

Analytic SQL (Windowing etc..)
2688053 Wrong results using GROUPING SETS
2744760 Unexpected ORA-604/ORA-904 possible using GROUPING SETS clause
2773831 Wrong results possible from GROUPING SETS with OUTER JOIN
2791967 ORA-7445 [EVAFSTLST] possible using DENSE_RANK with FIRST/LAST function
2836690 ROLLUP over DBLINK may fail with OERI:qks3tinit
2861866 Wrong results from STAR transformation with WINDOW functions
2910437 Inefficient plans on rewrite of SQL with GROUPING SETS and CASE expressions
2928676 CREATE MVIEW using LAG with PARTITION clause may spin in JA16SJIS
2939697 ORA-7445 [qerwnWriteToDisk] using duplicate analytic window functions
2953931 ORA-4031 parsing query with numerous groupings

Application Context
2595839 ORA-2070 can occur using SYS_CONTEXT in an RLS policy function
2635664 VPD policy groups may not respond to the driving application context
2685869 Wrong results using PQO with OLS/VPD which uses application context
2882484 DROP evaluation context FORCE does not invalidate dependents - dumps / OERI possible

Constraint Related
1874320 Constraints needlessly revalidated during import of transported tablespace metadata
2594803 EXCHANGE PARTITION with Unique constraints can be slow
2663465 Wrong results from CHECK CONSTRAINTS on OUTER JOINED table
2688197 ORA-1408 adding UNIQUE / PK CONSTRAINT with COMPRESSED KEY index
2688545 ORA-600 [QERNSROWP] from NOSORT with CHECK constraint/s
2750401 DEFERRABLE UNIQUE CONSTRAINTS can cause LOGICAL STANDBY apply errors
2754410 Multi-row insert SLOW with multiple FK constraints
2873855 "SET CONSTRAINTS ALL IMMEDIATE" may incorrectly signal violations
2878338 INSERT into HASH PARTITION may fail with false ORA-2291
2879257 OERI[16609] selecting from PARTITIONED table with CONSTRAINTS

Datatypes - AnyData
1758854 ORA-22922 accessing CLOB attribute of ADT in AnyData

Datatypes - LOBs (CLOB/BLOB/BFILE)
1380218 getMetaData().getColumns() does not describe BLOB/CLOB/TIMESTAMP columns
1615764 ORA-22922 accessing TEMP LOB in a REF CURSOR returned from PLSQL
2329001 ArrayOutOfBoundsException reading BLOB with JDBC Thin
2643723 ORA-1555 possible using AUTO space managed LOB segments
2708441 ORA-22275 using RETURNING CLAUSE for UPDATE of LOB
2726398 OERI:kokegPinLob1 from VIEW with EXPRESSION on a CLOB column
2741185 Fast refresh of MV on remote LOB columns may hang
2747582 TEMPORARY LOB LEAK on PLSQL <collection>.DELETE or assignment