讨论11g 11.1.0.6 升级到 11.1.0.7

zf_wu

看看11.1.0.7 fixed bug

11.1.0.7 Bug Fixes by Category




Oracle Server

ANSI Joins
5031632 Wrong results from NATURAL JOIN  
6471020 ORA-1790 or ORA-904 from FULL JOIN  
7249290 Wrong results from virtual column in select list of ANSI join  

ASSM Space Management (Bitmap Managed Segments)
6086497 OERI[ktspgetmyb-1] / bitmap segment corruption for ASSM segments  
6376915 HW enqueue contention for ASSM LOB segments  
6413373 Lob HW enqueue contention  
6474009 On ASSM tablespaces Scans using Parallel Query can be slower than in 9.2  
6730429 ORA-600 [ktecgeb-2] may occur after converting an ASSM tablespace to a different endianness using RMAN  
6844739 ASSM Truncate very slow even with fix for bug 6086497  

Advanced / Secure Networking
6005762 SYS_CONTEXT('USERENV','AUTHENTICATION_METHOD') returns NULL  

Advanced Queuing
5457450 Excessive polling of the aq$_<qtab>_f queue table view from dequeue by condition  
5933656 OERI[kwqpcbk179] from AQ  
6044513 Cannot dequeue a message with a correlation padded with spaces  
6049324 Memory leak from array dequeue  
6065604 DBMS_AQ.DEQUEUE_ARRAY PGA memory leak  
6143688 node startups cAN spend up to 2 mins in AQ partition code  
6151536 Altering max_retries can cause orphan messages  
6280961 OCCI AQ client dumps on FAILOVER  
6341494 Invalid property name JMSXRcvTimestamp specified for OJMS messages  
6633347 ORU-10027 from expdp  
6750302 OCI AQ listener client may dump  

Analytic SQL (Windowing etc..)
5622851 Wrong results from CONNECT BY with GROUPING SETS  
6051782 Wrong results using GROUPING SETS with ORDER BY and DISTINCT  
6315495 OERI[qctstc2o1] / OERI [kkqtcpopn: 0] optimizing subquery inside subquery  
6402957 Suboptimal parallel query performance for Top-n rank queries.  
6878200 Dump possible from query with window / group by or sort nodes  

Application Context
6005762 SYS_CONTEXT('USERENV','AUTHENTICATION_METHOD') returns NULL  

Automatic Memory Management
6275904 ASM does not start of AMM enabled  

Automatic Storage Management (ASM)
4693355 ASM does not close open descriptors even after DROP DISKGROUP  
6139547 Shadow process leak on ASM instance when diskspace exhausted (ORA-20)  
6163771 Mounting a diskgroup fails with error ORA-600 [kfcema02]  
6264570 Slow file creation in ASM if EM is running  
6270137 Unnecessary acquisition of the list header block in ASM  
6275904 ASM does not start of AMM enabled  
6278034 Poor performance when ASM disks are OFFLINE  
6334552 Hang / ORA-4031 / OERI:kfrcsoDelete_3 on rollback of ASM file resize  
6361755 OERI:kfioRqTracer_insert:01 in ASM after an exception  
6367360 Long ASM file open times  
6399504 Offline after FORCE DROP causes staleness registry corruption  
6453944 ORA-15196 with ASM disks larger than 2TB  
6468666 High redundancy diskgroups do not tolerate loss of disks in two failgroups  
6469211 Slow startup with many log files on ASM  
6487591 ASMCMD cannot restore alias directories  
6493270 ASM does not resync disk properly if it is offlined due to a disk open failure on write  
6494961 OERI:kfcemk10 on ASM diskgroup mount  
6522708 ASM instance may hang  
6597063 OERI [kfrpass2_03] can occur in ASM  
6605106 OERI:kfclUpdateBuffers20 due to accessing an ASM null converted buffer  
6639330 OERI:kfbupdate05 after drop ASM disk  
6639644 ASM instance crash (ORA-15040 in SMON) during instance recovery in RAC  
6674673 ASM corruption after IO error with redundancy  
6769870 ASMCMD LSDSK does not show values of bytes_written  
6925708 OERI:[kfclbast0_05] can occur in ASM with RAC and LMS may crash the ASM instance  
6934230 Instance crash from OERI:kfnmClientRegister05 with ASM  

Bitmap Indexes
6110752 OERI[[qerbuNStrp:eridgt] from parallel bitmap merge  
6313035 OERI[kdibc3position] from "bitmap merge" row source  
6399168 DBMS_STATS can be slow for large table with bitmap indexes  
6525496 Wrong results (no rows) from BITMAP operation on functional index  
6642751 Dump (qkabxo) from FIRST_ROWS_K if bitmap index chosen / OERI:kkobmid  
6653704 Dump (evaopn2) from nested loop join with bitmap access to functional index  
6694548 Suboptimal execution plan using bitmap full index scan  
6833602 Wrong results with BITMAP OR  

Change Data Capture
6501817 No rows from DBA_SOURCE_TABLES with CDC  

Cluster Ready Services / Parallel Server Management
4587300 Improve CRS shutdown sequence  
5629557 CRS does not receive reconfig from CSS on SAN failure  
5893629 crsd dumps after being unable to delete backup OCR file  
5926147 malloc() memory corruption errors from CRS  
6074454 Service resource does not become offline when VIP does failover  
6165289 Default service is not set to service_names when crsd.bin is killed  
6219072 CRS-233 can occur on crs_stop -f  
6401902 CRSD dumps during OS reboot  
6436734 OCR timeout for releasing unresponsive session is too long  
6486564 Lack of symbolic stack trace for ocssd.bin or other executables  
6899183 srvctl can fail with PROC-9  

Code Improvement
2227223 ALTER TABLESPACE READ ONLY waits for all active transactions to complete  
6522622 Allow external tables to be pre-processed  
6688108 Enhancement: Allow ORA-1555 to be ignored during table scan  
6708183 CBO cannot get good cardinality estimate for TABLE() functions  
6718212 enhancement to dbms_stats to merge column usage statistics from remote system  

Compressed Data Storage
7123643+ Wrong results (NULL) from select on compressed table  
6268371 ORA-12996 / ORA-12998 / corruption from ALTER TABLE DROP UNUSED COLUMNS CHECKPOINT  
6374297 Drop column on a virtual column gets ORA-39726 with fix for bug 6268371  
6512811 ORA-39726 adding column to table after it is uncompressed (by ALTER TABLE .. MOVE)  

Connect By / Hierarchical Queries
5284200 Suboptimal plan from SELECT DISTINCT with CONNECT BY  
5622851 Wrong results from CONNECT BY with GROUPING SETS  
6073325 OERI[kkqcbydrv:1] from CONNECT BY  
6244173 Dump (qeesTraverseExpr) from CONNECT BY with NOT BETWEEN  
6282093 Cost based CONNECT BY does not OR expand START WITH  
6282944 Poor CONNECT BY performance with complex views  
6333108 Wrong results (duplicates) from CONNECT BY query  
6521934 OERI[qkacon:FJswrwo] from CONNECT BY query  
6643093 Wrong results from CONNECT BY and WITH clause  
6679575 Wrong results from CONNECT BY and WITH clause  
6729992 OERI [qkacon:fjswpri] during CONNECT BY query  

Constraint Related
5131180 Wrong NLS settings after querying tables with DATE related constraints  
5523375 expdp does not export disabled PRIMARY KEY constraints  
5851267 Dump / false constraint violations on DML with trigger  
5885265 Deferred constraints may incorrectly error at commit for IOTs  
6175584 Insert hang with Foreign Key constraint and read-only tablespace  
6316536 ALTER table to change column to TIMESTAMP WITH TIME ZONE can break constraints  
6474004 DBMS_METADATA GET_SXML output does not show RELY for a table constraint  
6523114 ORA-1502 on MVIEW complete refresh with UNIQUE constraint  
7197716 ALTER TABLE ADD CONSTRAINT should not be allowed on FLASHBACK data archive tables  

Corrupt/Bad Backup
6084232 Corrupt datapump export of encrypted column data  

Corruption
5923486 SPFILE streams pool / buffer cache parameters may be changed  
6086497 OERI[ktspgetmyb-1] / bitmap segment corruption for ASSM segments  
6316536 ALTER table to change column to TIMESTAMP WITH TIME ZONE can break constraints  
6361755 OERI:kfioRqTracer_insert:01 in ASM after an exception  
6405339 Corruption / OERI[kcbz_check_objd_typ_3] / OERI:5400 from PQ  
6453944 ORA-15196 with ASM disks larger than 2TB  
6471351 Invalidation redo generated under database force logging mode in RAC  
6493270 ASM does not resync disk properly if it is offlined due to a disk open failure on write  
6667318 Space sign at the end of XMLElement values removed by XMLtype()  
6684357 Change tracking at standby can miss changed blocks after a database crash  
6760697 DBMS_SPACE_ADMIN.ASSM_SEGMENT_VERIFY does not detect certain segment header block corruption  
6764606 BACKUP of backupset fails if re-read is needed

zf_wu

Corruption (Dictionary)
5211477 Sequence starts with wrong value after expdp/impdp  
5662283 CREATE or REPLACE view with FORCE can create a corrupt view definition  
6430688 Property 0x800 of internal object type (SYS_YOID%) is lost after running utlirp  
6430718 Wrong information in DBA_UPDATABLE_COLUMNS  
6441665 OERI [kkpolpd12] / dictionary corruption from coalesce of composite hash partitioned table  
6603249 Create interval partitioned table can insert bad dictionary interval data  
6666915 OERI[25027] / dictionary corruption from concurrent partition DDL  

Corruption (Logical)
3136315 Direct SQLLoad of a DATE column from a TIMESTAMP loads invalid data  
5667658 Wrong results / errors from flashback to SCN before segment shrink (affects MViews)  
5685411 Updating columns to NULL in a trigger may have no effect  
5874989 Datapump import can load data longer than column definition  
5951099 Wrong data in materialized view with concurrent insert to master table  
5988345 Update policy applied to more tables than is should for SELECT for UPDATE  
6215662 Direct path SQL*Load swaps bytes during load of BINARY_DOUBLE / FLOAT between platforms  
6343054 Corruption / errors from concurrent update/refresh on materialized join views  
6346393 Import can load bad SYS.ANYDATA into the database  
6458801 REPLACE on a CLOB can corrupt multibyte data  
6703563 Wrong MV data after fast refresh of ROWID based materialized view  
6756089 Floating point numbers in OBJECTs can loose precision > 5  
6804815 Jobs in incorrect schema after datapump import  
6826661 Wrong data in NUMBER column for specific FLOAT values (SQLT_FLT)  
6994194 Logical corruption from UPDATE DML  
7008262 Assigning EMPTY_CLOB/EMPTY_BLOB in a trigger does not work  
7197716 ALTER TABLE ADD CONSTRAINT should not be allowed on FLASHBACK data archive tables  

Corruption (Physical)
6646613* IOT corruption after upgrade from <= 9.2 to >= 10g. This bug is alerted in Note 471479.1  
4527606 MOVE of IOT can cause corruption / OERI  
6268371 ORA-12996 / ORA-12998 / corruption from ALTER TABLE DROP UNUSED COLUMNS CHECKPOINT  
6674673 ASM corruption after IO error with redundancy  
6730429 ORA-600 [ktecgeb-2] may occur after converting an ASSM tablespace to a different endianness using RMAN  
6795264 OERI:18127 / rollback segment corruption in RAC from global transaction  

Database Link / Distributed
5223587 OERI[4400] from distributed PDML with DDL  
5665531 ORA-22992 on select from remote table with local LOB variable  
5976269 Queries using a loopback database link cannot execute in parallel  
5977865 OERI:qerrmObnd1 from query over database link  
6028753 ORA-907 / ORA-933 from DML over database link  
6029071 Wrong results from distributed SQL with OUTER joins  
6056659 ORA-979 from SQL with ORDER BY and BINDS over database link  
6060280 Wrong results UNION ALL and database link  
6155920 ORA-2063 / ORA-972 in subquery using database link  
6163785 Intermittent Wrong Results with dblink and cursor_sharing  
6318678 ORA-904 from MERGE SQL over database link  
6351293 SQL may execute in wrong schema when using database links  
6520125 ORA-904 from a select over a database link  
6620988 ORA-904 from outer join query over database link  
6621937 [NO]PARALLEL_INDEX hint not sent to remote site for SQL over database link  
6718212 enhancement to dbms_stats to merge column usage statistics from remote system  
6828981 Unexpected ORA-1461 from SQL over database link  
6960874 ORA-1483 can occur with fix for bug 6828981  

Database Replay
6336576 Replay takes longer than capture on RAC  
6733318 Database replay client incorrectly replays timestamp data  
7040652 Replayed workload generates different content than original workload  

Datapump Export/Import
5158215 ORA-39023 / dump (kupfxinit) / ORA-39021 with SPACE character in COMPATIBLE parameter  
5192493 IMPDP fails if dmp file contains an invalid Oracle number  
5211477 Sequence starts with wrong value after expdp/impdp  
5523375 expdp does not export disabled PRIMARY KEY constraints  
5530086 EXPDP / DBMS_METADATA do not get TRIGGER data if DB_BLOCK_SIZE < 4k  
5690152 Package comments not imported when using datapump schema import  
5705160 Cannot impdp a table that has both LONG RAW and TDE encrypted columns  
5747615 DBMS_DATAPUMP.DATA_FILTER filter INCLUDE_ROWS=1 does not export row data  
5767565 ImpDP does not handle QUERY parameter with REMAP_SCHEMA set  
5861640 ORA-39127 / ORA-30926 from EXPDP of XMLTYPE column with functional index  
5874989 Datapump import can load data longer than column definition  
5891213 ORA-6502 / LPX-7 from DBMS_METADATA.GET_DDL with domain index present  
5944874 TABLE_STATISTICS through DBMS_METADATA returns analyze if function based index present  
5961283 ORA-39779 from IMPDP if source database has 8i objects  
6051635 Wrong DDL from DBMS_METADATA for domain index or index on XMLType column  
6063940 Datapump export / import does not handle tablespace groups  
6081425 impdp fails with ORA-1403 if table already exists  
6082832 EXPDP does not mask ENCRYPTION_PASSWORD parameter  
6084232 Corrupt datapump export of encrypted column data  
6156708 expdp puts the index creation statements into dump in wrong order  
6368018 Data pump import with compression=data_only fails (OERI:klaprs_12)  
6379123 EXPDP/IMPDP ORA-39083 due to changes in MERGE privilege between 10.1 and 10.2  
6454237 Wrong output from DBMS_METADATA.GET_DDL for trigger definition with comment  
6487005 impdp for AUDIT on DIRECTORY object fails  
6633314 ORA-29358 from IMPDP  
6633347 ORU-10027 from expdp  
6635956 DBMS_METADATA / Datapump import fails with LPX-7/ORA-39125  
6729716 expdp/impdp changes scheduler start_date (the year part)  
6749942 Cannot use 11g expdp with NETWORK_LINK to 10g  
6800507 Shared pool memory leak ("ksws service *" memory) using EXPDP often  
6804815 Jobs in incorrect schema after datapump import  

Datatypes (AnyData)
6346393 Import can load bad SYS.ANYDATA into the database  

Datatypes (LOBs/CLOB/BLOB/BFILE)
5049352 DBMS_LOB.LOADCLOBFROM does not work on files over 4gb (ORA-22288)  
5051432 DBMS_LOB does not execute with the privileges of the calling procedure  
5665531 ORA-22992 on select from remote table with local LOB variable  
6061623 OERI:qctcte1 from cost based transformation of INSERT as SELECT with TO_LOB  
6082605 ORA-32036 while executing a WITH clause statement  
6191877 OERI:kdlxSetEncxCtor-1 from MOVE of securefile LOB with encryption  
6315003 Truncate table fails with OERI[ktsstrn-4]  
6367945 OERI:kdliReadPos from securefile LOBs  
6376915 HW enqueue contention for ASSM LOB segments  
6412375 ALTER TABLE .. MODIFY LOB does not change PCTVERSION of BASICFILE/SECUREFILE LOB  
6413373 Lob HW enqueue contention  
6454763 Various OERI after recovery of SecureFile LOB buffers  
6603936 Hang/memory corruption/OCI-21500 using LOBS in OCI_OBJECT mode in multi-threaded client  
6607505 OERI [15201] from DML on table with FUNCTION BASED index on LOB column/s  
6620517 ORA-29308 from TSPITR with IOT with LOB column  
6667800 OERI:12333 / client hang using OCILob() in multithreaded OCI client  
6698457 Securefile LOB can over-allocate space  
6873515 ORA-32602 from conventional IMPORT for tables with FREEPOOLS LOB attribute  
7008262 Assigning EMPTY_CLOB/EMPTY_BLOB in a trigger does not work  

Datatypes (Objects/Types/Collections)
5308497 Dump (nsoexc) from natural join with correlation  
5944121 OERI:kghufree_06 using collections with non-final type elements  
5961283 ORA-39779 from IMPDP if source database has 8i objects  
6029647 ORA-12714 accessing typed column from TABLE() function  
6142534 OCCI getObject() fails to fetch null using isNull() from object with VARRAY  
6165874 OERI[kksfbc-reparse-infinite-loop] after DROP / reCREATE of subtype  
6430688 Property 0x800 of internal object type (SYS_YOID%) is lost after running utlirp  
6452485 SGA memory corruption / OERI [17182] with fix for bug 6085625  
6661262 TTS expdp from 10.2 and impdp into 11g fails for Spatial or object tables  
6708183 CBO cannot get good cardinality estimate for TABLE() functions  
6756089 Floating point numbers in OBJECTs can loose precision > 5  
6760382 Dump [evaopn2] from DML with triggers and functional index  

Datatypes (TIMESTAMP)
3136315 Direct SQLLoad of a DATE column from a TIMESTAMP loads invalid data  
5437593 Millisecond value not present using TIMESTAMPTZ.dateValue()  
5764402 JDBC TIMESTAMPTZ problems with milliseconds  
6119382 More expensive Index range scan chosen for TIMESTAMP predicate  
6156762 OCCI fractional seconds portion can be wrong  
6267310 Import of large table with a TIMESTAMP column is slow  
6316536 ALTER table to change column to TIMESTAMP WITH TIME ZONE can break constraints  
6317878 Dump [kksfbc] from INSERT ALL with TRIGGER for certain datatypes  
6330994 ORA-1830 from jobs executing programs with TIMESTAMP metadata arguments  
6336914 DBMS_SCHEDULER.GET_SYS_TIME_ZONE_NAME returns NULL for GMT time zone  
6659496 Slow load of XML documents with TIMESTAMP WITH LOCAL TIMEZONE  
6733318 Database replay client incorrectly replays timestamp data  
6868399 JDBC TIMEZONETAB.getOffset() returns wrong GMT offset  

Deadlock
5476091 Ctrl-C ignored for sessions waiting for mutexes  
5685189 Self deadlock on dc_objects after DBMS_SPACE.UNUSED_SPACE errors  
5756769 Deadlock between Create MVIEW and DML  
5849679 Undetected deadlock in RAC involving a TM lock  
6145177 Single resource deadlock with a zero DID  
6410146 Self deadlock from unbundled describe call  
6475688 Concurrent rewrite and on-commit refresh can deadlock (library cache pin <--> lock)  
6496514 RAC deadlock between "libary cache lock" and TX enqueue  
6514983 False global enqueue deadlock in RAC  
6618312 Deadlock between ON COMMIT materialized view refresh and query rewrite (library cache pin V lock deadlock)  
6644122 ON COMMIT refresh deadlock (library cache pin V lock)  
6710019 Deadlock / hang from concurrent MV refresh and TRUNCATE  
7175822 ORA-60 possible on DROP MATERIALIZED VIEW  

Diagnostic Output Problem / Improvement
6343023 Diagnostic enhancement to include short stacks in RAC deadlock reports  
6358382 10046 trace does not dump NCHAR bind variables in AL16UTF16  
6486564 Lack of symbolic stack trace for ocssd.bin or other executables  
6659611 Redo dump code fails to dump invalidation redo records  
6733627 Unaccounted Wait Time on "Direct Path" operations with FILESYSTEM_IO_OPTIONS=NONE  
6778199 OERI[kkocxj : pjpctx] lacks useful diagnostics  

Direct Path Operations
3136315 Direct SQLLoad of a DATE column from a TIMESTAMP loads invalid data  
3951755 SQLLDR Direct load OERI[kohdtf048] / ORA-21780 with function based index  
4224958 Direct path loader can dump loading SYSDATE into CHAR(8) column  
5944227 SQLloader direct path load into IOT can dump [kdblldrp]  
6770202 SQL Loader returns ORA-12899 with DIRECT=Y for shift sensitive data  

Domain Indexes
5891213 ORA-6502 / LPX-7 from DBMS_METADATA.GET_DDL with domain index present  
5908945 Dump [qxopqdca] with ancilliary operator  
6051635 Wrong DDL from DBMS_METADATA for domain index or index on XMLType column  
6497310 ORA-942 / dump for DML in XMLTYPE column with domain index  
6685261 Dump [lnxmin] using ancilliary operators with inline views  

Excessive CPU Usage
6193945 High LGWR CPU use and long 'log file sync' latency in RAC  
6337547 High CPU from query with DSLASH on recursive schema  
6356566 Memory leak / high CPU selecting from V$SQL_PLAN (affects statspack)  
6407273 LGWR spins during slow log switch  
6413089 Restarting a logminer session can be slow if the session has fallen behind  
6605370 Excessive hard parse time for nested SQL  
6641036 High CPU usage by MRP due to checksum processing  

Export/Import
5600056 Export of triggers extremely slow  
5872788 ORA-29821 importing OPERATORS  
6267310 Import of large table with a TIMESTAMP column is slow  
6346393 Import can load bad SYS.ANYDATA into the database  
6873515 ORA-32602 from conventional IMPORT for tables with FREEPOOLS LOB attribute  

Expression Filters / Rules
6708565 DBMS_RLMGR fails with ORA-38500 when specifying NLS length semantics  

External Tables
5734188 Wrong reporting of row number when using external table  
5852921 External tables can error with KUP-562  
5938620 ORA-30657 attempting to disable audit on an external table  
6189541 KUP-600 [kudmcxgg:grfunc] / incident report for user error with external table  
6522622 Allow external tables to be pre-processed  

Flashback
5667658 Wrong results / errors from flashback to SCN before segment shrink (affects MViews)  
6150680 ORA-38788 / ORA-38784 from CREATE RESTORE POINT <rpname> GUARANTEE FLASHBACK DATABASE  
6406880 System hang possible after killing processes when waiting for flashback logs  
6429856 False ORA-19815 errors from MMON  
6432837 ORA-19804 errors in alert log / RVWR trace  
6453203 Very high Flashback archive retention not handled properly  
6470994 Poor performance when flashback database is enabled with high PROCESSES value  
6511494 Cannot flashback (ORA-38753)  
6768069 Cannot FLASHBACK DATABASE on RAC physical standby  
6976005 CF enqueue held for longer than needed with flashback enabled  
7197716 ALTER TABLE ADD CONSTRAINT should not be allowed on FLASHBACK data archive tables  

Function Based Index (Including DESC Indexes)
3951755 SQLLDR Direct load OERI[kohdtf048] / ORA-21780 with function based index  
5522793 Wrong results when function based index which returns NCHAR is used  
5739162 Wrong result when SUBSTR is used in functional index  
5767661 Wrong results with function based index  
5861640 ORA-39127 / ORA-30926 from EXPDP of XMLTYPE column with functional index  
5944874 TABLE_STATISTICS through DBMS_METADATA returns analyze if function based index present  
6041584 Join elimination not working when function-based index exists on table  
6122097 Wrong Results/Dump [evaopn2] with function based index present  
6131467 Wrong result when function based index created with SUBSTR  
6145570 Wrong results / OERI from LIKE with join predicate pushdown  
6194582 High hard parse time with function based indexes  
6376928 Dump from GROUP BY query with predicates on functional index column  
6438731 Dump (under evaopn2) from INSERT as SELECT with function based index  
6474804 Dump [evaopn2] from push predicate with function based index  
6525496 Wrong results (no rows) from BITMAP operation on functional index  
6607505 OERI [15201] from DML on table with FUNCTION BASED index on LOB column/s  
6653704 Dump (evaopn2) from nested loop join with bitmap access to functional index  
6760382 Dump [evaopn2] from DML with triggers and functional index  
7026584 ORA-904 from query using function based index and subquery  

Gateways / Heterogeneous Services
6084823 ORA-2070 deleting from a table over HS using a NVARCHAR column in WHERE predicate  
6262792 MTA Extproc memory leak  
6351293 SQL may execute in wrong schema when using database links  
6398252 CHAR columns from HS source not correctly blank padded if NLS translated  
6701400 DG4ODBC does not allow access to Excel  
6778642 ORA-28500 / sqlcode=-417 from remote query against non-Oracle database  

Gateways / MGW Message Gateway
6754889 Unable to make bindings connection to non_default QMGR  

Gateways / Procedural Gateway For MQ Series
6686366 PG4MQ fails with ORA-28509  

Gateways / Transparent Gateway For DRDA
5735157 TG4DRDA does not properly support unicode data  

Global Temporary Tables
6683178 Capture performance degrades due to lots of DDL (eg truncate of empty tables)  
6756739 OERI[17183] / dump (kxttDrpPh) using temporary tables  

Globalization Support (NLS)
4991474 Codepoints 0x80 - 0x9f missing from some ISO 8859 character sets  
5131180 Wrong NLS settings after querying tables with DATE related constraints  
5522793 Wrong results when function based index which returns NCHAR is used  
5638367 Incorrect sorting of symbols "TEL" in GENERIC_M  
5685304 LocaleBuilder does not handle special letters in monolingual sorts  
5735157 TG4DRDA does not properly support unicode data  
6047482 Rebuilt GENERIC_M / custom sort dumps (lxsucPushKeysToBuf)  
6069409 ORA-979 when NLS_COMP=linguistic  
6084823 ORA-2070 deleting from a table over HS using a NVARCHAR column in WHERE predicate  
6131467 Wrong result when function based index created with SUBSTR  
6168288 Dump instead of ORA-1863  
6168297 ORA-12899 from OCIDirPathColArrayToStream with UTF8  
6195148 TO_MULTI_BYTE('-') maps to wrong display width in UTF8 / AL32UTF8  
6268409 ORA-29275 error when querying the sql_redo/undo columns of V$LOGMNR_CONTENTS  
6326934 Poor selectivity for equality of fixed CHAR column with VARCHAR2 bind  
6343150 Dataguard broker does not work with NLS_COMP=linguistic  
6357601 Romanian base letter mapping missing for some characters  
6388718 Partial multibyte character in V$SQL.SQL_TEXT (SP2-784 from sqlplus)  
6398252 CHAR columns from HS source not correctly blank padded if NLS translated  
6400373 Wrong result from DBMS_XMLGEN.CONVERT with multibyte input  
6439315 Two byte null terminator missing for SQLT_AVC SQLCS_NCHAR define  
6447861 OERI[evacolverflow] from monolingual sort in multibyte database  
6455659 Stored outlines do not work in multibyte DB  
6458801 REPLACE on a CLOB can corrupt multibyte data  
6460895 CSSCAN may hang / run slowly  
6494820 CSSCAN fails with ORA-1455 on tables with more than 2^31-1 blocks  
6510788 Wrong results from LIKE with certain NLS_SORT settings  
6627733 OERI[dmlsrvColLenChk_2:dty] inserting NULLs into CHAR length semantics column  
6642692 Wrong results from LIKE operator with NLS_SORT=BINARY_CI and NLS_COMP=linguistic  
6712066 Wrong result from internal copy of certain NLS characters  
6770202 SQL Loader returns ORA-12899 with DIRECT=Y for shift sensitive data  

Hang (Involving Shared Resource)
6310591 DB hang with CKPT waiting for enquiry response in RAC  
6406880 System hang possible after killing processes when waiting for flashback logs  
6418420 Database wide hang with process trying to flush buffers from the cache  
6522708 ASM instance may hang  
6809093 Hang due to TT enqueue waits on an UNDO tablespace  

Hang (Process Hang)
2227223 ALTER TABLESPACE READ ONLY waits for all active transactions to complete  
5476091 Ctrl-C ignored for sessions waiting for mutexes  
5756769 Deadlock between Create MVIEW and DML  
6120004 Concurrent eager transactions may cause logical standby apply to hang  
6144079 Instance crash in RAC (OERI:2103)  
6169451 OCCI client hangs after TAF failover when using session pools  
6175584 Insert hang with Foreign Key constraint and read-only tablespace  
6219529 RAC hang during exchange with hash locks  
6334552 Hang / ORA-4031 / OERI:kfrcsoDelete_3 on rollback of ASM file resize  
6394429 Sessions in resource group may be blocked  
6410146 Self deadlock from unbundled describe call  
6447303 Processes hang waiting for "DFS lock handle" on DROP DATAFILE  
6475688 Concurrent rewrite and on-commit refresh can deadlock (library cache pin <--> lock)  
6496514 RAC deadlock between "libary cache lock" and TX enqueue  
6603936 Hang/memory corruption/OCI-21500 using LOBS in OCI_OBJECT mode in multi-threaded client  
6618312 Deadlock between ON COMMIT materialized view refresh and query rewrite (library cache pin V lock deadlock)  
6644122 ON COMMIT refresh deadlock (library cache pin V lock)  
6667800 OERI:12333 / client hang using OCILob() in multithreaded OCI client  
6710019 Deadlock / hang from concurrent MV refresh and TRUNCATE  
6711644 Dump / hang in multithreaded OCI client  
6733394 RMAN channel failover hangs in 11g  
6970283 OCI hang / ORA-12559 after FAN notification

zf_wu

Hash Join
5947623 Excess PGA memory used by hash joins  
6126439 A query with hash join takes a long time to abort from kill session  
6471770 ORA-32695 from Hash GROUP BY  
6506617 Wrong results from STAR transformation with extended pruning  

Index Organized Tables (IOT)
6646613* IOT corruption after upgrade from <= 9.2 to >= 10g. This bug is alerted in Note 471479.1  
4527606 MOVE of IOT can cause corruption / OERI  
5406763 Wrong cost when access IOT through secondary index  
5885265 Deferred constraints may incorrectly error at commit for IOTs  
5944227 SQLloader direct path load into IOT can dump [kdblldrp]  
6070548 Dump (qertbGetPartitionNumber) / wrong results from bitmap access to IOT  
6354678 Wrong results from FIRST ROW MIN / MAX optimization on secondary IOT index  
6620517 ORA-29308 from TSPITR with IOT with LOB column  
6794366 CTAS dumps under qertqosSetProperties creating an IOT  

Instance May Crash
5686407 SGA memory corruption / instance crash with various ORA-600 [171XX] when using XDB  
6075582 OERI[kjbmpref:sh] / dump [kjmpbmsg] in LMS causing instance crash  
6079224 RAC ORA-27506 / IPC Send timeout  
6144079 Instance crash in RAC (OERI:2103)  
6153945 SMON crashes instance with OERI[ktcrsp_1: drop/truncate not comp]  
6269484 OERI [kjbresourcelatch] from DBW if there is a corrupt block in cache  
6271689 RAC instance crash possible  
6378112 LMS can crash RAC instance with OERI[kjblpkeydrmqscchkkey]  
6500033 LMON crash the instance with ORA-481 due to DRM sync timeout  
6501007 DRM sync timeout in RAC  
6509115 Instance crash in RAC due to OERI[504] on LMD  
6518062 RAC instance crah with OERI[kjlrem:!ast]  
6639644 ASM instance crash (ORA-15040 in SMON) during instance recovery in RAC  
6658484 Instance crash / OERI[kclexpand_5] from DRM in RAC  
6737765 PMON dump [kgskrecalc] crashes instance cleaning dead process  
6765855 DBW crashes instance with OERI[kjbrwreq:wip_piscn]  
6778714 Instance crash in RAC when PMON cleans dead process  
6925708 OERI:[kfclbast0_05] can occur in ASM with RAC and LMS may crash the ASM instance  
6934230 Instance crash from OERI:kfnmClientRegister05 with ASM  
6954722 OERI[15709] in SMON in RAC / instance crash  

Instance Startup
6143688 node startups cAN spend up to 2 mins in AQ partition code  
6469211 Slow startup with many log files on ASM  
6619318 GIM-105/GIM-104 from EM Healthcheck during instance startup  
6624011 ORA-4030 / ORA-4031 on startup with > 4Gb SGA_TARGET  
6795133 Startup delayed by QMNC queries  

Interoperability (Between Releases)
5377242 OERI[16203] on reference to remote synonym  
6749942 Cannot use 11g expdp with NETWORK_LINK to 10g  

JDBC
5437593 Millisecond value not present using TIMESTAMPTZ.dateValue()  
5764402 JDBC TIMESTAMPTZ problems with milliseconds  
6278984 java.awt.font.glyphvector.getglyphoutline returns empty shape  
6341494 Invalid property name JMSXRcvTimestamp specified for OJMS messages  
6629411 ArrayOutofBoundsException using awt GlyphVector  
6868399 JDBC TIMEZONETAB.getOffset() returns wrong GMT offset  

JavaVM / JSP / Corba etc..
5377060 ORA-604 ORA-1000 when selecting from DBA_JAVA_CLASSES  
5613685 Socket.connect() does not respect the timeout period in the JVM  
6310590 OERI:17147 under ioc_get_granted_roles in JVM  
6392076 Streams does not handle Java DDL correctly  
6408917 Excessive PGA memory use for REF cursors returned from stored Java  
6501565 Dump under JVM from JIT of Java class compiled with old Java compiler  
6641438 Java native frames not cleaned up  
6650069 ExceptionInInitializerError from JVM  
6653675 OERI[kgeade_is_0] under ioc_exit_call  
6653782 OERI[kghfru:ds] in Java Pool when using 64Mb granule size  
6723072 java.lang.SecurityException using Kerberos in stored Java  
6738567 JVM spins / fails to compile a class with modulus (%) operator  
6743907 OCI-21500 [17099] / Java VM dump when concurrent threads use same XDBDocument.toString()  
6833814 DBMS_JAVA.DEPLOY_CLOSE should not exist  

Job Queues
5705385 DBMS_SCHEDULE chain does not complete  
5928612 V$SESSION SQL_ADDRESS / SQL_HASH_VALUE not set for DBMS_JOBs  
6071651 Delays executing a job if execution time exceeds SCHEDULE_LIMIT  
6330994 ORA-1830 from jobs executing programs with TIMESTAMP metadata arguments  
6729716 expdp/impdp changes scheduler start_date (the year part)  
6805387 Job slaves not recycled in RAC  
7147411 Memory corruption / dump in kslgetl in CJQ  

Latch Contention
5918642 Heavy latch contention with DB_CACHE_ADVICE on  
6333663 Shared pool latch contention due to fragmentation of large pool  
6356566 Memory leak / high CPU selecting from V$SQL_PLAN (affects statspack)  
6505878 "shared pool" latch contention from XA / distributed transactions  
6530010 High version count for cursor with binds with fix for bug 5872943  

Leak (Memory Leak / Growth)
5386986 Leak / ORA-4031 leak when DROP UNUSED COLUMN issued on large partitioned table  
5947623 Excess PGA memory used by hash joins  
6011182 Parsing of large query takes long time / memory leak / ORA-4030 /4031  
6049324 Memory leak from array dequeue  
6065604 DBMS_AQ.DEQUEUE_ARRAY PGA memory leak  
6181488 Logical standby can fail ith ORA-4030  
6262792 MTA Extproc memory leak  
6271590 SGA subheap imbalance with lots of free memory in a few subheaps  
6356566 Memory leak / high CPU selecting from V$SQL_PLAN (affects statspack)  
6400175 Memory leak from DML with session_cached_cursors with TRIGGERs  
6408917 Excessive PGA memory use for REF cursors returned from stored Java  
6414844 Wasted memory possible from batch allocations in kghu subheaps  
6506816 ORA-4030 / memory leak in 'session heap' using XDB  
6506818 PGA memory leak (koh dur heap) converting XMLType to CHAR  
6615740 ORA-4030 in logical standy ("knas:shtrans"  
6653879 XA tracing leaks client side memory / dumps if trace cannot be written  
6656630 XmlAgg with GROUP BYleaks memory  
6800507 Shared pool memory leak ("ksws service *" memory) using EXPDP often  
6827260 Excessive memory usage for LCR cache due to large freelists  

Leak (Resources Eg: File Handles)
4693355 ASM does not close open descriptors even after DROP DISKGROUP  
5377060 ORA-604 ORA-1000 when selecting from DBA_JAVA_CLASSES  
6139547 Shadow process leak on ASM instance when diskspace exhausted (ORA-20)  
6625888 File handles open on dropped datafiles in RAC  
6730200 Kernel Asynch IO leak possible in some clients  

Literal Replacement (CURSOR_SHARING)
3461251 V$SQL_SHARED_CURSOR shows all N with CURSOR_SHARING=FORCE  
4071519 GROUP BY query with CURSOR_SHARING fails with ORA-1802  
5757106 OERI[15851] selecting aggregate of a constant with literal replacement  
6163785 Intermittent Wrong Results with dblink and cursor_sharing  
6337716 Wrong max column size for NULL strings with literal replacement  
7212120 Session cursor cache not used properly when CURSOR_SHARING=force/similar