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 Before row update trigger may not fire for MERGE statement
    2536531 MERGE on table with BITMAP index fails with OERI:[kauins:1]

    NLS (National Language Support)
    2379746 Multibyte data corrupted by setPlsqlIndexTable()
    2448925 ORA-4030 from CTAS of CLOB over DBLINK from non_UTF8 -> UTF8
    2455551 Blank padded comparison fails with NLS_COMP=ANSI & NLS_SORT<>BINARY
    2506655 ORA-22921 using REPLACE() on a CLOB in PLSQL in UTF8
    2529036 LIKE against multi-byte CLOB can give wrong results
    2533766 Wrong results from HASH JOIN over DBLINK between multibyte databases
    2616459 CHR() returns CHR(0) when NLS_SORT is set
    2635990 Java mappings for IANA character sets missing
    2649659 Invalid data in OCI7 client in non-blocking mode with NLS conversion
    2656881 LOB data corrupt after migrating DB from single -> multibyte
    2675123 Client gets no data in some cases when NLS_LANG is UTF8
    2682894 ORA-1424 from LIKE expression on multibyte non-shifting character set
    2695425 CONVERT() CLOB to a multibyte characterset gives corrupt result

    Optimizer
    2444517 ORA-918 possible with "_subquery_pruning_enabled"=true
    2470864 UPDATE may not update all rows if CHECK CONSTRAINT compares columns
    2474630 optimizer_dynamic_sampling >1 forces CBO
    2487808 Poor join cardinality if both columns have histograms
    2489405 Re-ANALYZE after DELETE / UPDATE to NULL may get bad column statistics
    2534430 Poor plan possible from OR-expansion
    2539837 Wrong results using FIRST_ROWS_N with > 5 tables in FROM clause
    2542139 Long parse times possible if _B_TREE_BITMAP_PLANS=TRUE
    2603036 ORA-6533 gathering stats for partitioned table with DBMS_STATS
    2629376 DBMS_STATS has inaccurate estimation of NDV for small sample sizes
    2652654 DBMS_STATS can produce poor NDV column statistics
    2660592 CBO may needlessly evaluate bitmap plans for Domain indexes

    Parallel Query (PQO)
    2175150 ORA-7445 [kcbldrcls] and ORA-10387 possible with parallel query
    2333947 Wrong results possible from PQ on PARTITIONED table
    2442125 Wrong results from PQ which compares a CHAR column to a BIND variable
    2498399 OERI:[KXFPRDP:1] / ORA-10388 if node is shutdown as PQ starts
    2524784 PQ on RAC may crash the instance with OERI[KSLPSPR1]
    2533038 PARALLEL_ADAPTIVE_MULTI_USER load calculation sensitive to IDLE sessions
    2569154 Wrong results from PQ with NL of BITMAP INDEX with ROWID predicate
    2618958 File descriptor/handle leak from IPQ slaves over IPC
    2618998 Dump from PDML with MONITORING on single partition
    2664654 Unnecessary partition access during PQ with NL join to partitioned table

    Query Rewrite (including Materialized Views)
    2157903+ MOVE of MVIEW corrupts the data or dumps (ORA-7445 [qerltRop] or similar)
    2536041+ OERI[KKQSADJP-1] with QUERY_REWRITE_ENABLED=TRUE
    2328821 CREATE MATERIALIZED VIEW .. WITH GROUPING SET does not work after upgrade from to 9i
    2375621 MATERIALIZED View dumps if only remote tables inside inline view
    2395714 SQL with subqueries may be slow after query rewrite
    2533616 Materialized view refresh can use lots of CPU
    2544257 Query rewrite only rewrites one branch of GROUP BY UNION ALL statement
    2547290 Refresh of Materialized View over DBLINK wastes memory (ORA-4030)
    2557893 ORA-7445[qsmmecin] from rewrite of nested subquery with correlation
    2605240 Row cache lock contention updating table with MATERIALIZED VIEW LOG in RAC
    2616047 DBMS_METADATA does not show full query of Materialized view if TEXT > 4000
    2662211 FAST REFRESH of MV with subquery may be very slow

    Star Transformation
    2499014 STAR_TRANSFORMATION_ENABLED=TRUE can generate unnecessary semijoin subqueries
    2559375 Wrong results from STAR_TRANSFORMATION_ENABLED due to transitively generated predicates
    2711788 Wrong results possible from STAR transformation with OR predicates

    Star Transformation with Temp Tables
    2522549 Wrong results possible with STAR_TRANSFORMATION_ENABLED=TRUE
    2540375 ORA-918 possible with STAR_TRANSFORMATION_ENABLED=TRUE
    2550212 'TEMP TABLE GENERATION' can give very poor query performance
    2698687 Dump in qes3tCleanLockInfo from temp table transformation
    2708898 STAR_TRANSFORMATION with a WINDOW function may dump (evaopn2)
    2767539 Dump (in qerpxStart) possible from TEMP TABLE TRANSFORMATION with WINDOW function

    Triggers
    1955577 Dump (in KOKEIS) using BINDS if TRIGGER updates nested table column
    2078899 OERI[4814] / OERI[kkdlgon4] on startup with DDL in SYSTEM TRIGGER
    2473741 Before row update trigger may not fire for MERGE statement
    2646865 ORA-7445 [INSBRP] from INSERT .. RETURNING with a trigger
    2648289 ORA-7445 [kkmdel] deleting from a table with BEFORE DELETE trigger



    How things are Stored / Defined


    Bitmap Indexes
    2451259 ORA-28604 on recreate of BITMAP index on COMPRESSED table
    2536531 MERGE on table with BITMAP index fails with OERI:[kauins:1]
    2556294 ORA-7445[kkocfcc] possible using Bitmap Join Index
    2569154 Wrong results from PQ with NL of BITMAP INDEX with ROWID predicate

    Compressed Key Index / IOT
    2566356 ONLINE MOVE of KEY-COMPRESSED IOT corrupts the IOT
    2629193 OERI:[711]..[KDIFXS - PREFIX CONTEXT] selecting COMPRESSed key IOT

    Compressed data storage
    2451259 ORA-28604 on recreate of BITMAP index on COMPRESSED table
    2474106 COMPRESSION information not shown in dictionary views
    2501800 ORA-7445 [kdblailb] from Direct path load into a COMPRESSed table
    2553074 ORA-12996 should always occur ALTER TABLE DROP COLUMN after COMPRESS

    Domain Indexes
    2467216 MERGE/SPLIT partition with LOCAL DOMAIN indexes and UPDATE GLOBAL INDEXES dumps
    2526334 OERI:25012 from AND EQUAL with B-Tree and DOMAIN index
    2628799 Blank data from Domain Index only scan fetching PK only for IOT
    2631842 DBMS_ODCI.ESTIMATE_CPU_UNIT results loose accuracy
    2660592 CBO may needlessly evaluate bitmap plans for Domain indexes

    External Tables
    2662576 EXTERNAL TABLE select may fail with OERI:[KPXSDPINIT_02]

    Function Based Index (including DESC indexes)
    2468542 ORA-7445 [EVAOPN2] with DECODE predicate involving FUNCTIONAL index
    2477249 Wrong results / Dump from INSERT AS SELECT with GROUP BY using FUNCTIONAL INDEX
    2607029 High memory use optimizing SQL with functional indexes and many expressions

    Index Only Tables (IOT)
    2566356 ONLINE MOVE of KEY-COMPRESSED IOT corrupts the IOT
    2628768 ORA-922 possible with OVERFLOW and VARRAY clauses on an object IOT
    2628799 Blank data from Domain Index only scan fetching PK only for IOT
    2629193 OERI:[711]..[KDIFXS - PREFIX CONTEXT] selecting COMPRESSed key IOT
    2707304 OERI:17059 / OERI:kqlupd2 / PLS-907 after adding partitions to Partitioned IOT
    2718814 DML/Rollback problems with SUPPLEMENTAL LOG GROUP on IOT

    Oracle Disk Manager
    2580111 CREATE DATABASE fails with ODM when DB_BLOCK_SIZE=32K

    Partitioned Tables
    2333947 Wrong results possible from PQ on PARTITIONED table
    2339666 Parallel MERGE into composite partitioned table not performant
    2467216 MERGE/SPLIT partition with LOCAL DOMAIN indexes and UPDATE GLOBAL INDEXES dumps
    2473601 OERI:[qkaPIdsqkn1] possible from index-join on partitioned tables
    2526164 SDO has poor query performance with large partitioned tables
    2541038 Streams / Logical standby get corrupt/missing data for row migrated partitioned LOB columns
    2552982 PRUNING does not occur on CONCAT KEY PARTITION with INLIST and range on keys
    2592966 OERI:[qkaPIdsqkn1] from AND EQUAL against partitioned table
    2606090 ORA-7445[LNXN2COPT] is pruning predicate contains subquery
    2617877 ORA-7445 [kkehbs] possible querying partitioned table
    2618998 Dump from PDML with MONITORING on single partition
    2625279 OERI[6763] during ANALYZE TABLE .. ESTIMATE STATISTICS with concurrent DROP
    2626347 OERI:17059 accessing view after ADD / SPLIT PARTITION
    2636685 Hang / OERI:[17059] after adding a list value to a partition
    2664654 Unnecessary partition access during PQ with NL join to partitioned table
    2707304 OERI:17059 / OERI:kqlupd2 / PLS-907 after adding partitions to Partitioned IOT
    2729673 Wrong result from COMPOSITE PARTITIONING, INLIST and GLOBAL INDEX

    Space Management - Bitmap Managed Segments
    2531519 OERI:[25012] from parallel direct load of bitmap managed segments
    2619867 OERI:[KCBGTCR_12] / ORA-8103 / ORA-1410 SELECTing from bitmap managed segment
    2676912 OERI[KTELRWI-2] from CREATE UNIQUE INDEX with Bitmap managed segment
    2685269 OERI[ktspstchg-1] on DELETE from bitmap managed table/index

    Space Management - Locally Managed Tablespaces
    2569255 OERI:KCBGTCR_5 dropping segment upgrade from 8i



    Net / Connectivity / Authentication / Distributed


    Advanced / Secure Networking
    2542487P Win: Rapid connect/disconnect not possible with Kerberos
    2171847 KERBEROS adapter cannot handle Windows 2000 tickets
    2392264 Kerberos adapter cannot get a ticket from a MS KDC user with >= 75 groups
    2666840 Certificate with CN greater than 64 bytes rejected

    DB-Link / Distributed
    2642168* Buffer overflow vulnerability with CREATE DATABASE LINK
    This bug is alerted in Note 237172.1
    1829296 False ORA-980 from PLSQL referencing SYNONYM which uses a DBLINK
    2374041 OERI[QERSQCLOSE-1] selecting REMOTE sequence from empty local table
    2425312 ENH: Include PLSQL RPC information in 10046 trace
    2438953 OERI[KCBGCUR_2] / OERI[6856] from RECO in RAC/OPS
    2448925 ORA-4030 from CTAS of CLOB over DBLINK from non_UTF8 -> UTF8
    2452537 SELECT of remote sequence leaks cursors (ORA-1000)
    2487248 Dump / memory corruption if Event 10129 is set for a distributed query
    2490061 ORA-932 for remote SQL using TIMESTAMP datatype
    2519148 Memory leak from PLSQL RPC to an older database version in a LOOP
    2533616 Materialized view refresh can use lots of CPU
    2533766 Wrong results from HASH JOIN over DBLINK between multibyte databases
    2545840 Distributed query may see remote changes from AFTER the snapshot SCN
    2567290 Large packet over DBLINK may fail with ORA-12539
    2572944 SELECT over 8i -> 9i DBLINK may fail with ORA-7445 [opidsi]
    2576353 ORA-7445[qxopqgcd] from remote query with user defined function
    2599290 OERI from 8.0 client querying NULLs and LONG over 9i -> 9i DBLINK
    2608776 ORA-3106 in 8.0 client SELECTing pseudo column from 9i server over DBLINK
    2622558 XA Open option to close precompiler cursors on XA_END (avoid ORA-24779 errors)
    2641473 OERI[OPIXRB-4] from V7 client binding SQLT_RID to 9.2 table over DBLINK
    2658212 OERI:[KKCHBYT] possible with _keep_remote_column_size = TRUE
    2694605 ORA-3118 possible when PLSQL executed over a DBLINK
    2696120 OCCI client dump (kpuhhalo) on Commit/Rollback if using DML over DBLINK
    2698435 Repeated OERI:18260 / OERI:18186 if XA DBLINK errors at commit
    2701820 OERI[18250] / dump using migratable database links

    Gateways / Heterogeneous Services
    2590687 DML over HS may dump
    2599708 Newer HS agent causes the older RDBMS server to fail

    Interoperability (between releases)
    2261722 8i export of 9i database dump (in koputilassert) with SUBTYPE / NOT FINAL type
    2517719 ORA-3115 from setTimestamp() in JDBC 9.2 with an 8.0 database
    2519148 Memory leak from PLSQL RPC to an older database version in a LOOP
    2551933 ORA-7445[ttcclr] from V7 protocol client
    2563206 CLOB data is corrupted when inserted from an 8.0 client to multibyte 9.2 server
    2572944 SELECT over 8i -> 9i DBLINK may fail with ORA-7445 [opidsi]
    2599290 OERI from 8.0 client querying NULLs and LONG over 9i -> 9i DBLINK
    2608776 ORA-3106 in 8.0 client SELECTing pseudo column from 9i server over DBLINK
    2641473 OERI[OPIXRB-4] from V7 client binding SQLT_RID to 9.2 table over DBLINK

    Network
    2540219* Listener denial of service vulnerability
    This bug is alerted in Note 213411.1
    2431526 Failover: ORA-1089 possible from shutdown IMMEDIATE
    2436572 FAILOVER: ORA-1 possible after FAILOVER during SELECT of an XMLType
    2655865 Re-registering services after listener reload can take 60 seconds

    Security ( Authentication / Privileges / Auditing )
    2479882 Permission changes may not propogate to all nodes
    2523151 ORA-7445[updexe] with AUDIT_TRAIL=DB with stressed shared pool
    2652538 ORA-7445 [kkkiprpriv] during GRANT/REVOKE in trusted callout

    Transparent Application Failover
    2496780 TAF client may dump if failover occurs during SELECT of LONG column
    2542693 Repeated ORA-0000 after failover
    2605435 Client memory leak on TAF connection
    2652845 SQLPLUS client may get ORA-25402 after TAF failover if no previous SQL issued
    2686200 FAILOVER dumps if OCI_ATTR_INTERNAL_NAME / OCI_ATTR_EXTERNAL_NAME set in UTF16 client

    XA / Distributed Transactions
    2191497 XA_END in PRO fails with ORA-24779 when using a DBLINK after an error
    2497219 OERI:[17065] / OERI:[17064] from XAOROLLBACK with AQ in OPS/RAC
    2511780 Add JDBC XA support for LOOSE transactions
    2622558 XA Open option to close precompiler cursors on XA_END (avoid ORA-24779 errors)
    2638483 XAER_RMERR returned on XA_COMMIT instead of XA_RETRY
    2659833 Client side errors during JDBC XA operations are ignored
    2678338 Heuristically commited/rollback cases are not handled by JDBC XA (ORA-24756)
    2698435 Repeated OERI:18260 / OERI:18186 if XA DBLINK errors at commit



    Database Options / Major Features


    Physical Standby Database / Dataguard
    2539160 ORA-16139 on "switchover to primary"
    2542609 Corruption from CANCEL of managed standby if primary is RAC
    2605652 STANDBY database may get ORA-338
    2632802 LGWR ASYNC or SYNC=PARALLEL archival may cause ORA-332 on STANDBY
    2643872 OERI:[KCRRNSFWA.2] possible
    2644178 Physical standby may fail with ORA-354 if primary archival fails
    2646214 In ASYNC mode LGWR may send a large number of messages
    2654862 Open of standby in READ ONLY mode may fail after upgrade (ORA-16000)
    2683226 LGWR ASYNC transport over WAN degrades throughput
    2722482 Better ALERT log message for LGWR ASYNC buffer full condition
    2736013 LGWR network IO optimization
    2740929 New STANDBY recovery may fail with ORA-16016

    Advanced Queuing
    2381172+ IMPORT fails / corrupts the AQ dictionary with duplicate QUEUE_TABLE names
    2298215 AQ dequeue can intermittently take seconds to dequeue
    2370520 EMON hang - message notifications not delivered
    2486477 "buffer busy waits" on very active Queue table (IOT)
    2490090 Propogation stops if queues are recreated and enqueuing session does not reconnect
    2497219 OERI:[17065] / OERI:[17064] from XAOROLLBACK with AQ in OPS/RAC
    2543395 RETRY_COUNT not incremented when DEQUEUEING session dies
    2573516 When DEQUEUE rolled back other sessions do not see the message immediately
    2598124 EXP-8 / ORA-1422 if queue and queue table have same name

    Change Data Capture
    2362606 DBMS_CDC_PUBLISH.PURGE does not purge the change table

    JavaVM / JSP / Corba etc..
    2185189 OERI[26599] possible executing DBMS_JAVA.SERVER_STARTUP
    2460091 ORA-7445[pgmbiad_build_input] if PLSQL calls Java callout with a TIMESTAMP parameter
    2503614 PLSQL calling JSP with TIMESTAMP argument dumps
    2627474 Wrong results from CURSOR expression in JSP if first column is an ADT

    Job Queues
    2649244* JOBS may not run at scheduled intervals
    This bug is alerted in Note 228059.1

    LogMiner
    2537320 SQL_REDO for large LOB operations is not executable
    2590317 OERI:[krvxrptl:Cannot delete current l] selecting from V$LOGMNR_CONTENTS
    2656036 OERI/memory corruption selecting SQL_REDO for CLOB DMLS
    2666229 Log mining of LOB DMLs fails
    2683363 Incorrect translation of TEMPORARY TABLE DMLs in LogMiner
    2683414 Logminer may use excessive memory selecting redo for LONG columns
    2685942 OERI/dump possible minig LOB redo
    2691486 Mined data loss possible from LOB ERASE/TRIM/WRITE redo
    2707212 Memory leak from long running log mines

    Oracle Label Security
    2735964 SA_USER_ADMIN.ADD_GROUPS() fails when given IN_DEF and IN_ROW

    Oracle OLAP
    2510750 ORA-35810 running XUMUTS.PLB on UTF8 database

    Oracle Text (formerly interMedia Text)
    1839270 Setting FILE_DATASTORE over 260 characters can corrupt server memory
    2274954 BASIC_LEXER CONTINUATION does not work for DOS documents with CR-LF line breaks
    2375782 NEAR operator may not return rows with several terms
    2464264 Dump / wrong results from Japanese Lexer with doublebyte punctuation
    2474192 OERI:[OPIBND1] on CREATE of TEXT INDEX with CURSOR_SHARING
    2489881 DRG-50603 indexing WORD in two LANGUAGES with MULTI_STOPLIST and PREFIX_INDEX
    2514079 Import of ALTERED CTXRULE index can fail with DRG-11000
    2537672 UPDATE on XMLtype column which has an XPATH index may dump
    2569357 Korean lexer does not remove QUOTES around tokens with WILDCARDS (%)
    2601175 Wrong results for German sharp-s with BASE_LETTER and ALTERNATE_SPELLING
    2601447 CTX_DOC.GIST() fails with DRG-10001
    2605166 OERI:koksctri1 during create TEXT index on EXTRACT() expression
    2610068 '_' character treated as a WILDCARD for CTXCAT indextype
    2617683 Query optimization may use more CPU than needed with fuzzy operators
    2629794 Parallel SYNC of TEXT index may be slow
    2636886 DRG-50603 from CTX_DLL.SYNC_INDEX with MULTI_STOPLIST index
    2663986 Missing rows querying CTXRULE index in sections (eg: 'CAT WITHIN MAMMAL')
    2676316 Poor performance / ORA-14098 after EXCHANGE PARTITION with TEXT index
    2684307 Mixed tokens not uppercased with BASE_LETTER in multibyte database
    2706319 CJK Lexers do not support AL32UTF8 surrogate pairs or private use characters
    2765871 Not all THEMES identified for documents with large paragraphs

    Oracle Text INSO Filters
    2661541 INSO_FILTER for BEQUEATH connections may fail with dynamic linker errors on Unix

    RAC (Real Application Clusters)
    2448663P AIX: Cannot startup RAC instance if LANG=Ja_JP
    2620053P AIX5L: Corrupt blocks (ORA-1578) possible when shutdown RAC node
    2695783P Win: OERI:[KCCSBCK_FIRST] possible if Oracle & CM restarted
    2438953 OERI[KCBGCUR_2] / OERI[6856] from RECO in RAC/OPS
    2479882 Permission changes may not propogate to all nodes
    2496772 ENH: Allow RAC load balancing by session counts rather than load
    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
    2499023 Diagnostic dump performed on SHUTDOWN ABORT of RAC instance
    2516493 LMS may dump with OERI[KJBRWRDONE:!W]
    2524784 PQ on RAC may crash the instance with OERI[KSLPSPR1]
    2542609 Corruption from CANCEL of managed standby if primary is RAC
    2560353 PQ load module may produce repeated name service publish requests
    2563162 Crash recovery may hang in RAC
    2580238 Reduce CPU usage of multiple DBW processes with RAC
    2594172 LMS may die with OERI:[KJBMPUPMASTER:DS]
    2605240 Row cache lock contention updating table with MATERIALIZED VIEW LOG in RAC
    2618958 File descriptor/handle leak from IPQ slaves over IPC
    2630846 In RAC the library cache pin owner list is not maintained correctly
    2633268 OERI:[kclwcrs_15] possible
    2649033 LMON may crash instance with ORA-227 errors
    2652409 False ORA-60 possible in RAC / OPS environments
    2654246 Hang possible in OPS due to local converts not occurring
    2657312 Under-posting of RAC receive buffers
    2689585 LMS might encounter ORA-600[504] during the simultaneous shutdown
    2695517 CR may SPIN after an instance crash
    2695916 LCK PGA memory leak - may crash instance
    2712701 Increased diagnostics for long enqueue timeouts in RAC

    Replication
    2601708 Parallel propogation may hang

    Row Level Security / FGA
    2484754 Cannot drop policy in a non-existent group or with name starting "DEFAULT"
    2615477 FGA audit trail may show invalid statement type in DBA_FGA_AUDIT_TRAIL

    Shared Server (formerly MTS)
    2640528P DBMS_LDAP.SIMPLE_BIND() fails in MTS mode with > 64 connections
    2567290 Large packet over DBLINK may fail with ORA-12539
    2701820 OERI[18250] / dump using migratable database links
    2728916 SGA memory for NETWORK BUFFERS increased (over 9.0)

    Spatial Data
    2689563+ Spatial Option not completely upgraded after running 9202 CATPATCH.SQL script
    2526164 SDO has poor query performance with large partitioned tables
    2531403 ORA-13249 creating SPATIAL index on attribute of object table
    2545415 ORA-29902 from VIEWPORT_TRANSFORM
    2548412 INTERSECTION containing ARCS may dump
    2582293 SYNCHRONIZE after DEFERRED may fail after UPDATES
    2588406 ARC validates ofter failing (ORA-13349) with smaller tolerance
    2592406 Dump possible SYNCHRONIZING a DEFERRED spatial index
    2622496 SDO_RELATE returns wrong results on ARCS with reasonable tolerance
    2626372 INTERSECTION of POLYGON with HOLE and POLYGON returns NULL
    2633138 Dump from SDO_RELATE with convexhull
    2637320 Dump from SDO_CONVEXHULL
    2638946 Creation of local partitioned spatial index may fail
    2653232 Spatial queries can exceed CPU RESOURCE_LIMIT as CPU not updated
    2669515 VALIDATE GEOMETRY may dump
    2671089 UNION of GEODETIC GEOMETRIES returns INVALID GEOMETRY (ORA-13349)
    2673154 SDO RELATE may show different relationships depending on TOLERANCE
    2679773 "CREATE INDEX ... LOCAL UNUSABLE" should create dummy indexes
    2682980 Add DBMS_PCLXUTIL to support parallel spatial index build
    2685914 SDO_WITHIN_DISTANCE may return wrong answer for geodetic data
    2685976 SDO_RELATE with SDO_BUFFER AROUND WINDOW gives wrong answer
    2692602 OBJECT tables cannot be indexed by SDO
    2694899 "ALTER INDEX REBUILD PARTITION <NO PARAMETERS>" should use previous parameters
    2696860 Wrong results from SDO_WITHIN_DISTANCE for MULTI-POINT Geometry when parallel to the axis
    2723677 ORA-955 adding a partition to a spatial table with a LOCAL SPATIAL index
    2727824 SDO_WITHIN_DISTANCE fails with 2D window against 3D data indexed 2D

    Spatial RTREE
    2768576+ SDO_RELATE (point - line) for CONTAINS on RTREE returns WRONG RESULT
    1941373 SDO_TUNE functions show no output for RTREEs
    2534045 OERI:kghuichk_07 using SDO_RELATE against RTREE with Circular Arc Geometry
    2671434 SDO_RELATE can be very slow with RTREE

    Streams / Logical Standby
    2376027 SUPPLEMENTAL LOG GROUP has a limit of 33 columns (ORA-2257)
    2541038 Streams / Logical standby get corrupt/missing data for row migrated partitioned LOB columns
    2552188 Certain DDLs can cause capture to die (OERI:KNLCFGETOBJINFO:GTA)
    2560808 Logical Standby apply slaves leak memory in Max Availability mode
    2615349 PQ traces generated in Streams / Logical Standby
    2621671 Memory leak in logical standby
    2623859 ORA-1400 possible during DBMS_APPLY_ADM
    2623931 Capture may not start after upgrade from 9201 to 9202
    2641682 Logical standby apply skip DDL may not skip all operations and error/stop
    2644200 Logical standby may stall with large DDL transactions
    2644381 Streams with log shipping stalls
    2654469 Streams capture does not handle EMPTY_LOBS properly
    2662771 Logfiles not registered with logical standby logminer session
    2666229 Log mining of LOB DMLs fails
    2691474 Lowering MAX_EVENTS_RECORDED does not free rows in DBA_LOGSTDBY_EVENTS
    2691486 Mined data loss possible from LOB ERASE/TRIM/WRITE redo
    2692936 Apply engine may hang
    2693159 Fetch slave may hang
    2694760 ORA-1405 from DBMS_STREAMS_ADM.ADD_SCHEMA_RULES etc..
    2701643 OERI [krvxmds_MemberDictSet]/ORA-7445 mining redo from upgraded database
    2702392 Hang / dump possible mining redo
    2709359 Dump/errors restarting logical standby with AGE SPILL data present
    2715979 Apply may fail for tables with PRIMARY KEY DEFERRABLE
    2718814 DML/Rollback problems with SUPPLEMENTAL LOG GROUP on IOT
    2728053 Logminer checkpointing may not happen for long time
    2732343 Streams capture update of LOB data > 32K gives wrong length on APPLY
    2736124 DBA_APPLY_ERROR.MESSAGE_COUNT value incorrect
    2736672 LSP0 failure may crash instance

    Transportable Tablespaces
    2347596 Transport of OBJECT table may get index in wrong tablespace
    2518758 ORA-1460 IMPORTING metadata for TRANSPORT of table with LONG column
    2544428 Export may write bad LOB storage clause for TRANSPORT (ORA-22850 on IMPORT)
    2544536 Transportable tablespace export may produce bad export
    2551267 OERI:[kkdxptcn1] during TRANSPORT import of tables with LONG columns
    2555141 OERI:[PITL1] using an TRANSPORTED table created in 8i (or earlier)
    2556845 ORA-955 / ORA-14452 running concurrent transportable tablespace exports
    2563296 Import may fail with server ORA-7445[kfpchkchar]

    XDB
    No Bug#+ 9.2.0.3 is a mandatory minimum patch level for XDB
    2332184 ORA-7445[kope2upic] from XML.ToObject()
    2334377 Memory Leak from TABLE subquery against XMLType
    2337501 Repeated elements with non-identical types cannot be handled
    2412825 Listing an XDB folder may be very slow
    2483617 DBMS_XSLPROCESSOR.SELECTNODES may dump in qmxGetNumChildren
    2486954 ORA-4031 / Dump from concurrent DGURIServlet access to SQLX XMLType view
    2491404 Cannot find files with multibyte names (with a "\" byte)
    2535425 XDB wrong result possible from EXISTSNODE with "/*"
    2537917 OERI:729 possible with XDB
    2553163 XDB may dump in QMUBANINS
    2558798 Add indexes to XDB$RESOURCE improve XDB performance
    2587723 OERI:[kolasaWrite-3] / OERI:[ksmovrflow] possible with XDB
    2587768 XDB internal fix
    2591551 OERI:[qesmmaLogUnResSpc1] with XDB
    2595396 Dump in KGEADP possible with XDB
    2600262 XDB may not show correct content of XMLType column
    2605166 OERI:koksctri1 during create TEXT index on EXTRACT() expression
    2611590 OERI:[17003] running XDBRELOD.SQL
    2615657 XMLTYPE is always pickled as LOB/TEXT (never ADT)
    2616549 OERI:QMR_CB_PR1 possible in XDB
    2619800 XML files with non-default extensions not treated as XML in XDB
    2621345 Using IOTs for NESTED TABLES wastes space in XDB
    2622151 Incorrect query rewrite of XPATHS on schemas with Subs groups
    2622913 OERI:[qmtsSetTypeInfo9] possible
    2642976 Memory growth on INSERT of XMLTYPE
    2648408 OERI:[QMTSGETCOMPLEXINFO1] on RegisterSchema
    2676936 DBMS_XMLDOM, DBMS_XMLPROCESSOR not NAMESPACE aware
    2678676 ProcessXSL / Transform truncates output at 4000 characters
    2687401 XDBSCHEMAs may not be imported to correct schema
    2712908 Create VIEW may hang creating view over XMLSEQUENCE
    2719085 Poor performance / memory use of SQL/XML operators
    2721749 Directory style operations slow on documents with subtypes
    2721864 SELECT of XMLType slow
    2744798 DBMS_XMLGEN.NEWCONTEXT with a REFCURSOR leaks memory



    Programming Languages


    JDBC
    2121433 ORA-1401 after type change between two AddBatches
    2379746 Multibyte data corrupted by setPlsqlIndexTable()
    2498661 getMetaData() throws NullPointerExeception if statement not executed
    2509105 JDBC with pooled OracleConnection slower in 9i than 8i
    2511780 Add JDBC XA support for LOOSE transactions
    2517719 ORA-3115 from setTimestamp() in JDBC 9.2 with an 8.0 database
    2543401 JDBC thin throws an Exception for wrong username/pwd with encryption enabled
    2548088 Connection URL & user name not in DMS Statistics
    2550971 NullPointerException from defineColumnType executed twice in KPRB
    2589186 Empty Timestamp is returned for NULL column value
    2608837 JSSL close of layered socket does not close base socket
    2623740 sendBatch() method may return incorrect row count
    2646101 Data corruption binding a JDBC TEMP CLOB into an NCLOB column
    2654607 OERI binding NULL REF type from JDBC Thin
    2657221 JDBC spins using Scrollable ResultSet with ORDER BY
    2659833 Client side errors during JDBC XA operations are ignored
    2678338 Heuristically commited/rollback cases are not handled by JDBC XA (ORA-24756)
    2684915 CHAR.toString returns HEX values if input has invalid character
    2691131 set/getConnectionProperties not in OracleDataSource.
    2696397 Blob.length() fails when selected with a Stream type (LONG, LONG RAW)
    2698190 Retain STACK trace for JDBC XA errors with fix for BUG 2659833
    2700006 JDBC Thin "Unexpected Packet" error with LOBS in multithreaded client
    2723384 ORACLE.SQL.CLOB.CREATETEMPORARY can leak TEMP LOBS
    2739638 ArrayIndexOutOfBoundsException from defineColumnType

    OCCI
    2519017 OCCI:RESULTSET.GETOBJECT() dump for NULL objects
    2696120 OCCI client dump (kpuhhalo) on Commit/Rollback if using DML over DBLINK

    OCI
    2598387* Export / OCI clients using prefetch may see corrupt data
    This bug is alerted in Note 223399.1
    2645455+ Control characters are trimmed from bind variables
    1130195 OCIBindByPos "curelep" parameter wrong if PLSQL deletes elements of C array
    1850169 ORA-1405 occurs if OCIBindDynamic() used for NULL PLSQL OUT bind
    2019207 DYNAMIC bind callback functions not called properly with RETURNING clause
    2227982 OCIIntervalSetYearMonth() may produce ORA-1873 errors
    2235818 The SCALE of a NUMBER with no SCALE specified shows as 0
    2448939 OCICacheFlush stores objects as the base type instead of the SUBTYPE
    2449486 OCI_ATTR_CLIENT_IDENTIFIER attribute cannot be cleared once set
    2510357 ODESCR dumps with unaliased column expression length >= 960 chars
    2514005 Client may dump (kpurst) when calling OCIBreak / OCIReset
    2517189 Handle leak on repeated CONNECT/DISCONNECT in OCI_THREADED mode
    2539277 Client dump possible (ttcSetBuf) during fetch
    2616833 Non blocking OCI may not show error text for user PLSQL errors (ORA-20000-ORA-20099)
    2624452 Redefinition of buffer length with OCIDefineByPos gets wrong no bytes for LONGS
    2635098 ODESCR may dump if unaliased column expression too long
    2641473 OERI[OPIXRB-4] from V7 client binding SQLT_RID to 9.2 table over DBLINK
    2649659 Invalid data in OCI7 client in non-blocking mode with NLS conversion
    2686200 FAILOVER dumps if OCI_ATTR_INTERNAL_NAME / OCI_ATTR_EXTERNAL_NAME set in UTF16 client

    PL/SQL
    2647211+ Implicit cursor FOR loop memory leak / CPU hit
    1130195 OCIBindByPos "curelep" parameter wrong if PLSQL deletes elements of C array
    1829296 False ORA-980 from PLSQL referencing SYNONYM which uses a DBLINK
    1850169 ORA-1405 occurs if OCIBindDynamic() used for NULL PLSQL OUT bind
    2093521 Memory leak using SAVE EXCEPTIONS with FORALL BULK operations
    2243411 PLS-597 from "FETCH..BULK COLLECT INTO"
    2399954 OERI:733 / OERI[KGHALF1] possible from PLSQL execution using many cursors
    2425312 ENH: Include PLSQL RPC information in 10046 trace
    2489526 PLS-801 [21076] / package corruption (in memory) recompiling PLSQL
    2503614 PLSQL calling JSP with TIMESTAMP argument dumps
    2506655 ORA-22921 using REPLACE() on a CLOB in PLSQL in UTF8
    2519148 Memory leak from PLSQL RPC to an older database version in a LOOP
    2556195 OERI:[SORPUT_1] / Wrong results using PIPELINED function in SQL
    2601203 ORA-3106 from INSERT .. RETURNING a NULL into a TIMESTAMP column
    2614464 ORA-979 from PLSQL query with TABLE() function and PLSQL bind in the GROUP BY clause
    2616833 Non blocking OCI may not show error text for user PLSQL errors (ORA-20000-ORA-20099)
    2627946 Error text of RAISE_APPLICATION_ERROR may be lost
    2685935 Deletion of associative array elemnent by KEY value does not work
    2694605 ORA-3118 possible when PLSQL executed over a DBLINK
    2702333 Memory leak using PLSQL associative array

    PL/SQL (DBMS Packages)
    2410688 DBMS_SQL.PARSE of VARCHAR2S needs higher line width limit
    2444186 OERI[PSDISA:SESNUM] passing an invalid ID to DBMS_SESSION.IS_SESSION_ALIVE
    2566659 ORA-1555 running DBMS_PCLXUTIL.BUILD_PART_INDEX
    2603036 ORA-6533 gathering stats for partitioned table with DBMS_STATS
    2616047 DBMS_METADATA does not show full query of Materialized view if TEXT > 4000
    2629376 DBMS_STATS has inaccurate estimation of NDV for small sample sizes
    2652654 DBMS_STATS can produce poor NDV column statistics

    PL/SQL External Procedures (EXTPROC)
    2642203* EXTPROC buffer overflow possible on LONG LIBRARY NAME
    This bug is alerted in Note 175429.1

    Pro* Precompiler
    1326752 ProCobol PCB-S-400, PCB-I-556 errors for "PROCEDURE DIVISION USING COPY XYZ"
    1810960 ProCobol signals PLS-103 errors for PLSQL GOTO labels in code
    2513269 PCC-S-2014 if a SPACE appears after "\" in #elif
    2573812 ProCobol generates bad code for CURSOR VARIABLES when COMP1=INTEGER
    2668683 Array binds to PLSQL blocks may ORA-1458 or no data is fetched
    2672965 Pro client dump (sqlrdf) if cursor used for both dynamic method 3 and 4
    2688717 Pro client mey get NULL rows with PREFETCH enabled
    2717317 Client memory leak from EXEC SQL CONTEXT ALLOCATE / FREE
    2765286 ORA-1458 from Pro ARRAY insert (9.2.0.2 only)
    2796974 MODADA clients may dump

    SQLJ
    1743466 False SQLJException "Invalid column name" with JDK 1.3

    XDK
    2438656 Oracle XML DOM parser does not parse correctly
    2495218 XDK for Java may fail with NullPointerException with multiple threads
    2502135 LPX-4 "Multichar overflow" possible parsing XML documents
    2701717 XML parser does not support setExpandEntityReferences(FALSE)

    XML
    No Bug#+ The 9.2.0.3 Patch Set contains XDK version 9.2.0.5
    2436572 FAILOVER: ORA-1 possible after FAILOVER during SELECT of an XMLType
    2537672 UPDATE on XMLtype column which has an XPATH index may dump
    2702942 DBMS_XMLDOM.APPENDCHILD() does not work properly
    2757613 SELECT XMLELEMENT() may fail with OERI:[kolasaRead-1.1]



    Product Related


    DBVerify Utility
    2348277 DBV/RMAN may incorrectly report completely zero blocks as corrupt
    2469314 DBVERIFY may dump when reporting a block corruption

    Export/Import
    2598387* Export / OCI clients using prefetch may see corrupt data
    This bug is alerted in Note 223399.1
    2381172+ IMPORT fails / corrupts the AQ dictionary with duplicate QUEUE_TABLE names
    2261722 8i export of 9i database dump (in koputilassert) with SUBTYPE / NOT FINAL type
    2435257 IMP-3 / ORA-1031 in SYS.DBMS.DDL if IMP_FULL_DATABASE granted via a ROLE
    2448243 Full export from non DBA user may fail with ORA-1031 in SYS.LT_EXPORT_PKG
    2461455 ORA-7445 [qcdlgtd] or ORA-942 from IMPORT FROMUSER / TOUSER
    2488590 EXP-8 ORA-3113 exporting large CREATE OPERATOR statement
    2508813 ORA-16000 exporting from READ ONLY database
    2514079 Import of ALTERED CTXRULE index can fail with DRG-11000
    2598124 EXP-8 / ORA-1422 if queue and queue table have same name
    2599613 IMP-60 possible when object already exists in database
    2619341 Export may contain invalid SQL for CREATE SYNONYM in FULL export
    2629652 PLS-302 'EXPORT_RULE_SET' must be declared from EXPORT
    2687401 XDBSCHEMAs may not be imported to correct schema

    Intelligent Agent
    2307005P Win: SQLPLUS job returns NMS-915 but no ORA error
    2490128P Sol: "PROCESS" class missing
    2596217P Sun: Capacity planner does not display ERI interface for Sun.58
    1473558 ALERT event triggered periodically when ALERT.LOG inaccessible
    1653586 DUMPFULL and DMPFULPCT events may fail without an error message
    1874903 Register ALERT event fails on OpenVMS
    2061886 CHUNKSML event test performs poorly on large databases
    2180332 TABLESPACE and SEGMENT details missing for MAX EXTENTS event
    2241006 DBSNMP dumps on startup if SNMP_RO.ORA too large
    2283515 TABLESPACE FULL event returns NMS-1005 / NMS-1078 for RAW device
    2288229 Invalid timezone returned by Agent to OMS on Linux
    2301903 ORA-1438 / ORA-1406 possible from ORAMOVELONG with large NUMBER columns
    2355062 DBSNMP.HOSTNAME not used by agent collection service
    2378422 Jobs fail when a PASSWORD_FILE is used
    2378428 DBSNMP.HOSTNAME should overrule HOSTNAME for discovery
    2423440 The "Chunk Small" event fails if the TABLESPACE not in DBA_FREE_SPACE
    2437916 AGENTCTL may dump on STOP AGENT command
    2438101 EMDDISCOVER fails on some platforms
    2440387 NMS-1078 evaluating a network mounted file system
    2445663 Small DBSNMP memory leak running jobs
    2467637 MIB value for oraDbSysParseCount cannot be queried
    2487889 Agent reports TNS-12538 errors for SQLPLUS jobs
    2506864 DBSNMPWD may die rather than restart DBSNMP

    LDAP / Oracle Internet Directory
    2640528P DBMS_LDAP.SIMPLE_BIND() fails in MTS mode with > 64 connections
    2382299 DBMS_LDAP_UTL may error for users not associated with "inetorgperson"
    2458526 OIDCA /createDefaultSubscriber fails
    2461769 DBMS_LDAP.normalize_dn_with_case does not do NLS translation
    2483741 OID allows object to be deleted multiple times without error
    2515844 Memory leak using PL/SQL and LDAP

    RMAN (Recovery Manager)
    2348277 DBV/RMAN may incorrectly report completely zero blocks as corrupt
    2484250 RMAN CUMULATIVE BACKUP / MAINTENENCE may appear to hang (spin)
    2534017 DELETE/REPORT OBSOLETE lists wrong BACKUPSET if it contains READ ONLY / OFFLINE tablespace
    2541360 V$BACKUP_SPFILE records can get corrupted / RMAN-10031
    2610596 Huge CPU usage from RMAN server when TAPE not mounted with BACKUP_TAPE_IO_SLAVE=TRUE
    2634796 Crash during RMAN "proxy copy" can leave database unopenable

    SQL*Loader
    2479354 Direct path load of column Objects give wrong results / dumps
    2501800 ORA-7445 [kdblailb] from Direct path load into a COMPRESSed table
    2513944 9i loader performance slow with multiple INTO clauses with failed WHEN clauses
    2729655 Direct load of PARTITION may not update bitmap index

    SQL*Plus
    2581911* iSqlplus buffer overflow vulnerability
    This bug is alerted in Note 216775.1
    1854041 SQLPLUS GUI may dump with increased LINESIZE
    2097904 Zeroed out AUTOTRACE statistics shown when connected as SYSDBA
    2157907 SQLPLUS select of CLOB/NCLOB Unicode surrogate pairs shows incorrect data
    2387804 STARTUP command with invalid option reports internal error (SP2-642)
    2471872 Quoted parameter to SQLPLUS is ignored
    2480427 Setting AUTOTRACE in iSqlplus in the System Variables page does not show errors
    2494108 Multi line heading output order wrong with SET MARKUP HTML PREFORMAT ON
    2538083 SQLPLUS /NOLOG fails with SP-2 when NLS_LANG is HEBREW_ISRAEL
    2652845 SQLPLUS client may get ORA-25402 after TAF failover if no previous SQL issued

    Ultra Search
    2650812 Multiple "/" in URL from HTTP redirection
    2673282 WKG-30008 crawling a FILE-DATASOURCE with > 127 character FILENAME
    2695209 CRAWLER may not find files in a directory in file data store
    2709760 MAKE of sample fails with portal_global_code.jsp cannot be read

    Wallet Manager
    2494999 Wallet Manager will not import CA certificate
    2623513 Wallet Manager hangs importing CERTIFICATE with BMPSTRING encoding



    Miscellaneous


    Large file / memory issues (Eg: 2Gb)
    1668488P NT: Cannot AUTOEXTEND to 4Gb boundary - full restore required
    2729107P SGA cache > 2GB prevents instance startup

    NUMA Related
    2587650P Tru64: Restrict Oracle to subset of processor groups

    Miscellaneous
    2404397P Tru64: Increase file descriptor limit to 64K
    2654576P HP: Connect may fail with many processes
    2398069 Unnessesary "SEARCH IN KDISTI..." trace file messages
    2529763 Rename of 9.0.1 OMF file fails with ORA-1276
    2710910 ALL_SOURCE, USER_SOURCE and DBA_SOURCE views are slow

    9203 Special Notes (if any)


    No Bug# +     Fixed: 9203
    There are a number of XDB fixes in 9.2.0.3.
    The 9.2.0.2 fixes are NOT listed in the README.
    9.2.0.3 is considered a mandatory patch level for the use of XDB.
    

    No Bug# +     Fixed: 9203
    The 9.2.0.3 Patch Set contains XDK version 9.2.0.5.
    Not all of the XDK bug fixes are listed in the Patch Note.
    

    End of 9.2.0.3 Fix list
    .

    Copyright © 2005, Oracle. All rights reserved. Legal Notices and Terms of Use.