Doc ID: Note:245758.1
Subject: 9.2.0.4 Patch Set - List of Bug Fixes by Problem Type
Type: README
Status: PUBLISHED
Content Type: TEXT/X-HTML
Creation Date: 08-AUG-2003
Last Revision Date: 11-AUG-2005

Bugs fixed in the 9.2.0.4 Patch Set

  • See Note 189908.1 for Support Status and Alerts affecting 9.2.0 releases.
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.
  • '*' against a bug indicates that an alert exists for that issue.
  • '+' indicates a particularly notable bug.
  • 'P' indicates a port specific bug.@>
  • '@' indicates UNPUBLISHED information X>
  • "OERI:nnnnn is used as shorthand for ORA-600 [nnnnn].

Notable exceptions and omissions

  • OLAP fixes are not included in this listing
  • Some port specific issues may not be listed
  • This is a new format of fix listing so some of the links may not work. We hope to correct any problems shortly.

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