Doc ID: Note:245939.1
Subject: 9.2.0.3 Patch Set - List of Bug Fixes by Problem Type
Type: README
Status: PUBLISHED
Content Type: TEXT/X-HTML
Creation Date: 12-AUG-2003
Last Revision Date: 29-AUG-2003

Bugs fixed in the 9.2.0.3 Patch Set

  • See Note 189908.1 for Support Status and Alerts affecting 9.2.0 releases.
  • This Patch Set has been superceeded by the 9.2.0.4 Patch Set
This note lists the bugs fixed in the 9.2.0.3 Patch Set over and above those fixed in 9.2.0.2. The 9.2.0.3 Patch Set itself is cumulative and includes all fixes in 9.2.0.2 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

  • The port specific fixes in this listing are incomplete.
  • OLAP fixes are not shown in this list.

Security Alert Issues fixed in the 9.2.0.3 Patch Set

Fixed Bug# Security Alert# Document Summary
9.2.0.3 2642168 / 2749511 Sec. Alert#54 Note 237172.1 Buffer overflow vulnerability with CREATE DATABASE LINK
9.2.0.3 2620726 Sec. Alert#51 Note 229287.1 Buffer overflow in Oracle server
9.2.0.3 2642439 Sec. Alert#50 Note 229286.1 TO_TIMESTAMP_TZ overflow vulnerability
9.2.0.3 2642267 Sec. Alert#49 Note 229285.1 TZ_OFFSET overflow vulnerability
9.2.0.3 2642117 Sec. Alert#48 Note 229284.1 Overflow vulnerability in DIRECTORY parameter of BFILENAME
9.2.0.3 2581911 Sec. Alert#46 Note 216775.1 iSqlplus buffer overflow vulnerability
9.2.0.3 2540219 Sec. Alert#42 Note 213411.1 Listener denial of service vulnerability
9.2.0.3 2642203 Sec. Alert#29 Note 175429.1 EXTPROC buffer overflow possible on LONG LIBRARY NAME
9.2.0.3 2528524 - Note 210317.1 Clear text passwords visible in LIBRARY_CACHE dumps

9.2.0.3 Bug Categories



    9.2.0.3 Bug Fixes by Category



    Symptom


    Corruption (Corrupt Export)
    2598387* Export / OCI clients using prefetch may see corrupt data
    This bug is alerted in Note 223399.1

    Corruption (Dictionary)
    2591284* Upgrade to 9i may fail leaving bad KOTTD$ type information in dictionary
    This bug is alerted in Note 215522.1
    2381172+ IMPORT fails / corrupts the AQ dictionary with duplicate QUEUE_TABLE names
    1584155 DROP FORCE/RECREATE TYPE with DEPENDENCIES corrupts dictionary information

    Corruption (Incorrect / missing corruption checks)
    2348277 DBV/RMAN may incorrectly report completely zero blocks as corrupt
    2354965 False fractured block messages possible during Direct Path IO
    2469314 DBVERIFY may dump when reporting a block corruption

    Corruption (Index)
    2729655 Direct load of PARTITION may not update bitmap index

    Corruption (Logical)
    2645455+ Control characters are trimmed from bind variables
    2697938+ UPDATE of object table sets columns to NULL with index only access
    2234028 CREATE TABLE OF <TYPE> AS SELECT can produce invalid table data
    2470864 UPDATE may not update all rows if CHECK CONSTRAINT compares columns
    2473741 Before row update trigger may not fire for MERGE statement
    2508682 Under heavy load concurrent sessions may use wrong shared cursor (wrong schema)
    2541038 Streams / Logical standby get corrupt/missing data for row migrated partitioned LOB columns
    2563206 CLOB data is corrupted when inserted from an 8.0 client to multibyte 9.2 server
    2646101 Data corruption binding a JDBC TEMP CLOB into an NCLOB column
    2656881 LOB data corrupt after migrating DB from single -> multibyte
    2732343 Streams capture update of LOB data > 32K gives wrong length on APPLY

    Corruption (Physical)
    2157903+ MOVE of MVIEW corrupts the data or dumps (ORA-7445 [qerltRop] or similar)
    2645378+ LOB data corruption after RECOVERY
    2620053P AIX5L: Corrupt blocks (ORA-1578) possible when shutdown RAC node
    2541360 V$BACKUP_SPFILE records can get corrupted / RMAN-10031
    2542609 Corruption from CANCEL of managed standby if primary is RAC
    2562274 Block corruption / OERI[KCOAPL_BLKCHK] updating LONG data
    2566356 ONLINE MOVE of KEY-COMPRESSED IOT corrupts the IOT
    2585648 OERI:[KCCCHB_1] should CRASH the instance but does not

    Corrupt/Bad Backup
    2645378+ LOB data corruption after RECOVERY

    Deadlock
    2136347 ORA-4020 on CREATE OR REPLACE VIEW with SELF-REFERENTIAL CONSTRAINTS
    2235386 Improved diagnostics for ORA-60 deadlocks
    2479110 Self deadlock (on library cache pin) revalidating INVALID PLSQL
    2652409 False ORA-60 possible in RAC / OPS environments
    2664217 Undetected deadlock (dc_objects V library cache lock) invalidating dependencies

    Excessive CPU usage
    2647211+ Implicit cursor FOR loop memory leak / CPU hit
    2533616 Materialized view refresh can use lots of CPU
    2580238 Reduce CPU usage of multiple DBW processes with RAC
    2610596 Huge CPU usage from RMAN server when TAPE not mounted with BACKUP_TAPE_IO_SLAVE=TRUE
    2617683 Query optimization may use more CPU than needed with fuzzy operators

    Fix is considered an enhancement
    2235386 Improved diagnostics for ORA-60 deadlocks
    2425312 ENH: Include PLSQL RPC information in 10046 trace
    2496772 ENH: Allow RAC load balancing by session counts rather than load
    2712701 Increased diagnostics for long enqueue timeouts in RAC

    Hang - Involving shared resource
    2479110 Self deadlock (on library cache pin) revalidating INVALID PLSQL
    2563162 Crash recovery may hang in RAC
    2636685 Hang / OERI:[17059] after adding a list value to a partition
    2664217 Undetected deadlock (dc_objects V library cache lock) invalidating dependencies
    2666244 Library cache lock corruption possible

    Hang - Process hang
    2320407 Session may hang on row cache enqueue if SQL_TRACE=true
    2370520 EMON hang - message notifications not delivered
    2388569 Hang possible in parallel transaction recovery
    2601708 Parallel propogation may hang
    2692936 Apply engine may hang
    2702392 Hang / dump possible mining redo

    Hang - Process spins
    2484250 RMAN CUMULATIVE BACKUP / MAINTENENCE may appear to hang (spin)
    2550212 'TEMP TABLE GENERATION' can give very poor query performance
    2636685 Hang / OERI:[17059] after adding a list value to a partition
    2657221 JDBC spins using Scrollable ResultSet with ORDER BY
    2695517 CR may SPIN after an instance crash
    2698133 TKPROF can spin with some trace files

    Install is not performed correctly
    2663836P+ AIX: Important Step Missing from AIX Patch Set Install Instructions
    2685912P+ Solaris 64bit: "libocijdbc9.so" Missing from 9.2.0.2 Patch Set on Solaris 64bit

    Instance may crash
    2524784 PQ on RAC may crash the instance with OERI[KSLPSPR1]
    2548338 LGWR may CRASH the instance (ORA-340) after failure of a single log
    2590120 PMON may crash instance with ORA-600 [KTUABT_1: DROP/TRUNCATE NOT COMP]
    2649033 LMON may crash instance with ORA-227 errors
    2688442 SMON may CRASH instance with ORA-7445[KSFD_OSDRQFIL]
    2695916 LCK PGA memory leak - may crash instance
    2736672 LSP0 failure may crash instance

    Leak - Memory leak / Growth
    2647211+ Implicit cursor FOR loop memory leak / CPU hit
    2093521 Memory leak using SAVE EXCEPTIONS with FORALL BULK operations
    2334377 Memory Leak from TABLE subquery against XMLType
    2441734 Win: Setting SQLNET.EXPIRE_TIME wastes stack memory
    2448925 ORA-4030 from CTAS of CLOB over DBLINK from non_UTF8 -> UTF8
    2515844 Memory leak using PL/SQL and LDAP
    2519148 Memory leak from PLSQL RPC to an older database version in a LOOP
    2547290 Refresh of Materialized View over DBLINK wastes memory (ORA-4030)
    2560808 Logical Standby apply slaves leak memory in Max Availability mode
    2605435 Client memory leak on TAF connection
    2607029 High memory use optimizing SQL with functional indexes and many expressions
    2642976 Memory growth on INSERT of XMLTYPE
    2643775 OERI:730 on shutdown using object level statistics
    2683414 Logminer may use excessive memory selecting redo for LONG columns
    2695916 LCK PGA memory leak - may crash instance
    2702333 Memory leak using PLSQL associative array
    2707212 Memory leak from long running log mines
    2717317 Client memory leak from EXEC SQL CONTEXT ALLOCATE / FREE

    Leak - Resources eg: File handles
    2452537 SELECT of remote sequence leaks cursors (ORA-1000)
    2517189 Handle leak on repeated CONNECT/DISCONNECT in OCI_THREADED mode
    2618958 File descriptor/handle leak from IPQ slaves over IPC
    2624737 Cursor leak (ORA-1000) selecting from X$KTFBUE
    2723384 ORACLE.SQL.CLOB.CREATETEMPORARY can leak TEMP LOBS

    Memory Corruption
    2652771P AIX: OERI[1100] / OERI[KCBGET_37] SGA corruption
    1839270 Setting FILE_DATASTORE over 260 characters can corrupt server memory
    2487248 Dump / memory corruption if Event 10129 is set for a distributed query
    2666244 Library cache lock corruption possible

    Performance affected (General)
    1721097 Inline query in SELECT list not in EXPLAIN PLAN
    1743159 A number of WAITs can occur under "null event"
    2414971 UTLXPLS.SQL may report incorrect OPTIMIZER USED and may raise ORA-6502
    2602332 "buffer busy wait" waiter may sometimes not get posted
    2649563 ALL_TYPE_ATTRS view is SLOW for SQL with predicates on OWNER / TYPE_NAME
    2698133 TKPROF can spin with some trace files
    2710321 X$KCCFN / V$DATAFILE much slower in 9i than 8i with many datafiles

    Performance of Query/ies affected
    2474630 optimizer_dynamic_sampling >1 forces CBO
    2487808 Poor join cardinality if both columns have histograms
    2534430 Poor plan possible from OR-expansion
    2542139 Long parse times possible if _B_TREE_BITMAP_PLANS=TRUE
    2660592 CBO may needlessly evaluate bitmap plans for Domain indexes

    Security or Service denial vulnerability
    2528524* Clear text passwords visible in LIBRARY_CACHE dumps
    This bug is alerted in Note 210317.1
    2540219* Listener denial of service vulnerability
    This bug is alerted in Note 213411.1
    2581911* iSqlplus buffer overflow vulnerability
    This bug is alerted in Note 216775.1
    2620726* Buffer overflow in Oracle server
    This bug is alerted in Note 229287.1
    2642117* Overflow vulnerability in DIRECTORY parameter of BFILENAME
    This bug is alerted in Note 229284.1
    2642168* Buffer overflow vulnerability with CREATE DATABASE LINK
    This bug is alerted in Note 237172.1
    2642203* EXTPROC buffer overflow possible on LONG LIBRARY NAME
    This bug is alerted in Note 175429.1
    2642267* TZ_OFFSET overflow vulnerability
    This bug is alerted in Note 229285.1
    2642439* TO_TIMESTAMP_TZ overflow vulnerability
    This bug is alerted in Note 229286.1

    Shared Pool affected
    2450264 Add event to improve cursor sharability
    2586762 Direct LOB reads can result in ORA-4031 / excessive shared pool usage
    2607029 High memory use optimizing SQL with functional indexes and many expressions
    2708134 FIRST_ROWS(K) HINT causes cursor not to be shared

    Wrong Results
    2429929* V$SESSION_EVENT.SID has the wrong SID (out by 1)
    This bug is alerted in Note 208105.1
    2598387* Export / OCI clients using prefetch may see corrupt data
    This bug is alerted in Note 223399.1
    2673783+ Wrong year values possible from DATE data types (apparently random)
    2768576+ SDO_RELATE (point - line) for CONTAINS on RTREE returns WRONG RESULT
    2628258P Win: Trailing "\0" added to MACHINE column of V$SESSION
    2333947 Wrong results possible from PQ on PARTITIONED table
    2375782 NEAR operator may not return rows with several terms
    2408817 V$RECOVERY_PROCESS.SOFAR may decrease during media recovery
    2442125 Wrong results from PQ which compares a CHAR column to a BIND variable
    2452631 Wrong results with CHECK CONSTRAINTS on OUTER JOIN columns
    2455551 Blank padded comparison fails with NLS_COMP=ANSI & NLS_SORT<>BINARY
    2470864 UPDATE may not update all rows if CHECK CONSTRAINT compares columns
    2477249 Wrong results / Dump from INSERT AS SELECT with GROUP BY using FUNCTIONAL INDEX
    2502129 Wrong results possible depending on order of predicates
    2518109 Wrong results possible when INDEX JOIN used in execution plan
    2522549 Wrong results possible with STAR_TRANSFORMATION_ENABLED=TRUE
    2529036 LIKE against multi-byte CLOB can give wrong results
    2533766 Wrong results from HASH JOIN over DBLINK between multibyte databases
    2539837 Wrong results using FIRST_ROWS_N with > 5 tables in FROM clause
    2545840 Distributed query may see remote changes from AFTER the snapshot SCN
    2551568 OERI:[rworupo.1] / wrong results from queries involving OBJECTS
    2556195 OERI:[SORPUT_1] / Wrong results using PIPELINED function in SQL
    2559375 Wrong results from STAR_TRANSFORMATION_ENABLED due to transitively generated predicates
    2569154 Wrong results from PQ with NL of BITMAP INDEX with ROWID predicate
    2589186 Empty Timestamp is returned for NULL column value
    2601175 Wrong results for German sharp-s with BASE_LETTER and ALTERNATE_SPELLING
    2610068 '_' character treated as a WILDCARD for CTXCAT indextype
    2616459 CHR() returns CHR(0) when NLS_SORT is set
    2622496 SDO_RELATE returns wrong results on ARCS with reasonable tolerance
    2624452 Redefinition of buffer length with OCIDefineByPos gets wrong no bytes for LONGS
    2627474 Wrong results from CURSOR expression in JSP if first column is an ADT
    2628799 Blank data from Domain Index only scan fetching PK only for IOT
    2630054 ORA-7445 [EVAOPN2] / wrong results from CASE expression
    2633193 Wrong results possible from DECODE in a NOT IN subquery
    2649659 Invalid data in OCI7 client in non-blocking mode with NLS conversion
    2656627 Wrong results from ANSI OUTER JOIN with CONSTANT predicates in ON clause
    2658851 Wrong results from SEMIJOIN on CLUSTERED column
    2663986 Missing rows querying CTXRULE index in sections (eg: 'CAT WITHIN MAMMAL')
    2675123 Client gets no data in some cases when NLS_LANG is UTF8
    2684307 Mixed tokens not uppercased with BASE_LETTER in multibyte database
    2685914 SDO_WITHIN_DISTANCE may return wrong answer for geodetic data
    2688717 Pro client mey get NULL rows with PREFETCH enabled
    2695425 CONVERT() CLOB to a multibyte characterset gives corrupt result
    2711788 Wrong results possible from STAR transformation with OR predicates
    2729655 Direct load of PARTITION may not update bitmap index
    2729673 Wrong result from COMPOSITE PARTITIONING, INLIST and GLOBAL INDEX

    Error may occur
    2307005P Win: SQLPLUS job returns NMS-915 but no ORA error
    2448663P AIX: Cannot startup RAC instance if LANG=Ja_JP
    1810960 ProCobol signals PLS-103 errors for PLSQL GOTO labels in code
    1829296 False ORA-980 from PLSQL referencing SYNONYM which uses a DBLINK
    1850169 ORA-1405 occurs if OCIBindDynamic() used for NULL PLSQL OUT bind
    2121433 ORA-1401 after type change between two AddBatches
    2136347 ORA-4020 on CREATE OR REPLACE VIEW with SELF-REFERENTIAL CONSTRAINTS
    2175150 ORA-7445 [kcbldrcls] and ORA-10387 possible with parallel query
    2191497 XA_END in PRO fails with ORA-24779 when using a DBLINK after an error
    2227982 OCIIntervalSetYearMonth() may produce ORA-1873 errors
    2235386 Improved diagnostics for ORA-60 deadlocks
    2243411 PLS-597 from "FETCH..BULK COLLECT INTO"
    2272485 ORA-7445 / ORA-607 creating a clustered table using CTAS
    2272566 MERGE statement may dump (ORA-7445) in insape instead of signalling ORA-1401
    2283515 TABLESPACE FULL event returns NMS-1005 / NMS-1078 for RAW device
    2301903 ORA-1438 / ORA-1406 possible from ORAMOVELONG with large NUMBER columns
    2387804 STARTUP command with invalid option reports internal error (SP2-642)
    2399093 ORA-16000 opening database READ ONLY
    2414971 UTLXPLS.SQL may report incorrect OPTIMIZER USED and may raise ORA-6502
    2431526 Failover: ORA-1089 possible from shutdown IMMEDIATE
    2432911 OERI[6757] from HASH CLUSTER if INITRANS has been altered
    2435257 IMP-3 / ORA-1031 in SYS.DBMS.DDL if IMP_FULL_DATABASE granted via a ROLE
    2436572 FAILOVER: ORA-1 possible after FAILOVER during SELECT of an XMLType
    2436600 OERI:[KTFTHCF-1] possible from V$FILESTAT / DBA_DATA_FILES
    2440387 NMS-1078 evaluating a network mounted file system
    2444517 ORA-918 possible with "_subquery_pruning_enabled"=true
    2448243 Full export from non DBA user may fail with ORA-1031 in SYS.LT_EXPORT_PKG
    2448925 ORA-4030 from CTAS of CLOB over DBLINK from non_UTF8 -> UTF8
    2451259 ORA-28604 on recreate of BITMAP index on COMPRESSED table
    2452537 SELECT of remote sequence leaks cursors (ORA-1000)
    2461455 ORA-7445 [qcdlgtd] or ORA-942 from IMPORT FROMUSER / TOUSER
    2476514 ORA-22324 / OERI:[4883] adding method to OBJECT with REF dependencies
    2486954 ORA-4031 / Dump from concurrent DGURIServlet access to SQLX XMLType view
    2487889 Agent reports TNS-12538 errors for SQLPLUS jobs
    2488590 EXP-8 ORA-3113 exporting large CREATE OPERATOR statement
    2489526 PLS-801 [21076] / package corruption (in memory) recompiling PLSQL
    2489881 DRG-50603 indexing WORD in two LANGUAGES with MULTI_STOPLIST and PREFIX_INDEX
    2490061 ORA-932 for remote SQL using TIMESTAMP datatype
    2495123 PLS-306 using DBMS_LOB.LOADFROMFILE after upgrade to 9.2
    2496556 OERI[KDOURP-2] possible during CR rollback (rare)
    2498399 OERI:[KXFPRDP:1] / ORA-10388 if node is shutdown as PQ starts
    2501591 ORA-928 / ORA-4031 on "ALTER VIEW <sys_view> COMPILE" if REMOTE objects exist with same name
    2502135 LPX-4 "Multichar overflow" possible parsing XML documents
    2506655 ORA-22921 using REPLACE() on a CLOB in PLSQL in UTF8
    2508813 ORA-16000 exporting from READ ONLY database
    2510750 ORA-35810 running XUMUTS.PLB on UTF8 database
    2510810 ORA-911 / ORA-936 from ANALYZE .. VALIDATE STRUCTURE when USERNAME / TABLE_NAME contain special characters
    2514079 Import of ALTERED CTXRULE index can fail with DRG-11000
    2517719 ORA-3115 from setTimestamp() in JDBC 9.2 with an 8.0 database
    2518758 ORA-1460 IMPORTING metadata for TRANSPORT of table with LONG column
    2519148 Memory leak from PLSQL RPC to an older database version in a LOOP
    2523151 ORA-7445[updexe] with AUDIT_TRAIL=DB with stressed shared pool
    2529763 Rename of 9.0.1 OMF file fails with ORA-1276
    2531403 ORA-13249 creating SPATIAL index on attribute of object table
    2539160 ORA-16139 on "switchover to primary"
    2539791 ORA-600[kksscl-inf-inl-loop] possible following process death
    2540375 ORA-918 possible with STAR_TRANSFORMATION_ENABLED=TRUE
    2542693 Repeated ORA-0000 after failover
    2544428 Export may write bad LOB storage clause for TRANSPORT (ORA-22850 on IMPORT)
    2544536 Transportable tablespace export may produce bad export
    2545415 ORA-29902 from VIEWPORT_TRANSFORM
    2547290 Refresh of Materialized View over DBLINK wastes memory (ORA-4030)
    2548338 LGWR may CRASH the instance (ORA-340) after failure of a single log
    2553074 ORA-12996 should always occur ALTER TABLE DROP COLUMN after COMPRESS
    2556845 ORA-955 / ORA-14452 running concurrent transportable tablespace exports
    2564693 ORA-22813 from CAST(MULTISET(...))
    2566659 ORA-1555 running DBMS_PCLXUTIL.BUILD_PART_INDEX
    2567290 Large packet over DBLINK may fail with ORA-12539
    2582293 SYNCHRONIZE after DEFERRED may fail after UPDATES
    2586762 Direct LOB reads can result in ORA-4031 / excessive shared pool usage
    2588406 ARC validates ofter failing (ORA-13349) with smaller tolerance
    2598043 False ORA-1410 accessing migrated Oracle7 table with ROWID= predicate
    2598124 EXP-8 / ORA-1422 if queue and queue table have same name
    2599613 IMP-60 possible when object already exists in database
    2601203 ORA-3106 from INSERT .. RETURNING a NULL into a TIMESTAMP column
    2601447 CTX_DOC.GIST() fails with DRG-10001
    2603036 ORA-6533 gathering stats for partitioned table with DBMS_STATS
    2604343 ORA-12085 / OERI:1234 possible using non-empty RESOURCE_MANAGER_PLAN
    2605652 STANDBY database may get ORA-338
    2607029 High memory use optimizing SQL with functional indexes and many expressions
    2608776 ORA-3106 in 8.0 client SELECTing pseudo column from 9i server over DBLINK
    2614464 ORA-979 from PLSQL query with TABLE() function and PLSQL bind in the GROUP BY clause
    2617480 OERI:[KDISLE:NROWS][1] during INSERT into an INDEX
    2619827 ORA-903 / ORA-911 from ALTER VIEW COMPILE with UNION ALL in inline view
    2619867 OERI:[KCBGTCR_12] / ORA-8103 / ORA-1410 SELECTing from bitmap managed segment
    2621671 Memory leak in logical standby
    2622558 XA Open option to close precompiler cursors on XA_END (avoid ORA-24779 errors)
    2623859 ORA-1400 possible during DBMS_APPLY_ADM
    2628768 ORA-922 possible with OVERFLOW and VARRAY clauses on an object IOT
    2629652 PLS-302 'EXPORT_RULE_SET' must be declared from EXPORT
    2632802 LGWR ASYNC or SYNC=PARALLEL archival may cause ORA-332 on STANDBY
    2636886 DRG-50603 from CTX_DLL.SYNC_INDEX with MULTI_STOPLIST index
    2642031 ORA-979 from complex view merge of "THE" subquery.
    2644178 Physical standby may fail with ORA-354 if primary archival fails
    2649033 LMON may crash instance with ORA-227 errors
    2652409 False ORA-60 possible in RAC / OPS environments
    2652845 SQLPLUS client may get ORA-25402 after TAF failover if no previous SQL issued
    2662838 ORA-2095 attempting to modify SESSION modifiable parameter in SPFILE
    2668683 Array binds to PLSQL blocks may ORA-1458 or no data is fetched
    2670901 ORA-604 / ORA-907 / ORA-904 from WITH clause with ANSI join in it
    2671089 UNION of GEODETIC GEOMETRIES returns INVALID GEOMETRY (ORA-13349)
    2673282 WKG-30008 crawling a FILE-DATASOURCE with > 127 character FILENAME
    2676316 Poor performance / ORA-14098 after EXCHANGE PARTITION with TEXT index
    2678481 OERI[729] possible on SHUTDOWN
    2682894 ORA-1424 from LIKE expression on multibyte non-shifting character set
    2686862 OERI [qesmmaLogUnResSpc1] possible under load
    2694605 ORA-3118 possible when PLSQL executed over a DBLINK
    2694760 ORA-1405 from DBMS_STREAMS_ADM.ADD_SCHEMA_RULES etc..
    2701826 OERI[1236] possible
    2707304 OERI:17059 / OERI:kqlupd2 / PLS-907 after adding partitions to Partitioned IOT
    2723677 ORA-955 adding a partition to a spatial table with a LOCAL SPATIAL index
    2740929 New STANDBY recovery may fail with ORA-16016
    2765286 ORA-1458 from Pro ARRAY insert (9.2.0.2 only)

    Internal Error may occur (ORA-600)
    2536041+ OERI[KKQSADJP-1] with QUERY_REWRITE_ENABLED=TRUE
    2652771P AIX: OERI[1100] / OERI[KCBGET_37] SGA corruption
    2695783P Win: OERI:[KCCSBCK_FIRST] possible if Oracle & CM restarted
    2040114 OERI:[qcsrlidm1] from predicate with TYPE MEMBER method call
    2078899 OERI[4814] / OERI[kkdlgon4] on startup with DDL in SYSTEM TRIGGER
    2185189 OERI[26599] possible executing DBMS_JAVA.SERVER_STARTUP
    2374041 OERI[QERSQCLOSE-1] selecting REMOTE sequence from empty local table
    2399954 OERI:733 / OERI[KGHALF1] possible from PLSQL execution using many cursors
    2432911 OERI[6757] from HASH CLUSTER if INITRANS has been altered
    2436600 OERI:[KTFTHCF-1] possible from V$FILESTAT / DBA_DATA_FILES
    2438953 OERI[KCBGCUR_2] / OERI[6856] from RECO in RAC/OPS
    2444186 OERI[PSDISA:SESNUM] passing an invalid ID to DBMS_SESSION.IS_SESSION_ALIVE
    2458655 OERI[QCTECTE1] from FULL OUTER JOIN with BIND variable in subquery
    2473601 OERI:[qkaPIdsqkn1] possible from index-join on partitioned tables
    2474192 OERI:[OPIBND1] on CREATE of TEXT INDEX with CURSOR_SHARING
    2476514 ORA-22324 / OERI:[4883] adding method to OBJECT with REF dependencies
    2496556 OERI[KDOURP-2] possible during CR rollback (rare)
    2497219 OERI:[17065] / OERI:[17064] from XAOROLLBACK with AQ in OPS/RAC
    2498399 OERI:[KXFPRDP:1] / ORA-10388 if node is shutdown as PQ starts
    2507421 OERI:[kkqwrm_noref: COLFDNF set] possible from WINDOW function and WITH clause
    2516493 LMS may dump with OERI[KJBRWRDONE:!W]
    2524784 PQ on RAC may crash the instance with OERI[KSLPSPR1]
    2526334 OERI:25012 from AND EQUAL with B-Tree and DOMAIN index
    2531519 OERI:[25012] from parallel direct load of bitmap managed segments
    2534045 OERI:kghuichk_07 using SDO_RELATE against RTREE with Circular Arc Geometry
    2536531 MERGE on table with BITMAP index fails with OERI:[kauins:1]
    2537917 OERI:729 possible with XDB
    2539791 ORA-600[kksscl-inf-inl-loop] possible following process death
    2551267 OERI:[kkdxptcn1] during TRANSPORT import of tables with LONG columns
    2551568 OERI:[rworupo.1] / wrong results from queries involving OBJECTS
    2552188 Certain DDLs can cause capture to die (OERI:KNLCFGETOBJINFO:GTA)
    2555141 OERI:[PITL1] using an TRANSPORTED table created in 8i (or earlier)
    2556195 OERI:[SORPUT_1] / Wrong results using PIPELINED function in SQL
    2562274 Block corruption / OERI[KCOAPL_BLKCHK] updating LONG data
    2569255 OERI:KCBGTCR_5 dropping segment upgrade from 8i
    2585648 OERI:[KCCCHB_1] should CRASH the instance but does not
    2587723 OERI:[kolasaWrite-3] / OERI:[ksmovrflow] possible with XDB
    2590120 PMON may crash instance with ORA-600 [KTUABT_1: DROP/TRUNCATE NOT COMP]
    2590317 OERI:[krvxrptl:Cannot delete current l] selecting from V$LOGMNR_CONTENTS
    2591551 OERI:[qesmmaLogUnResSpc1] with XDB
    2592966 OERI:[qkaPIdsqkn1] from AND EQUAL against partitioned table
    2594172 LMS may die with OERI:[KJBMPUPMASTER:DS]
    2599290 OERI from 8.0 client querying NULLs and LONG over 9i -> 9i DBLINK
    2604211 OERI:[KKSFBC-NEW-CHILD-THRESH-EXCEEDED] using literal replacement
    2604343 ORA-12085 / OERI:1234 possible using non-empty RESOURCE_MANAGER_PLAN
    2605166 OERI:koksctri1 during create TEXT index on EXTRACT() expression
    2605511 OERI[3672] changing tablespace READ-WRITE after incomplete recovery
    2607128 OERI:[qmxiUnpPacked2] if CATPATCH.SQL/XDBPATCH.SQL fails
    2611590 OERI:[17003] running XDBRELOD.SQL
    2616549 OERI:QMR_CB_PR1 possible in XDB
    2617480 OERI:[KDISLE:NROWS][1] during INSERT into an INDEX
    2619867 OERI:[KCBGTCR_12] / ORA-8103 / ORA-1410 SELECTing from bitmap managed segment
    2622913 OERI:[qmtsSetTypeInfo9] possible
    2625279 OERI[6763] during ANALYZE TABLE .. ESTIMATE STATISTICS with concurrent DROP
    2626347 OERI:17059 accessing view after ADD / SPLIT PARTITION
    2629193 OERI:[711]..[KDIFXS - PREFIX CONTEXT] selecting COMPRESSed key IOT
    2633268 OERI:[kclwcrs_15] possible
    2636685 Hang / OERI:[17059] after adding a list value to a partition
    2641473 OERI[OPIXRB-4] from V7 client binding SQLT_RID to 9.2 table over DBLINK
    2642848 OERI:16206 possible on 9.2 -> 8.1 downgrade
    2643775 OERI:730 on shutdown using object level statistics
    2643872 OERI:[KCRRNSFWA.2] possible
    2644285 OERI:2652 from LOB update with supplemental logging
    2648408 OERI:[QMTSGETCOMPLEXINFO1] on RegisterSchema
    2654607 OERI binding NULL REF type from JDBC Thin
    2656036 OERI/memory corruption selecting SQL_REDO for CLOB DMLS
    2658212 OERI:[KKCHBYT] possible with _keep_remote_column_size = TRUE
    2658284 OERI:[QERPFFETCH1] possible during OBJECT table BULK SELECT
    2662576 EXTERNAL TABLE select may fail with OERI:[KPXSDPINIT_02]
    2676912 OERI[KTELRWI-2] from CREATE UNIQUE INDEX with Bitmap managed segment
    2678481 OERI[729] possible on SHUTDOWN
    2685269 OERI[ktspstchg-1] on DELETE from bitmap managed table/index
    2686862 OERI [qesmmaLogUnResSpc1] possible under load
    2689585 LMS might encounter ORA-600[504] during the simultaneous shutdown
    2698435 Repeated OERI:18260 / OERI:18186 if XA DBLINK errors at commit
    2701643 OERI [krvxmds_MemberDictSet]/ORA-7445 mining redo from upgraded database
    2701820 OERI[18250] / dump using migratable database links
    2701826 OERI[1236] possible
    2707304 OERI:17059 / OERI:kqlupd2 / PLS-907 after adding partitions to Partitioned IOT
    2718814 DML/Rollback problems with SUPPLEMENTAL LOG GROUP on IOT
    2757613 SELECT XMLELEMENT() may fail with OERI:[kolasaRead-1.1]

    Process may Dump / Abend / Abort
    2157903+ MOVE of MVIEW corrupts the data or dumps (ORA-7445 [qerltRop] or similar)
    1955577 Dump (in KOKEIS) using BINDS if TRIGGER updates nested table column
    2058579 CTAS referencing PLSQL function may dump if shared pool flushes
    2175150 ORA-7445 [kcbldrcls] and ORA-10387 possible with parallel query
    2261722 8i export of 9i database dump (in koputilassert) with SUBTYPE / NOT FINAL type
    2272485 ORA-7445 / ORA-607 creating a clustered table using CTAS
    2272566 MERGE statement may dump (ORA-7445) in insape instead of signalling ORA-1401
    2311637 ORA-7445 IN QKKSKIPORDOPT() WITH RULE HINT
    2332184 ORA-7445[kope2upic] from XML.ToObject()
    2460091 ORA-7445[pgmbiad_build_input] if PLSQL calls Java callout with a TIMESTAMP parameter
    2461455 ORA-7445 [qcdlgtd] or ORA-942 from IMPORT FROMUSER / TOUSER
    2468542 ORA-7445 [EVAOPN2] with DECODE predicate involving FUNCTIONAL index
    2483617 DBMS_XSLPROCESSOR.SELECTNODES may dump in qmxGetNumChildren
    2501800 ORA-7445 [kdblailb] from Direct path load into a COMPRESSed table
    2508702 ORA-7445 [KKSLHIB] with CURSOR_SHARING=FORCE with INTO clause
    2510357 ODESCR dumps with unaliased column expression length >= 960 chars
    2514005 Client may dump (kpurst) when calling OCIBreak / OCIReset
    2514869 Dump (qerhjWalkHashBucket->kpofcr) from HASH JOIN OUTER with BINDs
    2517736 Update of LONG with BIND may dump if cursor invalidated
    2523151 ORA-7445[updexe] with AUDIT_TRAIL=DB with stressed shared pool
    2526540 SIGFPE possible during optimization
    2548412 INTERSECTION containing ARCS may dump
    2551933 ORA-7445[ttcclr] from V7 protocol client
    2553163 XDB may dump in QMUBANINS
    2556294 ORA-7445[kkocfcc] possible using Bitmap Join Index
    2557893 ORA-7445[qsmmecin] from rewrite of nested subquery with correlation
    2560364 ORA-7445 [pegisc] from BITAND with BINARY_INTEGER arguments
    2563296 Import may fail with server ORA-7445[kfpchkchar]
    2563936 ORA-7445 [qcdottnc] from SELECT XXX() where "XXX" is not a type/function
    2572944 SELECT over 8i -> 9i DBLINK may fail with ORA-7445 [opidsi]
    2576353 ORA-7445[qxopqgcd] from remote query with user defined function
    2592406 Dump possible SYNCHRONIZING a DEFERRED spatial index
    2594513 ORA-7445 [kcrradinit] possible during ARCH cross-instance archival
    2595396 Dump in KGEADP possible with XDB
    2606090 ORA-7445[LNXN2COPT] is pruning predicate contains subquery
    2617877 ORA-7445 [kkehbs] possible querying partitioned table
    2630054 ORA-7445 [EVAOPN2] / wrong results from CASE expression
    2640623 ORA-7445[ksupgpcl] possible in PMON during SHUTDOWN
    2646865 ORA-7445 [INSBRP] from INSERT .. RETURNING with a trigger
    2648289 ORA-7445 [kkmdel] deleting from a table with BEFORE DELETE trigger
    2652538 ORA-7445 [kkkiprpriv] during GRANT/REVOKE in trusted callout
    2663395 Stack corruption if write back of mirror broken block fails
    2672965 Pro client dump (sqlrdf) if cursor used for both dynamic method 3 and 4
    2688442 SMON may CRASH instance with ORA-7445[KSFD_OSDRQFIL]
    2696120 OCCI client dump (kpuhhalo) on Commit/Rollback if using DML over DBLINK
    2698687 Dump in qes3tCleanLockInfo from temp table transformation
    2701643 OERI [krvxmds_MemberDictSet]/ORA-7445 mining redo from upgraded database
    2701820 OERI[18250] / dump using migratable database links
    2708898 STAR_TRANSFORMATION with a WINDOW function may dump (evaopn2)
    2732590 Creating complex types with SUB TYPES in NOT FINAL MODE may dump (kopocue)
    2767539 Dump (in qerpxStart) possible from TEMP TABLE TRANSFORMATION with WINDOW function



    Task Related


    Instance startup
    2448663P AIX: Cannot startup RAC instance if LANG=Ja_JP
    2729107P SGA cache > 2GB prevents instance startup
    2078899 OERI[4814] / OERI[kkdlgon4] on startup with DDL in SYSTEM TRIGGER
    2185189 OERI[26599] possible executing DBMS_JAVA.SERVER_STARTUP
    2387804 STARTUP command with invalid option reports internal error (SP2-642)
    2399093 ORA-16000 opening database READ ONLY
    2634796 Crash during RMAN "proxy copy" can leave database unopenable
    2654862 Open of standby in READ ONLY mode may fail after upgrade (ORA-16000)

    Migration / Upgrade / Downgrade
    2591284* Upgrade to 9i may fail leaving bad KOTTD$ type information in dictionary
    This bug is alerted in Note 215522.1
    2689563+ Spatial Option not completely upgraded after running 9202 CATPATCH.SQL script
    2328821 CREATE MATERIALIZED VIEW .. WITH GROUPING SET does not work after upgrade from to 9i
    2529763 Rename of 9.0.1 OMF file fails with ORA-1276
    2569255 OERI:KCBGTCR_5 dropping segment upgrade from 8i
    2598043 False ORA-1410 accessing migrated Oracle7 table with ROWID= predicate
    2607128 OERI:[qmxiUnpPacked2] if CATPATCH.SQL/XDBPATCH.SQL fails
    2623931 Capture may not start after upgrade from 9201 to 9202
    2629917 ORA-20000 error downgrading from 9i to 8i
    2642848 OERI:16206 possible on 9.2 -> 8.1 downgrade
    2654862 Open of standby in READ ONLY mode may fail after upgrade (ORA-16000)
    2685546 XMLCONCAT function should be dropped after 9201 -> 9202 upgrade

    Performance Monitoring
    2429929* V$SESSION_EVENT.SID has the wrong SID (out by 1)
    This bug is alerted in Note 208105.1

    Recovery
    2645378+ LOB data corruption after RECOVERY
    2388569 Hang possible in parallel transaction recovery
    2399093 ORA-16000 opening database READ ONLY
    2408817 V$RECOVERY_PROCESS.SOFAR may decrease during media recovery
    2424490 OPTIONAL LOG_ARCHIVE_DEST_X failures not written to ALERT LOG
    2449124 MAX_FAILURE in LOG_ARCHIVE_DEST_N does not work
    2555509 Parallel media recovery slower than needed
    2594513 ORA-7445 [kcrradinit] possible during ARCH cross-instance archival
    2605511 OERI[3672] changing tablespace READ-WRITE after incomplete recovery
    2662180 RECOVER UNTIL SCN may stop before expected SCN if log corrupt



    SQL commands / features used


    ANSI Joins
    2315444 Dump from query with LATERAL view
    2458655 OERI[QCTECTE1] from FULL OUTER JOIN with BIND variable in subquery
    2656627 Wrong results from ANSI OUTER JOIN with CONSTANT predicates in ON clause
    2670901 ORA-604 / ORA-907 / ORA-904 from WITH clause with ANSI join in it

    Analytic SQL (Windowing etc..)
    2507421 OERI:[kkqwrm_noref: COLFDNF set] possible from WINDOW function and WITH clause
    2708898 STAR_TRANSFORMATION with a WINDOW function may dump (evaopn2)
    2767539 Dump (in qerpxStart) possible from TEMP TABLE TRANSFORMATION with WINDOW function

    Application Context
    2435725 APPLICATION CONTEXT attribute visible after dropping the NAMESPACE

    Constraint Related
    2136347 ORA-4020 on CREATE OR REPLACE VIEW with SELF-REFERENTIAL CONSTRAINTS
    2452631 Wrong results with CHECK CONSTRAINTS on OUTER JOIN columns
    2470864 UPDATE may not update all rows if CHECK CONSTRAINT compares columns

    Datatypes - LOBs (CLOB/BLOB/BFILE)
    2642117* Overflow vulnerability in DIRECTORY parameter of BFILENAME
    This bug is alerted in Note 229284.1
    2645378+ LOB data corruption after RECOVERY
    2242133 Dump possible if SQL calls PLSQL function which returns a LOB
    2448925 ORA-4030 from CTAS of CLOB over DBLINK from non_UTF8 -> UTF8
    2495123 PLS-306 using DBMS_LOB.LOADFROMFILE after upgrade to 9.2
    2506655 ORA-22921 using REPLACE() on a CLOB in PLSQL in UTF8
    2529036 LIKE against multi-byte CLOB can give wrong results
    2537320 SQL_REDO for large LOB operations is not executable
    2541038 Streams / Logical standby get corrupt/missing data for row migrated partitioned LOB columns
    2544428 Export may write bad LOB storage clause for TRANSPORT (ORA-22850 on IMPORT)
    2563206 CLOB data is corrupted when inserted from an 8.0 client to multibyte 9.2 server
    2586762 Direct LOB reads can result in ORA-4031 / excessive shared pool usage
    2644285 OERI:2652 from LOB update with supplemental logging
    2646101 Data corruption binding a JDBC TEMP CLOB into an NCLOB column
    2656036 OERI/memory corruption selecting SQL_REDO for CLOB DMLS
    2656881 LOB data corrupt after migrating DB from single -> multibyte
    2685942 OERI/dump possible minig LOB redo
    2695425 CONVERT() CLOB to a multibyte characterset gives corrupt result
    2696397 Blob.length() fails when selected with a Stream type (LONG, LONG RAW)
    2700006 JDBC Thin "Unexpected Packet" error with LOBS in multithreaded client
    2702872 Unnecessary library cache pin / lock activity during LOB reads
    2723384 ORACLE.SQL.CLOB.CREATETEMPORARY can leak TEMP LOBS

    Datatypes - Objects (Types/Collections)
    2697938+ UPDATE of object table sets columns to NULL with index only access
    1584155 DROP FORCE/RECREATE TYPE with DEPENDENCIES corrupts dictionary information
    1955577 Dump (in KOKEIS) using BINDS if TRIGGER updates nested table column
    2040114 OERI:[qcsrlidm1] from predicate with TYPE MEMBER method call
    2234028 CREATE TABLE OF <TYPE> AS SELECT can produce invalid table data
    2261722 8i export of 9i database dump (in koputilassert) with SUBTYPE / NOT FINAL type
    2347596 Transport of OBJECT table may get index in wrong tablespace
    2448939 OCICacheFlush stores objects as the base type instead of the SUBTYPE
    2476514 ORA-22324 / OERI:[4883] adding method to OBJECT with REF dependencies
    2479354 Direct path load of column Objects give wrong results / dumps
    2551568 OERI:[rworupo.1] / wrong results from queries involving OBJECTS
    2564693 ORA-22813 from CAST(MULTISET(...))
    2599613 IMP-60 possible when object already exists in database
    2614464 ORA-979 from PLSQL query with TABLE() function and PLSQL bind in the GROUP BY clause
    2628768 ORA-922 possible with OVERFLOW and VARRAY clauses on an object IOT
    2658284 OERI:[QERPFFETCH1] possible during OBJECT table BULK SELECT
    2732590 Creating complex types with SUB TYPES in NOT FINAL MODE may dump (kopocue)

    Datatypes - TIMESTAMP
    2227982 OCIIntervalSetYearMonth() may produce ORA-1873 errors
    2460091 ORA-7445[pgmbiad_build_input] if PLSQL calls Java callout with a TIMESTAMP parameter
    2490061 ORA-932 for remote SQL using TIMESTAMP datatype
    2601203 ORA-3106 from INSERT .. RETURNING a NULL into a TIMESTAMP column

    Direct Path operations
    2354965 False fractured block messages possible during Direct Path IO
    2479354 Direct path load of column Objects give wrong results / dumps

    Hash Join
    2514869 Dump (qerhjWalkHashBucket->kpofcr) from HASH JOIN OUTER with BINDs
    2533766 Wrong results from HASH JOIN over DBLINK between multibyte databases

    Literal Replacement (CURSOR_SHARING)
    2474192 OERI:[OPIBND1] on CREATE of TEXT INDEX with CURSOR_SHARING
    2508702 ORA-7445 [KKSLHIB] with CURSOR_SHARING=FORCE with INTO clause
    2604211 OERI:[KKSFBC-NEW-CHILD-THRESH-EXCEEDED] using literal replacement

    MERGE .. USING
    2272566 MERGE statement may dump (ORA-7445) in insape instead of signalling ORA-1401
    2329059 DML monitoring does not track modifications by MERGE statements
    2339666 Parallel MERGE into composite partitioned table not performant
    2473741