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

Bugs fixed in the 9.2.0.2 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.2 Patch Set. These fixes are also included in 9.2.0.3 onwards. 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.2 Patch Set

Fixed Bug# Security Alert# Document Summary
9.2.0.2 2395416 Sec. Alert#40 Note 207269.1 Net overrun security vulnerability
9.2.0.2 2467947 Sec. Alert#38 Note 207268.1 LISTENER vulnerability

9.2.0.2 Bug Categories



    9.2.0.2 Bug Fixes by Category



    Symptom


    Corruption (Dictionary)
    2371453+ CREATE OR REPLACE SYNONYM can lead to inconsistent dictionary (old IDL data)
    2161360 DROP of OPERATOR corrupts dictionary - ORA-29836 on ALTER INDEXTYPE
    2286290 ALTER TABLE MOVE should not be allowed for Queue tables
    2377630 OERI[5106] / dictionary corruption on concurrent ADD DATAFILE & DROP TABLESPACE
    2380475 Dictionary corruption from CREATE OR REPLACE SYNONYM on TYPE
    2405258 Dictionary corruption / OERI:15265 from MOVE LOB to existing segment name
    2498186 DEPENDENCY$ corrupted on ALTER INDEXTYPE
    2515703 Dictionary corruption from concurrent partitioned IOT maintenance

    Corruption (Incorrect / missing corruption checks)
    2373145 DBVERIFY does not identify fractured blocks
    2432864 DBVERIFY does not work properly on RAW or for different BLOCKSIZE

    Corruption (Index)
    2215837 OERI:6100 / index corruption possible on compressed key index
    2299909 ARRAY UPDATE can cause TABLE / INDEX inconsistency

    Corruption (Logical)
    1733957 Array interface deletes too many rows with correlated subquery
    2014766 Java TRIGGERS do not set :NEW variables to the new values
    2025426 Bad number data / NumberFormatException with leading 0's in number string in JDBC
    2197703 Update of LONG with PLSQL BULK BIND can update incorrectly
    2232548 VARRAY number columns are not rounded / truncated
    2245006 OCCI populating NESTED TABLE / VARRAY > 245 elements inserts corrupt data
    2259466 PLSQL: Assigning one VARRAY to another produces corrupt VARRAY - ORA-6533 / OERI:KOPE2_READSTR232
    2299683 PK not enforced if added using existing COMPRESSED NON UNIQUE index
    2314238 VARCHAR2 Bind variables loose any TRAILING SPACES when used over a DATABASE LINK or bound dynamically
    2336714 PARALLEL MERGE does not error if the UPDATE violates a CHECK CONSTRAINT.
    2367256 Fix for Bug:2133357 not in Oracle9i (Corrupt LOBS after altering DB characterset)
    2386401 LOADER may load incorrect values for PACKED DECIMAL data
    2421031 VARRAY of FLOATs are truncated on insert
    2423571 Invalid Oracle numbers possible if ProCobol uses COMP variables containing invalid COMP data
    2448081 DIRECT load loads PACKED DECIMALS exceeding specified precision / scale
    2468782 Direct load with SQL expression in CONTROL file can fail / store incorrect data

    Corruption (Physical)
    2384289* Corruption / internal errors after upgrading database to 9.2
    This bug is alerted in Note 197737.1
    2293492 Fatal error during COMMIT / ROLLBACK may cause permanent corruption (eg: ORA-8102)
    2366191 Database corruption possible from concurrent ALTER DATABASE OPEN
    2399039 ALTER TABLE DROP COLUMN drops the wrong column
    2485931 ORA-8102 from IOT DML with concurrent MOVE ONLINE

    Corrupt/Bad Backup
    2334532 Not all backuppieces have a magic buffer written

    Deadlock
    2223234 Concurrent DML against a CLUSTER TABLE may deadlock
    2272671 DEADLOCK possible on CREATE INDEX ONLINE (KGL lock v. TT enqueue)
    2415134 SR enqueue deadlock possible
    2442539 SMONs may deadlock updating COL_USAGE$ in RAC

    Fix is considered an enhancement
    1788921 ENH: Add OCI_ATT_IS_EXTERNAL attribute to show table is EXTERNAL
    2232905 Diagnostic to dump information for corrupt library cache handles in OPS/RAC
    2294821 Additional diagnostics for OERI:12700
    2352376 Enhancement: Improve heuristic for subquery unnesting for partially matches indexed correlation predicates
    2384165 ENH: Small performance improvement for 8.0/8i/9i Pro clients
    2387007 ENH: Allow UNUSED COLUMNS to be TRANSPORTED
    2402677 ENH: Add JDBC thin OJMS support for all JMS message types on single destination
    2402690 ENH: Add JDBC thin OJMS support for all JMS message types on single destination

    Hang - Involving shared resource
    2166890 Hang / ORA-4021 possible using using PLSQL clients
    2208882 SPIN for SQL against a VIEW which references an ALTERED LIST PARTITION table
    2209142 Surviving node may HANG when PARALLEL_INSTANCE_GROUP set
    2272671 DEADLOCK possible on CREATE INDEX ONLINE (KGL lock v. TT enqueue)
    2351854 Dispatchers may hang if ORA-4031 occurs
    2442539 SMONs may deadlock updating COL_USAGE$ in RAC
    2487487 LGWR may hang writing to >1 archive destinations with NOAFFIRM

    Hang - Process hang
    2223234 Concurrent DML against a CLUSTER TABLE may deadlock
    2296198 Shared server may not process client message for about 30 seconds
    2299898 Client may hang processing LONG data
    2321000 Subquery with a ROWNUM predicate may hang using CURSOR SHARING
    2347262 Hang during startup possible in SMU mode
    2379327 Multithreaded client may hang when using BEQ adaptor
    2415134 SR enqueue deadlock possible
    2435787 PDML may hang for tables with referential integrity constraints

    Hang - Process spins
    2090827 Spin in KDIFIND() possible updating indexed table (rare)
    2208882 SPIN for SQL against a VIEW which references an ALTERED LIST PARTITION table
    2211515 Spatial query may SPIN if TOLERANCE is too large
    2238718 Spin possible due to corrupt block on mirrored datafile
    2282891 Select from V$SQLTEXT may spin if HASH_VALUE is given as a predicate
    2306331 Hang / OERI[17059] on view after SET_KEY or SET_DML_INVOKATION on base table
    2367783 SQLPLUS may spin if it selects an incomplete multibyte character
    2480451 SPIN (in KDB4CHK) possible if block is corrupt
    2516119 LIKE pat ESCAPE with no escape character in pat spins in multibyte

    Instance may crash
    2028564 ORA-7445 or OERI:17114 errors possible after OERI:729 - PMON may die
    2108072 OERI:1433 if LGWR archival is ASYNC and network congested
    2200934 PMON may crash in kssxdl cleaning up session which was enqueuing a message
    2200961 OERI:[529] in PMON after session dies when adding a subscriber
    2271499 CKPT may crash the instance if datafile cannot be accessed
    2308667 PMON may OERI:[KSSRMP1]
    2321616 ORA-7445 [kjctcommerr] / instance crash if a different instance is killed
    2376087 PMON can crash the instance with OERI:[KJCCFMB:X!] if a process dies in a small timing window
    2389513 SMON may crash with ORA-7445 in kxsrod()
    2391877 PMON may crash the instance with OERI:[4157] if AUDITING is enabled
    2392166 Calling SERIALLY_REUSABLE PLSQL from SQL can cause PMON to crash
    2472541 PMON ORA-7445 [kghxfr] after shared server gets ORA-4031

    Latch Contention
    2264893 Recursive SQL under triggers can contribute to latch contention
    2272866 Client side PLSQL can cause excessing "library cache lock" and latch gets
    2283941 Changes to reduce contention on "library cache latch"
    2351554 "post/wait queue" latch contention in RAC
    2430992 Waits possible on "FILE NUMBER TRANSLATION" latch

    Leak - Memory leak / Growth
    2124770 Client memory leak in LDAP C-API
    2193939 FAILOVER: Client memory leak using TAF when repeatedly open/close connections
    2206438 High memory usage from DBMS_STATS.GATHER_TABLE_STATS on partitioned table
    2227360 QMN process leaks memory ("kprbalo temp mem")
    2281071 ORA-4030 / memory leak calling RPC in PLSQL cursor loop
    2295845 OERI:729 if TRUNCATE PARTITION / ALTER TABLE MODIFY COLUMN interrupted
    2303271 OCCI memory leak calling getRef() on an object
    2322384 EXEC SQL OBJECT GET leaks memory
    2322759 DBMS_LOB.READ can leak "koh-kghu call" heap memory
    2324976 Objects may be allocated with session duration
    2371235 Memory leak passing LOB parameters to PLSQL callouts in a loop
    2372441 DBMS_LDAP_UTL.get_group_membership() server memory leak
    2376673 Memory leak in OCCI
    2379136 SQLPLUS memory / LOB leak querying XMLType
    2381566 Large UPDATE of NESTED TABLE column shows excessive memory use
    2385206 OERI:723 possible after ORA-22813 error on objects
    2389423 JDBC thick memory leak
    2391827 HS agent leaks memory which can lead to ORA-2055
    2395838 Memory leak in JVM on some platforms
    2403347 Memory leak in KPRB driver with statement caching enabled
    2408475 Memory leak for sessions connecting over HS
    2413560 Calling MQGET in a loop leaks PGA memory (ORA-4030)
    2416245 Large memory leak using SDO_RELATE in a PLSQL loop
    2416678 Memory leak calling OPAQUE TYPE member function
    2449579 DIAG process can leak memory
    2508513 ORA-22813 / OERI:723 with large objects/collections
    2559902 Memory leak creating CONTEXT/CTXXPATH index on schema XMLType col

    Leak - Resources eg: File handles
    2250904 LDAP server file descriptor leak
    2251552 Cursor leak / ORA-1000 using CURSOR() expressions
    2273745 Job Queue processes selecting over HS link leaks file descriptors
    2379136 SQLPLUS memory / LOB leak querying XMLType
    2422803 ORA-1000 / cursor leak in JDBC THIN

    Memory Corruption
    2021310 HS agent memory corruption / dump fetching data
    2228280 Private memory corruption possible with OPTIMIZER_MODE=RULE if tracing sometimes used
    2257361 ORA-3113/ORA-600 indexing an multi-byte data in XML CDATA sections
    2296247 Incorrect results / memory corruption / dump from UPDATE using HASH JOIN with correlated SUBQUERY
    2298888 ORA-7445 / ORA-27092 / PGA memory corruption in PRESPAWNED server
    2311292 OCCI client memory corruption
    2340656 Private memory corruption possible from RAISE_APPLICATION_ERROR for long error messages
    2370947 Shadow memory corruption / false ORA-1483 assigning NULL to COMP-3 bind
    2376273 Memory corruption using LEADING hint with STAR transformation

    Performance affected (General)
    1767169 Working sets not assigned to best DBW on NUMA
    2237682 FAILOVER: Non SELECT SQL is reparsed on each execute after failover
    2307224 "ALTER INDEX .. REBUILD ONLINE" is slow
    2364823 Index range scan can be slower than 9.0 or earlier
    2384165 ENH: Small performance improvement for 8.0/8i/9i Pro clients

    Performance of Query/ies affected
    2109825 Incorrect cardinality estimate with OR predicate and NULL values
    2273591 FIRST_ROWS_N can produce a much slower plan than expected
    2283254 Redundant filter predicates from FIRST_ROWS and concatenated index
    2287990 Bad plan possible from unnesting of multiple complex views
    2297645 Bad plan possible using CONTAINS() clause if DB_BLOCK_SIZE > 2K
    2307892 Poor plan possible with long inlist on multiple columns
    2324795 Join predicates not pushed into UNION ALL view with index access to CLUSTER
    2329325 CBO may choose FTS over index FFS for partitioned table
    2352376 Enhancement: Improve heuristic for subquery unnesting for partially matches indexed correlation predicates
    2384552 NO_PUSH_SUBQ hint may be ignored
    2397501 Dump / bad plan sometimes from HISTOGRAM statistics on JOIN columns
    2413264 Negative cost / bad plan for queries on partitioned table
    2424183 Wrong INDEX SELECTIVITY for multi-column IN-LIST predicate
    2449515 Worse plan in 9.2 with unnested subquery & concatenated index
    2458455 Add ability to perform DISTINCT pushdown

    Security or Service denial vulnerability
    2395416* Net overrun security vulnerability
    This bug is alerted in Note 207269.1
    2467947* LISTENER vulnerability
    This bug is alerted in Note 207268.1

    Shared Pool affected
    2264893 Recursive SQL under triggers can contribute to latch contention
    2272866 Client side PLSQL can cause excessing "library cache lock" and latch gets
    2273604 CURSOR_SHARING=FORCE may not share cursors using a BETWEEN clause with CBO
    2283941 Changes to reduce contention on "library cache latch"
    2385153 Shared pool LEAK on global enqueue timeouts in RAC
    2580648 Anonymous PLSQL not shared with SQL_TRACE / TIMED_STATISTICS

    Wrong Results
    2437484+ DECODE() returns wrong results for empty string ('') compared to NULL
    1231199 Wrong results possible from parallel queries where NLS_SORT is not BINARY
    1951553 Wrong results from PQ with ORDER BY NLSSORT
    2147213 Wrong results / dump possible using DESC functional index
    2161906 Wrong results possible using ROWNUM / LEVEL in predicates / GROUP BY with multiple views
    2183412 Wrong results possible with DESC index
    2202561 Wrong results possible from CHECK CONSTRAINT with empty string ''
    2206022 Wrong results / OERIs from DML on UPDATE JOIN VIEW with STORED OUTLINE
    2210617 SELECT from corrupt IOT returns wrong results
    2214266 Multibyte EXTERNAL TABLE with >1 file may return wrong results
    2221401 Queries with complex view may return wrong results if predicates have implicit type conversion
    2252055 Wrong res from OR-expanded plan with inequality SMJ
    2257375 Turkish language characters are not converted correctly with SPECIFIC or GENERIC base letter
    2258035 Wrong results possible from Max/Min/Count(DISTINCT) on top of window function
    2262196 Intermitent wrong results from PARALLEL partition wise join
    2263263 Wrong results possible from HASH or SMJ of view with columns based on join key
    2286442 Nested WITHIN may miss hits
    2289081 Wrong results from STAR_TRANSFORMATION with TEMP table generation with OR predicates
    2296247 Incorrect results / memory corruption / dump from UPDATE using HASH JOIN with correlated SUBQUERY
    2296307 Wrong results possible from DISTINCT on VIEW with AGGREGATES and SUBQUERIES
    2314238 VARCHAR2 Bind variables loose any TRAILING SPACES when used over a DATABASE LINK or bound dynamically
    2320751 Wrong results possible from Text phrase search on XML document
    2324468 Wrong results from SDO_WITHIN_DISTANCE with BUFFER and R-TREE INDEX
    2327249 V$SYSSTAT may show huge incorrect values when using Parallel Query
    2338661 Wrong results possible from ANSI outer join
    2343219 NCHAR LIKE comparisons may not match on EBCDIC platforms
    2352429 (FLOAT)getObject(n) returns 0.0 for NULL data
    2352928 Wrong results / dump from FULL OUTER JOIN to SUBQUERY with GROUP BY
    2360043 LEFT OUTER JOIN may produce incorrect results instead of ORA-1799
    2363209 Wrong results possible from IS NULL on list partitioned table with DEFAULT partition
    2383138 Wrong results from ANTI-JOIN to single table subquery with constant "FALSE" predicate
    2384272 JDBC getTime() of a TIMESTAMP does not return the correct Time value
    2388008 Wrong results from ANSI outer join with 'const <relop> col'
    2388400 OCI_ATTR_ROW_COUNT returns incorrect row count for piecewise fetches
    2389429 ALL_COLL_TYPES may omit rows
    2393988 WRONG RESULT WHEN USING DECODE WITH COST BASED OPTIMIZER
    2397402 Dump / Wrong res with many INLIST predicates on non-indexed column
    2404234 Wrong results from predicate push into view with CONNECT BY and join
    2411876 BULK BIND deletes cause incorrect delete counts in USER_TAB_MODIFICATIONS
    2417894 ORA-7445 [EVAMINMAX] / wrong results from complex view if aggregate correlated to SUBQUERY
    2423226 Extra characters appended with REPLACE / RTRIM on multibyte shifted data
    2448615 Wrong results from HASH JOIN over DBLINK with multibyte data
    2468606 Cobol: COMP-3 packed decimal can return incorrect number data
    2474692 V$BUFFER_POOL_STATISTICS DBBGET and CONGET are wrong
    2477368 Full table scan of AUTO space managed table may not return all rows
    2481002 V$FILESTAT.AVGIOTIM is incorrect
    2482089 GROUPING SET QUERY gives wrong results on Query REWRITE
    2597503 Cursors with SYNONYM specific policies may not be shared properly

    Error may occur
    2434384+ Updatable snapshots with an 8i MASTER do not work - Fast refresh fails (ORA-2064)
    2258144P "sdsnm" errors in tracefiles
    1532054 ORA-604 / ORA-600 / Dump possible referencing TYPE in TABLE() clause
    1585197 ORA-1036 executing a stored procedure with a SQL Expression as a parameter
    1607797 DRG-11101 possible indexing DEPRECATED HTML features
    1740494 PLS-801 [22914] with TABLE() expression
    1779188 OCI-21500 on SELECT of a FINAL ADT with an embedded non FINAL collection
    1803897 Bad define conversions may fail with ORA-3115 rather than ORA-932
    1870770 PLS-707 [2603] / Dump from BULK Bind with index variable
    1872981 ALTER SYSTEM QUIESCE RESTRICT still allows user sessions to get locks / ORA-54
    1889003 ORA-30757 on query view hierarchy if user has no privilege on a SUBTYPE
    1918751 ORA-6502 possible from UNION and CONCAT (||) with constant strings
    2011927 ORA-02068 / dump in TTCI2U for snapshot with EMPTY_CLOB() data with heterogeneous databases
    2037285 Dump referencing TYPENAME.ATTRIBUTENAME in SQL in PLSQL
    2053110 SMU may report ORA-30036 when undo space is available
    2055230 ORA-979 possible from Text query with in-line view and GROUP BY clause
    2073948 ORA-6550 possible referencing remote partitioned table after DDL performed on it
    2083537 ORA-01457 selecting non-zero DECIMAL through Heterogeneous Services
    2104392 OERI:[QCSFBDNP:1] from nested CONNECT BY with binds in START WITH or FROM clause
    2113937 QUERY REWRITE may report ORA-00942 when not run as MV owner
    2131687 ORA-604 / ORA-1001 querying V$AQ / X$KWQSI
    2141115 ORA-1008 / OERI:15212 from MERGE statement with BIND variables in the USING clause
    2150741 ORA-937 on rewrite for MV with aggregate expressions and no GROUP BY
    2158358 ORA-1062 SELECTing a NULL REF from an OBJECT view
    2161360 DROP of OPERATOR corrupts dictionary - ORA-29836 on ALTER INDEXTYPE
    2166798 ORA-3124 inserting NULL into CLOB with UTF8 characterset
    2166890 Hang / ORA-4021 possible using using PLSQL clients
    2167905 ORA-2072 / OERI:17147 with DB2 select with > 20 indexes when DBSTATS=YES
    2168939 ORA-932 / DUMP on INSERT with INSTEAD OF TRIGGER on LOB/OBJECT column
    2169804 Indexing EXCEL spreadsheets which contain macros may fail with DRG-11207
    2171144 PLS-491 / PLS-217 compiling STANDARD with PLSQL_V2_COMPATIBILITY=TRUE
    2174510 ORA-23308 / ORA-23309 replicating pre-created tables with FLOAT columns
    2177840 ORA-23399 on Migration from 8.0 to 9i leaving REPLICATED table STATUS in ERROR
    2179444 Unexpected ORA-3123 possible instead of ORA-3113 - affects TAF
    2187428 ORA-06544 [84203] possible from client 8.0 PLSQL to 9i Server
    2202285 CTXLOAD -THESDUMP does not dump thesaurus properly
    2204827 ORA-22905 on GRANT against VIEW using TABLE() function
    2205649 ORA-29531 from DBMS_LOGMNR_CDC_PUBLISH.DROP_SUBSCRIBER_VIEW
    2217015 ORA-4016 accessing recreated SEQUENCE after DROP USER CASCADE
    2222386 ORA-28528 / ORA-1401 transferring > 4k over PG4APPC
    2223449 ORA-29925 / ORA-932 from DML against table with functional DOMAIN index on ADT expression
    2228694 DBMS_LOGSTDBY.BUILD returns ORA-16108
    2232903 Cancel causes subsequent ORA-1013 if no current call in progress
    2235422 Indexing RTF with unknown control words fails with DRG-11207
    2240307 ORA-1007 not thrown when REF CURSOR column count != number of INTO items
    2245372 ORA-904 possible from TABLE.* in SELECT list from ANSI join query
    2245527 ORA-903/ORA-911 selecting from UNION view
    2249786 IMP-17 / ORA-24150 possible importing user RULE SET
    2251552 Cursor leak / ORA-1000 using CURSOR() expressions
    2252369 NLS_LANG using UTF8 leads to ORA-12708 / ORA-12705 errors on startup on EBCDIC platforms
    2255030 ORA-3106 possible from 8.0 client talking to 8i / 9i over a DBLINK
    2257361 ORA-3113/ORA-600 indexing an multi-byte data in XML CDATA sections
    2258603 OERI:12327 possible on SELECT with uncorreted subquery
    2258881 Unexpected ORA-22922 possible using TEMP LOBS
    2259246 ORA-1280 if both DBMS_LOGMNR.CONTINUOUS_MINE an SCN range set
    2259466 PLSQL: Assigning one VARRAY to another produces corrupt VARRAY - ORA-6533 / OERI:KOPE2_READSTR232
    2262202 MERGE INTO .. INSERT .. RETURNING dumps - should ORA-933
    2263160 ORA-25191 using DBMS_STATS.ALTER_SCHEMA_TAB_MONITORING with an IOT
    2265030 OERI:[KGHFRF1] possible select from X$KTFBFE for a non-existent tablespace
    2265794 Dequeue with next message navigation may get ORA-1555
    2266130 8.0 PLSQL client may report a false ORA-04062
    2266135 OERI [KTSXTFFS-3] possible from X$KTFBFE for TEMPORARY tablespaces
    2268221 PLS-717 calling TYPE member function mapped to a TRUSTED Callout
    2268284 ORA-12842 possible during PQ if concurrent DDL occurs
    2276622 ORA-29740 possible in RAC under heavy load
    2276981 OERI:16608 possible if a session DROPS a dependent object of a query
    2277191 OERI:QERPFALLOCATEX2 possible from SELECT
    2277283 Only SYS can register Connection Factories using JDBC (or PLS-201 thrown)
    2279288 ORA-28527 when selecting from ALL_VIEWS with AS/400 DB2/400 target
    2279891 ORA-900 from temp table STAR transformation
    2281071 ORA-4030 / memory leak calling RPC in PLSQL cursor loop
    2283232 ORA-1839 possible converting date to Hiraj calendar
    2286448 ORA-29532 using XSLProcessor within StyleSheet
    2293492 Fatal error during COMMIT / ROLLBACK may cause permanent corruption (eg: ORA-8102)
    2294821 Additional diagnostics for OERI:12700
    2295440 Dump referencing ROWID when using TABLE() in an inline view
    2296597 RESUMABLE session may OERI:2006 with AUTOMATIC segment space management
    2296922 Large SQL may fail with ORA-972
    2298888 ORA-7445 / ORA-27092 / PGA memory corruption in PRESPAWNED server
    2302662 Index join should be disallowed for SELECT FOR UPDATE (ORA-2014)
    2306106 OERI:[qerfxFetch_01] possible - affects OEM
    2309738 PLSQL SELECT over DB link throws unexpected error instead of ORA-1403 / no_data_found
    2316137 OERI:[KKSSCL-INF-INL-LOOP] possible
    2316487 ORA-604 / ORA-942 with STAR_TRANSFORMATION_ENABLED=TRUE
    2317933 LSX-333 when MULTIBYTE data used in a PATTERN
    2326948 DBV-111 using DBVERIFY SEGMENT_ID=... on a bitmap space managed segment
    2328192 ORA-1407 changing data source from USING DISPLAY URL to NOT USING
    2332700 Conventional load can reject a row which should be loaded if CTRL-C occurs
    2332996 OERI:kokbcrwo1 from SELECT DISTINCT .. CURSOR() .. statements
    2333038 ORA-24360 binding REF to PLSQL from OCCI
    2333731 ORA-8103 possible in PQ slave
    2334318 ORA-942 accessing LOB through VIEW WITH CHECK OPTION
    2336572 ORA-1416 from PQ on views with constant expression in select list
    2336819 2nd call to START_LOGMNR with DDL TRACKING fails
    2338739 DBMS_LOGMNR_CDC_PUBLISH / DBMS_CDC_PUBLISH may error with ORA-1426
    2340064 ORA-1841 when ADD_MONTHS function results in DECEMBER 9999
    2341491 ORA-13050 possible on SDO_BUFFER of valid SDO geometry
    2343833 ORA-29552 from oracle.xdb.XMLType.createXML after 901 upgrade/downgrade
    2344250 DRG-11614 errors possible from URL_DATASTORE to non-apache HTTP server
    2345060 ORA-600[kokvxsql1] can occur compiling a view
    2345538 OERI:kdsgrds from SERIALIZABLE transaction on row dependent table
    2346368 ORA-6502 in multibyte using NLS_LENGTH_SEMANTICS=CHAR
    2346568 ORA-22921 comparing CLOBS from different character sets
    2348151 OERI:comp3 possible from compressed insert direct load
    2349201 ORA-1647 importing TRANSPORTABLE set with partitioned object table
    2351255 GROUP BY with large group key can OERI:[15851]
    2351682 ORA-1259 on DROP TABLESPACE when ODM enabled for RAW device
    2351854 Dispatchers may hang if ORA-4031 occurs
    2353474 OERI:[kksscl-inf-inl-loop] possible (rare)
    2355622 OERI[2907] possible on TEMPFILES
    2358432 DBMS_SPACE_ADMIN.SEGMENT_DUMP() signals ORA-03211 for SMU Undo Segments
    2358608 Concurrent ANALYZE and DDL on table may OERI:16607
    2360043 LEFT OUTER JOIN may produce incorrect results instead of ORA-1799
    2360088 ORA-1092 on STARTUP if the firsT UNDO_TABLESPACE is OFFLINE (ORA-376 in alert)
    2360357 ORA-2304 on CREATE OR REPLACE TYPE with OID
    2361148 OERI:[qerrmoFBU1] may mask a real user error
    2365220 OERI:[KCBBXSV_6] possible on an SGA SHRINK
    2370324 False ORA-904 possible on NATURAL RIGHT JOIN of different schema tables
    2370947 Shadow memory corruption / false ORA-1483 assigning NULL to COMP-3 bind
    2371613 OERI:12412 from CASE expression in SELECT FOR UPDATE
    2371937 ALTER TABLE may signal false ORA-928
    2372945 OERI:[KJPCRE2] possible connecting to instance in RAC or OPS environments
    2373278 CREATE INDEX in PARALLEL can fail with ORA-30562 in some locales
    2382986 WKG-10900 possible after renaming a search attribute
    2383527 DBMS_XMLQuery does not indicate ORA-942 errors if a bind variable is used
    2384233 ORA-604 / ORA-1422 on CREATE / DROP table after upgrade
    2385206 OERI:723 possible after ORA-22813 error on objects
    2385673 OERI:[kpoblblen: pos1] reexecuting SQL from PLSQL with CURSOR_SPACE_FOR_TIME=TRUE
    2386775 Ultrasearch EMAIL schedule may error with PLS-201
    2387671 Incorrect password in DB LINK returns ORA-4052, ORA-28511 instead of ORA-1017
    2390780 ORA-1538 reverting to UNDO_MANAGEMENT=MANUAL in RAC
    2391185 ORA-1 returned from ROLLBACK if session has been killed (should get ORA-1012)
    2391217 PLS-430 from PLSQL Bulk Bind using an index
    2391827 HS agent leaks memory which can lead to ORA-2055
    2395193 OERI:4414 / ORA-1403 on dequeue of pre-9.2 enqueued messages
    2396270 FAILOVER: ORA-25401 after failover when fetching CLOB data
    2401153 DRG-51311 possible after rebuilding CTXCAT index
    2401353 Java setup may fail with ORA-1422 in initjvmaux.rollbacksetup
    2401529 IMP-17/ORA-1031 DBMS_RULE_EXIMP importing 9.0 export file into 9.2
    2401670 Refinement of the fix for Bug:2361084 (ORA-1002)
    2403646 Pro statement reparsed each time after an error
    2405013 ORA-8102 on ALTER TABLE MOVE PARTITION COMPRESS UPDATE GLOBAL INDEXES
    2406422 ORA-37 possible using OCI connection pooling in RAC environment
    2407473 ORA-3106 possible on UPDATE of a LONG using character bind > 4000 bytes long
    2407732 ORA-28576 from DEBUG_EXTPROC.STARTUP_EXTPROC_AGENT
    2417032 ORA-907 from STAR_TRANSFORMATION and inline UNION view
    2420305 ORA-26041 from Direct path load of TIMESTAMP data on EBCDIC
    2422299 SDO upgrade may signal ORA-2260
    2422803 ORA-1000 / cursor leak in JDBC THIN
    2423571 Invalid Oracle numbers possible if ProCobol uses COMP variables containing invalid COMP data
    2424746 Unexpected ORA-24033 enqueuing an AQ message after upgrade to 9.2
    2431567 Oracle errors may show wrong OS error
    2434873 OERI[kksscl-inf-inl-loop] during heavy load with CURSOR_SPACE_FOR_TIME=TRUE
    2437995 Cannot reset PLSQL native mode related parameters - OERI:15419
    2438883 ORA-27544 can occur on connect if previous connect failed
    2443896 OERI:[12811] from concurrent SELECT and DDL (DROP) with SQL_TRACE=TRUE
    2445330 ORA-1403 from DBMS_PICKLER.GET_TYPE_SHAPE for a type whose TDS length > 32000 bytes
    2446649 ORA-7445 [kkslod] / ORA-600[kksscl-inf-inl-loop] possible
    2452173 ORDImage.import fails with ORA-29400 in multibyte
    2457676 XSD-2034 possible with user defined ComprexType
    2460104 ORA-24391 in precompiled code in 9.2
    2468979 ORA-13249/ORA-6502 creating partitioned RTREE spatial index in parallel
    2472541 PMON ORA-7445 [kghxfr] after shared server gets ORA-4031
    2479523 STARTUP FORCE may fail with OERI[KJPCR3]
    2485931 ORA-8102 from IOT DML with concurrent MOVE ONLINE
    2488515 EXP-8/ORA-911 on DBMS_RULE_EXP_RL_INTERNAL if usernames have double quotes
    2498342 DRG-50953 from ExistsNode() on XPATH expression containing node() or text()
    2499257 ORA-28115 from TO_DATA_LABEL on ad-hoc labels
    2508513 ORA-22813 / OERI:723 with large objects/collections
    2508833 ORA-350 trying to DROP STANDBY REDO logfile
    2511906 ORA-8102 possible on update of IOT
    2518863 LDAPSEARCH may fail with LDAP error 53 / ORA-936
    2520470 ORA-28506 querying ALL_CONSTRAINTS in HS over TG4DRDA
    2520796 ORA-439 trying to enable VLM in Standard Edition
    2535965 ALTER SYSTEM SET FILE_MAPPING=TRUE fails (ORA-2097)
    2549696 OERI:4406 on startup if system trigger hits ORA-4092

    Internal Error may occur (ORA-600)
    2366678+ Passing parameters to CALLOUTS may dump or report ORA-600 errors
    1532054 ORA-604 / ORA-600 / Dump possible referencing TYPE in TABLE() clause
    1785175 OERI:kcbgcur_9 from CLOB TO CHAR or BLOB TO RAW conversion
    1788639 OERI:4882 from CREATE MATERIALIZED VIEW on OBJECT table
    1831941 OERI:koktcntv1 on ALTER TYPE when it has been recreated in another session
    2028564 ORA-7445 or OERI:17114 errors possible after OERI:729 - PMON may die
    2064478 CREATE or REPLACE TYPE BODY can fail with OERI:[QCSRWAE1]
    2091962 PQ against composite partitioned table with INLIST on subpartition key may error (OERI:QERPXMOBJVI5)
    2104392 OERI:[QCSFBDNP:1] from nested CONNECT BY with binds in START WITH or FROM clause
    2108072 OERI:1433 if LGWR archival is ASYNC and network congested
    2108544 OERI:KCLFADB_2 possible in RAC environment
    2134836 OIERI:QKABRIX1 possible with BITMAP and PARTITIONED index on NON-PARTITIONED table
    2138987 OERI:kohdtgde1 / OERI:koxsihread1 possible executing a trigger
    2141115 ORA-1008 / OERI:15212 from MERGE statement with BIND variables in the USING clause
    2144939 OERI:[2006] inserting data into an IOT with mapping table
    2156961 OERI:20040 possible from bitmap index
    2157502 OERI:4819 possible when partition maintenence is running against an IOT
    2160802 OERI:PITL1 possible plugging 8i tablespace into 9i
    2167905 ORA-2072 / OERI:17147 with DB2 select with > 20 indexes when DBSTATS=YES
    2176103 OERI:[KKQSRRE-1] on query rewrite with FIRST / LAST & aggregate
    2185245 OERI:qkaPIdsmrg2 possible during PQ partition-wise join
    2198861 Transporting a locally managed tablespace gives OERI:[KTFBFGET-1] at the TARGET
    2200057 OERI:[KKXMAGTC1] possible for OUT / IN OUT bind to PLSQL
    2200961 OERI:[529] in PMON after session dies when adding a subscriber
    2207382 OERI:12333 fetching from Oracle/DB2 in XA
    2209813 OERI:5213 possible on direct load into table with bitmapped functional index
    2210922 OERI:[kola_set_locator-2] from string operations on virtual CLOB
    2212656 OERI[ktspfupdst-1] possible during DML on bitmap managed segments
    2215837 OERI:6100 / index corruption possible on compressed key index
    2225569 OERI:KOKBNP2 possible parsing CURSOR() expression
    2229315 BULK BIND on nested table with OBJECTS may dump / OERI
    2237610 OERI:[kgskbwt1] / OERI:[kskbind1] possible using CURSOR_SHARING
    2242753 OERI[SRSALE_2] possible from GROUP BY SORT on PARTITION row source
    2252824 ANALYZE TABLE with COLUMN STATISTICS may OERI:16515 or not collect statistics
    2257361 ORA-3113/ORA-600 indexing an multi-byte data in XML CDATA sections
    2258479 ORA-00600 [15264] enabling FOREIGN KEY constraint against a view
    2258603 OERI:12327 possible on SELECT with uncorreted subquery
    2259466 PLSQL: Assigning one VARRAY to another produces corrupt VARRAY - ORA-6533 / OERI:KOPE2_READSTR232
    2265030 OERI:[KGHFRF1] possible select from X$KTFBFE for a non-existent tablespace
    2266135 OERI [KTSXTFFS-3] possible from X$KTFBFE for TEMPORARY tablespaces
    2267728 OERI:[KOHCPI298] from TRUSTED CONSTRUCTOR function that returns a NULL ADT
    2269285 OERI:[QCTVCO : BFC] INSERTing '' to table with TIMESTAMP column & trigger
    2272964 QMN may die with OERI:[KWQITNMPTME:WAIT] when dequeue by message ID
    2273245 Internod PQ may fail with OERI:[KXFRSLVSETINFO1]
    2276981 OERI:16608 possible if a session DROPS a dependent object of a query
    2277043 OERI:16221 from CREATE OR REPLACE VIEW depending on FUNCTIONAL index
    2277188 OERI:kjbenterdlm possible in RAC
    2277191 OERI:QERPFALLOCATEX2 possible from SELECT
    2280027 OERI:504 possible from using SNAPSHOTs against 8i
    2283252 OERI:[17285] from ORA errors on push/pop of autonomous transaction
    2286367 OERI:KPOSCWR2 / OERI:KPOSCF10 from OCIStmtFetch2 array fetch
    2288481 SQL on partitioned table when object is invalidated (eg:ANALYZEd) can dump / OERI:15212
    2293492 Fatal error during COMMIT / ROLLBACK may cause permanent corruption (eg: ORA-8102)
    2294821 Additional diagnostics for OERI:12700
    2295845 OERI:729 if TRUNCATE PARTITION / ALTER TABLE MODIFY COLUMN interrupted
    2296247 Incorrect results / memory corruption / dump from UPDATE using HASH JOIN with correlated SUBQUERY
    2296597 RESUMABLE session may OERI:2006 with AUTOMATIC segment space management
    2306106 OERI:[qerfxFetch_01] possible - affects OEM
    2306331 Hang / OERI[17059] on view after SET_KEY or SET_DML_INVOKATION on base table
    2308033 OERI:6191 / OERI:6193 possible on DIRECT mode EXPORT of long row with >=8k DB_BLOCK_SIZE
    2308667 PMON may OERI:[KSSRMP1]
    2309579 OERI:kokeicd2m1 on multi-table INSERT with an out-of-line column
    2310541 OERI:711 .. [kdiulk - prefix context] possible during parallel rollback
    2313914 OERI:KGHALF1 / hang calling RPC in debugger / plsded
    2314669 OERI:18090 using local functions with remote tables.
    2316137 OERI:[KKSSCL-INF-INL-LOOP] possible
    2326066 OERI[ktspffbmb-4] creating LOB column in AUTO SEGMENT SPACE MANAGEMENT
    2329551 OERI [kcbgcur_6] after EXCHANGE PARTITION on IOT with LOBS
    2331475 OERI:[qkaSplitOGs.2] possible from COUNT(*) with window functions.
    2331804 OERI:SORSIK_2 possible from SEMI-JOIN and OR-Expansion
    2332996 OERI:kokbcrwo1 from SELECT DISTINCT .. CURSOR() .. statements
    2336289 OERI:[15713] possible setting up a PQ - rare timing condition
    2345060 ORA-600[kokvxsql1] can occur compiling a view
    2345538 OERI:kdsgrds from SERIALIZABLE transaction on row dependent table
    2347749 OERI:[KCFRBD_1] possible on PQ scan of a cluster
    2348151 OERI:comp3 possible from compressed insert direct load
    2349883 OERI:[kwqpaspse2c: invalid status] after interrupted DBMS_AQADM.UNSCHEDULE_PROPAGATION
    2351255 GROUP BY with large group key can OERI:[15851]
    2353474 OERI:[kksscl-inf-inl-loop] possible (rare)
    2355622 OERI[2907] possible on TEMPFILES
    2357784 OERI[QCTCTE1] parsing ANSI OUTER JOIN with a VIEW with a SET operation (eg: UNION ALL)
    2358608 Concurrent ANALYZE and DDL on table may OERI:16607
    2361148 OERI:[qerrmoFBU1] may mask a real user error
    2362461 OERI:[15709] possible due to PQ slave cleanup race condition
    2364710 OERI [12868] possible on DROP USER when GRANT exists on ALTERED TYPE
    2365220 OERI:[KCBBXSV_6] possible on an SGA SHRINK
    2371613 OERI:12412 from CASE expression in SELECT FOR UPDATE
    2372945 OERI:[KJPCRE2] possible connecting to instance in RAC or OPS environments
    2373192 OERI[KOPE2_WRITES118] on AQ propogations between different character set databases
    2376087 PMON can crash the instance with OERI:[KJCCFMB:X!] if a process dies in a small timing window
    2377136 OERI:[KCLCHKINTEG_1] possible in RAC
    2377630 OERI[5106] / dictionary corruption on concurrent ADD DATAFILE & DROP TABLESPACE
    2385206 OERI:723 possible after ORA-22813 error on objects
    2385207 OERI:16206 on upgrade to 9.0/9.2
    2385673 OERI:[kpoblblen: pos1] reexecuting SQL from PLSQL with CURSOR_SPACE_FOR_TIME=TRUE
    2391730 OERI:[KOTDATV5] evolving a type already evolved in another session
    2391877 PMON may crash the instance with OERI:[4157] if AUDITING is enabled
    2392166 Calling SERIALLY_REUSABLE PLSQL from SQL can cause PMON to crash
    2394273 OERI:20084 possible from BITMAP MERGE over BITMAP CONVERSION to ROWIDS
    2395193 OERI:4414 / ORA-1403 on dequeue of pre-9.2 enqueued messages
    2398190 OERI:[QKAGBY4] fron INLIST and PARTITION ITERATOR over a GROUP BY
    2398517 OERI:KOPE2PIC661 and similar on AQ propogation between different Oracle versions
    2405258 Dictionary corruption / OERI:15265 from MOVE LOB to existing segment name
    2405517 FAILOVER: OERI:[kclscrs_7] on FAILOVER in RAC
    2406802 OERI[kcbgtcr_3] / OERI[kcbcxx_1] after DROP TABLE in locally managed tablespace
    2407020 ALTER INDEX REBUILD PARTITION may OERI[6074]
    2409601 OERI[!QSCHEMA] from DBMS_AQADM.VERIFY_QUEUE_TYPES if queue name does not include SCHEMA
    2411553 OERI:17271 from V7 XA client updating tables with SNAPSHOT on it
    2414972 OERI:[kcbnew]/OERI:[kcbgtcr_3] after resize in LOCALLY MANAGED tablespace
    2418454 Direct load may fail with OERI:[klaprs_40] loading large data files
    2422726 OERI[16201] possible when RECOMPILING a WRAPPED PACKAGE
    2426916 OERI:[KDISS_PIN_HDR: TOO MANY] on index skip scan
    2427938 OERI:[KSIRES_1][KJUSERSTAT_BADLEVEL] on Ctrl-C in RAC/OPS
    2428202 ORA-600[kdrpFLdoseg_1] using DBMS_REPAIR.REBUILD_FREELISTS
    2434873 OERI[kksscl-inf-inl-loop] during heavy load with CURSOR_SPACE_FOR_TIME=TRUE
    2434915 OERI:6816 possible on SELECT SEQUENCE.NEXTVAL in RAC or OPS
    2437995 Cannot reset PLSQL native mode related parameters - OERI:15419
    2439695 OERI[4191] possible on shrink of system managed undo segment
    2443896 OERI:[12811] from concurrent SELECT and DDL (DROP) with SQL_TRACE=TRUE
    2446649 ORA-7445 [kkslod] / ORA-600[kksscl-inf-inl-loop] possible
    2459355 OERI:XTYCSR3 from PQ Select with GROUP BY and PLSQL function on an aggregate
    2460603 OERI:[QERNSROWP] from DISTINCT, ORDER BY and GROUP BY
    2461184 OERI:[kkqsfxvc-2] possible during query rewrite
    2474033 OERI[KTSPTRM_BMB-3] possible from parallel direct load
    2477651 Parallel direct load may report success on failure
    2479415 Dump / OERI with >1 cursor selecting from V$LOGMNR_CONTENTS
    2479523 STARTUP FORCE may fail with OERI[KJPCR3]
    2508513 ORA-22813 / OERI:723 with large objects/collections
    2538136 Complex View merging with subqueries may OERI:12327 with Bug:2417894
    2549696 OERI:4406 on startup if system trigger hits ORA-4092

    Process may Dump / Abend / Abort
    2366678+ Passing parameters to CALLOUTS may dump or report ORA-600 errors
    2011927 ORA-02068 / dump in TTCI2U for snapshot with EMPTY_CLOB() data with heterogeneous databases
    2021310 HS agent memory corruption / dump fetching data
    2028564 ORA-7445 or OERI:17114 errors possible after OERI:729 - PMON may die
    2123461 Multithread JDBC dumps in upibrk using connection pooling
    2143154 Dump (in evaopn2) from view merging of semi joins
    2179558 ORA-7445[KOTGTSCH] possible selecting from external table
    2189463 ORA-7445 [EVAOPN2] with FUNCTIONAL INDEX on semi-join (EXISTS) predicate
    2211047 ORA-7445 [QCSPOBY] possible from CAST/MULTISET on subquery with ORDER BY
    2219776 Dump possible during queries against X$KGLOB
    2222308 Dump in qcsfoep() on CREATE TYPE BODY which references unqualified PLSQL function
    2222688 ORA-7445 [memcpy] from kpobvr() with bind > 2000 then bind = 0
    2226328 Dump in nsoexc() on SELECT from VIEW with OBJECTS and CONNECT BY
    2229315 BULK BIND on nested table with OBJECTS may dump / OERI
    2234325 ALTER partitioned table with global FUNCTIONAL index and LOBS dumps in kkfiSetMemRep
    2236259 ORA-7445 [LXHCSN] possible during STARTUP
    2239348 SDO_GEOM.RELATE / UNION can return UNKNOWN MASK / NULL or ORA-7445 [mdirf2g]
    2242955 Dump possible from INDEX JOIN access path against CLUSTER
    2243589 Dump in KOKEIOD2M using NESTED TABLE columns in OUTER joins
    2251136 ORA-7445[KGLSUPD] from concurrent DROP/TRUNCATE and ANALYZE
    2253106 ORA-7445 [KSLGPRL] possible repeatedly selecting from V$LATCHHOLDER
    2257361 ORA-3113/ORA-600 indexing an multi-byte data in XML CDATA sections
    2262758 ORA-7445 [pfripDr_purge_DL01_refs] possible from PLSQL
    2275942 ORA-7445 [klcfcfre] possible from DIRECT LOAD of large input file
    2281312 ORA-7445/dump possible on UPDATE of PRIMARY KEY enforced with a DESC index
    2282235 ORA-7445 possible from remote joins of Oracle and DB2 tables over HS
    2286794 Dump in evaopn2 if STAR transformation FACT table has >1 bitmap index on a join column
    2291043 Client dump in lmsaicmt() creating many program contexts using OCIEnvInit() in non-US NLS env
    2293722 ORA-7445 [evaopn2] possible using BITMAP JOIN INDEX with may NULLs
    2296247 Incorrect results / memory corruption / dump from UPDATE using HASH JOIN with correlated SUBQUERY
    2298888 ORA-7445 / ORA-27092 / PGA memory corruption in PRESPAWNED server
    2305613 ORA-7445 [kkodislike] from OR-expansion of LIKE on non-character expression
    2308292 ORA-7445 [kkslhib] for INTO <bind> using CURSOR_SHARING and SESSION_CACHED_CURSORS
    2311529 "SHUTDOWN" may dump with ORA-7445 [lxhcsn]
    2314151 ORA-7445[kdudcp] from PARALLEL UPDATE / DELETE on JOIN VIEW
    2319370 JDBC OCI threaded application may dump in nsdo()
    2321616 ORA-7445 [kjctcommerr] / instance crash if a different instance is killed
    2322586 ORA-7445 [QERLTIDLM] using APPEND hint in trigger
    2326268 PQ slaves may dump
    2331804 OERI:SORSIK_2 possible from SEMI-JOIN and OR-Expansion
    2349021 ADT LOB dequeue may dump in multithreaded client
    2358608 Concurrent ANALYZE and DDL on table may OERI:16607
    2358756 Dump possible with TIMED_STATISTICS=TRUE
    2363304 ORA-7445 [QKABXO] with FIRST_ROWS_N
    2364585 STAR transformation may dump (EVAOPN2) if fact column is leading prefix of bitmap index
    2378847 ORA-7445 [PRSPO_PROC_OPTS] creating IOT with NOMAPPING clause
    2383449 ORA-7445 [pfrbnd] possible from ORDER BY LEVEL in PLSQL
    2386334 ORA-7445[QERUAROWPROCEDURE] possible from SELECT from UNION ALL view
    2389513 SMON may crash with ORA-7445 in kxsrod()
    2396474 ORA-7445 [KOXSS2GPAGE] querying inline view with aggregate on OBJECT column
    2405244 ORA-7445 when RMAN reported re-read of a corrupt mirrored block
    2417894 ORA-7445 [EVAMINMAX] / wrong results from complex view if aggregate correlated to SUBQUERY
    2417912 Dump [pbedeupdate] from DBMS_DEBUG.DEBUG_ON called from NCOMPed code
    2419951 ORA-7445 [kghalf] possible from SYSTEMSTATE dump using ORADEBUG
    2421874 Dumps possible in opiodr() using resource limits or killing sessions
    2423689 ORA-7445 [INSBRP] on DML against a table with UNUSED columns with a TRIGGER
    2428537 ORA-7445 [MEMCPY] from DECODE() predicates in unmerged views
    2446649 ORA-7445 [kkslod] / ORA-600[kksscl-inf-inl-loop] possible
    2453215 ORA-7445[vopsvc] selecting ROWID from a complex join view
    2459191 ORA-7445 [EVADCD] from constant DECODE predicate
    2460603 OERI:[QERNSROWP] from DISTINCT, ORDER BY and GROUP BY
    2472541 PMON ORA-7445 [kghxfr] after shared server gets ORA-4031
    2479415 Dump / OERI with >1 cursor selecting from V$LOGMNR_CONTENTS
    2482535 CTX_CLS.TRAIN may ORA-7445[KRCIIBITMAP] with large number of training documents
    2483794 ORA-7445[NSOINP] using GROUPING SETS with SUBQUERY
    2483854 ORA-7445 [kwqppreaqe] with >10 remote subscribers to a queue
    2507641 ORA-7445 [PEVM_CVTIN] after DBMS_SESSION.MODIFY_PACKAGE_STATE



    Task Related


    Instance startup
    2252369 NLS_LANG using UTF8 leads to ORA-12708 / ORA-12705 errors on startup on EBCDIC platforms
    2332285 Unnecessary trace files are generated on startup/shutdown
    2347262 Hang during startup possible in SMU mode
    2360088 ORA-1092 on STARTUP if the firsT UNDO_TABLESPACE is OFFLINE (ORA-376 in alert)
    2549696 OERI:4406 on startup if system trigger hits ORA-4092

    Migration / Upgrade / Downgrade
    2177840 ORA-23399 on Migration from 8.0 to 9i leaving REPLICATED table STATUS in ERROR
    2293968 SQLJTYPE Java classes invalid on downgrade from 9.2 to 9.0/8.1
    2324679 INVALID AQ$ objects after downgrade to 8i
    2334789 Patch set scripts loose GRANTS on DBMS_LOCK_ALLOCATED
    2343833 ORA-29552 from oracle.xdb.XMLType.createXML after 901 upgrade/downgrade
    2384233 ORA-604 / ORA-1422 on CREATE / DROP table after upgrade
    2385207 OERI:16206 on upgrade to 9.0/9.2
    2395193 OERI:4414 / ORA-1403 on dequeue of pre-9.2 enqueued messages
    2401353 Java setup may fail with ORA-1422 in initjvmaux.rollbacksetup
    2422299 SDO upgrade may signal ORA-2260
    2424746 Unexpected ORA-24033 enqueuing an AQ message after upgrade to 9.2

    Recovery
    2238718 Spin possible due to corrupt block on mirrored datafile
    2487487 LGWR may hang writing to >1 archive destinations with NOAFFIRM



    SQL commands / features used


    ANSI Joins
    2245372 ORA-904 possible from TABLE.* in SELECT list from ANSI join query
    2338661 Wrong results possible from ANSI outer join
    2352928 Wrong results / dump from FULL OUTER JOIN to SUBQUERY with GROUP BY
    2357784 OERI[QCTCTE1] parsing ANSI OUTER JOIN with a VIEW with a SET operation (eg: UNION ALL)
    2360043 LEFT OUTER JOIN may produce incorrect results instead of ORA-1799
    2370324 False ORA-904 possible on NATURAL RIGHT JOIN of different schema tables
    2388008 Wrong results from ANSI outer join with 'const <relop> col'

    Analytic SQL (Windowing etc..)
    2176103 OERI:[KKQSRRE-1] on query rewrite with FIRST / LAST & aggregate
    2331475 OERI:[qkaSplitOGs.2] possible from COUNT(*) with window functions.
    2443764 Simple CASE expressions much slower than DECODE equivalent
    2482089 GROUPING SET QUERY gives wrong results on Query REWRITE
    2483794 ORA-7445[NSOINP] using GROUPING SETS with SUBQUERY

    Constraint Related
    2202561 Wrong results possible from CHECK CONSTRAINT with empty string ''
    2236731 BULK ROW COUNT returned from ARRAY insert may be wrong if constraint violated
    2258479 ORA-00600 [15264] enabling FOREIGN KEY constraint against a view
    2281312 ORA-7445/dump possible on UPDATE of PRIMARY KEY enforced with a DESC index
    2299683 PK not enforced if added using existing COMPRESSED NON UNIQUE index
    2336714 PARALLEL MERGE does not error if the UPDATE violates a CHECK CONSTRAINT.
    2435787 PDML may hang for tables with referential integrity constraints
    2520470 ORA-28506 querying ALL_CONSTRAINTS in HS over TG4DRDA

    Datatypes - LOBs (CLOB/BLOB/BFILE)
    1785175 OERI:kcbgcur_9 from CLOB TO CHAR or BLOB TO RAW conversion
    1818720 Dump with PLSQL and Java Stored Procedure returning NULL CLOB
    2166798 ORA-3124 inserting NULL into CLOB with UTF8 characterset
    2168939 ORA-932 / DUMP on INSERT with INSTEAD OF TRIGGER on LOB/OBJECT column
    2193313 PLSQL CreateAbstractClob() dumps if LOB not freed
    2207959 Dump from COALESCE of PARTITIONED table with LOB
    2210922 OERI:[kola_set_locator-2] from string operations on virtual CLOB
    2234325 ALTER partitioned table with global FUNCTIONAL index and LOBS dumps in kkfiSetMemRep
    2242146 Inserting a virtual LOB into a LOB column dumps
    2255864 ABSTRACT LOB does not support multibyte data
    2258881 Unexpected ORA-22922 possible using TEMP LOBS
    2273837 Server Dump when JDBC THIN writes data to multibyte TEMP LOB
    2322759 DBMS_LOB.READ can leak "koh-kghu call" heap memory
    2326066 OERI[ktspffbmb-4] creating LOB column in AUTO SEGMENT SPACE MANAGEMENT
    2329551 OERI [kcbgcur_6] after EXCHANGE PARTITION on IOT with LOBS
    2334318 ORA-942 accessing LOB through VIEW WITH CHECK OPTION
    2346568 ORA-22921 comparing CLOBS from different character sets
    2367256 Fix for Bug:2133357 not in Oracle9i (Corrupt LOBS after altering DB characterset)
    2371235 Memory leak passing LOB parameters to PLSQL callouts in a loop
    2396270 FAILOVER: ORA-25401 after failover when fetching CLOB data
    2405258 Dictionary corruption / OERI:15265 from MOVE LOB to existing segment name
    2466076 DBMS_LOB.LOADCLOBFROMFILE() may dump for AL16UTF16 data
    2475163 Privilege errors modifying LOB in an ADT via a view

    Datatypes - Objects (Types/Collections)
    1532054 ORA-604 / ORA-600 / Dump possible referencing TYPE in TABLE() clause
    1740494 PLS-801 [22914] with TABLE() expression
    1779188 OCI-21500 on SELECT of a FINAL ADT with an embedded non FINAL collection
    1788639 OERI:4882 from CREATE MATERIALIZED VIEW on OBJECT table
    1831941 OERI:koktcntv1 on ALTER TYPE when it has been recreated in another session
    1889003 ORA-30757 on query view hierarchy if user has no privilege on a SUBTYPE
    1941831 EXECUTE IMMEDIATE of CALL type constructor dumps in kkxmstcs
    2037285 Dump referencing TYPENAME.ATTRIBUTENAME in SQL in PLSQL
    2064478 CREATE or REPLACE TYPE BODY can fail with OERI:[QCSRWAE1]
    2158358 ORA-1062 SELECTing a NULL REF from an OBJECT view
    2168939 ORA-932 / DUMP on INSERT with INSTEAD OF TRIGGER on LOB/OBJECT column
    2193493 VARRAYs with embedded SUBSTITUTABLE TYPE may dump
    2204827 ORA-22905 on GRANT against VIEW using TABLE() function
    2211047 ORA-7445 [QCSPOBY] possible from CAST/MULTISET on subquery with ORDER BY
    2222308 Dump in qcsfoep() on CREATE TYPE BODY which references unqualified PLSQL function
    2223449 ORA-29925 / ORA-932 from DML against table with functional DOMAIN index on ADT expression
    2225569 OERI:KOKBNP2 possible parsing CURSOR() expression
    2226328 Dump in nsoexc() on SELECT from VIEW with OBJECTS and CONNECT BY
    2232548 VARRAY number columns are not rounded / truncated
    2243589 Dump in KOKEIOD2M using NESTED TABLE columns in OUTER joins
    2246137 ArrayIndexOutOfBoundsException in oracle.jdbc.oracore.UnpickleContext.read_lengthBytes after changing between 32<->64 bit
    2259466 PLSQL: Assigning one VARRAY to another produces corrupt VARRAY - ORA-6533 / OERI:KOPE2_READSTR232
    2267728 OERI:[KOHCPI298] from TRUSTED CONSTRUCTOR function that returns a NULL ADT
    2268221 PLS-717 calling TYPE member function mapped to a TRUSTED Callout
    2271862 Dump selecting ALTERED collection type using JDBC
    2295440 Dump referencing ROWID when using TABLE() in an inline view
    2300104 CREATE VIEW OF TYPE .. UNDER .. does not export the UNDER clause
    2301875 ALTER TYPE MODIFY ATTRIBUTE does not change DESCRIBE information of ATTRIBUTE
    2309579 OERI:kokeicd2m1 on multi-table INSERT with an out-of-line column
    2311571 OTT does not generate destructor code for OBJECT attributes
    2316195 OCI with COLLECTION may dump on OCIObjectFlush / OCITransCommit
    2329949 NOT FINAL methods can be invoked without privilege
    2349201 ORA-1647 importing TRANSPORTABLE set with partitioned object table
    2360357 ORA-2304 on CREATE OR REPLACE TYPE with OID
    2364710 OERI [12868] possible on DROP USER when GRANT exists on ALTERED TYPE
    2380475 Dictionary corruption from CREATE OR REPLACE SYNONYM on TYPE
    2381566 Large UPDATE of NESTED TABLE column shows excessive memory use
    2385206 OERI:723 possible after ORA-22813 error on objects
    2389429 ALL_COLL_TYPES may omit rows
    2391730 OERI:[KOTDATV5] evolving a type already evolved in another session
    2396474 ORA-7445 [KOXSS2GPAGE] querying inline view with aggregate on OBJECT column
    2416678 Memory leak calling OPAQUE TYPE member function
    2430504 Dump selecting from table with VARRAY and VPD policy
    2445330 ORA-1403 from DBMS_PICKLER.GET_TYPE_SHAPE for a type whose TDS length > 32000 bytes
    2475163 Privilege errors modifying LOB in an ADT via a view
    2508513 ORA-22813 / OERI:723 with large objects/collections

    Datatypes - TIMESTAMP
    2269285 OERI:[QCTVCO : BFC] INSERTing '' to table with TIMESTAMP column & trigger
    2286804 Incorrect timezone conversion for some TIMESTAMPs for certain zones
    2339030 :OLD / :NEW contain garbage for TIMESTAMP WITH LOCAL TIMEZONE columns
    2354325 Fetching a TIMESTAMP with getTimestamp(int,Calendar) throws SQLException
    2378216 Retrieving a TIMESTAMP value using getTime() throws NumberFormatException
    2384272 JDBC getTime() of a TIMESTAMP does not return the correct Time value
    2420305 ORA-26041 from Direct path load of TIMESTAMP data on EBCDIC
    2502439 JDBC OCI returns INCORRECT nanoseconds value

    Hash Join
    2296247 Incorrect results / memory corruption / dump from UPDATE using HASH JOIN with correlated SUBQUERY

    Literal Replacement (CURSOR_SHARING)
    2052836 Client dump possible using CALL statement with CURSOR_SHARING=FORCE
    2237610 OERI:[kgskbwt1] / OERI:[kskbind1] possible using CURSOR_SHARING
    2273604 CURSOR_SHARING=FORCE may not share cursors using a BETWEEN clause with CBO
    2308292 ORA-7445 [kkslhib] for INTO <bind> using CURSOR_SHARING and SESSION_CACHED_CURSORS
    2321000 Subquery with a ROWNUM predicate may hang using CURSOR SHARING
    2442097 INSERTS into USER-DEFINED TYPES with CURSOR_SHARING=FORCE does not share cursors

    MERGE .. USING
    2141115 ORA-1008 / OERI:15212 from MERGE statement with BIND variables in the USING clause
    2262202 MERGE INTO .. INSERT .. RETURNING dumps - should ORA-933
    2336714 PARALLEL MERGE does not error if the UPDATE violates a CHECK CONSTRAINT.

    NLS (National Language Support)
    1231199 Wrong results possible from parallel queries where NLS_SORT is not BINARY
    1926886 Some Text Lexers do not support AL32UTF8
    1951553 Wrong results from PQ with ORDER BY NLSSORT
    2166798 ORA-3124 inserting NULL into CLOB with UTF8 characterset
    2200107 Wrong unicode mappings in WE8MACROMAN8 for "en dash"
    2219627 Character conversion problem between ZHT16DBCS and UNICODE
    2252369 NLS_LANG using UTF8 leads to ORA-12708 / ORA-12705 errors on startup on EBCDIC platforms
    2255864 ABSTRACT LOB does not support multibyte data
    2273837 Server Dump when JDBC THIN writes data to multibyte TEMP LOB
    2283232 ORA-1839 possible converting date to Hiraj calendar
    2291043 Client dump in lmsaicmt() creating many program contexts using OCIEnvInit() in non-US NLS env
    2321765 Scrollable ResultSet can return "?" for multibyte data
    2343219 NCHAR LIKE comparisons may not match on EBCDIC platforms
    2346368 ORA-6502 in multibyte using NLS_LENGTH_SEMANTICS=CHAR
    2352727 XMLType has poor performance in multibyte
    2367256 Fix for Bug:2133357 not in Oracle9i (Corrupt LOBS after altering DB characterset)
    2423226 Extra characters appended with REPLACE / RTRIM on multibyte shifted data
    2430006 Some JA16EUC characters not handled correctly
    2448615 Wrong results from HASH JOIN over DBLINK with multibyte data
    2471679 PLSQL length validation differs from SQL for CHAR SEMANTICS
    2516119 LIKE pat ESCAPE with no escape character in pat spins in multibyte
    2527123 CL8EBCDIC1158 / CL8EBCDIC1158R NLS data missing

    ONLINE DDL
    2272671 DEADLOCK possible on CREATE INDEX ONLINE (KGL lock v. TT enqueue)
    2307224 "ALTER INDEX .. REBUILD ONLINE" is slow
    2485931 ORA-8102 from IOT DML with concurrent MOVE ONLINE

    Optimizer
    2109825 Incorrect cardinality estimate with OR predicate and NULL values
    2143154 Dump (in evaopn2) from view merging of semi joins
    2157655 GATHER_SCHEMA_STATS with GATHER STALE/GATHER EMPTY can fail to collect statistics
    2252824 ANALYZE TABLE with COLUMN STATISTICS may OERI:16515 or not collect statistics
    2262336 Compute statistics on COMPRESSed key index has wrong DISTINCT KEYS value
    2263517 DROP / EXCHANGE partition does not re-aggregate index statistics
    2273591 FIRST_ROWS_N can produce a much slower plan than expected
    2283254 Redundant filter predicates from FIRST_ROWS and concatenated index
    2287990 Bad plan possible from unnesting of multiple complex views
    2297645 Bad plan possible using CONTAINS() clause if DB_BLOCK_SIZE > 2K
    2302662 Index join should be disallowed for SELECT FOR UPDATE (ORA-2014)
    2305613 ORA-7445 [kkodislike] from OR-expansion of LIKE on non-character expression
    2306067 ADD/COALESCE/MERGE/SPLIT PARTITION sets table statistics to NULL
    2307892 Poor plan possible with long inlist on multiple columns
    2324795 Join predicates not pushed into UNION ALL view with index access to CLUSTER
    2329325 CBO may choose FTS over index FFS for partitioned table
    2352376 Enhancement: Improve heuristic for subquery unnesting for partially matches indexed correlation predicates
    2363304 ORA-7445 [QKABXO] with FIRST_ROWS_N
    2384552 NO_PUSH_SUBQ hint may be ignored
    2394273 OERI:20084 possible from BITMAP MERGE over BITMAP CONVERSION to ROWIDS
    2397501 Dump / bad plan sometimes from HISTOGRAM statistics on JOIN columns
    2413264 Negative cost / bad plan for queries on partitioned table
    2418668 GATHER_SCHEMA_STATS() may fail in 9.2 for partitioned tables
    2424183 Wrong INDEX SELECTIVITY for multi-column IN-LIST predicate
    2426916 OERI:[KDISS_PIN_HDR: TOO MANY] on index skip scan
    2428537 ORA-7445 [MEMCPY] from DECODE() predicates in unmerged views
    2449515 Worse plan in 9.2 with unnested subquery & concatenated index
    2458455 Add ability to perform DISTINCT pushdown
    2469905 DBMS_STATS.GATHER..STATS may be slower in 9.2
    2538136 Complex View merging with subqueries may OERI:12327 with Bug:2417894

    Parallel Query (PQO)
    925366 Query with NESTED TABLE does not run parallel
    1231199 Wrong results possible from parallel queries where NLS_SORT is not BINARY
    1951553 Wrong results from PQ with ORDER BY NLSSORT
    2091962 PQ against composite partitioned table with INLIST on subpartition key may error (OERI:QERPXMOBJVI5)
    2185245 OERI:qkaPIdsmrg2 possible during PQ partition-wise join
    2234068 PDML may not achieve expected degree of parallelism
    2262196 Intermitent wrong results from PARALLEL partition wise join
    2268284 ORA-12842 possible during PQ if concurrent DDL occurs
    2273245 Internod PQ may fail with OERI:[KXFRSLVSETINFO1]
    2310541 OERI:711 .. [kdiulk - prefix context] possible during parallel rollback
    2314151 ORA-7445[kdudcp] from PARALLEL UPDATE / DELETE on JOIN VIEW
    2326268 PQ slaves may dump
    2327249 V$SYSSTAT may show huge incorrect values when using Parallel Query
    2333731 ORA-8103 possible in PQ slave
    2336289 OERI:[15713] possible setting up a PQ - rare timing condition
    2336572 ORA-1416 from PQ on views with constant expression in select list
    2347749 OERI:[KCFRBD_1] possible on PQ scan of a cluster
    2362461 OERI:[15709] possible due to PQ slave cleanup race condition
    2373278 CREATE INDEX in PARALLEL can fail with ORA-30562 in some locales
    2374649 DBMS_APPLICATION_INFO CLIENT_INFO not shown for PQ slaves
    2375998 PQ slaves may produce needless tracefiles
    2376821 Parallelization may not occur if PARALLEL index used on right of NL join
    2435787 PDML may hang for tables with referential integrity constraints
    2459355 OERI:XTYCSR3 from PQ Select with GROUP BY and PLSQL function on an aggregate

    Query Rewrite (including Materialized Views)
    1788639 OERI:4882 from CREATE MATERIALIZED VIEW on OBJECT table
    2113937 QUERY REWRITE may report ORA-00942 when not run as MV owner
    2150741 ORA-937 on rewrite for MV with aggregate expressions and no GROUP BY
    2176103 OERI:[KKQSRRE-1] on query rewrite with FIRST / LAST & aggregate
    2179567 Updatable snapshots do not work after 8.0 export -> 8i/9i import
    2259259 MLOG$ entries may not be purged for 9i master to 8i snapshot site
    2280027 OERI:504 possible from using SNAPSHOTs against 8i
    2305302 MVIEW on single table with MAX/MIN does not FAST REFRESH
    2411553 OERI:17271 from V7 XA client updating tables with SNAPSHOT on it
    2461184 OERI:[kkqsfxvc-2] possible during query rewrite
    2482089 GROUPING SET QUERY gives wrong results on Query REWRITE

    Star Transformation
    2286794 Dump in evaopn2 if STAR transformation FACT table has >1 bitmap index on a join column
    2364585 STAR transformation may dump (EVAOPN2) if fact column is leading prefix of bitmap index
    2376273 Memory corruption using LEADING hint with STAR transformation
    2417032 ORA-907 from STAR_TRANSFORMATION and inline UNION view

    Star Transformation with Temp Tables
    2279891 ORA-900 from temp table STAR transformation
    2289081 Wrong results from STAR_TRANSFORMATION with TEMP table generation with OR predicates
    2316487 ORA-604 / ORA-942 with STAR_TRANSFORMATION_ENABLED=TRUE
    2476322 Temp Table STAR TRANSFORMATION may show negative cost

    Triggers
    2014766 Java TRIGGERS do not set :NEW variables to the new values
    2138987 OERI:kohdtgde1 / OERI:koxsihread1 possible executing a trigger
    2168939 ORA-932 / DUMP on INSERT with INSTEAD OF TRIGGER on LOB/OBJECT column
    2264893 Recursive SQL under triggers can contribute to latch contention
    2269285 OERI:[QCTVCO : BFC] INSERTing '' to table with TIMESTAMP column & trigger
    2273417 RECO may not recover IN-DOUBT transactions when LOGON triggers exist
    2322586 ORA-7445 [QERLTIDLM] using APPEND hint in trigger
    2339030 :OLD / :NEW contain garbage for TIMESTAMP WITH LOCAL TIMEZONE columns
    2423689 ORA-7445 [INSBRP] on DML against a table with UNUSED columns with a TRIGGER



    How things are Stored / Defined


    Bitmap Indexes
    2134836 OIERI:QKABRIX1 possible with BITMAP and PARTITIONED index on NON-PARTITIONED table
    2156961 OERI:20040 possible from bitmap index
    2286794 Dump in evaopn2 if STAR transformation FACT table has >1 bitmap index on a join column
    2293722 ORA-7445 [evaopn2] possible using BITMAP JOIN INDEX with may NULLs
    2364585 STAR transformation may dump (EVAOPN2) if fact column is leading prefix of bitmap index

    Compressed Key Index / IOT
    2215837 OERI:6100 / index corruption possible on compressed key index
    2262336 Compute statistics on COMPRESSed key index has wrong DISTINCT KEYS value
    2299683 PK not enforced if added using existing COMPRESSED NON UNIQUE index

    Domain Indexes
    2366678+ Passing parameters to CALLOUTS may dump or report ORA-600 errors
    2099345 Parameters are not passed properly to ODCIStats routines for STATIC TYPE METHODS
    2161360 DROP of OPERATOR corrupts dictionary - ORA-29836 on ALTER INDEXTYPE
    2223449 ORA-29925 / ORA-932 from DML against table with functional DOMAIN index on ADT expression
    2312728 Query against partitioned DOMAIN index dumps if there are many partitions
    2498186 DEPENDENCY$ corrupted on ALTER INDEXTYPE

    External Tables
    1788921 ENH: Add OCI_ATT_IS_EXTERNAL attribute to show table is EXTERNAL
    2179558 ORA-7445[KOTGTSCH] possible selecting from external table
    2214266 Multibyte EXTERNAL TABLE with >1 file may return wrong results
    2245711 TERMINATED BY " " with ENCLOSED BY may incorrectly reject rows
    2245909 SQLLoad with EXTERNAL_TABLE does not find DIRECTORY objects correctly

    Function Based Index (including DESC indexes)
    2147213 Wrong results / dump possible using DESC functional index
    2148807 Function based index with GROUP BY / ORDER BY dumps in evaopn2
    2183412 Wrong results possible with DESC index
    2189463 ORA-7445 [EVAOPN2] with FUNCTIONAL INDEX on semi-join (EXISTS) predicate
    2209813 OERI:5213 possible on direct load into table with bitmapped functional index
    2234325 ALTER partitioned table with global FUNCTIONAL index and LOBS dumps in kkfiSetMemRep
    2277043 OERI:16221 from CREATE OR REPLACE VIEW depending on FUNCTIONAL index
    2281312 ORA-7445/dump possible on UPDATE of PRIMARY KEY enforced with a DESC index

    Index Only Tables (IOT)
    2144939 OERI:[2006] inserting data into an IOT with mapping table
    2157502 OERI:4819 possible when partition maintenence is running against an IOT
    2210617 SELECT from corrupt IOT returns wrong results
    2218504 IOT inherits tablespace COMPRESS property
    2263160 ORA-25191 using DBMS_STATS.ALTER_SCHEMA_TAB_MONITORING with an IOT
    2329551 OERI [kcbgcur_6] after EXCHANGE PARTITION on IOT with LOBS
    2378847 ORA-7445 [PRSPO_PROC_OPTS] creating IOT with NOMAPPING clause
    2485931 ORA-8102 from IOT DML with concurrent MOVE ONLINE
    2511906 ORA-8102 possible on update of IOT
    2515703 Dictionary corruption from concurrent partitioned IOT maintenance

    Oracle Disk Manager
    2351682 ORA-1259 on DROP TABLESPACE when ODM enabled for RAW device
    2360437 CREATE DATABASE hangs with mix of ODM/non-ODM control files
    2382523 RMAN backup to ODM fails
    2418614 In RAC "ALTER TABLESPACE READ-WRITE" fails under ODM
    2449721 Enabling ODM increases system calls

    Partitioned Tables
    2073948 ORA-6550 possible referencing remote partitioned table after DDL performed on it
    2091962 PQ against composite partitioned table with INLIST on subpartition key may error (OERI:QERPXMOBJVI5)
    2134836 OIERI:QKABRIX1 possible with BITMAP and PARTITIONED index on NON-PARTITIONED table
    2143167 Compile time PARTITION PRUNING does not occur with RR or RRRR in NLS_DATE_FORMAT
    2157502 OERI:4819 possible when partition maintenence is running against an IOT
    2157655 GATHER_SCHEMA_STATS with GATHER STALE/GATHER EMPTY can fail to collect statistics
    2185245 OERI:qkaPIdsmrg2 possible during PQ partition-wise join
    2206438 High memory usage from DBMS_STATS.GATHER_TABLE_STATS on partitioned table
    2207959 Dump from COALESCE of PARTITIONED table with LOB
    2208882 SPIN for SQL against a VIEW which references an ALTERED LIST PARTITION table
    2234068 PDML may not achieve expected degree of parallelism
    2234325 ALTER partitioned table with global FUNCTIONAL index and LOBS dumps in kkfiSetMemRep
    2242753 OERI[SRSALE_2] possible from GROUP BY SORT on PARTITION row source
    2259470 Partition pruning does not occur if predicate contains an operator
    2262196 Intermitent wrong results from PARALLEL partition wise join
    2263517 DROP / EXCHANGE partition does not re-aggregate index statistics
    2288481 SQL on partitioned table when object is invalidated (eg:ANALYZEd) can dump / OERI:15212
    2306067 ADD/COALESCE/MERGE/SPLIT PARTITION sets table statistics to NULL
    2329325 CBO may choose FTS over index FFS for partitioned table
    2329551 OERI [kcbgcur_6] after EXCHANGE PARTITION on IOT with LOBS
    2363209 Wrong results possible from IS NULL on list partitioned table with DEFAULT partition
    2398190 OERI:[QKAGBY4] fron INLIST and PARTITION ITERATOR over a GROUP BY
    2405013 ORA-8102 on ALTER TABLE MOVE PARTITION COMPRESS UPDATE GLOBAL INDEXES
    2407020 ALTER INDEX REBUILD PARTITION may OERI[6074]
    2411876 BULK BIND deletes cause incorrect delete counts in USER_TAB_MODIFICATIONS
    2413264 Negative cost / bad plan for queries on partitioned table
    2418668 GATHER_SCHEMA_STATS() may fail in 9.2 for partitioned tables
    2515703 Dictionary corruption from concurrent partitioned IOT maintenance

    Space Management - Bitmap Managed Segments
    2212656 OERI[ktspfupdst-1] possible during DML on bitmap managed segments
    2296597 RESUMABLE session may OERI:2006 with AUTOMATIC segment space management
    2326066 OERI[ktspffbmb-4] creating LOB column in AUTO SEGMENT SPACE MANAGEMENT
    2326948 DBV-111 using DBVERIFY SEGMENT_ID=... on a bitmap space managed segment
    2477368 Full table scan of AUTO space managed table may not return all rows

    Space Management - Locally Managed Tablespaces
    2198861 Transporting a locally managed tablespace gives OERI:[KTFBFGET-1] at the TARGET
    2406802 OERI[kcbgtcr_3] / OERI[kcbcxx_1] after DROP TABLE in locally managed tablespace
    2414972 OERI:[kcbnew]/OERI:[kcbgtcr_3] after resize in LOCALLY MANAGED tablespace

    System Managed Undo
    2053110 SMU may report ORA-30036 when undo space is available
    2347262 Hang during startup possible in SMU mode
    2358432 DBMS_SPACE_ADMIN.SEGMENT_DUMP() signals ORA-03211 for SMU Undo Segments
    2360088 ORA-1092 on STARTUP if the firsT UNDO_TABLESPACE is OFFLINE (ORA-376 in alert)
    2390780 ORA-1538 reverting to UNDO_MANAGEMENT=MANUAL in RAC
    2439695 OERI[4191] possible on shrink of system managed undo segment



    Net / Connectivity / Authentication / Distributed


    Advanced / Secure Networking
    2275708 FIPS-140 fails completely on Windows platforms
    2285343 RADIUS adapter client may dump for passwords over 128 characters
    2299279 Dump possible if user certificate is also a trusted certificate
    2337115 JavaSSL: InterruptedException not handled properly
    2517364 Certicom SSL bug fixes
    2524122 SSL patch for "CERT advisory CA-2002-23"

    DB-Link / Distributed
    2043542 DATA_PRECISION incorrectly set to 38 for CTAS of SMALLINT over DBLINK
    2073948 ORA-6550 possible referencing remote partitioned table after DDL performed on it
    2254550 Enterprise user using shared schema passes wrong username over DBLINK
    2255030 ORA-3106 possible from 8.0 client talking to 8i / 9i over a DBLINK
    2267522 "INSERT INTO ... SELECT FUNC@LOOP" reports incorrect number of rows processed
    2273417 RECO may not recover IN-DOUBT transactions when LOGON triggers exist
    2281071 ORA-4030 / memory leak calling RPC in PLSQL cursor loop
    2309738 PLSQL SELECT over DB link throws unexpected error instead of ORA-1403 / no_data_found
    2314238 VARCHAR2 Bind variables loose any TRAILING SPACES when used over a DATABASE LINK or bound dynamically
    2314669 OERI:18090 using local functions with remote tables.

    Gateways / Heterogeneous Services
    1870073 HS may fail to write to trace files with absolute path names
    2021310 HS agent memory corruption / dump fetching data
    2031989 HS_PASSTHROUGH inserts BLANKS for DBCS data
    2083537 ORA-01457 selecting non-zero DECIMAL through Heterogeneous Services
    2167905 ORA-2072 / OERI:17147 with DB2 select with > 20 indexes when DBSTATS=YES
    2207382 OERI:12333 fetching from Oracle/DB2 in XA
    2273745 Job Queue processes selecting over HS link leaks file descriptors
    2282235 ORA-7445 possible from remote joins of Oracle and DB2 tables over HS
    2338866 Setting HS_TIME_ZONE gives incorrect values for implicit TIMEZONE columns
    2408475 Memory leak for sessions connecting over HS
    2422277 TG4IFX describes NOT NULL columns as NULLABLE
    2422316 TG4IFMX INSERT to TEXT datatype fails

    Gateways / Procedural Gateway for APPC
    2222386 ORA-28528 / ORA-1401 transferring > 4k over PG4APPC

    Gateways / Procedural Gateway for MQ Series
    2387671 Incorrect password in DB LINK returns ORA-4052, ORA-28511 instead of ORA-1017
    2391827 HS agent leaks memory which can lead to ORA-2055
    2413560 Calling MQGET in a loop leaks PGA memory (ORA-4030)
    2479779 PG4MQ part of fix for BUG:2391827

    Gateways / Transparent Gateway for DRDA
    2276069 No error on BIND when package name > 8 characters
    2279288 ORA-28527 when selecting from ALL_VIEWS with AS/400 DB2/400 target
    2504285 CTAS through TG4DRDA can give bad NUMBER precision/scale
    2520470 ORA-28506 querying ALL_CONSTRAINTS in HS over TG4DRDA

    Interoperability (between releases)
    2434384+ Updatable snapshots with an 8i MASTER do not work - Fast refresh fails (ORA-2064)
    2187428 ORA-06544 [84203] possible from client 8.0 PLSQL to 9i Server
    2255030 ORA-3106 possible from 8.0 client talking to 8i / 9i over a DBLINK
    2259259 MLOG$ entries may not be purged for 9i master to 8i snapshot site
    2266130 8.0 PLSQL client may report a false ORA-04062
    2280027 OERI:504 possible from using SNAPSHOTs against 8i
    2296516 9i ODBC driver cannot access a LONG column in an 8i database
    2308496 9.2 client may dump talking to Oracle7 - should error on connect
    2411553 OERI:17271 from V7 XA client updating tables with SNAPSHOT on it

    Network
    2395416* Net overrun security vulnerability
    This bug is alerted in Note 207269.1
    2467947* LISTENER vulnerability
    This bug is alerted in Note 207268.1
    2434834+ LSNRCTL/CMAN/NAMES passwords do not match
    1964080 Net Listener Vulnerability
    2123156 FAILOVER: V$SESSION.FAILOVER_METHOD / FAILOVER _TYPE may be wrong for second connection
    2179444 Unexpected ORA-3123 possible instead of ORA-3113 - affects TAF
    2187760 64 bit listener may crash intermittently when 32 bit ORACLE_HOME registers
    2194549 REMOTE_LISTENER may not work if LOCAL_LISTENER not set
    2210612 FAILOVER: Client may dump if query involves ROWID at failover time
    2222011 FAILOVER in a RAC environment can result in ORA-3113 at the client
    2237682 FAILOVER: Non SELECT SQL is reparsed on each execute after failover
    2308496 9.2 client may dump talking to Oracle7 - should error on connect
    2396270 FAILOVER: ORA-25401 after failover when fetching CLOB data
    2399875 FAILOVER: PIECEWISE FETCH does not call callback function
    2405517 FAILOVER: OERI:[kclscrs_7] on FAILOVER in RAC
    2447729 LISTENER may spin repeatedly logging "nsevwait_error" errors
    2454234 A 64 bit LISTENER may refuse load updates from a 32 bit server.
    2520311 FAILOVER: JVM may crash after failover

    Network - Connection Manager
    2434834+ LSNRCTL/CMAN/NAMES passwords do not match
    2023584 CMAN may rejects connections if hostname omits domain

    Oracle Names
    2488200 names.trace_timestamp does not work

    Security ( Authentication / Privileges / Auditing )
    2127974 Cannot decrypt cipher encrypted using 3DES
    2254550 Enterprise user using shared schema passes wrong username over DBLINK
    2329949 NOT FINAL methods can be invoked without privilege
    2350535 MEDIA_DIR is granted READ to PUBLIC in default database
    2391877 PMON may crash the instance with OERI:[4157] if AUDITING is enabled

    Transparent Application Failover
    2193939 FAILOVER: Client memory leak using TAF when repeatedly open/close connections

    XA / Distributed Transactions
    2207382 OERI:12333 fetching from Oracle/DB2 in XA
    2411553 OERI:17271 from V7 XA client updating tables with SNAPSHOT on it



    Database Options / Major Features


    Physical Standby Database / Dataguard
    2108072 OERI:1433 if LGWR archival is ASYNC and network congested
    2330521 Mandatory standby destination failure not noticed
    2339282 MRP process cannot be restarted if it dies
    2503934 LGWR NETWORK RE-CONNECT stalls primary up to 2 minutes
    2504422 LGWR should not block on ASYNC cache buffer full
    2508640 LGWR/NOAFFIRM reverts to synchronous I/O for STANDBY REDO LOG files
    2508833 ORA-350 trying to DROP STANDBY REDO logfile

    Advanced Queuing
    2131687 ORA-604 / ORA-1001 querying V$AQ / X$KWQSI
    2145198 AQ event notifications may not be delivered / QMN does not free connection descriptors
    2200934 PMON may crash in kssxdl cleaning up session which was enqueuing a message
    2200961 OERI:[529] in PMON after session dies when adding a subscriber
    2221168 Orphan messages possible after remote subscriber removed
    2249786 IMP-17 / ORA-24150 possible importing user RULE SET
    2265794 Dequeue with next message navigation may get ORA-1555
    2272964 QMN may die with OERI:[KWQITNMPTME:WAIT] when dequeue by message ID
    2273354 AQ/JMS message notifications may not be received
    2277283 Only SYS can register Connection Factories using JDBC (or PLS-201 thrown)
    2286290 ALTER TABLE MOVE should not be allowed for Queue tables
    2349021 ADT LOB dequeue may dump in multithreaded client
    2349883 OERI:[kwqpaspse2c: invalid status] after interrupted DBMS_AQADM.UNSCHEDULE_PROPAGATION
    2364533 ClassLoaderException possible using OJMS in OC4J EJB
    2372052 OJMS does not support multiple JMS connections in JDBC Thin
    2372422 OJMS throws NullPointerException with NULL payload enqueued using JDBC THIN
    2373192 OERI[KOPE2_WRITES118] on AQ propogations between different character set databases
    2384580 OJMS fails to remove a durable subscriber in compliant mode
    2390435 OJMS close() rolls back current global transaction
    2395193 OERI:4414 / ORA-1403 on dequeue of pre-9.2 enqueued messages
    2398517 OERI:KOPE2PIC661 and similar on AQ propogation between different Oracle versions
    2402677 ENH: Add JDBC thin OJMS support for all JMS message types on single destination
    2402690 ENH: Add JDBC thin OJMS support for all JMS message types on single destination
    2405004 PROPAGATION from TYPED QUEUE to AnyData queue fails
    2409601 OERI[!QSCHEMA] from DBMS_AQADM.VERIFY_QUEUE_TYPES if queue name does not include SCHEMA
    2424746 Unexpected ORA-24033 enqueuing an AQ message after upgrade to 9.2
    2458956 OJMS AQjmsException enqueuing javax.jms.BytesMessage > 2000 bytes
    2483854 ORA-7445 [kwqppreaqe] with >10 remote subscribers to a queue

    Change Data Capture
    2205649 ORA-29531 from DBMS_LOGMNR_CDC_PUBLISH.DROP_SUBSCRIBER_VIEW
    2338739 DBMS_LOGMNR_CDC_PUBLISH / DBMS_CDC_PUBLISH may error with ORA-1426

    InterMedia (Images)
    2452173 ORDImage.import fails with ORA-29400 in multibyte
    2495716 ProcessCopy errors with non latin character sets

    InterMedia (Video)
    2444809 ORDVidea.setProperties slow for REAL Video data

    JavaVM / JSP / Corba etc..
    1818720 Dump with PLSQL and Java Stored Procedure returning NULL CLOB
    2014766 Java TRIGGERS do not set :NEW variables to the new values
    2095829 Dump passing using setNull() to bind a NULL ADT in KPRB driver
    2289268 POLICYTABLE demo does not work in 9.2 as sess_sh does not exist
    2293968 SQLJTYPE Java classes invalid on downgrade from 9.2 to 9.0/8.1
    2311562 NullPointerException creating NUMBER array > 16376 elements in KPRB
    2395838 Memory leak in JVM on some platforms
    2403347 Memory leak in KPRB driver with statement caching enabled
    2415848 No removal script for catjava.sql - add catnojav.sql
    2476780 OJVMJAVA tool is missing from 9.2.0.1
    2520311 FAILOVER: JVM may crash after failover

    Job Queues
    2273745 Job Queue processes selecting over HS link leaks file descriptors

    LogMiner
    2205649 ORA-29531 from DBMS_LOGMNR_CDC_PUBLISH.DROP_SUBSCRIBER_VIEW
    2259246 ORA-1280 if both DBMS_LOGMNR.CONTINUOUS_MINE an SCN range set
    2336819 2nd call to START_LOGMNR with DDL TRACKING fails
    2338739 DBMS_LOGMNR_CDC_PUBLISH / DBMS_CDC_PUBLISH may error with ORA-1426
    2479415 Dump / OERI with >1 cursor selecting from V$LOGMNR_CONTENTS

    Oracle Label Security
    2499257 ORA-28115 from TO_DATA_LABEL on ad-hoc labels

    Oracle Text (formerly interMedia Text)
    1926886 Some Text Lexers do not support AL32UTF8
    2055230 ORA-979 possible from Text query with in-line view and GROUP BY clause
    2202285 CTXLOAD -THESDUMP does not dump thesaurus properly
    2257361 ORA-3113/ORA-600 indexing an multi-byte data in XML CDATA sections
    2257375 Turkish language characters are not converted correctly with SPECIFIC or GENERIC base letter
    2286442 Nested WITHIN may miss hits
    2297645 Bad plan possible using CONTAINS() clause if DB_BLOCK_SIZE > 2K
    2320751 Wrong results possible from Text phrase search on XML document
    2327806 Japanese lexer as sublexer of multilexer may produce no tokens
    2344250 DRG-11614 errors possible from URL_DATASTORE to non-apache HTTP server
    2387002 CBO chooses inconsistent plans for TEXT queries with invalid query strings
    2401153 DRG-51311 possible after rebuilding CTXCAT index
    2443804 Add Oracle Text support for JA16SJISTILDE and JA16EUCTILDE
    2482535 CTX_CLS.TRAIN may ORA-7445[KRCIIBITMAP] with large number of training documents
    2498342 DRG-50953 from ExistsNode() on XPATH expression containing node() or text()
    2559902 Memory leak creating CONTEXT/CTXXPATH index on schema XMLType col

    Oracle Text INSO Filters
    No Bug#+ INSO filter update
    1607797 DRG-11101 possible indexing DEPRECATED HTML features
    1910911 URLs > 64 bytes long are TRUNCATED in Word Perfect documents
    2169804 Indexing EXCEL spreadsheets which contain macros may fail with DRG-11207
    2235422 Indexing RTF with unknown control words fails with DRG-11207
    2266334 Filtering of MS-WORD documents fail if text in a table
    2279550 PDF documents containing special German characters are incorrectly filtered

    RAC (Real Application Clusters)
    2379821P Tru64: DLM overhead in OPS / RAC too high
    2108544 OERI:KCLFADB_2 possible in RAC environment
    2209142 Surviving node may HANG when PARALLEL_INSTANCE_GROUP set
    2232905 Diagnostic to dump information for corrupt library cache handles in OPS/RAC
    2273245 Internod PQ may fail with OERI:[KXFRSLVSETINFO1]
    2276622 ORA-29740 possible in RAC under heavy load
    2277188 OERI:kjbenterdlm possible in RAC
    2321616 ORA-7445 [kjctcommerr] / instance crash if a different instance is killed
    2351554 "post/wait queue" latch contention in RAC
    2353976 Instance crash can corrupt the database in RAC (database checkpoint > thread checkpoint)
    2372945 OERI:[KJPCRE2] possible connecting to instance in RAC or OPS environments
    2376087 PMON can crash the instance with OERI:[KJCCFMB:X!] if a process dies in a small timing window
    2377136 OERI:[KCLCHKINTEG_1] possible in RAC
    2385153 Shared pool LEAK on global enqueue timeouts in RAC
    2389807 "LKDEBUG -A PROC" does not work properly
    2390780 ORA-1538 reverting to UNDO_MANAGEMENT=MANUAL in RAC
    2404957 Memory needlessly allocated for GCS resources in EXCLUSIVE mode
    2405517 FAILOVER: OERI:[kclscrs_7] on FAILOVER in RAC
    2406422 ORA-37 possible using OCI connection pooling in RAC environment
    2418614 In RAC "ALTER TABLESPACE READ-WRITE" fails under ODM
    2427938 OERI:[KSIRES_1][KJUSERSTAT_BADLEVEL] on Ctrl-C in RAC/OPS
    2434915 OERI:6816 possible on SELECT SEQUENCE.NEXTVAL in RAC or OPS
    2438585 Lots of timeouts from "global cache ..." operations
    2442539 SMONs may deadlock updating COL_USAGE$ in RAC
    2475236 RAC performance issue using UDP IPC

    Replication
    2434384+ Updatable snapshots with an 8i MASTER do not work - Fast refresh fails (ORA-2064)
    2011927 ORA-02068 / dump in TTCI2U for snapshot with EMPTY_CLOB() data with heterogeneous databases
    2103527 INVALID OBJECTS remain after running CATREPR.SQL
    2174510 ORA-23308 / ORA-23309 replicating pre-created tables with FLOAT columns
    2177840 ORA-23399 on Migration from 8.0 to 9i leaving REPLICATED table STATUS in ERROR
    2227755 Incorrect INSERT statement from OFFLINE INSTANTIATION with fractioned values

    Row Level Security / FGA
    2430504 Dump selecting from table with VARRAY and VPD policy
    2456761 Policy function not re-evaluated if cursor in SESSION CACHE
    2597503 Cursors with SYNONYM specific policies may not be shared properly

    Shared Server (formerly MTS)
    2296198 Shared server may not process client message for about 30 seconds
    2334868 Break (ctrl-c) may not interrupt a long running operation on a SHARED SERVER
    2351854 Dispatchers may hang if ORA-4031 occurs
    2472541 PMON ORA-7445 [kghxfr] after shared server gets ORA-4031
    2506629 Dispatcher should time out on incomplete connect requests

    Spatial Data
    2172055 SDO_INTERSECTION may generate NULL geometries
    2211515 Spatial query may SPIN if TOLERANCE is too large
    2239348 SDO_GEOM.RELATE / UNION can return UNKNOWN MASK / NULL or ORA-7445 [mdirf2g]
    2324468 Wrong results from SDO_WITHIN_DISTANCE with BUFFER and R-TREE INDEX
    2334976 Incorrect measures generated by SDO_AGGR_LRS_CONCAT for geodetic data
    2341491 ORA-13050 possible on SDO_BUFFER of valid SDO geometry
    2412341 FALSE EASTING and FALSE NORTHING parameters are always in METERS
    2416245 Large memory leak using SDO_RELATE in a PLSQL loop

    Spatial RTREE
    2468979 ORA-13249/ORA-6502 creating partitioned RTREE spatial index in parallel

    Streams / Logical Standby
    No Bug#+ 9.2.0.2 is mandatory minimum patch level for Streams / Logical Standby
    2228694 DBMS_LOGSTDBY.BUILD returns ORA-16108

    Transportable Tablespaces
    1993176 Transportable sets cannot contain a HASH CLUSTER
    2160802 OERI:PITL1 possible plugging 8i tablespace into 9i
    2198861 Transporting a locally managed tablespace gives OERI:[KTFBFGET-1] at the TARGET
    2349201 ORA-1647 importing TRANSPORTABLE set with partitioned object table
    2387007 ENH: Allow UNUSED COLUMNS to be TRANSPORTED
    2518865 Transportable tablespace with LONG may miss column data



    Programming Languages


    JDBC
    993752 ResultSet.getMetaData describes FLOAT columns as NUMBER
    1987973 ArrayOutOfBoundsException from getPlsqlIndexTable of a null element
    2025426 Bad number data / NumberFormatException with leading 0's in number string in JDBC
    2123461 Multithread JDBC dumps in upibrk using connection pooling
    2232903 Cancel causes subsequent ORA-1013 if no current call in progress
    2246137 ArrayIndexOutOfBoundsException in oracle.jdbc.oracore.UnpickleContext.read_lengthBytes after changing between 32<->64 bit
    2258128 SQLException not thrown when calling stmt.executeUpdate("select ...")
    2263847 NullPointerException if DriverManager.setLogStream() called
    2271862 Dump selecting ALTERED collection type using JDBC
    2273837 Server Dump when JDBC THIN writes data to multibyte TEMP LOB
    2285052 NCHAR data is null padded instead of blank padded in JDBC thin
    2319370 JDBC OCI threaded application may dump in nsdo()
    2321765 Scrollable ResultSet can return "?" for multibyte data
    2351441 setObject() may throw ClassCastException even with fix for bug 2263645
    2352429 (FLOAT)getObject(n) returns 0.0 for NULL data
    2354325 Fetching a TIMESTAMP with getTimestamp(int,Calendar) throws SQLException
    2363615 getObject() of FLOAT returns java.math.BigDecimal
    2363882 Binding a null element in a non null PlsqlIndexTable throws an NullPointerException
    2378216 Retrieving a TIMESTAMP value using getTime() throws NumberFormatException
    2384272 JDBC getTime() of a TIMESTAMP does not return the correct Time value
    2387032 ClassCastException binding a Jpub ARRAY object using setObject()
    2389423 JDBC thick memory leak
    2394555 oracle.net.config.Config.systemName() may not include DOMAIN information
    2394922 SecurityException using JDBC in an applett
    2396763 Unnecessary parses using JDBC Thin
    2422803 ORA-1000 / cursor leak in JDBC THIN
    2427185 JDBC Thin does not support redirection to another NET listener
    2429208 defineColumnType throws ArrayIndexOutOfBoundsException with statement caching
    2478248 JDBC thin has no way to set TCP.NODELAY
    2502439 JDBC OCI returns INCORRECT nanoseconds value
    2503211 Java makefiles in DEMO.ZIP do not work (Windows)
    2505692 Trying to create a TypeDescriptor for a large object throws an exception

    OCCI
    2245006 OCCI populating NESTED TABLE / VARRAY > 245 elements inserts corrupt data
    2303271 OCCI memory leak calling getRef() on an object
    2311292 OCCI client memory corruption
    2311322 OCCI REF destruction dumps if ref->pin() fails
    2324342 next(1) fails for setDataBuffer with prefetch enabled
    2333038 ORA-24360 binding REF to PLSQL from OCCI
    2335874 OCCI application may hang on commit
    2376673 Memory leak in OCCI

    OCI
    2345096P Tru64: FORK() call hangs for PRO/OCI clients
    1788921 ENH: Add OCI_ATT_IS_EXTERNAL attribute to show table is EXTERNAL
    2159595 Multithreaded OCI client may dump processing Oracle errors
    2286367 OERI:KPOSCWR2 / OERI:KPOSCF10 from OCIStmtFetch2 array fetch
    2291043 Client dump in lmsaicmt() creating many program contexts using OCIEnvInit() in non-US NLS env
    2316195 OCI with COLLECTION may dump on OCIObjectFlush / OCITransCommit
    2360115 OCI demo header lines longer than 79 characters (affects OS/390)
    2379327 Multithreaded client may hang when using BEQ adaptor
    2388400 OCI_ATTR_ROW_COUNT returns incorrect row count for piecewise fetches
    2406422 ORA-37 possible using OCI connection pooling in RAC environment
    2445917 User signal handler not called if SA_SIGINFO set
    2463295 Cache client access to error message files reduce file access

    ODBC Driver
    1585197 ORA-1036 executing a stored procedure with a SQL Expression as a parameter
    2296516 9i ODBC driver cannot access a LONG column in an 8i database

    PL/SQL
    1740494 PLS-801 [22914] with TABLE() expression
    1870770 PLS-707 [2603] / Dump from BULK Bind with index variable
    1918751 ORA-6502 possible from UNION and CONCAT (||) with constant strings
    1941831 EXECUTE IMMEDIATE of CALL type constructor dumps in kkxmstcs
    2037285 Dump referencing TYPENAME.ATTRIBUTENAME in SQL in PLSQL
    2073948 ORA-6550 possible referencing remote partitioned table after DDL performed on it
    2119513 ARRAY BINDS to PLSQL anonymous blocks treated wrongly in 9i
    2166890 Hang / ORA-4021 possible using using PLSQL clients
    2171144 PLS-491 / PLS-217 compiling STANDARD with PLSQL_V2_COMPATIBILITY=TRUE
    2187428 ORA-06544 [84203] possible from client 8.0 PLSQL to 9i Server
    2193313 PLSQL CreateAbstractClob() dumps if LOB not freed
    2197703 Update of LONG with PLSQL BULK BIND can update incorrectly
    2200057 OERI:[KKXMAGTC1] possible for OUT / IN OUT bind to PLSQL
    2222308 Dump in qcsfoep() on CREATE TYPE BODY which references unqualified PLSQL function
    2229315 BULK BIND on nested table with OBJECTS may dump / OERI
    2236731 BULK ROW COUNT returned from ARRAY insert may be wrong if constraint violated
    2240307 ORA-1007 not thrown when REF CURSOR column count != number of INTO items
    2259466 PLSQL: Assigning one VARRAY to another produces corrupt VARRAY - ORA-6533 / OERI:KOPE2_READSTR232
    2262758 ORA-7445 [pfripDr_purge_DL01_refs] possible from PLSQL
    2266130 8.0 PLSQL client may report a false ORA-04062
    2269035 Dump possible using BULK COLLECT with DATE types
    2281071 ORA-4030 / memory leak calling RPC in PLSQL cursor loop
    2283252 OERI:[17285] from ORA errors on push/pop of autonomous transaction
    2286387 SQL%FOUND/NOTFOUND etc.. altered by COMMIT / ROLLBACK
    2290374 Dump using REF cursor with BULK COLLECT
    2309738 PLSQL SELECT over DB link throws unexpected error instead of ORA-1403 / no_data_found
    2313914 OERI:KGHALF1 / hang calling RPC in debugger / plsded
    2340656 Private memory corruption possible from RAISE_APPLICATION_ERROR for long error messages
    2346368 ORA-6502 in multibyte using NLS_LENGTH_SEMANTICS=CHAR
    2351498 PLSQL which references a function with insufficient privileges may not error on compilation
    2383449 ORA-7445 [pfrbnd] possible from ORDER BY LEVEL in PLSQL
    2388768 Loading a WRAP file through OCI/JDBC fails (PLS-103)
    2391217 PLS-430 from PLSQL Bulk Bind using an index
    2392166 Calling SERIALLY_REUSABLE PLSQL from SQL can cause PMON to crash
    2407732 ORA-28576 from DEBUG_EXTPROC.STARTUP_EXTPROC_AGENT
    2411876 BULK BIND deletes cause incorrect delete counts in USER_TAB_MODIFICATIONS
    2417912 Dump [pbedeupdate] from DBMS_DEBUG.DEBUG_ON called from NCOMPed code
    2422726 OERI[16201] possible when RECOMPILING a WRAPPED PACKAGE
    2437995 Cannot reset PLSQL native mode related parameters - OERI:15419
    2471679 PLSQL length validation differs from SQL for CHAR SEMANTICS

    PL/SQL (DBMS Packages)
    2184648 DBMS_OUTPUT does not output NCLOB data properly
    2263160 ORA-25191 using DBMS_STATS.ALTER_SCHEMA_TAB_MONITORING with an IOT
    2276418 UTL_HTTP.REQUEST does not use HTTP_PROXY environment variable nor SET_PROXY API
    2288868 DBMS_TRACE may dump in [PBT_SET_LOC]
    2358432 DBMS_SPACE_ADMIN.SEGMENT_DUMP() signals ORA-03211 for SMU Undo Segments
    2428202 ORA-600[kdrpFLdoseg_1] using DBMS_REPAIR.REBUILD_FREELISTS
    2445330 ORA-1403 from DBMS_PICKLER.GET_TYPE_SHAPE for a type whose TDS length > 32000 bytes
    2507641 ORA-7445 [PEVM_CVTIN] after DBMS_SESSION.MODIFY_PACKAGE_STATE

    PL/SQL External Procedures (EXTPROC)
    2222508 EXTPROC may dump freeing objects (in horccoX_ExecCalloutCallbackOut)
    2371235 Memory leak passing LOB parameters to PLSQL callouts in a loop

    Pro* Precompiler
    2345096P Tru64: FORK() call hangs for PRO/OCI clients
    2255182 PROCOB generates bad code for EXEC SQL INCLUDE followed by ELSE
    2291043 Client dump in lmsaicmt() creating many program contexts using OCIEnvInit() in non-US NLS env
    2296498 ProC may dump if PASSWORD supplied interactively
    2296922 Large SQL may fail with ORA-972
    2300956 Pro client may dump if SQL uses CURSOR VARIABLES
    2316666 Cobol: SQLRowidGet may dump
    2321534 PROCOB generates bad code on 64 bit platforms for SQL-CONTEXT typed variables
    2322384 EXEC SQL OBJECT GET leaks memory
    2369763 ProC CODE=ANSI_C precompile error for "va_list"
    2384165 ENH: Small performance improvement for 8.0/8i/9i Pro clients
    2391185 ORA-1 returned from ROLLBACK if session has been killed (should get ORA-1012)
    2403646 Pro statement reparsed each time after an error
    2423571 Invalid Oracle numbers possible if ProCobol uses COMP variables containing invalid COMP data
    2445917 User signal handler not called if SA_SIGINFO set
    2446447 MAKEFILE does not include THREADS=YES for CPDEMO1 and CPDEMO2
    2460104 ORA-24391 in precompiled code in 9.2
    2463295 Cache client access to error message files reduce file access
    2468606 Cobol: COMP-3 packed decimal can return incorrect number data

    SQLJ
    2357847 SQLJ cannot distinguish same PACKAGE . FUNCTION in different schemas

    XDK
    2241542 XMLDocument.print() ignores namespace characteristics
    2244581 XPath processor fails if XPath expression traverses non-existing parent nodes
    2317933 LSX-333 when MULTIBYTE data used in a PATTERN
    2328033 "the element is undefined" when not expected
    2340748 Old javax.xml.transform.TransformerFactory included in xmlparserv2.jar
    2343833 ORA-29552 from oracle.xdb.XMLType.createXML after 901 upgrade/downgrade
    2358025 isSchemaValid/isSchemaBased do not work for some charactersets (eg JA16SJIS/JA16EUC)
    2410191 ArrayIndexOutOfBoundsException parsing XML using SAX parser
    2415063 XDK parse does not always handle NAMESPACE prefixes
    2457676 XSD-2034 possible with user defined ComprexType

    XML
    No Bug#+ The 9.2.0.2 Patch Set contains XDK version 9.2.0.4
    2192062 DBMS_XMLQuery.getXML() does not reset ROW NUM
    2257361 ORA-3113/ORA-600 indexing an multi-byte data in XML CDATA sections
    2286448 ORA-29532 using XSLProcessor within StyleSheet
    2320751 Wrong results possible from Text phrase search on XML document
    2352727 XMLType has poor performance in multibyte
    2383527 DBMS_XMLQuery does not indicate ORA-942 errors if a bind variable is used



    Product Related


    DBVerify Utility
    2326948 DBV-111 using DBVERIFY SEGMENT_ID=... on a bitmap space managed segment
    2373145 DBVERIFY does not identify fractured blocks
    2432864 DBVERIFY does not work properly on RAW or for different BLOCKSIZE

    Export/Import
    2311919+ FULL export with datafile > 1024M produces WRONG size datafiles in .DMP file
    2179567 Updatable snapshots do not work after 8.0 export -> 8i/9i import
    2249786 IMP-17 / ORA-24150 possible importing user RULE SET
    2249845 Export does not export SUPPLEMENTAL LOG syntax
    2300104 CREATE VIEW OF TYPE .. UNDER .. does not export the UNDER clause
    2308033 OERI:6191 / OERI:6193 possible on DIRECT mode EXPORT of long row with >=8k DB_BLOCK_SIZE
    2401529 IMP-17/ORA-1031 DBMS_RULE_EXIMP importing 9.0 export file into 9.2
    2488515 EXP-8/ORA-911 on DBMS_RULE_EXP_RL_INTERNAL if usernames have double quotes

    LDAP / Oracle Internet Directory
    1399887 DN cannot be longer than 255 characters
    1900178 OID binds to all IP addresses on multi-homed host
    2124770 Client memory leak in LDAP C-API
    2150432 LDAP server cannot handle multibyte orclpasswordattribute
    2197620 Subtree search results incorrect when the DN has "%" or "_"
    2250904 LDAP server file descriptor leak
    2275804 DBMS_LDAP leaks "session heap" memory
    2314755 BULKLOAD may not load some attributes
    2334728 "DSA unwilling to Perform" possible creating subscriber DIT
    2356142 OID bulkload slow with many binary attributes
    2356334 Verifiers cannot be modified if already hashed
    2372441 DBMS_LDAP_UTL.get_group_membership() server memory leak
    2385093 Change log corruption in OID replication
    2392901 Delete of entry with ACP causes complete REFRESH on CONSUMER
    2400552 LDAP query with wildcard can fail with "invalid DN syntax"
    2427622 OIDLDAPD dumps when modifying/deleting a null referral entry.
    2435276 orclcommongroupsearchbase attribute is ignored - enterprise groups found ONLY under oracle context
    2447643 Binary attributes > 80 bytes will not synchronize properly
    2463666 DBMS_LDAP_UTL.CHECK_GROUP_PROPERTIES() can be slow
    2473527 OIDLDAP server dump when modifying expired password
    2483720 Ldapsearch with NOT and AND/OR filter may error
    2499991 Missing entries from onelevel search against OID
    2518863 LDAPSEARCH may fail with LDAP error 53 / ORA-936

    Oracle Type Translator
    2357255 OTT fails with ClassNotFoundException:oracle.jdbc.driver.OracleDriver

    RMAN (Recovery Manager)
    2323159 V$ARCHIVED_LOG may show STATUS="?" instead of a valid value if RMAN has been used
    2334532 Not all backuppieces have a magic buffer written
    2336178 LIST BACKUP reports incorrect datafile name
    2382523 RMAN backup to ODM fails
    2385857 RMAN backup performance degrades over time for large DB_FILES
    2405244 ORA-7445 when RMAN reported re-read of a corrupt mirrored block
    2458246 RMAN thinks backups with SPFILE are OBSOLETE
    2478669 RMAN uses existing DATAFILE copies at 2nd TSPITR (RMAN-6163)

    SQL*Loader
    2182152 Incorrect record skipping / RECNUM values during continued load
    2209813 OERI:5213 possible on direct load into table with bitmapped functional index
    2211262 Loader parameter COMMIT_DISCONTINUED does not work
    2245909 SQLLoad with EXTERNAL_TABLE does not find DIRECTORY objects correctly
    2275942 ORA-7445 [klcfcfre] possible from DIRECT LOAD of large input file
    2332700 Conventional load can reject a row which should be loaded if CTRL-C occurs
    2386401 LOADER may load incorrect values for PACKED DECIMAL data
    2418454 Direct load may fail with OERI:[klaprs_40] loading large data files
    2420305 ORA-26041 from Direct path load of TIMESTAMP data on EBCDIC
    2448081 DIRECT load loads PACKED DECIMALS exceeding specified precision / scale
    2468782 Direct load with SQL expression in CONTROL file can fail / store incorrect data
    2474033 OERI[KTSPTRM_BMB-3] possible from parallel direct load
    2477651 Parallel direct load may report success on failure

    SQL*Plus
    1764458 COPY TABLE with RAW datatype column does not copy correctly
    2117791 SQLPLUS cannot open SQL file with no extension after SET SUFFIX '' or ""
    2245455 SET LINESIZE >1024 may return blank data as output in SQLPLUS
    2261290 ISQLPLUS "DESCRIBE" does not show PLSQL PROCEDURE parameters
    2278758 ISQLPLUS set SERVEROUTPUT to 0 causes subsequent errors
    2287093 System Variables -> Instance wrong in iSqlPlus
    2298683 SQLPLUS truncates TNS description strings to 160 bytes
    2357300 "BROWSE" button sometimes doesn't work in iSqlplus
    2367783 SQLPLUS may spin if it selects an incomplete multibyte character
    2379136 SQLPLUS memory / LOB leak querying XMLType

    Ultra Search
    2280521 Edit Attribute Mapping page has incorrect Mapping
    2318866 Unable to DELETE GROUP in multibyte
    2328192 ORA-1407 changing data source from USING DISPLAY URL to NOT USING
    2335396 Exception when DELETE ATTRIBUTE LOV with long MBC name
    2349367 Admin tool cannot detect PRIMARY KEYS when base table not in the instance schema
    2350367 Need option to allow CRAWLER to ignore Robot Exclusion rules
    2350381 Different instances share same search attribute space
    2382986 WKG-10900 possible after renaming a search attribute
    2386775 Ultrasearch EMAIL schedule may error with PLS-201
    2391052 Crawler may not object ROBOTS.TXT rule
    2406868 SQLEXCEPTION searching for "*" (asterisk)
    2422743 Crawler rate slows over time
    2427164 NUMBER Attribute values not deleted on re-crawl
    2428263 Inconsistent document checksum for document due to MIMETYPE
    2464769 Unable to view >1 remote crawler profile
    2569663 Crawler filtering fails for JA16EUC

    Wallet Manager
    2347682 Cannot load certificate with SUBJECT_NAME with AVA type IA5_STRING



    Miscellaneous


    NUMA Related
    1767169 Working sets not assigned to best DBW on NUMA

    Miscellaneous
    2396671P HPUX64: Unsatisfied symbols linking network libraries (eg: nautabnum)
    1872981 ALTER SYSTEM QUIESCE RESTRICT still allows user sessions to get locks / ORA-54
    2106360 MODULE (V$SESSION/V$SQL) should default to the PROGRAM name
    2206480 PROCESS RESOURCE COUNT not accurate
    2207685 BATCH ERROR handling with INSERT..SELECT does not work
    2252932 V$SEGSTAT statistics not cleaned up on TRUNCATE / MOVE
    2293250 "JOIN" cannot be used as a table alias
    2367294 Invalidation of dependent objects is slow
    2372332 SPFILE entries are case sensitive
    2385294 Change default dynamic SGA granule reuse policy to LIFO
    2401318 No error raised when DB_CACHE_ADVICE and DB_BLOCK_BUFFERS set
    2419951 ORA-7445 [kghalf] possible from SYSTEMSTATE dump using ORADEBUG
    2430992 Waits possible on "FILE NUMBER TRANSLATION" latch
    2474452 Dumps possible pickling / unpickling collections
    2535965 ALTER SYSTEM SET FILE_MAPPING=TRUE fails (ORA-2097)

    9202 Special Notes (if any)


    No Bug# +     Fixed: 9202
    The 9.2.0.2 Patch Set includes an updated INSO filter..
    See <Note:212584.1> on Metalink
    

    No Bug# +     Fixed: 9202
    There are a number of Streams / Logical Standby fixes in 9.2.0.2.
    These are not listed in the README as 9.2.0.2 is a mandatory
    minimum patch level for the use of these options.
    

    No Bug# +     Fixed: 9202
    The 9.2.0.2 Patch Set contains XDK version 9.2.0.4.
    Not all of the XDK bug fixes are listed in the Patch note.
    

    End of 9.2.0.2 Fix list
    .

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