补丁12.1.0.2在中修复的bug list

补丁12.1.0.2在中修复的bug list

 

 

12.1.0.2 Bug Fixes by Category

 

Advanced Networking Option

Undocumented Advanced Networking Option

17497520

 

JDBC

JDBC

13725094 Stored Java KPRB reports ORA-1459 for zero length string binds (rather than treating them as NULL)
17580553 OracleParameterMetaDataParser returns corrupted table and column names

Undocumented JDBC

9655468 10246250 14777095 14789006 15870552 16178394 16203115 16431531 16462666 16626549 16664993 16754863 16757837 16812581 17222466 17298891 17311363 17483619 17597382 17625111 17627221 17739502 17804361 17924262 18052561 18056788 18096964 18169399 18195760

 

Net Configuration Assistant – NetCA

Undocumented Net Configuration Assistant – NetCA

14087252 17871619

 

Net Manager – NetMgr

Undocumented Net Manager – NetMgr

17372478

 

Oracle Database Configuration Assistant

Undocumented Oracle Database Configuration Assistant

5841067 9563513 12402840 13401088 14570318 16316864 16713738 17166562 17397985 17604175 18019991

 

Oracle Database Gateway for APPC

Undocumented Oracle Database Gateway for APPC

14052525

 

Oracle Database Gateway for DRDA

Oracle Database Gateway for DRDA

14331264 db2 sql error -803 no longer mapped to ora-00001

Undocumented Oracle Database Gateway for DRDA

13926612 14276412 16667832 17370855 17489147 18292115

 

Oracle Database Gateway for Sybase

Undocumented Oracle Database Gateway for Sybase

14213919 17634518

 

Oracle Database Upgrade Assistant

Undocumented Oracle Database Upgrade Assistant

9540005 13810008 13857716 16238456

 

Oracle Fusion Middleware

Undocumented Oracle Fusion Middleware

15904453 16824331 18154692

 

Oracle Multimedia

Undocumented Oracle Multimedia

14798603

 

Oracle Net Services

Oracle Net Services

17572525E Enhancement to add SQLNET.FIPS_140 Net parameter
16747455 Client side segmentation fault with dispatchers POOL=ON when database shutdown
17490484 ASMCMD cp command fails with ORA-12569 “tns:packet checksum failure” or “ORA-12592 TNS:bad packet”

Undocumented Oracle Net Services

15958866 16403549 16409926 17054981

 

Oracle ODBC Driver

Undocumented Oracle ODBC Driver

9642938 13044472 16009315 16096713 16235055 16959397 17583959 17896495 18232462

 

Oracle OLAP

Undocumented Oracle OLAP

13859811 14167351 14323300 14500348 15954555 16265211 16446846 16656546 16784376 17170282 17316771 17334960 17408327 17430165 17458961 17673094 17741894 17928808 17959361

 

Oracle Security Service

Oracle Security Service

16410570E Internal enhancement to provide a ZT API for turning on FIPS mode
18513099 MES library update to MES 4.0.5.1

Undocumented Oracle Security Service

13714018 14784247 17898325

 

Oracle Server

Code Improvement

4991675E Diagnostic event improve diagnosability of data dictionary invalidation issues
12416600E Diagnostic enhancement for ORA-600 [4400] errors with Database Link involved
12911115E Diagnostic enhancement to allow setting of tracefile_identifier through oradebug
12928658E “ocr error code: %rc” in olsnodes.log does shows “%rc” instead of the error code
13117122E Enhance ORA-19625 error text
13117136E Enhance ORA-245 and ORA-19511 error text
13396185E Diagnostic enhancement to capture OS information about memory / swap in traces / alert
13593748E Avoid reporting ORA-600 [729] / ORA-600 [723] / ORA-600 [730] for minor and harmless leaks
13647312E Diagnostic enhancement to provide applied patch information in IPS package
13695011E Need a warning in alert log for lack of hugepages
13695236E New ORADEBUG PDUMP command to dump multiple stacks n seconds apart
13702947E Additional diagnostic trace for problems with network-file-transfer for RMAN active duplication
13771513E Additional diagnostics for heapdumps and ORA-4031 errors
13782248E Enhancement to expose parameter DEFAULT_VALUE in V$PARAMETER / V$SYSTEM_PARAMETER
14271183E Diagnostic enhancement for dynamic tracing of AQ event notification code
14525210E Diagnostic enhancement to write current and previous receive buffer for ORA-1461 and ORA-1460
14582560E Diagnostic enhancement to dump more information for ORA-600 [kcrfw_search_blklctn: Dead loop]
14780541E Diagnostic enhancement to include “ORA-60” in alert text when a GES Deadlock is detected
15832129E Include ONS logs when running diagcollection.sh
15898589E Enhancement to restrict the size of SGA base library cache heaps
16206952E Include messages related to OS load in the alert log file in RAC
16206997E Include in alert log file an error when a CSSD thread is not scheduled
16217962E Diagnostic enhancement to dump the PLSQL call stack for SQL parse errors from PLSQL
16317771E Improve log messages for daemon mdnsd
16346413E Provide log information when a gipc interface is cleaned up – superseded
16363060E Managed standby recovery should alert user when datafile is no longer valid
16707927E Enhancement to allow a subset of tablespaces to be used for a CREATE PLUGGABLE DATABASE
16727238E No information of primary timestamp that standby recovered up to during rolw transition
16742368E Diagnostic enhancement for ORA-600 [kglhpd-bad-free0] errors (introduces new error codes)
16747308E Script diagcollection.pl should collect patch information
16770399E Include obsolete cursor related information in AWR
16822629E SOURCE_FILE_NAME_CONVERT for PDBs in ASM is too long with many datafiles
16846090E Support query of software version on all cluster nodes
16988464E Diagnostic enhancement to show RAC DLM lock history in text form
16996992E Diagnostic enhancement to Validate a DLM lock when replaying a resource in RAC
17038200E Diagnostic enhancement for DBWR auto tracing of delayed/stalled writes
17038848E Diagnostic enhancement for improved event 10238 trace (kgi)
17043168E Diagnostic enhancement to add an additional argument to ORA-600 [kjbconsign:sender]
17043323E Diagnostic enhancement – Additional arguments for ORA-600 [kjbmiclo:creq]
17049117E Diagnostic enhancement to write RAC resource for ORA-600 [kjbwrdone:!op]
17049276E Diagnostic enhancement – Additional parameter in error ORA-600 [kjbmmchkinteg:from]
17049298E Diagnostic improvement for ORA-600 [kjblgolocal:g1]
17049676E Add additional argument to ORA-600 [kjbreqwr:xsp] error
17049773E Diagnostic enhancement to give additional parameter in error ORA-600 [ kjctr_pbmsg:badbmsg2]
17062524E Diagnostic enhancement to write default trace bucket to trace file for database
17080436E Diagnostic enhancement to write out OSS map elements in Exadata
17087371E Improve diagnostics for certain failures in ssclsi.c
17164551E Diagnostic enhancement to add more “_kgl_debug” trace points
17227541E Diagnostic enhancement for RAC to track stale “crstate”
17230905E Improved diagnostics when ASM in Exadata receives a hard check failure from the Storage Server (ORA-27626)
17264014E Diagnostic enhancement to write more information for ORA-600 [kgx*] errors
17315090E Improve error text for ASM ORA-15085 errors when reporting ‘sector size mismatch’ issues
17405302E Enhance oraagent gimh check message
17405605E Improve log messages when an OCR mirror is not available
17447078E Diagnostic enhancement for ORA-600 [kdBlkCheckError] .. [18007] errors
17531342E Clarify error CRS-1625: Node was manually shutdown
17550049E Improve diagnostics for asmcmd copy operations
17578682E udma should skip zeroed blocks
17596398E Enhancement to report datafile resize operations in the alert log
17609235E Diagnostic enhancement to add a table of contents to incident dumps for easier navigation
17610763E Diagnostic enhancement to allow clusterware trace file size to be modified
17626607E Add new error “ORA-600 [kcl_le2flash_6]” to try to catch cause of ORA-600[kclfadb_2] earlier
17707226E Diagnostic enhancement to allow clusterware trace file size to be modified
17711618E Diagnostic enhancement to write more information for ORA-600 [kclexpand_9] errors
17777061E Enhancement: Add datapatch parameters to operate on specific set of PDBs
17781373E Diagnostic enhancement or ORAAGENT to report that LOCAL_LISTENER is not set, if LISTENER_NETWORKS is used
17834663E Include SQL ID for statement that created a temporary segment in GV$SORT_USAGE
17844130E Diagnostic Enhancement to enable error snap history by default
17889599E Diagnostic enhancement to add additional arguments to ORA-600 [kjbrfixres:stalew] errors
17889691E Diagnostic enhancement – Additional parameters for ORA-600 [kjbldrmrpst:pkey] and ORA-600 [kjblpkeydrmqscchk:pkey]
17957017E Diagnostic enhancement to produce more information for ORA-600 [qesmaGetTblSeg1] errors
17997497E Diagnostic enhancement for event 39505 to trace clusterware calls from RDBMS code
17997508E Additional diagnostics when destroying a mutex in OCSSD
18047161E Diagnostic enhancement – additional arguments for ORA-00600 [kjrfnd1]
18119430E Improve diagnostics for ORA-600 [kfdJoin3 ]
18232647E DBVerify reports DBV-600 [21] [5] [0] [0] when datafile size is beyond expected – produce a more meaningful error
18284561E Diagnostic enhancement for ORA-600 [ktgFreeParam_1] and ORA-600 [ktgFreeParam_3]
18289960E Remove duplicated ORA-600 in ASM functions better diagnosability
18339044E Support encryption on oracle public cloud sbt library in standard edition
18352846E Additional log information when the ARP cache is deleted
18377764E Enhancement to dump full error message stack to the alert log on PDB open/close errors
18464784E Misleading message produced in ValidateIpExistence
18483595E Enhancement to support hair-trigger I/O timeout support for ASM
18596828E Producing ORA-1405 replacing a Voting File
17376015PE Windows: Diagnostic enhancement to include .sym files for component skgxp

Corrupt/Bad Backup

16057129 Exadata cell optimized incremental backup can skip some blocks to backup
16384983 RMAN bad backup – causes recovery to fail with ORA-600 [3020]
16692232 RMAN backup archivelog all not backed up / delete all input does not work as expect
18304997 RMAN deletes archivelogs not applied to a deferred standby even with fix 16082541
18455956 RMAN “restore primary controlfile” doesn’t convert role of controlfile
18487753 ‘report obsolete’ improperly shows datafile copies as obsolete

Corruption

17447078E Diagnostic enhancement for ORA-600 [kdBlkCheckError] .. [18007] errors
8352043 Logminer generates incorrect LCR for update to compressed table with trailing null.
16311211 ALTER INDEX .. REBUILD sets the MONITORING to OFF
16776922 ORA-1578/ORA-600 block corruption messages on the temporary data blocks
17193825 Missing supplemental log data for update DML on a previously compressed table
17386756 ORA-600 [krsr_rfs_wda.9] reported by RFS
17443671 Exadata block repair may invalidate cache lines
18240704 ORA-8103 during upgrade on ALTER TABLE kottd$ MOVE LOB

Corruption (Dictionary)

7449468 “jar” files loaded with “loadjava -jarsasdbobjects” not dropped when user is dropped
16187992 Public functions synonyms take precedence over the constructors of local object types – superseded
16275522 Streams may stall / give constraint errors after ALTER TABLE DDL
16676109 Procedure referring to a public synonym still valid after EXECUTE privilege is revoked
16783376 ORA-600 [kdstgr_ktid_not_ehcc_compressed] from ANALYZE of HCC compressed table ONLINE
16791865 “ALTER TABLE .. add .. default ” not null” executes without error
16982702 NUMBER/NUMBER(38) datatype discrepancies between base table and FDA history table
17032726 PDB upgrade does not populate old type OBJ$ signature properly (ORA-600 [kqludp2])
17159920 Column precision mismatch on view created on table with flashback data archive
17563549 xdb.xdb_resource_t is not modified properly when upgrading from 10.2 to 11g or higher
17785817 Dictionary entry in SLOG$ is not removed if users other than owner drop a materialized view
17920125 huge trace file is dumped due to corrupted row cache subordinate object

Corruption (Index)

17761775+ ORA-600 [kclchkblkdma_3] ORA-600 [3020] or ORA-600 [kcbchg1_16] Join of temp and permanent table in RAC might lead to corruption
17449815 ORA-8102 ORA-1499 after ORA-1/ORA-2291 by MERGE with DML ERROR LOGGING

Corruption (Logical)

14398428+ Sporadic Wrong results from Exadata (duplicate rows)
13521413 Incorrect supplemental redo generated when using IOT with keys > 128 bytes long
13866822 catbundle rollback does not update registry$history correctly
14580303 Incorrect timestamp data inserted via instead-of trigger
14789076 Wrong data due to column swapping using trigger and CLOB with bind size >4000
15894143 Insert statement via database link causes wrong results / logical corruption
15913355 Supplementally logged column values incorrect for clustered tables
15999982 ORA-600 [kcl_sanity_check_cr_1] ORA-600 [kclchkblkdma_3] in RAC or ORA-752 ORA-600 [3020] during recovery
16491477 Missing changes to Securefile LOB if session gets an error
16523150 OGG errors / missing info due to DML reordering
16579012 instantiation_scn incorrectly set via expdp/impdp
16584684 Corrupt data / errors from OGG replicate of LOB to LONG in multibyte
16663303 Incorrect privileges from upgraded DB with PDB
16683859 OGG data divergence after piecewise LOB update on compressed Securefile LOB with deduplication
16700693 ORA-600 [12406] after import compressed partition table via TTS
16910001 Streams apply eager error not recorded causing OGG to have missing data
17036357 ORA-1438 from SQLLDR direct path on virtual column / ORA-600 [KUPDLS_RDDATA-01] from IMPDP with DIRECT_PATH
17311728 Incomplete supplementally logged columns in OGG
17325413 Drop column with DEFAULT value and NOT NULL definition ends up with dropped column data hitting disk leading to corruption
17348614 Logminer generates unsupported LCRs when mining XMLType table with out-of-line storage and LOB
17488527 ImpDP remap_table of a partition over network_link does not remap the table name
17501565 DBMS_STATS.gather_system_stats on Exadata gets inconsistent measurement of IOTFRSPEED
18284763 ORA-600 [3020] on ASSM blocks in Standby Database after CONVERT TO PHYSICAL or ORA-8103 ORA-600 [4552] in non-standby after FLASHBACK
18436307 A trigger with a ‘WHEN’ condition that is created on an Editioned View (EV) does not fire when the EV has a VPD policy defined on it

Corruption (Physical)

17761775+ ORA-600 [kclchkblkdma_3] ORA-600 [3020] or ORA-600 [kcbchg1_16] Join of temp and permanent table in RAC might lead to corruption
13498382 ORA-1122 ORA-1208 RMAN Duplicate overwrites datafiles at original location despite db_create_file_dest
16057129 Exadata cell optimized incremental backup can skip some blocks to backup
16384983 RMAN bad backup – causes recovery to fail with ORA-600 [3020]
16844448 ORA-600 [3020] after flashback database in a RAC
17217593 Various corruption related ORA-600 attempting to apply undo to a temporary table
17325413 Drop column with DEFAULT value and NOT NULL definition ends up with dropped column data hitting disk leading to corruption
17437634 ORA-1578 or ORA-600 [6856] transient in-memory corruption on TEMP segment during transaction recovery / ROLLBACK (eg: after Ctrl-C)
17480600 ORA-8103 / ORA-600 [ktsfbfmt:objdchk_kcbnew_3] after ALTER INDEX on AQ$_QT_I/T
18159793 Data corruption / ORA-600 from large I/Os to/from dNFS (eg using RMAN)
18356166 ORA-600:[kdblkcheckerror][x][x][18020] possible in ASSM
18508861 Create datafile on RAW can produce a corrupt file header / causes ORA-17515 and crash in 11.2.0.4
18619917 Block corruption / ORA-600 [kdBlkCheckError]..[6110] on insert to OLTP compressed table
18788853 ALTER TABLESPACE .. ADD DATAFILE .. REUSE on existing datafile can corrupt the file

Deadlock

14780541E Diagnostic enhancement to include “ORA-60” in alert text when a GES Deadlock is detected
8250557 Unexpected deadlock involing DDL against functional index or domain index may happen
12608451 Deadlock from concurrent DDL with “library cache lock” / “library cache load lock” wait
13869467 Many waits for ‘row cache lock’ in RAC while creating many tables with constraints
13884774 Deadlock from concurrent select/ALTER SUMMARY and ALTER TABLE if query_rewrite_enabled set to true/force – superseded
15975838 ORA-60 between MMON slave and auto space advisor
16191248 Hang from concurrent drop of on-commit materialized views or using DBMS_REDEFINITION
16448569 PQ hang/deadlock possible – “cursor: pin S wait on X” waits
16571443 ORA-60 deadlock inserting to SECUREFILE with FDA enabled
16585527 Parallel MERGE statement produces ORA-60 on table with HCC partitions
16660242 ORA-4020 from CTAS with SQL profile and SPM
16741246 ORA-60 deadlock aborts apply process rather than rollback and retry
16943711 OGG XStream inbound encounters ORA-60 deadlock error on EHCC tables
16981293 ORA-60 can occur when executing multiple impdp commands concurrently
17082359 ORA-60 deadlock from OGG apply (IR) into securefile columns with deduplicate on
17165204 Self deadlock while updating HCC compressed tables
17514321 ORA-12008 / ORA-4020 with fix for bug 17051587 present
17571306 Self deadlock on CREATE OR REPLACE SYNONYM SQL
17588480 library cache mutex/shared pool latch deadlock
17602269 DISKMON master hang due to self deadlock
17828499 Opening PDB hangs waiting for row cache lock on open UPGRADE
17982838 ORA-60 during PDB rename
18163767 expdp or impdp encounters ORA-60 on CREATE TABLE ET$ statement – superseded
18560427 MV refresh fails intermittently with ORA-4021 with fix for bug 13884774

Diagnostic Output Problem / Improvement

4991675E Diagnostic event improve diagnosability of data dictionary invalidation issues
12416600E Diagnostic enhancement for ORA-600 [4400] errors with Database Link involved
12911115E Diagnostic enhancement to allow setting of tracefile_identifier through oradebug
12928658E “ocr error code: %rc” in olsnodes.log does shows “%rc” instead of the error code
13117122E Enhance ORA-19625 error text
13117136E Enhance ORA-245 and ORA-19511 error text
13396185E Diagnostic enhancement to capture OS information about memory / swap in traces / alert
13593748E Avoid reporting ORA-600 [729] / ORA-600 [723] / ORA-600 [730] for minor and harmless leaks
13647312E Diagnostic enhancement to provide applied patch information in IPS package
13695011E Need a warning in alert log for lack of hugepages
13695236E New ORADEBUG PDUMP command to dump multiple stacks n seconds apart
13702947E Additional diagnostic trace for problems with network-file-transfer for RMAN active duplication
13771513E Additional diagnostics for heapdumps and ORA-4031 errors
13782248E Enhancement to expose parameter DEFAULT_VALUE in V$PARAMETER / V$SYSTEM_PARAMETER
14271183E Diagnostic enhancement for dynamic tracing of AQ event notification code
14525210E Diagnostic enhancement to write current and previous receive buffer for ORA-1461 and ORA-1460
14582560E Diagnostic enhancement to dump more information for ORA-600 [kcrfw_search_blklctn: Dead loop]
14780541E Diagnostic enhancement to include “ORA-60” in alert text when a GES Deadlock is detected
15832129E Include ONS logs when running diagcollection.sh
15898589E Enhancement to restrict the size of SGA base library cache heaps
16206952E Include messages related to OS load in the alert log file in RAC
16206997E Include in alert log file an error when a CSSD thread is not scheduled
16217962E Diagnostic enhancement to dump the PLSQL call stack for SQL parse errors from PLSQL
16317771E Improve log messages for daemon mdnsd
16346413E Provide log information when a gipc interface is cleaned up – superseded
16363060E Managed standby recovery should alert user when datafile is no longer valid
16742368E Diagnostic enhancement for ORA-600 [kglhpd-bad-free0] errors (introduces new error codes)
16747308E Script diagcollection.pl should collect patch information
16770399E Include obsolete cursor related information in AWR
16988464E Diagnostic enhancement to show RAC DLM lock history in text form
16996992E Diagnostic enhancement to Validate a DLM lock when replaying a resource in RAC
17038200E Diagnostic enhancement for DBWR auto tracing of delayed/stalled writes
17038848E Diagnostic enhancement for improved event 10238 trace (kgi)
17043168E Diagnostic enhancement to add an additional argument to ORA-600 [kjbconsign:sender]
17043323E Diagnostic enhancement – Additional arguments for ORA-600 [kjbmiclo:creq]
17049117E Diagnostic enhancement to write RAC resource for ORA-600 [kjbwrdone:!op]
17049276E Diagnostic enhancement – Additional parameter in error ORA-600 [kjbmmchkinteg:from]
17049676E Add additional argument to ORA-600 [kjbreqwr:xsp] error
17049773E Diagnostic enhancement to give additional parameter in error ORA-600 [ kjctr_pbmsg:badbmsg2]
17062524E Diagnostic enhancement to write default trace bucket to trace file for database
17080436E Diagnostic enhancement to write out OSS map elements in Exadata
17087371E Improve diagnostics for certain failures in ssclsi.c
17164551E Diagnostic enhancement to add more “_kgl_debug” trace points
17227541E Diagnostic enhancement for RAC to track stale “crstate”
17230905E Improved diagnostics when ASM in Exadata receives a hard check failure from the Storage Server (ORA-27626)
17264014E Diagnostic enhancement to write more information for ORA-600 [kgx*] errors
17405302E Enhance oraagent gimh check message
17405605E Improve log messages when an OCR mirror is not available
17447078E Diagnostic enhancement for ORA-600 [kdBlkCheckError] .. [18007] errors
17531342E Clarify error CRS-1625: Node was manually shutdown
17550049E Improve diagnostics for asmcmd copy operations
17596398E Enhancement to report datafile resize operations in the alert log
17609235E Diagnostic enhancement to add a table of contents to incident dumps for easier navigation
17610763E Diagnostic enhancement to allow clusterware trace file size to be modified
17626607E Add new error “ORA-600 [kcl_le2flash_6]” to try to catch cause of ORA-600[kclfadb_2] earlier
17707226E Diagnostic enhancement to allow clusterware trace file size to be modified
17711618E Diagnostic enhancement to write more information for ORA-600 [kclexpand_9] errors
17781373E Diagnostic enhancement or ORAAGENT to report that LOCAL_LISTENER is not set, if LISTENER_NETWORKS is used
17834663E Include SQL ID for statement that created a temporary segment in GV$SORT_USAGE
17844130E Diagnostic Enhancement to enable error snap history by default
17889599E Diagnostic enhancement to add additional arguments to ORA-600 [kjbrfixres:stalew] errors
17889691E Diagnostic enhancement – Additional parameters for ORA-600 [kjbldrmrpst:pkey] and ORA-600 [kjblpkeydrmqscchk:pkey]
17957017E Diagnostic enhancement to produce more information for ORA-600 [qesmaGetTblSeg1] errors
17997497E Diagnostic enhancement for event 39505 to trace clusterware calls from RDBMS code
17997508E Additional diagnostics when destroying a mutex in OCSSD
18047161E Diagnostic enhancement – additional arguments for ORA-00600 [kjrfnd1]
18119430E Improve diagnostics for ORA-600 [kfdJoin3 ]
18232647E DBVerify reports DBV-600 [21] [5] [0] [0] when datafile size is beyond expected – produce a more meaningful error
18284561E Diagnostic enhancement for ORA-600 [ktgFreeParam_1] and ORA-600 [ktgFreeParam_3]
18289960E Remove duplicated ORA-600 in ASM functions better diagnosability
18352846E Additional log information when the ARP cache is deleted
18377764E Enhancement to dump full error message stack to the alert log on PDB open/close errors
18464784E Misleading message produced in ValidateIpExistence
18596828E Producing ORA-1405 replacing a Voting File
14799449P AIX: Diagnostic stack unwind can fail with ORA-7445 [sskgds_snm]
17376015PE Windows: Diagnostic enhancement to include .sym files for component skgxp
13929159 Instance crash due to ORA-700[dbgrfrfr_2] / ORA-7445[dbgrfrfr_remove_fileref]
14076173 oifcfg iflist -p -n shows unnecessary and confusing output
14829250 ORA-7445 [ktbdbh] during diagnostic IOT output
16242449 aqmonitor.sql does not report on 12c AQ performance views
16394467 SQL_Optimizer / 10053 diagnostic trace shows costs / cardinalities with only 2 digits of precision
16747257 10053 index selectivity is printed as float instead of exponent showing 0.000000 instead of a true value
16928832 Exadata reconnect diagnostics missing
17480013 Warning “failed to retrieve db spfile location” in the alert log
17862404 User errors such as ORA-1543 not reported in alert.log in PDB
17920125 huge trace file is dumped due to corrupted row cache subordinate object

Error May Occur

14398428+ Sporadic Wrong results from Exadata (duplicate rows)
17761775+ ORA-600 [kclchkblkdma_3] ORA-600 [3020] or ORA-600 [kcbchg1_16] Join of temp and permanent table in RAC might lead to corruption
17475946P root.sh or acfsroot install fails with ACFS-9109 on SLES11 SP3
5143510 Cannot run dbms_xdbt unless logged in as XDB
11733603 ORA-54 with select statement using NOWAIT clause with no concurrent active transaction
11795985 PLSQL binds may fail with ORA-6502 in a multi-byte characterset
12364061 Flashback Versions query fails intermittently with ORA-30054
12650550 ORA-1436 on executing DBMS_STREAMS_ADVISOR_ADM.analyze_current_performance
12756248 RMAN-6004 ORA-1422 during RMAN restore on query from CATALOG tables: site_dfatt, df, node
13498382 ORA-1122 ORA-1208 RMAN Duplicate overwrites datafiles at original location despite db_create_file_dest
13768027 Datapump import raises KUP-11007 and ORA-1403
13829543 In DG auto resync from standby overwrites the standby controlfile – can cause resync/backup errors
13947258 ORA-16000 Unable to drop restore point from ADG database
13974665 ORA-24365 on replication push job with CLOB data
14090953 DBMS_SPACE.ASA_RECOMMENDATITON fails with ORA-6502 if NLS_NUMERIC_CHARACTERS set
14202396 Datapump remap_data fails if used for more than 10 cols in a table
14237433 ORA-918 from MERGE statement on partitioned table
14263190 A duplicate fails with RMAN-5531 when source is a standby
14285317 RMAN duplicate fails ORA-1507 if source has archivelog mode and cold backup
14307048 ORA-1427 from UTL_SPADV.collect_stats
14354737 Unexpected PLSQL compilation errors, such as PLS-206
14382117 ORA-4030 trying to allocate 488 bytes (callheap,kprbalo temp memory )
14476359 Dequeue by condition from secure queue can give ORA-1427
14489435 KBHS-715 “transfer-timeout” error restoring backups from S3 using RMAN
14595800 DRG-50857 / ORA-904 from CREATE of CONTEXT index on XMLType column with FGA policy on the table
14735446 impdp skip_constraint_error option does not work on PK with non unique index
14742832 ORA-2097 / ORA-1031 from MV refresh in non-atomic mode if _FIX_CONTROL has been set
15834345 DBMS_STATS.gather_database_stats_job_proc fails with ORA-942
15861775 ORA-1000 cursor leak from some V$ / X$ table accesses
15913355 Supplementally logged column values incorrect for clustered tables
15916457 Data pump fails to import REFERENCE partitioned tables if parent is in different schema (ORA-942)
15922287 ORA-1427 from DBMS_METADATA for a view with Editions enabled
15931893 ORA-338 may be written to the alert log on startup even though they are ignored
15931910 Clone remote PDB by database link fails with ORA-17628/ORA-19505
15975838 ORA-60 between MMON slave and auto space advisor
15979965 RMAN is aborted by resource manager with ORA-40
15999982 ORA-600 [kcl_sanity_check_cr_1] ORA-600 [kclchkblkdma_3] in RAC or ORA-752 ORA-600 [3020] during recovery
16173738 Controlfile creation fails with ORA-27603/ORA-27626 “Offload library initialization failed” – superseded
16188701 ORA-942 / ORA-7445 [ksscct] invoker right procedures run by users in parallel
16195633 ACFS hang / ORA-15023 from proxy instance alert and RBAL
16227068 ASM cannot create diskgroup with compatible.advm = 12.1.0.1.0
16228604 ORA-600 [kglUnlock-bad-lock] on restarting OGG Extract with missing/deleted REDO logs
16233001 expdp with network_link fails with ORA-39166
16275522 Streams may stall / give constraint errors after ALTER TABLE DDL
16281499 ORA-39127 from expdp after upgrade from 11.2.0.2 to 11.2.0.3
16286774 ORA-1405 restarting logminer when mining a PDB dictionary
16310682 ORA-39126 / ORA-22813 from datapump export of PROCOBJ items
16345970 ORA-2070 / ORA-600 [HO define: Long fetch] with DG4odbc
16369430 IMPDP reports ORA-39083/ORA-22808 when creating an index
16370198 ORA-1031 or ORA-942 by Apply process during INSERT INTO SYSTEM.LOGSTDBY$APPLY_PROGRESS
16382883 ORA-4030 (kolarsCreateCt,qmemNextBuf:Large Alloc) from XML query
16433869 ORA-955 during upgrade in XDB$RCLIST
16462998 XQuery fails with ORA-1704
16469401 ORA-904 accessing an XMLtype object with row level security policy
16472716 ORA-22920 occurs when applying piece-wise lob operation in Logical standby – superseded
16495802 Logminer ORA-16211 mining update of chained IOT rows with overflow
16496977 return code 4067 seen in AUD$ for the operation using database link
16524071 LMHB crashes the instance due to ORA-29770 during remastering with many locks
16524926 ORA-1031 from LOB writes in stored Java (JDBC KPRB) in definers rights
16543323 LMHB terminates instance with ORA-29770 due to LMS apparent slowness
16561657 Transport tablespace with DataPump does not preserve “add column optimization” flags
16571244 DBMS_RLS reports ORA-1031 on DV protected opbjects
16571443 ORA-60 deadlock inserting to SECUREFILE with FDA enabled
16571785 High “KTC latch subh” SGA memory use due to “lobs commit callback”
16572554 disabled local listener state remains ‘ready’ and causes ORA-12541
16584288 Space advisor job fails with ORA-6532
16584684 Corrupt data / errors from OGG replicate of LOB to LONG in multibyte
16585527 Parallel MERGE statement produces ORA-60 on table with HCC partitions
16585628 Nested table create fails in DBFS with ORa-64007 / ORA-6512 / ORA-1422
16590848 OGG add / delete supplemental logging fails with ORA-1031
16605180 Schema validation fails / LSX-222 when database is NOT AL32UTF8
16613676 ORA-2097 from ALTER SYSTEM SET DG_BROKER_START .. when the database is in NOMOUNT state
16617325 Apply fails with ORA-2292 “integrity constraint error”
16618977 ORA-27163 can occur during XML parsing of non-USASCII / non-UTF8
16621274 ORA-1422 from OGG inbound server with ALLOW_DUPLICATE_ROWS = Y
16621589 ORA-1426 “numeric overflow” from AUTO_SPACE_ADVISOR_JOB_PROC
16622497 ORA-917 from DBMS_REDEFINITION when attempting to add a new column using a sequence
16634207 Errors like ORA-21525 using collections of NVARCHAR2 between client and server with differing NLS settings
16634312 ORA-1426 “numeric overflow” from DBMS_STATS.gather_system_stats
16657378 ORA-20008 from DBMS_STATS.create_extended_stats
16660242 ORA-4020 from CTAS with SQL profile and SPM
16663303 Incorrect privileges from upgraded DB with PDB
16675668 ORA-1031 querying Spatial data with DV
16675739 ORA-22921 / ORA-4088 during database character set conversion with PDB
16682595 SPFILE / V$SPPARAMETER problems with PDB
16697600 ORA-65019 from “alter pluggable database all open instances = all”
16698577 ORA-10387 and ORA-600 [kglReleaseHandleReference1] from PQ with PDB
16707791 ORA-14223 during Datapump import for some tables with deferred segment creation
16709437 ORA-65074 during database upgrade
16710753 Excess shared pool memory use / ORA-4031 from DROP EDITION
16718622 ORA-29877 / ORA-1031 using Oracle Text index type with Database Vault
16730813 ORA-65144 when disabling restricted session in root
16744640 ORA-942 on a view on an FDA table with AS OF TIMESTAMP
16747736 LogMiner memory leak / ORA-1341 “logminer out-of-memory”
16756136 MapMessage enqueued by AQ-JMS API throws ClassCastException when dequeued by PL/SQL
16757715 RMAN backups throws ORA-27504 when copying a datafile to an NFS target
16757934 ORA-1461 using MAX_STRING_SIZE=EXTENDED with PDB
16769019 ORA-1403 in OGG with inline LOB and dedup fetch for PK update
16769943 diskgroup cannot mount on Exadata with cell down ( ORA-15080 )
16769998 impdp with REMAP_SCHEMA fails with ORA-31693 and ORA-932 when schema name < 8 characters
16776922 ORA-1578/ORA-600 block corruption messages on the temporary data blocks
16777689 ORA-6502 may occur due to improper sharing of a PL/SQL anonymous block cursor
16782193 ORA-38802 creating non Editioned object
16787973 OGG integrated replicat abends with OCI error ORA-1403 “no data found”
16788832 ORA-27609 error in smart scan in rare cases
16805362 ORA-1843 from predicate containing NVL and TO_DATE
16815432 ORA-39126 ORA-6502 from DataPump export
16816103 XIN aborts with ORA-4031 due to memory leak in OCIXStreamInCommit
16837704 ORA-54 from ‘ALTER INDEX MONITORING USAGE’ with active transaction
16844448 ORA-600 [3020] after flashback database in a RAC
16863989 Streams propagation sender does not reconnect after communications failure
16864048 ALTER USER .. ENABLE EDITIONS raises ORA-4030
16864359 ORA-1157 signaled for tempfiles in a PDB that requires dictionary check
16888264 Plugin of PDB returns ORA-65149
16897998 impdp returns unnecessary ORA-1 when SKIP_CONSTRAINT_ERRORS is used
16903536 ORA-12751 in MMON during regular AWR purge
16912439 OGG-2028 failed to attach: knlciDumpCaptureVDollarViewInfo err 1403
16918087 expdp transportable tablespace gives ORA-39127 / ORA-1422
16929165 ORA-900 / ORA-4045 compiling PLSQL if error position > 32767
16946613 Common user which was local prior to sync not synced on PDB open
16946990 ORA-65050 creating a user in a local PDB if “_ORACLE_SCRIPT” is set
16953880 Lots of “LRM-00109: could not open parameter file …” messages in non-Exadata environment with fix 16314214 present
16981293 ORA-60 can occur when executing multiple impdp commands concurrently
16982702 NUMBER/NUMBER(38) datatype discrepancies between base table and FDA history table
16995929 DBMS_METADATA.GET_DDL generates incomplete DDL for nested tables / ORA-22913 from IMPDP
17011832 RMAN-6023, RMAN-6026 on tablespace point in time recovery
17016369 ORA-1 against SYS.STREAMS$_APPLY_ERROR_TXN_UNQ from Streams
17037130 Excess shared pool “PRTMV” memory use / ORA-4031 with partitioned tables
17050888 ORA-600 compiling object in Edition after dropping covered objects
17059198 ORA-1 on TS_P1 during RMAN upgrade catalog
17079301 ORA-6525 length mismatch from MMON job
17080195 ORA-979 “not a group by expression” for a SQL with CASE operator and GROUP BY
17082359 ORA-60 deadlock from OGG apply (IR) into securefile columns with deduplicate on
17082983 Memory corruption querying some fixed tables / views (ORA-4029 / ORA-600 [17147] / ORA-600 [kghfrmrg:nxt])
17156687 ORA-600 [nsoexp:cby strp] with subquery and LEVEL pseudo column without a CONNECT BY
17182200 SET CONTAINER reports ORA-1035 even with restricted session privilege
17186905 Flashback database on standby reports ORA-38861 unnecessarily
17216406 PLS-201 selecting from view using an Editioned Function if function not in ORA$BASE (ORA-6552 / ORA-6553)
17227277 ORA-1741 during LogMining certain DDLs
17255538 ORA-4030 (kxs-heap-c,chedef : qcuatc) on REFRESH of an INVALID materialized view
17258090 Recursive SQL fails with ORA-1008 even with fix for bug 14458214
17280117 ORA-942 on DBMS_SCHEDULER during upgrade from 12.1.0.1
17292630 ORA-16075 in RAC with maximum protection mode after restart
17297939 OGG cursor leak during apply with Integrated Replicat
17306264 Frequent ORA-1628 max # extents (32765) reached for rollback segment
17308532 ORA-1507 from CKPT during shutdown
17324822 PDB sync does not sync delegate option for existing common role
17334246 ORA-31181 when DBMS_XMLDOM.FREEDOCUMENT frees incorrect domdocument object
17346091 OGG Integrated extract abends with OGG-2077 extract encountered error code 15012
17346671 ORA-3106 when selecting an empty LOB over the long interface
17348361 ORA-27028 / ORA-19511 from RMAN backup with “Object too large” message
17351122 Logical Standby terminates with ORA-1281 after consecutive automatic restarts
17357979 ORA-942 from SQL when a factored subquery is referenced in multiple full joins
17361122 ORA-22324 / ORA-4045 / ORA-60 when upgrading from 9.2 with XDB
17369347 ORA-1719 on query rewrite with outer join outside a disjunction
17381384 ORA-1427 from multiple logminer sessions loading data for tables with REF columns
17405549 ORA-65125 can occur due to a problem with PDB metadata
17414276 AQ dequeue operation throws ORA-1008 when cancelled and re-attempted
17437634 ORA-1578 or ORA-600 [6856] transient in-memory corruption on TEMP segment during transaction recovery / ROLLBACK (eg: after Ctrl-C)
17446849 KUP-4094 from external table with PREPROSESSOR directive – affects DBMS_QOPATCH and OPATCH_XML_ENV
17449815 ORA-8102 ORA-1499 after ORA-1/ORA-2291 by MERGE with DML ERROR LOGGING
17461374 Create and drop of a single PDB repeatly fails with ORA-59
17467075 Unpexpected ORA-4029 querying fixed tables/views
17468141 ORA-7445 [kglobcl] with client side PLSQL (such as Forms)
17478145 ORA-6540/ORA-900 when dropping library unit in old Edition
17480600 ORA-8103 / ORA-600 [ktsfbfmt:objdchk_kcbnew_3] after ALTER INDEX on AQ$_QT_I/T
17514321 ORA-12008 / ORA-4020 with fix for bug 17051587 present
17528315 ORA-29532 on javamail API
17549937 ORA-23308 from DBMS_STREAMS_ADM.maintain_change_table
17561400 ORA-14004 during online redefinition (DBMS_REDEFINITION) of partitioned table
17563549 xdb.xdb_resource_t is not modified properly when upgrading from 10.2 to 11g or higher
17571306 Self deadlock on CREATE OR REPLACE SYNONYM SQL
17572720 ORA-2032 signalled when querying CDB views
17590813 Identical predicates in disjoint incorrectly generate ORA-1719 error
17596344 ORA-6502 from datapatch for patches with a large number of patch files
17605638 ORA-16075 during restart of RAC instance in maximum protection
17610418 ORA-29548 from plugged in different version non CDB as PDB
17634921 ORA-22926 for direct path operation on table with LOBS in Logical Standby
17663482 Errors from Flashback Data Archive if table includes a column named “OPERATION”
17694209 OCI-21500 [knclprstr:str] from OGG
17750832 SET CONTAINER incorrectly enforces resource limit check for ADMIN users (ORA-2391)
17752995 ORA-4031 from explain of SQL with many subqueries and OR expansion
17754390 Diskgroup attributes disk_repair_time and failgroup_repair_time cannot be set to maxvalue
17782561 ORA-16075 in maximum protection on RAC
17810692 ORA-30757 on propagation between databases with different timezone files – superseded
17836837 ORA-1652 in TEMPORARY tablespace even though there is space
17848897 AQ propagation reports ORA-22337 with different database timezones or character sets
17867137 ORA-700 [Offload issue job timed out] on Exadata storage with fix of bug 16173738 present
17898041 catcon.pl reports ORA-942 errors
17956707 ORA-904 executing SQL over a database link
17982838 ORA-60 during PDB rename
18009564 RMAN overestimates backup size twice as much (False RMAN-3009 possible)
18054363 Query through dblink fails with ORA-979 “not a group by expression” with literal replacement
18106312 ORA-1830 when query or store XML with xs:date element containing timezone offset
18163767 expdp or impdp encounters ORA-60 on CREATE TABLE ET$ statement – superseded
18166577 Java stored procedure fails with ORA-29532 in 11.2.0.4/12.1.0.1
18188293 ORA-12899 “value too large for date column” from INSERT as SELECT with GROUP BY and DESC index
18193833 Logical Standby: SQL apply error ORA-10655 reported for shrink space check statement
18240704 ORA-8103 during upgrade on ALTER TABLE kottd$ MOVE LOB
18241194 ORA-904 still possible with fix for bug 16187992
18284763 ORA-600 [3020] on ASSM blocks in Standby Database after CONVERT TO PHYSICAL or ORA-8103 ORA-600 [4552] in non-standby after FLASHBACK
18293054 ORA-1426 when querying DBA_CAPTURE / V$GOLDENGATE_CAPTURE
18331944 Query fails with ORA-3171 during ADG instance recovery
18429735 ORA-700 [kgeade_is_0] on ANALYZE TABLE .. LIST CHAINED ROWS
18447188 ORA-1 has occured after applying the fix of bug:18163767
18456514 ORA-12705 in Logical Standby database after upgrade to 11.2.0.4
18508861 Create datafile on RAW can produce a corrupt file header / causes ORA-17515 and crash in 11.2.0.4
18516620 ORA-56904 / ORA-7445 from PIVOT query – superseded
18560427 MV refresh fails intermittently with ORA-4021 with fix for bug 13884774
18828868 Too Many Qxxx Processes Maxing Out the Number of Processes with fix for bug 14602788 present

Excessive CPU Usage

16442354 Fix for bug 13628110 causes extra CPU time in qmcxdsSearch
16633815 Poor performance of stored Java on some platforms
17009013 Excess CPU in kghrcdepth and kghfrempty using PGA_AGGREGATE_TARGET – superseded
17037130 Excess shared pool “PRTMV” memory use / ORA-4031 with partitioned tables
17390160 Small CPU overhead in ksusws->kcblsyncio for shared server sessions
17487865 Poor performance extracting ANYDATA attribute
17570240 CPU overhead in MTS under kpospfdrv due to use of sprintf()
18155703 CJQ0 consumes a lot of CPU on CDB related queries
18665660 High child cursor counts due to OPTIMIZER_MISMATCH with Optimizer_features_enable=9.2.0
18828868 Too Many Qxxx Processes Maxing Out the Number of Processes with fix for bug 14602788 present

Feature Unusable

12650550 ORA-1436 on executing DBMS_STREAMS_ADVISOR_ADM.analyze_current_performance
13498382 ORA-1122 ORA-1208 RMAN Duplicate overwrites datafiles at original location despite db_create_file_dest
16714031 Unified auditing: audit policy using “actions all” does not record audit trails
16800820 DBMS_METADATA.get_ddl generates faulty ddl for tables with temporal validity
17727676 optimizer hint ignored when using invisible indexes
17771733 DNFS unable to identify ZFSSA over management path using SNMP
17983042 Cannot alter user account in EM Express if the user is given a profile that is created by EM Express

Hang (Involving Shared Resource)

16069901 Hang/spin in RAC looking up object affinity
16178562 ASM proxy instance does not timeout when no ASM instances are available
16685417 LMS hang and database instance termination by LMHB
16964279 Instance hang / crash using server flash cache
17006183 DB hang as Archiver confuses destinations for EOR archivelog upon role change to primary
17284817 Switchover to standby hang using broker via Siteguard
17496884 Clusterwide ASM hang possible when ASM instance tries to start up
17847764 RAC hangs / stalls / evictions / crashes if DLM processing runs out of flow control tickets

Hang (Process Hang)

9439759 Ctrl-C / cancel of a query against DBA_FREE_SPACE may not release the TT enqueue (and so block other sessions)
12566247 DBMS_WORKLOAD_REPOSITORY.create_snapshot hangs for hours
12608451 Deadlock from concurrent DDL with “library cache lock” / “library cache load lock” wait
13506343 Split partition hangs on “pipe get” waits when restricted session enabled
13869467 Many waits for ‘row cache lock’ in RAC while creating many tables with constraints
13884774 Deadlock from concurrent select/ALTER SUMMARY and ALTER TABLE if query_rewrite_enabled set to true/force – superseded
16042673 Database hang when system trying to add interval partition to the table
16191248 Hang from concurrent drop of on-commit materialized views or using DBMS_REDEFINITION
16195633 ACFS hang / ORA-15023 from proxy instance alert and RBAL
16271658 In RAC a starting instance can block some other instance wanting an anti-lock
16275522 Streams may stall / give constraint errors after ALTER TABLE DDL
16305657 Objects locked for incorrect duration when SQL run from PLSQL
16447242 ANSI JOIN causes wrong results or even hang sometimes
16448569 PQ hang/deadlock possible – “cursor: pin S wait on X” waits
16512817 GRANT CONTAINER=ALL may hang with a PDB open in UPGRADE mode
16665268 ACFS hangs on 2.6.39 Linux from concurrent sessions writing to same ACFS file
16674842 Apply hangs in “wait for next chunk” state after coordinator requested rollback.
16842274 Logical Standby intermittently fail to make progress
16910734 ORA-600 [kcfis_create_flcunkeep_payload:invalid reqtype0] in Exadata
16921340 Non-CDB to PDB plugin hangs
17220460 parallel query hangs with ‘PX Deq: Execute Reply’
17496884 Clusterwide ASM hang possible when ASM instance tries to start up
17571306 Self deadlock on CREATE OR REPLACE SYNONYM SQL
17588480 library cache mutex/shared pool latch deadlock
17602269 DISKMON master hang due to self deadlock
17828499 Opening PDB hangs waiting for row cache lock on open UPGRADE
18280813 Process hangs in ‘gc current request’

Hang (Process Spins)

15865476 SQL spins with empty / null CLOB bind with AUDIT_TRAIL=xml, extended
16069901 Hang/spin in RAC looking up object affinity
16200780 Spin / dump:qcplgte_multibyte with fix for bug 12341619
16855292 Select on REFERENCE partitioned table using full piecewise joins spins during parse
17056988 Process spin using XML,EXTENDED auditing with a multi-byte database character
17082869 SQLLDR show high memory usage and slow performance
17561405 XDWK spins retrying automatic DISK ADD despite permanent ORA-15075
17663668 Parse hangs/spins in kkqsPruneSelOfRlsView with RLS policy on table with virtual column and MVIEW
18155703 CJQ0 consumes a lot of CPU on CDB related queries
18665660 High child cursor counts due to OPTIMIZER_MISMATCH with Optimizer_features_enable=9.2.0

Install/Patching Is Not Performed Correctly

17777061E Enhancement: Add datapatch parameters to operate on specific set of PDBs
17608025I catcdb_int.sql script from patch 17316776 has errors
17428148P ACFS driver cannot install on SLES11 sp2: 3.0.80-0.7-default
17475946P root.sh or acfsroot install fails with ACFS-9109 on SLES11 SP3
12932757 XDB reinstall drops non-XDB objects (catqm.sql)
17000176 Hang inside catcdb_int.sql called using catcon.pl
17306646 Undefined symbols vsnsta and Java_oracle_xdb_dom_XDBDocument_getChildrenByTagNameNSNative
17442449 sqlpatch rollback can happen on the wrong node in certain cases
17596344 ORA-6502 from datapatch for patches with a large number of patch files
17922172 Datapatch may apply sub-patches in the wrong sequence

Instance May Crash

14799449P AIX: Diagnostic stack unwind can fail with ORA-7445 [sskgds_snm]
13929159 Instance crash due to ORA-700[dbgrfrfr_2] / ORA-7445[dbgrfrfr_remove_fileref]
14010183 ORA-600 [ktspfundo:objdchk_kcbgcur_3] in SMON after failed temp segment merge load
14536110 ORA-600 [ktfaput: wrong pdb] / crash using PDB and FDA
15883525 ORA-600 [kcbo_switch_cq_1] can occur causing an instance crash
15986012 LMS crashes instance with ORA-600 [kjbmprlst:!rcfg]
16076097 ORA-600 [1433] during DB replay on RAC
16088176 RAC hang / LMD crashes instance with ORA-600[kjmscndscq:timeout]
16244191 ORA-600 [kjbmprcvass:rid] can occur in RAC crashing the instance
16392068 ORA-600 [kjbmpocr:dsb] from LMS / instance crash
16436434 ACFS kernel panic with oracleacfs:ofs_d_revalidate
16457621 ORA-600 [kkaegen_get_edition_name_3] after error during PDB open with Editions
16465158 ORA-600 [kjbmpocr:dsb1] / instance crash in RAC
16503473 ORA-600 [kjbrefbas:!res] from LMS in RAC
16524071 LMHB crashes the instance due to ORA-29770 during remastering with many locks
16543323 LMHB terminates instance with ORA-29770 due to LMS apparent slowness
16579084 LMS crashes instance with ORA-600 [kjbmprlst:shadow]
16674666 LMS crashes instance with ORA-600 [kclrecbst_9]
16685417 LMS hang and database instance termination by LMHB
16694728 ORA-600 [kjblpgorm:!antilock] in LMS in RAC
16733884 RAC instance crash with ORA-600 [kjbmprlst:!rcfg]
16810361 ORA-600 [kjbmpocr:ds!b] in RAC
16819962 RAC instance crash due to many message tickets waiting to be recycled
16856570 LMS crashes RAC instance with ORA-600 [kjbrcvt:!S]
16903084 ORA-7445 [ksfdpcl] in DBWR during media recovery
16930924 OERI[kfdOffline05] in smon after a failed disk add.
16964279 Instance hang / crash using server flash cache
16980342 PMON crashes ASM instance with ORA-600 [ksz_cln_proc1]
16991789 ORA-600 [kjbldrmrpst:invshad] and instance crash by RMV0 process
16993001 ORA-600 [1433] during object-based DB Replay on RAC
17159968 ORA-600 [kjbrwrdone:sc2] / instance crash in RAC
17205005 OERI[kglLockOwnersListDelete] after a process is killed
17215647 ORA-600 [kjbrasr:pkey] in LMS during instance recovery of DROP/TRUNCATE operations
17232014 RAC startup with large buffer cache reserves too little space for GES causing shared pool issues
17238511 RAC instance crash due to ORA-600 [kjbmpcrtpi:md]
17278804 ASM crash with ORA-600 [17147] after changing ASM_diskstring
17452841 LMS fails with ORA-600 [kjctsrw:1] leading to instance crash in RAC
17532245 ORA-600 [kjblfr:!cln] / instance crash in RAC
17570819 Processes may consume many of KJC message buffers during DRM
17801017 RAC instance eviction when internal DLM messaging stalls
17804469 PMON fails with ORA-7445 [kfclruc] causing ASM crash
17806676 PMON crashes instance with ORA-7445 [kksFreeCompileCallHeap] cleaning up failed process
17847764 RAC hangs / stalls / evictions / crashes if DLM processing runs out of flow control tickets
17891946 PMON may crash with kglOnErrorMutexCleanup on the stack
17974104 CDB instance crash with ORA-600 [kpdbBeginSetCleanSCN-badlk]
18029658 ORA-600 [krccflu_1] on standby
18190297 PMON may crash the instance with ORA-7445 [kgllkdl]
18273830 ORA-7445 [kge_is_oserr] mounting diskgroup if ora.asm asm_diskstring>1024
18326617 ORA-600 [kclobj_5] can occur in RAC crashing the instance
18508861 Create datafile on RAW can produce a corrupt file header / causes ORA-17515 and crash in 11.2.0.4
18554763 PMON crashes instance with ORA-600 [kksMutexRecovery-Bad-Opcode]

Internal Error May Occur (ORA-600)

17761775+ ORA-600 [kclchkblkdma_3] ORA-600 [3020] or ORA-600 [kcbchg1_16] Join of temp and permanent table in RAC might lead to corruption
18007210D ORA-600 [kqlindp: can’t find stub] from CREATE TABLE DDL
12416600E Diagnostic enhancement for ORA-600 [4400] errors with Database Link involved
12646133 ORA-600 [qmcxeWSNQ1] when exporting a column of type “XMLType storage binary”
13628110 ORA-600 [qmcxdsSspQn9] from XMLQuery with DTD – superseded
14010183 ORA-600 [ktspfundo:objdchk_kcbgcur_3] in SMON after failed temp segment merge load
14255701 ORA-600 [knasdaFilter:1] in streams Apply
14295985 Frequent ORA-600 [kkpouic:noCmtTxn]
14467329 ORA-600 [evapth] from CONNECT BY SQL with a PATH
14468157 Wrong results / ORA-600 [kdsgrp: No CU row] from bitmap access to HCC tables
14536110 ORA-600 [ktfaput: wrong pdb] / crash using PDB and FDA
14636798 ORA-7445 [xvmCtxNDStackEnsurePush] / memory corruption / ORA-600 [17147] from XQuery with extractValue()
14664684 ORA-600 [kpdbCleanupTaskInt:taskid] from DBMS_PDB.CLEANUP_TASK if invalid task_id supplied
15883525 ORA-600 [kcbo_switch_cq_1] can occur causing an instance crash
15923689 ORA-600 [5126] can occur if a user is dropped concurrent to SQL executing for objects of that user
15983996 ORA-600[kkzlpllg:5] during Online Redefinition or DROP of a snapshot log
15984414 Parallel slave process fail under kxfqdeq()
15986012 LMS crashes instance with ORA-600 [kjbmprlst:!rcfg]
15990359 ORA-600 [qeslinit1:null_colnum] from DROP table with logging
15999982 ORA-600 [kcl_sanity_check_cr_1] ORA-600 [kclchkblkdma_3] in RAC or ORA-752 ORA-600 [3020] during recovery
16007562 ORA-600 [kffMapLockCkpt10] in CKPT in ASM instance
16019728 ORA-600 [6891] / ORA-600 [kcbgcur_1] using materialized views
16043574 ORA-600 [rwoirw: check ret val] from aggregate on fixed view
16057129 Exadata cell optimized incremental backup can skip some blocks to backup
16076097 ORA-600 [1433] during DB replay on RAC
16088176 RAC hang / LMD crashes instance with ORA-600[kjmscndscq:timeout]
16228604 ORA-600 [kglUnlock-bad-lock] on restarting OGG Extract with missing/deleted REDO logs
16244191 ORA-600 [kjbmprcvass:rid] can occur in RAC crashing the instance
16268425 Memory corruption / ORA-7445 / ORA-600 gathering statistics in parallel for table with virtual column/s
16296213 ORA-600 [ktsladdfcb-bsz] creating segment for securefile if event 60063 set
16305657 Objects locked for incorrect duration when SQL run from PLSQL
16313881 ORA-600 [krvuatld] from Streams capture
16343493 ORA-600 [ksfd_odmgo2] … [ODM ERROR V-41-4-4-51-22 Invalid argument]
16345970 ORA-2070 / ORA-600 [HO define: Long fetch] with DG4odbc
16347068 ORA-600 [kfncPoolCb5] in ASM
16362839 ORA-600 [more fun:qkaTableQueueTraverse1] from multi table insert with NOAPPEND if parallel DML enabled
16384983 RMAN bad backup – causes recovery to fail with ORA-600 [3020]
16392068 ORA-600 [kjbmpocr:dsb] from LMS / instance crash
16427054 ORA-600 [kpdbIdtoName] in DBMS_PDB.describe() in Non-CDB Database
16444683 ORA-600[delprecg1] during delete
16448848 Memory corruption / ORA-600[17147] from Capture
16457621 ORA-600 [kkaegen_get_edition_name_3] after error during PDB open with Editions
16465149 ORA-600 [kcbchg1_16] can occur
16465158 ORA-600 [kjbmpocr:dsb1] / instance crash in RAC
16473934 ORA-600 from OGG delete collisions with many primary keys
16482849 ORA-600 [kkpoxgsoh1]
16503473 ORA-600 [kjbrefbas:!res] from LMS in RAC
16524968 ORA-600 [kccocx_02] from PDB
16525731 ORA-600 [kecpsSetupSyncProcess:cannot allocate process[file_id][call_ctr]]” during object based DB Replay
16570573 ORA-600 [qerbtRop:rowidIllegal] from SQL against compressed partitioned table
16579084 LMS crashes instance with ORA-600 [kjbmprlst:shadow]
16599661 ORA-600 [kghfrf1] loading a SQLSET using DBMS_SQLTUNE
16610217 ORA-600 [ktspgsb3:kcbz_objdchk] during ROLLBACK against ASSM segment
16634384 ORA-600 [krvuatla20] from OGG afer unregistering PDB
16657901 CDC create_change_table does not issue a commit at end of procedure
16663465 ORA-600 [kkdlGetBaseUser2:authIdType] setting USE_STORED_OUTLINES in a PDB
16668226 ORA-600 [723] / ORA-600 [15709] from hang manager in RAC
16674666 LMS crashes instance with ORA-600 [kclrecbst_9]
16689109 ALTER TYPE in upgrade script can product invalid objects in a CDB
16694728 ORA-600 [kjblpgorm:!antilock] in LMS in RAC
16698577 ORA-10387 and ORA-600 [kglReleaseHandleReference1] from PQ with PDB
16698629 ORA-600 [kdsgrp1] executing SELECT on table modified by a loosely coupled clusterwide global transaction
16698971 ORA-600 [19004] or inaccuracies on join of histogrammed columns
16700693 ORA-600 [12406] after import compressed partition table via TTS
16733884 RAC instance crash with ORA-600 [kjbmprlst:!rcfg]
16754830 ORA-600 [atbgdve] from exchange partition with fix 16533427 – superseded
16761566 Instance fails to start with ORA-600 [4000] [usn#]
16768092 ORA-600 [evacol:overflow] when using nls_sort=xgerman_din
16772060 DBMS_PDB.sync_pdb gets ORA-600 [kghstack_underflow_internal_1]
16774684 ORA-600 [kkoipt:invalid aptyp] from ANSI self join with USING keyword
16776922 ORA-1578/ORA-600 block corruption messages on the temporary data blocks
16777840 ORA-600 [kkdlGetOnDiskDefVal : no MODV] from CREATE MATERIALIZED VIEW over a database link
16783376 ORA-600 [kdstgr_ktid_not_ehcc_compressed] from ANALYZE of HCC compressed table ONLINE
16784143 ORA-600 [kcvfdb_pdb_set_clean_scn: cleanckpt] with PDBs
16784167 ORA-600 [2801] during PDB open / close
16789573 ORA-600 [ktsl_format_ufs_hbb:objdchk_kcbnew_3] in RAC
16795944 PDB open crashes after LICENSE_MAX_USERS set to less than current
16803438 ORA-600 [qmxtrtBuildFSTFromGrpDesc1] from XML query involving RAW data
16810361 ORA-600 [kjbmpocr:ds!b] in RAC
16839930 ORA-600 [qmxtcEvalXMLConcat] when XMLSEQUENCETYPE is null
16844448 ORA-600 [3020] after flashback database in a RAC
16849982 Physical metadata replication fails to relocate spfile in ASM
16856570 LMS crashes RAC instance with ORA-600 [kjbrcvt:!S]
16863422 ORA-600 [kxdam_notify_cell:ioctlFailed] in Exadata
16892396 ORA-600 [KFCHK_ERRRET] [kfa.c] from ASMCMD “rm -rf” operation
16901385 RECO process may get ORA-600:[k2vdrv: valid branch]
16907969 ORA-600 [qmxiStoreXobEl1] inserting into object relational storage
16910734 ORA-600 [kcfis_create_flcunkeep_payload:invalid reqtype0] in Exadata
16911730 ORA-600 [qctbyt : bfc] from XMLTable on XMLSerialize
16916051 ORA-600 [qknrSetCntForOpn:bfl for bind] or other ORA-600 ORA-7445 errors with cursor_sharing=force
16926863 An XQuery statement gets ORA-600 [qmxqtmCompOccFromSchm:2]
16930325 ORA-600 [kcfis_translate0] during Smart Scan
16930924 OERI[kfdOffline05] in smon after a failed disk add.
16935643 ORA-600 [kqludp2] while upgrading a PDB
16939612 Dropping edition gets ORA-600 [kqllod:no stub for dependency parent]
16964279 Instance hang / crash using server flash cache
16969016 ORA-600 [kzdUserPrivilegeUpdate-1] can occur
16978185 ORA-600 [KGHLATCH_REG4] in ASM on a system with many CPUs
16980342 PMON crashes ASM instance with ORA-600 [ksz_cln_proc1]
16991789 ORA-600 [kjbldrmrpst:invshad] and instance crash by RMV0 process
16993001 ORA-600 [1433] during object-based DB Replay on RAC
16993424 ORA-600 [kkaegen_get_edition_name_3] in PDB with Editions
16994576 ORA-600 [kqlbbotadd:3] when PDB is opened
17006727 ORA-600 [qerpxInitialize0] from SQL with UNION ALL and PARALLEL hint
17019107 ORA-600 [17147] reported on binary XML update – withdrawn
17025461 ORA-600 [krbbsThrottle_ zero_total_size] on RMAN backup
17032726 PDB upgrade does not populate old type OBJ$ signature properly (ORA-600 [kqludp2])
17033198 PMON fails with ORA-600 [kccocx_01]
17036357 ORA-1438 from SQLLDR direct path on virtual column / ORA-600 [KUPDLS_RDDATA-01] from IMPDP with DIRECT_PATH
17042658 ORA-600 [kewrsp_split_partition_2] after upgrade from 11.2 to 12.1
17050888 ORA-600 compiling object in Edition after dropping covered objects
17065035 ORA-600 [kkqsckjb:!sjo] from query rewrite
17068536 Set container via DBMS_SQL fails with ORA-600 [kkae_set_session_edition_step2]
17070459 ORA-600 [26599] using stored Java
17082983 Memory corruption querying some fixed tables / views (ORA-4029 / ORA-600 [17147] / ORA-600 [kghfrmrg:nxt])
17156687 ORA-600 [nsoexp:cby strp] with subquery and LEVEL pseudo column without a CONNECT BY
17159968 ORA-600 [kjbrwrdone:sc2] / instance crash in RAC
17164360 ORA-600 [kkoipt:incorrect pwj] parsing SQL with partition wide join
17174391 ORA-603 / ORA-600 [730] using ALTER SESSION SET CONTAINER
17185558 ORA-600 [kkoipt:incorrect pwj] occurs on querying partitioned table
17193825 Missing supplemental log data for update DML on a previously compressed table
17197563 ORA-600 [kkmupsViewDestFro_4] from MERGE SQL with STAR transformation
17205005 OERI[kglLockOwnersListDelete] after a process is killed
17210416 ORA-600 [kpdbChangeCbk:inv pdb] can occur in GEN0 process
17215306 ORA-600 [qmxptRewriteFro1] using XMLTABLE on CLOB storage xml column
17215647 ORA-600 [kjbrasr:pkey] in LMS during instance recovery of DROP/TRUNCATE operations
17217040 ORA-600 [kqlpgCallback: inv pdb] after PDB dropped and new PDB created
17217593 Various corruption related ORA-600 attempting to apply undo to a temporary table
17244462 ORA-600 [kspgsp2] on ALTER PLUGGABLE DATABASE .. OPEN UPGRADE
17246694 ORA-600 [rwoirw: check ret val] from CREATE MView selecting virtual column over database link
17260090 OGG deletes IR errors in CDB-RAC environment in non owning instance
17277476 ORA-600 [kcfis_update_recoverable_val_3] in Exadata
17278201 ORA-600 [12426] using old CONNECT BY on fixed tables/views
17278804 ASM crash with ORA-600 [17147] after changing ASM_diskstring
17289787 ORA-600 [qeshQBNextPiece.1] from GROUP BY
17298973 ORA-600 [krsa_geq_rel.2] from OGG downstream extract
17305959 ORA-600 [kfdreplicateprep20] in asm after setting compatible.asm = 12.1.0.0.0
17314888 ORA-600 [19004] when stats have been gathered with NLS_SORT / NLS_COMP not default BINARY
17325413 Drop column with DEFAULT value and NOT NULL definition ends up with dropped column data hitting disk leading to corruption
17332316 ORA-7445 [qksopVisitOpns] / ORA-600 [qkebValidateOpn:2] from SQL with invalid HAVING clause – should have reported ORA-979
17341326 Various ORA-600 / ORA-7445 from OGG replicat with XStreams
17351122 Logical Standby terminates with ORA-1281 after consecutive automatic restarts
17362796 Wrong results / ORA-600 [kdmv_check_row_1:imcu]
17386756 ORA-600 [krsr_rfs_wda.9] reported by RFS
17389192 OGG IR abends due to ORA-600 [knlqglcr:2] during repeated collisions handling
17397545 ORA-600 [kdtigetrow-2] from MERGE statement with LOG ERRORS INTO
17437634 ORA-1578 or ORA-600 [6856] transient in-memory corruption on TEMP segment during transaction recovery / ROLLBACK (eg: after Ctrl-C)
17443671 Exadata block repair may invalidate cache lines
17449815 ORA-8102 ORA-1499 after ORA-1/ORA-2291 by MERGE with DML ERROR LOGGING
17452841 LMS fails with ORA-600 [kjctsrw:1] leading to instance crash in RAC
17458477 ORA-600 [kkesGetIOStat2] when a gather stats call fails (eg: due to Ctrl-C)
17463935 ORA-600 [723] [memory leak] of “IPQ IPC context” memory
17468141 ORA-7445 [kglobcl] with client side PLSQL (such as Forms)
17469624 ORA-600 [kcfis_finalize_cached_sessions_2] / ORA-600 [kcfis_update_recoverable_val_3] during session cleanup
17478811 ORA-600 [26599] using CDB_JAVA views in PDB
17480600 ORA-8103 / ORA-600 [ktsfbfmt:objdchk_kcbnew_3] after ALTER INDEX on AQ$_QT_I/T
17516005 Intermittent ORA-600 [kpdbObjLinkEndOfFetch] in PDB
17532245 ORA-600 [kjblfr:!cln] / instance crash in RAC
17537656 ORA-600 [1113] from interrupted (Ctrl-C) query against views that access X$KTFBUE
17537911 ORA-600 [qolHintPivAddSid:1] using outlines for plans with long OR chains (or long inlists)
17540308 ORA-600 [kcbgtcr_7] can occur in rare cases
17540469 ORA-600 [kgl-hash-collision] triggered by ALTER SYSTEM use_stored_outlines
17587063 ORA-600 [qerghFetch:inc] reported on query with CURSOR_SHARING=force
17604137 ORA-600 [25026] when running query on table being dropped
17614134 ORA-600 [kglgtbo1] can occur reading a LOB in an Editioned environment
17622734 ORA-600 [kdliXfmCheck][xx][0][1] reading compressed Securefile
17654904 ORA-7445 [kauxalo] from EXPLAIN of an INSERT with XDB
17705023 ORA-600 [kkzuasid] on MV refresh
17762256 ORA-600 [kkdlGetCkyName1] in CDB environment
17767224 ORA-600 [kdliReorgPE:1] from DBFS workload using Securefile
17767676 ORA-600 [kcbchg1_28] possible on temporary ASSM segment
17785414 ORA-600 [qkssaGetSampleProb:!tmpOpnP] from SQL with SAMPLE clause
17799428 ORA-600 [kfcGet0_04] in ASM
17801017 RAC instance eviction when internal DLM messaging stalls
17823280 ORA-600 [kponPurgeUnreachLoc-3] [4021] [ORA-4021: timeout occurred]
17831758 ORA-600 [kwqitnmphe:ltbagi] in Qnnn background process
17866746 ORA-600 [kope2uattr:datetime] processing TIMESTAMP in XMLType
17877323 ORA-600 [krbi_init_fra_metadata_not_backup_ctl] from active duplicate on standby database
17892268 ORA-600 [koklread1-callback with conv flg] using 10.1 PLSQL client
17898730 ORA-600 [kpdbChangeCbk-pdbid-notfound] during concurrent PDB DDL
17935420 ORA-600 [qkaconPreUA:FJswrwo] from CONNECT BY query with OLD_PLAN_MODE – superseded
17951233 ORA-600 [kcblin_3] [103] after setting _pga_max_size > 2Gb
17973301 Rare ORA-600 [kkqsgpmop: invalid # of values: 2] from partition maintenance with materialized views
17974104 CDB instance crash with ORA-600 [kpdbBeginSetCleanSCN-badlk]
17997255 ORA-600 [kpdbaOpenClose: no IS enq] when open/close PDB
18003413 ORA-600 [kss_get_owner: bad control] / ORA-7445 [kglLock] from DRCP pooled server
18015360 ORA-600 [12270] issuing dynamic ALTER DATABASE .. SWITCHOVER from PLSQL
18025214 ORA-600 [kfcAppChg20] and ORA-600 [kfclDoDownConverts08] in ASM instance
18029658 ORA-600 [krccflu_1] on standby
18062715 ORA-600 [kkqtutlAddSelItem] with more than 1000 aggregate functions in select list
18088509 ORA-600 [rwoirw: check ret val] in CONNECT BY SQL with FOR UPDATE clause
18125878 ORA-600 [25027] on insert if table has rowdependencies and compress on pk
18159793 Data corruption / ORA-600 from large I/Os to/from dNFS (eg using RMAN)
18189036 ORA-600 [qkaffsindex3] from SQL Tuning task / advisor
18192858 ORA-600 [ktssdrp1] on a MERGE statement in a RAC environment
18259031 ORA-600 […:objdchk_kcbnew_3] with concurrent DROP / SELECT of ASSM segment
18284763 ORA-600 [3020] on ASSM blocks in Standby Database after CONVERT TO PHYSICAL or ORA-8103 ORA-600 [4552] in non-standby after FLASHBACK
18291073 ORA-600 [kopocel10] when declaring cursor in PL/SQL package
18308717 ORA-600 [krbdlmt_dup] from RMAN running backup backupset to tape in catalog mode
18324129 ORA-600 [kfdxWork22]
18326617 ORA-600 [kclobj_5] can occur in RAC crashing the instance
18334586 ORA-600 [kglUnLock-bad-lock] / ORA-7445 [kglUnLock] can occur
18356166 ORA-600:[kdblkcheckerror][x][x][18020] possible in ASSM
18384391 ORA-600 errors possible with fix for bug 16402712 present
18429735 ORA-700 [kgeade_is_0] on ANALYZE TABLE .. LIST CHAINED ROWS
18490543 ORA-600 [25027][0][0] from ALTER TABLE .. MOVE with nosegment index
18509558 ORA-600 [qmcxdsGotoRoot1] or similar on XQuery with binary XML
18554763 PMON crashes instance with ORA-600 [kksMutexRecovery-Bad-Opcode]
18619917 Block corruption / ORA-600 [kdBlkCheckError]..[6110] on insert to OLTP compressed table
18620694 ORA-600 [kjbmpclo:cvt] in RAC
18676416 ORA-600 [kghstack_finish 1] when DDL annotation is used with OGG
18685209 ORA-600 [kkogbro: no kkoaptyp] in FIRST_ROWS(k) mode with FULL OUTER JOIN
18695733 ORA-600 [15851] from RANK() with NLS_SORT and DESC with fix for bug 15936924 present
18708921 ORA-600 [kcbchg1_28] with the fix for bug 18268201
18751855 ORA-600 [qcspCheckAggs.1] with PIVOT group by placement if fix for bug 18516620 is present
18760484 RAC lock grant count can overflow causing ORA-600 errors
18762750 OGG cloned integrated extract fails with ORA-600 [knlogcStartLogminer: logminer start scn > captured_scn]
18973907 Memory corruption / various ORA-600/ORA-7445 using database links between 11.2.0.4/12.1.0.1 and earlier versions

Latch Contention

18199537 RAC database becomes almost hung when large amount of row cache are used in shared pool

Leak (Memory Leak / Growth)

14382117 ORA-4030 trying to allocate 488 bytes (callheap,kprbalo temp memory )
14582843 emory leak using getclobval on xmldata stored as binary
15861775 ORA-1000 cursor leak from some V$ / X$ table accesses
15946766 Instant Client OCIEnvCreate uses more memory in 11.2.0.2+ than 11.2.0.1
16200780 Spin / dump:qcplgte_multibyte with fix for bug 12341619
16382883 ORA-4030 (kolarsCreateCt,qmemNextBuf:Large Alloc) from XML query
16473957 Abstract LOB leak using getClobVal/getBlobVal in OCI connection
16571785 High “KTC latch subh” SGA memory use due to “lobs commit callback”
16710753 Excess shared pool memory use / ORA-4031 from DROP EDITION
16712501 Session heap leak using nested tables
16747736 LogMiner memory leak / ORA-1341 “logminer out-of-memory”
16816103 XIN aborts with ORA-4031 due to memory leak in OCIXStreamInCommit
16855783 Memory leak in PGA on insert of XMLtype column
16864048 ALTER USER .. ENABLE EDITIONS raises ORA-4030
17037130 Excess shared pool “PRTMV” memory use / ORA-4031 with partitioned tables
17082869 SQLLDR show high memory usage and slow performance
17086524 Private Memory leak from INSERT as SELECT with collections
17255538 ORA-4030 (kxs-heap-c,chedef : qcuatc) on REFRESH of an INVALID materialized view
17297939 OGG cursor leak during apply with Integrated Replicat
17463935 ORA-600 [723] [memory leak] of “IPQ IPC context” memory
17537657 Memory leak from XDB in oracle.xdb.SoftHashMap
17752995 ORA-4031 from explain of SQL with many subqueries and OR expansion
17753923 DBMS_XMLSTORE.insertxml on a table with a blob uses excess memory and fills temporary tablespace
17786518 Memory leak from oak_init in ASM
18828868 Too Many Qxxx Processes Maxing Out the Number of Processes with fix for bug 14602788 present

Leak (Resources Eg: File Handles)

16773771P Windows: oracore11.dll may leak critical section on dllmain()
9439759 Ctrl-C / cancel of a query against DBA_FREE_SPACE may not release the TT enqueue (and so block other sessions)
16473957 Abstract LOB leak using getClobVal/getBlobVal in OCI connection
18073792 Excess TO enqueues / “enq: TO – contention” using temporary tables with savepoints
18828868 Too Many Qxxx Processes Maxing Out the Number of Processes with fix for bug 14602788 present

Memory Corruption

14338435 ORA-7445 [knasald] / memory corruption from Streams apply AS process
14636798 ORA-7445 [xvmCtxNDStackEnsurePush] / memory corruption / ORA-600 [17147] from XQuery with extractValue()
16268425 Memory corruption / ORA-7445 / ORA-600 gathering statistics in parallel for table with virtual column/s
16283281 ORA-7445 / memory corruption from ANSI join with many columns
16422541 ORA-7445 [kghssapage] reported while updating table containing a CLOB
16448848 Memory corruption / ORA-600[17147] from Capture
16916051 ORA-600 [qknrSetCntForOpn:bfl for bind] or other ORA-600 ORA-7445 errors with cursor_sharing=force
17019107 ORA-600 [17147] reported on binary XML update – withdrawn
17082983 Memory corruption querying some fixed tables / views (ORA-4029 / ORA-600 [17147] / ORA-600 [kghfrmrg:nxt])
17278804 ASM crash with ORA-600 [17147] after changing ASM_diskstring
17341326 Various ORA-600 / ORA-7445 from OGG replicat with XStreams
17389192 OGG IR abends due to ORA-600 [knlqglcr:2] during repeated collisions handling
17600719 ORA-7445 from repeat calls to DBMS_UTILITY.invalidate which compiles Java objects
18270874 ORA-600 [kghstack_free1] using audit_trail=xml,extended in multibyte DB
18783969 Memory corruption / database does not start with cluster_database=true
18973907 Memory corruption / various ORA-600/ORA-7445 using database links between 11.2.0.4/12.1.0.1 and earlier versions

Mutex Contention

16232803 Library cache lock / mutex contention with fix 8508078 enabled
17279311 “library cache: mutex X” contention on bucket mutex

Optimizer Bad Cardinality

18304693+ Suboptimal higher cost plan chosen for Cost-Based Query Transformation.
12977599 CBO double-counting derived predicate selectivity
14085520 Wrong costing of non-mergable view with rejected OJPPD
14648222 Incorrect cardinality estimate for INDEX SKIP SCAN
16507317 Poor cardinality calculations and slow performance for anti joins
16622801 Underestimated cardinality from a join with repeated join clause
16796185 subestimated cardinality in table expansion plan
16837274 Cardinality feedback produces poor subsequent plan
17760686 Bad Cardinality estimation with dynamic sampling

Parsing SQL is expensive / slow

17442009D Poor parse performance with many tables in join order when some are from unnested subquery/ies
17799716 High row cache requests for a query with many indexes
18244973 Deeply nested qesmaIterNext calls / ORA-7445 [qesmaIterNext] with low OS stack limit

Performance Affected (General)

18304693+ Suboptimal higher cost plan chosen for Cost-Based Query Transformation.
15882436 Smart scan is not enabled at SQL-PLSQL-SQL recursive call in Exadata
15886837 CPU time samples from Resource Manager are incorrect for virtual threads
16232803 Library cache lock / mutex contention with fix 8508078 enabled
16850996 Serial flashcache scan performance degraded
16864864 Suboptimal Exadata fast file initialization
17232014 RAC startup with large buffer cache reserves too little space for GES causing shared pool issues
17264297 Serial DML with Parallel scan performs single block reads during full table scan when table has chained rows in 11.2
17390160 Small CPU overhead in ksusws->kcblsyncio for shared server sessions
17620702 dNFS buffers not sized correctly for 256k rtmax / wtmax
18199537 RAC database becomes almost hung when large amount of row cache are used in shared pool

Performance Of Certain Operations Affected

8325586 Client failover code queries GV$INSTNACE slowing failover
12566247 DBMS_WORKLOAD_REPOSITORY.create_snapshot hangs for hours
13609098 Datapump Import of small Securefile Lobs is slow
14794472 expdp/impdp is slow with many tablespaces
15998585 DBMS_STATS may be slow for tables with a large number of columns
16470836 High DML rate against MON_MODS$ related to DBMS_STATS
16633815 Poor performance of stored Java on some platforms
16796277 Capture does not send changes quickly
16811897 USER_HISTORY$ records increase on every import
16836674 Parallel text indexing of binary XMLtype is slower than serial indexing
16856028 Export datapump slow on dataguard standby instance
17062465 Client brownout delay due to delay between LMS/LMD stop and reconfiguration starting
17186644 The ARCH process does not share open cached FOB of online logs
17204397 Bitmap index root block may be repeatedly pinned/unpinned
17214497 Parallel batching reduces OGG throughput
17231267 Upgrade 10.2 to 11.2.0.3 with a large number of XDB resources never completes
17237521 LGWR needlessly waits at least 1 second for ARC process to start
17469077 DBMS_REDEFINITION.SYNC_INTERIM_TABLE performance issue if table has many rows
17477958 Logminer dictionary build can take very long time for large databases
17487865 Poor performance extracting ANYDATA attribute
17546761 Exadata griddisk resilvering takes a long time
17720709 High “latch: row cache objects” waits on dc_rollback_segments when using Securefiles
17721778 RMAN via NFS on ACFS is slow due to zeroing
17835627 Poor Logminer / OGG extract performance for large MERGE SQL
18292893 Jobs don’t execute per schedule with a large number of PDBs

Performance Of Query/ies Affected

17368047D JPPD does not work for UNION views with just DUAL in one branch
12977599 CBO double-counting derived predicate selectivity
13522189 Partition pruning does not happen for XMLExists query with XMLIndex
13724904 Poor performance of SQL accessing ALL_TABLES
14078947 Select from V$RMAN_STATUS very slow when database is open
14648222 Incorrect cardinality estimate for INDEX SKIP SCAN
16447242 ANSI JOIN causes wrong results or even hang sometimes
16507317 Poor cardinality calculations and slow performance for anti joins
16516751 Suboptimal execution plan for query with join and in-list using composite index
16516883 OR expansion does not occur with JPPD
16609749 HASH GROUP BY not used when expected for INSERT as SELECT with direct load
16615686 Suboptimal plan with INLIST predicate and extended statistics
16622801 Underestimated cardinality from a join with repeated join clause
16690013 ORDERED hint not honoured with distinct aggregate transformation
16712501 Session heap leak using nested tables
16725982 Dynamic sampling does not occur for level 4 if filter predicate involves virtual expression
16726844 Statistics may be regathered on partitions that have no changes
16753981 Query rewrite does not occur when expected, even with REWRITE hint
16809786 Secure view merging does not occur when user defined operators are present
16837274 Cardinality feedback produces poor subsequent plan
16954950 Suboptimal plan for SQL accessing table with multiple empty partitions
16976121 View merging to performed in a materialized WITH subquery if the subquery is referenced in a lateral view
17397506 SORT MERGE JOIN incorrectly chosen over HASH JOIN
17572606 SQL runs slow due to tbl$or$idx$part$num recursive query is repeatedly executed
17760755 “FAST DUAL” not used in 11.2.0.3 or 11.2.0.4 for certain queries when expected
17843019 Function based index not used with view merging when expected
17910279 NLSSORT predicates generated with wrong NLS_SORT comparison
18092127 Wrong results (or serial execution) for parallel query from PLSQL
18456944 Suboptimal plan for query fetching ROWID from nested VIEW with fix 10129357
18644187 Correlated set subquery not unnested with fix for 16765564

Process May Dump (ORA-7445) / Abend / Abort

14799449P AIX: Diagnostic stack unwind can fail with ORA-7445 [sskgds_snm]
9756271 Dump on kditpin
12414954 ORA-7445 [sltsmna] querying V$XML_AUDIT_TRAIL in Shared Server mode in 12c
13929159 Instance crash due to ORA-700[dbgrfrfr_2] / ORA-7445[dbgrfrfr_remove_fileref]
13973434 ORA-7445 [evaopn3] from SYS_CONNECT_BY_PATH
14237793 ORA-7445 [kqlr_get_diana_ts] using Editioned objects
14338435 ORA-7445 [knasald] / memory corruption from Streams apply AS process
14355775 ORA-7445 [ktrvleafrowsz] from “AS OF” query
14560822 ORA-7445 [memcpy] handling XML data
14632583 ORA-7445 [kkeics] during view merge
14636798 ORA-7445 [xvmCtxNDStackEnsurePush] / memory corruption / ORA-600 [17147] from XQuery with extractValue()
14829250 ORA-7445 [ktbdbh] during diagnostic IOT output
15838437 ORA-7445 [kglbrk] from AQ dequeue / possible ORA-24033 on AQ enqueue
15984414 Parallel slave process fail under kxfqdeq()
16070351 ORA-7445 [ctcdrv] from “ALTER TABLE MOVE PARTITION .. ONLINE”
16071494 ORA-7445 [kkqsgGetEqvClassManager]
16186165 Various ORA-7445 from PQ with rollup pushdown and long VARCHAR
16188701 ORA-942 / ORA-7445 [ksscct] invoker right procedures run by users in parallel
16200780 Spin / dump:qcplgte_multibyte with fix for bug 12341619
16247011 ORA-7445 [qsmqFindScnCtrVal] recreating a materialized view
16268425 Memory corruption / ORA-7445 / ORA-600 gathering statistics in parallel for table with virtual column/s
16283281 ORA-7445 / memory corruption from ANSI join with many columns
16299255 ORA-7445 [evaopn3] from SQL with outer join
16346645 ORA-7445 [msqopnws] from DBMS_MVIEW.explain_rewrite on SQL with binds
16422541 ORA-7445 [kghssapage] reported while updating table containing a CLOB
16459685 ORA-7445 after failed “CREATE PLUGGABLE DATABASE” / ORA-44310
16527374 ORA-7445 [qervwRowProcedure] or similar from select on standard views in a container database
16570573 ORA-600 [qerbtRop:rowidIllegal] from SQL against compressed partitioned table
16660558 ORA-7445 [ksfd_io] in create PDB undo callback
16675710 ORA-7445 [ksuSdiInProgress] from close PDB
16705020 ORA-7445 [ksp_pdb_spfile_insert] when creating PDB
16783586 ORA-7445[nau_sui] may be signaled by shared server
16784901 ORA-7445 after replacing Oracle-supplied common PLSQL object
16789573 ORA-600 [ktsl_format_ufs_hbb:objdchk_kcbnew_3] in RAC
16792070 ORA-600 [rwoirw: check ret val] from ANSI joins with star transformation
16836849 ORA-7445 [ktcAllocXcb] during database open
16848350 ORA-7445 [kkqjpdcvp] can occur optimizing a query
16851342 ORA-7445 [kkoatGetPreds] optimizing a query
16865352 ORA-7445 [qcsicrv] parsing SQL with both an XMLIndex and a functional index
16902138 ORA-7445 [rpidrv] after dropping a PDB
16903084 ORA-7445 [ksfdpcl] in DBWR during media recovery
16916051 ORA-600 [qknrSetCntForOpn:bfl for bind] or other ORA-600 ORA-7445 errors with cursor_sharing=force
16956380 ORA-7445 [knalsalex] during LOB assembly error for integrated replicat
16980523 ORA-7445 [evaopn3] from SQL with function based index if fix 7237571 enabled
16988491 ORA-7445 [qerilcil] from query with multi-column inlist/s
16989630 Intermitent ORA-7445 [kglHandleParent]
16993424 ORA-600 [kkaegen_get_edition_name_3] in PDB with Editions
17026503 ORA-7445 [kpdbdDropPdbApplyUndo] when drop PDB
17033499 ORA-7445 [kkqfppRelFilter] from SQL with PLSQL function
17034172 Move kffmop out of main SGA heap
17079498 MERGE statement fails with ORA-7445 [koksObjOpnHasLob]
17249820 ORA-7445 [kpdbSyncExec] with PDB
17308231 ORA-7445 [qctcopn] using XMLTable in PLSQL with a DEFAULT expression
17314427 ORA-7445 [kkqsBuildJoinAdjMatrix] from query rewrite
17330788 ORA-7445 in Stored Java GC calls such as eoa_csvr_scan_newmem_stack()
17332316 ORA-7445 [qksopVisitOpns] / ORA-600 [qkebValidateOpn:2] from SQL with invalid HAVING clause – should have reported ORA-979
17339455 ORA-7445 [kkorminl] or similar can occur when running Automatic tuning tasks / DBMS_SQLTUNE Index Advisor
17341326 Various ORA-600 / ORA-7445 from OGG replicat with XStreams
17349973 ORA-7445 [qmxtrtBuildFSTFromGrpDesc] from XDB
17391312 ORA-7445 [ioc_IUflags] during CDB upgrade
17394724 ORA-7445 [kpdbfDuplicateName] creating a PDB with tablespace containing multiple datafiles
17429556 ORA-7445 [lstclo] from query rewrite after partition maintenance
17460097 Sample seed with BLOCK gives wrong results with TABLE() functions / ORA-7445 [xtyopncb]
17534519 ORA-7445 [qkabxo] from query doing parallel table scan recost
17537656 ORA-600 [1113] from interrupted (Ctrl-C) query against views that access X$KTFBUE
17545847 IEV2 capture aborts with ORA-7445 [knluCompareNumberArrayKnlpar] when EXCLUDEUSERID is specified
17600719 ORA-7445 from repeat calls to DBMS_UTILITY.invalidate which compiles Java objects
17629694 ORA-7445 [kglUnpin] can occur
17638567 expdp fails with ORA-7445 [kwqbcbfq] and ORA-7445 [kkxtcs]
17655634 ORA-7445 [krvxInvokeCallbacks] from Logminer running under GoldenGate
17753428 ORA-7445 [stsInitParams] during PDB open on ADG
17758389 ORA-7445 [qmcxeEncStartElement] can occur with XDB
17775506 XML query fails with ORA-7445 [qmcxpmapGetPfxFromNspId]
17804469 PMON fails with ORA-7445 [kfclruc] causing ASM crash
17806676 PMON crashes instance with ORA-7445 [kksFreeCompileCallHeap] cleaning up failed process
17809973 ORA-7445 [upduaw]
17866746 ORA-600 [kope2uattr:datetime] processing TIMESTAMP in XMLType
17883081 ORA-7445 [kkdcnco] when Editioned objects are used
17886260 ORA-7445 [qersoProcessULS] can occur
17891946 PMON may crash with kglOnErrorMutexCleanup on the stack
17893931 ORA-7445 [kkobok] during filter pushdown in CONNECT BY .. PRIOR SQL
17950169 ORA-7445 [qmuhshenum_init] from DBMS_XMLSTORE.insertXML
17993995 ORA-7445 [kkeAdjFactColNdv] with star transformation
18000422 ORA-7445 [memcpy] under kdd* functions processing chained inline LOB
18003413 ORA-600 [kss_get_owner: bad control] / ORA-7445 [kglLock] from DRCP pooled server
18045331 ORA-7445 [atbepucs] during exchange partition
18090371 ORA-7445 [kkoioc] during bitmap plan processing
18125878 ORA-600 [25027] on insert if table has rowdependencies and compress on pk
18177966 Query using many outer joins and constant predicate fails with ORA-7445
18190297 PMON may crash the instance with ORA-7445 [kgllkdl]
18230522 ORA-7445 [kkpamCheckTransJoin] from full partition-wise join on REFERENCE partitioned object
18244973 Deeply nested qesmaIterNext calls / ORA-7445 [qesmaIterNext] with low OS stack limit
18270874 ORA-600 [kghstack_free1] using audit_trail=xml,extended in multibyte DB
18273830 ORA-7445 [kge_is_oserr] mounting diskgroup if ora.asm asm_diskstring>1024
18280356 ORA-7445 [kkmupd] on MERGE SQL
18334586 ORA-600 [kglUnLock-bad-lock] / ORA-7445 [kglUnLock] can occur
18405192 ORA-7445 under qervwFetch() or qervwRestoreViewBufPtrs() when deleting from view with an INSTEAD OF trigger
18453926 ORA-7445 [evaopn3] with fix for bug 17935420 (affects CONNECT BY)
18471685 ORA-7445 [knalkcdoce_fcfhdlrs] stopping OGG integrated replicat with handlers
18516620 ORA-56904 / ORA-7445 from PIVOT query – superseded
18704244 ORA-7445 [kgligl] can occur
18783969 Memory corruption / database does not start with cluster_database=true
18973907 Memory corruption / various ORA-600/ORA-7445 using database links between 11.2.0.4/12.1.0.1 and earlier versions
18996843 Apply fails with ORA-7445 [kghfre] with fix for bug 16472716 present

Relink errors / undefined symbols

17306646 Undefined symbols vsnsta and Java_oracle_xdb_dom_XDBDocument_getChildrenByTagNameNSNative

Shared Pool Affected

13771513E Additional diagnostics for heapdumps and ORA-4031 errors
15898589E Enhancement to restrict the size of SGA base library cache heaps
13951456 ASMCMD does not use bind variables in its SQL – affects shared pool
16571785 High “KTC latch subh” SGA memory use due to “lobs commit callback”
16710753 Excess shared pool memory use / ORA-4031 from DROP EDITION
17037130 Excess shared pool “PRTMV” memory use / ORA-4031 with partitioned tables
17232014 RAC startup with large buffer cache reserves too little space for GES causing shared pool issues
17273405 Cursors not shared / increasing VERSION_COUNT when expected when using stored outlines
17752995 ORA-4031 from explain of SQL with many subqueries and OR expansion
18665660 High child cursor counts due to OPTIMIZER_MISMATCH with Optimizer_features_enable=9.2.0

Storage Space Usage Affected

8666020 IMPDP of user password history inserts extra rows into USER_HISTORY$
13931087 RECYCLEBIN does not automatically purge under space pressure
14054676 SYS.SYS$SERVICE_METRICS_TAB queue table fills up when a RAC node is down
14084247 Failed AWR purge can lead to continued SYSAUX space use
14754390 Orphan object entries on object statistics management tables after DROP OBJECT
16590638 sys.col_usage$ grow / not purged after fix for bug 14712222
16811897 USER_HISTORY$ records increase on every import
16851194 Growth of SYSAUX tablespace with incremental statistics without growth in table data
16903536 ORA-12751 in MMON during regular AWR purge
16964686 Lightweight capture generates unneccessary redo on the database
17193562 OLTP compress does not happen on direct load operation for tables with 256 or more columns
17443596 Disk space leak during repeated PDB create/unplug/drop
17753923 DBMS_XMLSTORE.insertxml on a table with a blob uses excess memory and fills temporary tablespace
17785817 Dictionary entry in SLOG$ is not removed if users other than owner drop a materialized view
17920125 huge trace file is dumped due to corrupted row cache subordinate object
18098207 TEMP space leak from SQL using temp table transformation in a PLSQL REF cursor

Unstable Execution Plan

17727676 optimizer hint ignored when using invisible indexes
17760686 Bad Cardinality estimation with dynamic sampling

Unwanted or Excess Trace / Alert messages

12940206 “Checker run found # new persistent data failures” in alert log in hot backup mode
14279847 ASM shows “Attempting voting file refresh” messages for old or non voting file diskgroup
15931893 ORA-338 may be written to the alert log on startup even though they are ignored
16529874 Frequent “LCK(ospid: ****) has not moved for 20 sec” trace messages
16542886 Huge trace files with dNFS “CH OUT of ORDER” messages
16596890 AQ Qnnn trace messages “kwqicgpc: cursor close error 604” with fix for bug 14764829 present
16613964 Unwanted “Exadata” messages in ASM and DB alert logs on startup
16746889 Unwanted “kdstProcessSageData” trace in Exadata
16814544 ACFS “ofs_delete_inode: OFSASSERT(PFCB->FCBFLAGS & OFS_FCB_DIRECTORY)” messages
16850630 Excessive “kfOdaAppliance” tracing in GMON
17020894 Query warnings and unwanted trace files from PQ slaves that cannot join a query
17480013 Warning “failed to retrieve db spfile location” in the alert log
17952061 diskmon repeatedly dumping various state information
18456874 Excessing GMON trace in ASM instance

Wrong Results

14398428+ Sporadic Wrong results from Exadata (duplicate rows)
16551284P Incorrect number of CPU cores reported for AMD Opteron processors
8352043 Logminer generates incorrect LCR for update to compressed table with trailing null.
9878501 Query wtih DISTINCT returns duplicate row with nlssort
13253977 Wrong results or error with cursor-duration temp table and PLSQL function running on an active transaction
13591259 Wrong result from query on transported OLTP compressed table with column comparison predicate
14468157 Wrong results / ORA-600 [kdsgrp: No CU row] from bitmap access to HCC tables
14580303 Incorrect timestamp data inserted via instead-of trigger
14652700 Wrong results from query with function based index with parallel plan
14827309 LIKE gives wrong result (missing rows) for LINGUISTIC collation with _AI or _CI
14852021 “spawrio” script shows wrong %Reads and %Opt values
15894143 Insert statement via database link causes wrong results / logical corruption
16039533 Histogram in summary reported by orion (Oracle IO numbers) is wrong
16180753 V$SGA_TARGET_ADVICE has no rows
16186165 Various ORA-7445 from PQ with rollup pushdown and long VARCHAR
16229527 Wrong results (corrupt column value) from NLJ batching
16240139 Comments truncated at end of CREATE USER/ALTER USER/GRANT statements in LogMiner
16283430 wrong results from inlist on partitioned table and index on virtual column
16311211 ALTER INDEX .. REBUILD sets the MONITORING to OFF
16314254 Wrong results from query using multiblock scan for an OLTP compressed block
16342156 Wrong results from XMLTable in WITH clause
16447242 ANSI JOIN causes wrong results or even hang sometimes
16454223 Wrong results with flashback query (data archive)
16491477 Missing changes to Securefile LOB if session gets an error
16506031 Wrong data in V$SESSION_CONNECT_INFO for CLIENT_CHARSET / CLIENT_VERSION
16523150 OGG errors / missing info due to DML reordering
16551086 DBA_DIRECTORIES does not show PDB directories when PDB is in restricted mode
16623192 Wrong result from the first execution of a query that uses a function based index
16668584 V$SQL.SQL_FULLTEXT may show “garbled” SQL for some statements > 1000 bytes long
16682595 SPFILE / V$SPPARAMETER problems with PDB
16694280 Wrong results when joining composite partitioned tables
16751248 Wrong results from UNPIVOT operator
16801799 SYS_CONTEXT use in an RPC over a database link gives inconsistent results
16802693 Incorrect ORA_DICT_OBJ_OWNER for grant/revoke DDLs on directory objects
16803862 V$ASM_DISK.cold_used_mb and hot_used_mb shows wrong values
16818788 AWR report interconnect device statistics not populated while using infiniband
16841060 Wrong first day of the week for Bahrain, Kuwait and United Arab Emirates
16845022 Discrepancy between “read” and “read total” stats with Smart Scan
16861628 Wrong results from SQL with NVL() clause which is incorrectly removed
16864501 Empty tag when maintaindom false in registerschema when minoccurs is not specified
16878635 Wrong result from enforced query rewrite with RELY ON due to Join Elimination
16934803 Some analytic functions do not honour session NLS_SORT
16989676 ORA-937 is NOT generated when expected
16995929 DBMS_METADATA.GET_DDL generates incomplete DDL for nested tables / ORA-22913 from IMPDP
17000264 Wrong results from STAR transformation of SQL with multiple “IN(EXISTS)” subqueries
17016479 Wrong results from nested loops join to CDB view
17031322 OCIXmlDbRewriteXMLDiff returned bind variables are not whitespace preserving – affects OGG
17036973 NULL resilts from CLUSTER_PROBABILITY or CLUSTER_SET
17064391 Wrong result with USE_MERGE_CARTESIAN hint
17156148 Wrong results with query result cache using bind variable
17157954 Converting boolean value to integer in XMLTable returns wrong results
17191791 Wrong results with functional indexes, GROUP BY and user supplied ROWID
17205719 OGG: IR shows incorrect DML stats not matching with actual DMLs applied
17220339 Wrong results from CASE optimization with an Outer join
17308552 Select query with outer join and an ORDER BY returns rows in incorrect order
17332800 Wrong results with IOTs and fix of bug 13705338 present
17360606 Wrong results for materialized subquery factoring (WITH clause) on Data Guard
17362796 Wrong results / ORA-600 [kdmv_check_row_1:imcu]
17393683 OGG: IR reports negative daily/hourly stats & eventually total stats mistmatch
17436081 Wrong results when using “partition reference all”
17445370 Wrong result (duplicate) from a query with a subquery using nested loops
17449815 ORA-8102 ORA-1499 after ORA-1/ORA-2291 by MERGE with DML ERROR LOGGING
17460097 Sample seed with BLOCK gives wrong results with TABLE() functions / ORA-7445 [xtyopncb]
17500493 DBMS_METADATA.get_ddl doesn’t show storage clause “store as securefile” for queue table
17501565 DBMS_STATS.gather_system_stats on Exadata gets inconsistent measurement of IOTFRSPEED
17645326 Wrong Results with outer joins of subquery factoring having subqueries
17684143 Compression Advisor returns unrealistically small size for used space
17737485 data redaction feature returns the last day of the month wrongly
17801303 DBMS_METADATA returns two DDLs separated by semi-column for a User Defined Type
17812110 Wrong results from query using PARTITION REFERENCE ALL
17824637 A context sensitive cursor may be incorrectly shared leading to wrong results or errors
17918109 Wrong results (not sorted) with OR expansion and ORDER BY
17949480 Wrong results with column replacement in GROUPING functions
17979094 Wrong results from SQL with NVL involving a bind if columns in WHERE clause change sides
17980980 Wrong results from subquery coalescing
18020394 Wrong result from parallel query
18034871 Wrong results for query with ANSI join
18092127 Wrong results (or serial execution) for parallel query from PLSQL
18106915 Wrong behavior of interval for ‘asmcmd iostat’ command
18176929 Wrong results selecting from user-defined table
18353141 Wrong result from analytical query with NLS_SORT set
18458318 Low quality font image file created using stored Java after upgrade to 11.2.0.4
18559920 Wrong results from XMLtype virtual column

Wrong/Bad Shared Cursor

16777689 ORA-6502 may occur due to improper sharing of a PL/SQL anonymous block cursor
17824637 A context sensitive cursor may be incorrectly shared leading to wrong results or errors

ANSI Joins

16283281 ORA-7445 / memory corruption from ANSI join with many columns
16447242 ANSI JOIN causes wrong results or even hang sometimes
16774684 ORA-600 [kkoipt:invalid aptyp] from ANSI self join with USING keyword
16792070 ORA-600 [rwoirw: check ret val] from ANSI joins with star transformation
16976121 View merging to performed in a materialized WITH subquery if the subquery is referenced in a lateral view
17357979 ORA-942 from SQL when a factored subquery is referenced in multiple full joins
17651484 ORA-30393 – query rewrite not happening in when expected for MV with ANSI join
18034871 Wrong results for query with ANSI join
18177966 Query using many outer joins and constant predicate fails with ORA-7445

ASSM Space Management (Bitmap Managed Segments)

16610217 ORA-600 [ktspgsb3:kcbz_objdchk] during ROLLBACK against ASSM segment
17672719 ORA-600 [kclgclks_3] with fix 17382536 present
17760686 Bad Cardinality estimation with dynamic sampling
17767676 ORA-600 [kcbchg1_28] possible on temporary ASSM segment
18259031 ORA-600 […:objdchk_kcbnew_3] with concurrent DROP / SELECT of ASSM segment
18284763 ORA-600 [3020] on ASSM blocks in Standby Database after CONVERT TO PHYSICAL or ORA-8103 ORA-600 [4552] in non-standby after FLASHBACK
18356166 ORA-600:[kdblkcheckerror][x][x][18020] possible in ASSM

Active Dataguard (ADG)

13829543 In DG auto resync from standby overwrites the standby controlfile – can cause resync/backup errors
13947258 ORA-16000 Unable to drop restore point from ADG database
16613676 ORA-2097 from ALTER SYSTEM SET DG_BROKER_START .. when the database is in NOMOUNT state
16856028 Export datapump slow on dataguard standby instance
17284817 Switchover to standby hang using broker via Siteguard
17360606 Wrong results for materialized subquery factoring (WITH clause) on Data Guard
17386756 ORA-600 [krsr_rfs_wda.9] reported by RFS
17753428 ORA-7445 [stsInitParams] during PDB open on ADG
18331944 Query fails with ORA-3171 during ADG instance recovery
18536647 New ADG instances are in MOUNT state after switchover by broker

Advanced Clustered File System

14162505P AIX: Slow-speed write on ACFS running AIX
17359415P Linux: Configuring ACFS reports that cannot execute ‘/usr/bin/lsb_release’
17428148P ACFS driver cannot install on SLES11 sp2: 3.0.80-0.7-default
17475946P root.sh or acfsroot install fails with ACFS-9109 on SLES11 SP3
16195633 ACFS hang / ORA-15023 from proxy instance alert and RBAL
16436434 ACFS kernel panic with oracleacfs:ofs_d_revalidate
16665268 ACFS hangs on 2.6.39 Linux from concurrent sessions writing to same ACFS file
16814544 ACFS “ofs_delete_inode: OFSASSERT(PFCB->FCBFLAGS & OFS_FCB_DIRECTORY)” messages
17721778 RMAN via NFS on ACFS is slow due to zeroing

Advanced Queuing

14271183E Diagnostic enhancement for dynamic tracing of AQ event notification code
14002327 DBMS_AQADM.purge_queue_table to purge contents from queues invalidates objects
14476359 Dequeue by condition from secure queue can give ORA-1427
15838437 ORA-7445 [kglbrk] from AQ dequeue / possible ORA-24033 on AQ enqueue
16242449 aqmonitor.sql does not report on 12c AQ performance views
16596890 AQ Qnnn trace messages “kwqicgpc: cursor close error 604” with fix for bug 14764829 present
16756136 MapMessage enqueued by AQ-JMS API throws ClassCastException when dequeued by PL/SQL
17414276 AQ dequeue operation throws ORA-1008 when cancelled and re-attempted
17480600 ORA-8103 / ORA-600 [ktsfbfmt:objdchk_kcbnew_3] after ALTER INDEX on AQ$_QT_I/T
17500493 DBMS_METADATA.get_ddl doesn’t show storage clause “store as securefile” for queue table
17810692 ORA-30757 on propagation between databases with different timezone files – superseded
17823280 ORA-600 [kponPurgeUnreachLoc-3] [4021] [ORA-4021: timeout occurred]
17831758 ORA-600 [kwqitnmphe:ltbagi] in Qnnn background process
17848897 AQ propagation reports ORA-22337 with different database timezones or character sets
18828868 Too Many Qxxx Processes Maxing Out the Number of Processes with fix for bug 14602788 present

Analytic SQL (Windowing etc..)

13973434 ORA-7445 [evaopn3] from SYS_CONNECT_BY_PATH
14085520 Wrong costing of non-mergable view with rejected OJPPD
16186165 Various ORA-7445 from PQ with rollup pushdown and long VARCHAR
16751248 Wrong results from UNPIVOT operator
17949480 Wrong results with column replacement in GROUPING functions
18353141 Wrong result from analytical query with NLS_SORT set
18516620 ORA-56904 / ORA-7445 from PIVOT query – superseded
18695733 ORA-600 [15851] from RANK() with NLS_SORT and DESC with fix for bug 15936924 present
18751855 ORA-600 [qcspCheckAggs.1] with PIVOT group by placement if fix for bug 18516620 is present

Application Context

16801799 SYS_CONTEXT use in an RPC over a database link gives inconsistent results
17824637 A context sensitive cursor may be incorrectly shared leading to wrong results or errors

Automatic Diagnostic Repository

13647312E Diagnostic enhancement to provide applied patch information in IPS package
17609235E Diagnostic enhancement to add a table of contents to incident dumps for easier navigation

Automatic Memory Management

16180753 V$SGA_TARGET_ADVICE has no rows
17009013 Excess CPU in kghrcdepth and kghfrempty using PGA_AGGREGATE_TARGET – superseded

Automatic Storage Management (ASM)

16822629E SOURCE_FILE_NAME_CONVERT for PDBs in ASM is too long with many datafiles
17230905E Improved diagnostics when ASM in Exadata receives a hard check failure from the Storage Server (ORA-27626)
17315090E Improve error text for ASM ORA-15085 errors when reporting ‘sector size mismatch’ issues
17550049E Improve diagnostics for asmcmd copy operations
17578682E udma should skip zeroed blocks
18119430E Improve diagnostics for ORA-600 [kfdJoin3 ]
18289960E Remove duplicated ORA-600 in ASM functions better diagnosability
18483595E Enhancement to support hair-trigger I/O timeout support for ASM
18596828E Producing ORA-1405 replacing a Voting File
13951456 ASMCMD does not use bind variables in its SQL – affects shared pool
14279847 ASM shows “Attempting voting file refresh” messages for old or non voting file diskgroup
15861775 ORA-1000 cursor leak from some V$ / X$ table accesses
16007562 ORA-600 [kffMapLockCkpt10] in CKPT in ASM instance
16178562 ASM proxy instance does not timeout when no ASM instances are available
16182306 DB instance may be shut down unexpectedly in flex ASM converted environment
16195633 ACFS hang / ORA-15023 from proxy instance alert and RBAL
16227068 ASM cannot create diskgroup with compatible.advm = 12.1.0.1.0
16347068 ORA-600 [kfncPoolCb5] in ASM
16769943 diskgroup cannot mount on Exadata with cell down ( ORA-15080 )
16803862 V$ASM_DISK.cold_used_mb and hot_used_mb shows wrong values
16849982 Physical metadata replication fails to relocate spfile in ASM
16850630 Excessive “kfOdaAppliance” tracing in GMON
16892396 ORA-600 [KFCHK_ERRRET] [kfa.c] from ASMCMD “rm -rf” operation
16930924 OERI[kfdOffline05] in smon after a failed disk add.
16978185 ORA-600 [KGHLATCH_REG4] in ASM on a system with many CPUs
16980342 PMON crashes ASM instance with ORA-600 [ksz_cln_proc1]
17034172 Move kffmop out of main SGA heap
17186644 The ARCH process does not share open cached FOB of online logs
17265217 Inconsistent asmdeactivationoutcome during scrub resilvering
17278804 ASM crash with ORA-600 [17147] after changing ASM_diskstring
17305959 ORA-600 [kfdreplicateprep20] in asm after setting compatible.asm = 12.1.0.0.0
17443671 Exadata block repair may invalidate cache lines
17496884 Clusterwide ASM hang possible when ASM instance tries to start up
17561405 XDWK spins retrying automatic DISK ADD despite permanent ORA-15075
17602269 DISKMON master hang due to self deadlock
17754390 Diskgroup attributes disk_repair_time and failgroup_repair_time cannot be set to maxvalue
17786518 Memory leak from oak_init in ASM
17799428 ORA-600 [kfcGet0_04] in ASM
17804469 PMON fails with ORA-7445 [kfclruc] causing ASM crash
18025214 ORA-600 [kfcAppChg20] and ORA-600 [kfclDoDownConverts08] in ASM instance
18106915 Wrong behavior of interval for ‘asmcmd iostat’ command
18273830 ORA-7445 [kge_is_oserr] mounting diskgroup if ora.asm asm_diskstring>1024
18277454 ASM should get the “_asm_hbeatiowait” attribute from OAKLIB
18456874 Excessing GMON trace in ASM instance

Bitmap Indexes

14468157 Wrong results / ORA-600 [kdsgrp: No CU row] from bitmap access to HCC tables
17204397 Bitmap index root block may be repeatedly pinned/unpinned

Chained or Migrated Rows

16495802 Logminer ORA-16211 mining update of chained IOT rows with overflow
17193562 OLTP compress does not happen on direct load operation for tables with 256 or more columns
17264297 Serial DML with Parallel scan performs single block reads during full table scan when table has chained rows in 11.2

Change Data Capture

14295985 Frequent ORA-600 [kkpouic:noCmtTxn]
16657901 CDC create_change_table does not issue a commit at end of procedure

Cluster Ready Services / Parallel Server Management

18199185+ node reboot when Infiniband leaf switch rebooted
12928658E “ocr error code: %rc” in olsnodes.log does shows “%rc” instead of the error code
15832129E Include ONS logs when running diagcollection.sh
16206997E Include in alert log file an error when a CSSD thread is not scheduled
16317771E Improve log messages for daemon mdnsd
16346413E Provide log information when a gipc interface is cleaned up – superseded
16747308E Script diagcollection.pl should collect patch information
16846090E Support query of software version on all cluster nodes
17087371E Improve diagnostics for certain failures in ssclsi.c
17405302E Enhance oraagent gimh check message
17405605E Improve log messages when an OCR mirror is not available
17531342E Clarify error CRS-1625: Node was manually shutdown
17610763E Diagnostic enhancement to allow clusterware trace file size to be modified
17707226E Diagnostic enhancement to allow clusterware trace file size to be modified
17781373E Diagnostic enhancement or ORAAGENT to report that LOCAL_LISTENER is not set, if LISTENER_NETWORKS is used
17997497E Diagnostic enhancement for event 39505 to trace clusterware calls from RDBMS code
17997508E Additional diagnostics when destroying a mutex in OCSSD
18352846E Additional log information when the ARP cache is deleted
18464784E Misleading message produced in ValidateIpExistence
18596828E Producing ORA-1405 replacing a Voting File
17039197P CVU on RHEL 6 fails with “Reference data is not available for verifying prerequisites on this operating system distribution.”
17043601P AIX: OSYSMOND.BIN may dump core
17068448P Windoes: Enhance Windows Oracle Fence Driver log information
13836037 srvctl setenv not accepting values
13991403 rootupgrade.sh should validate that ONS local/remote ports are different
14076173 oifcfg iflist -p -n shows unnecessary and confusing output
14285210 CHM needs to collect the entire list of processes
16182306 DB instance may be shut down unexpectedly in flex ASM converted environment
16328993 ora.asm resource does not become online after patch of bug:14742343 is applied
16629075 Correct log message in scls_set_resource_limit
16709532 cluvfy errors due to error getting login shell (PRVG-0341)
16851630 ORA-13917 ORA-6512 generated in oraagent_oracle.log notifydbopen() issue
16897691 Executing ocrconfig manualbackup from multiple nodes at the same time may fail or corrupt key
17263488 OHASD/CRSD Core dumps when tries to start a resource that doesn’t exist
17722664 OCSSD terminates and stack shows clsaauthstart
17764053 db and service resource start with management_policy=norestart
17921339 4 haips start up even though there are only 2 private nics
17983675 Incorrect errors reported by orarootagent on HP-UX and AIX
18093627 Cannot see additional vip from “srvctl config vip” commmand if node name includes a capital letter
18187697 Misleading message voting disk corrupted
18471551 Node VIP started on a private interface on Solaris with IPMP

Compressed Data Storage

14398428+ Sporadic Wrong results from Exadata (duplicate rows)
13591259 Wrong result from query on transported OLTP compressed table with column comparison predicate
14468157 Wrong results / ORA-600 [kdsgrp: No CU row] from bitmap access to HCC tables
16170787 IR abend for EHCC enabled tables with parallelism>1
16314254 Wrong results from query using multiblock scan for an OLTP compressed block
16570573 ORA-600 [qerbtRop:rowidIllegal] from SQL against compressed partitioned table
16585527 Parallel MERGE statement produces ORA-60 on table with HCC partitions
16657378 ORA-20008 from DBMS_STATS.create_extended_stats
16700693 ORA-600 [12406] after import compressed partition table via TTS
16783376 ORA-600 [kdstgr_ktid_not_ehcc_compressed] from ANALYZE of HCC compressed table ONLINE
16943711 OGG XStream inbound encounters ORA-60 deadlock error on EHCC tables
17165204 Self deadlock while updating HCC compressed tables
17193562 OLTP compress does not happen on direct load operation for tables with 256 or more columns
17193825 Missing supplemental log data for update DML on a previously compressed table
17362796 Wrong results / ORA-600 [kdmv_check_row_1:imcu]
17684143 Compression Advisor returns unrealistically small size for used space
18619917 Block corruption / ORA-600 [kdBlkCheckError]..[6110] on insert to OLTP compressed table

Compressed Key Index / IOT

17332800 Wrong results with IOTs and fix of bug 13705338 present

Connect By / Hierarchical Queries

9756271 Dump on kditpin
13973434 ORA-7445 [evaopn3] from SYS_CONNECT_BY_PATH
14467329 ORA-600 [evapth] from CONNECT BY SQL with a PATH
17278201 ORA-600 [12426] using old CONNECT BY on fixed tables/views
17893931 ORA-7445 [kkobok] during filter pushdown in CONNECT BY .. PRIOR SQL
17935420 ORA-600 [qkaconPreUA:FJswrwo] from CONNECT BY query with OLD_PLAN_MODE – superseded
18088509 ORA-600 [rwoirw: check ret val] in CONNECT BY SQL with FOR UPDATE clause
18453926 ORA-7445 [evaopn3] with fix for bug 17935420 (affects CONNECT BY)

Constraint Related

13869467 Many waits for ‘row cache lock’ in RAC while creating many tables with constraints
14045842 SQL*Loader direct path load makes indexes unusable
16170787 IR abend for EHCC enabled tables with parallelism>1
16617325 Apply fails with ORA-2292 “integrity constraint error”
16791865 “ALTER TABLE .. add .. default ” not null” executes without error
16878635 Wrong result from enforced query rewrite with RELY ON due to Join Elimination
16897998 impdp returns unnecessary ORA-1 when SKIP_CONSTRAINT_ERRORS is used
17059198 ORA-1 on TS_P1 during RMAN upgrade catalog
17436081 Wrong results when using “partition reference all”

DBVerify Utility

18232647E DBVerify reports DBV-600 [21] [5] [0] [0] when datafile size is beyond expected – produce a more meaningful error

Database File System (DBFS)

16281499 ORA-39127 from expdp after upgrade from 11.2.0.2 to 11.2.0.3
16585628 Nested table create fails in DBFS with ORa-64007 / ORA-6512 / ORA-1422
17767224 ORA-600 [kdliReorgPE:1] from DBFS workload using Securefile

Database Link / Distributed

12416600E Diagnostic enhancement for ORA-600 [4400] errors with Database Link involved
15894143 Insert statement via database link causes wrong results / logical corruption
15931910 Clone remote PDB by database link fails with ORA-17628/ORA-19505
16233001 expdp with network_link fails with ORA-39166
16496977 return code 4067 seen in AUD$ for the operation using database link
16777840 ORA-600 [kkdlGetOnDiskDefVal : no MODV] from CREATE MATERIALIZED VIEW over a database link
16801799 SYS_CONTEXT use in an RPC over a database link gives inconsistent results
16863989 Streams propagation sender does not reconnect after communications failure
16901385 RECO process may get ORA-600:[k2vdrv: valid branch]
17020149 Wrong mview name is displayed in ORA-12048 error when DBMS_REFRESH encounters to remote error
17246694 ORA-600 [rwoirw: check ret val] from CREATE MView selecting virtual column over database link
17956707 ORA-904 executing SQL over a database link
18054363 Query through dblink fails with ORA-979 “not a group by expression” with literal replacement
18973907 Memory corruption / various ORA-600/ORA-7445 using database links between 11.2.0.4/12.1.0.1 and earlier versions

Database Replay

16076097 ORA-600 [1433] during DB replay on RAC
16525731 ORA-600 [kecpsSetupSyncProcess:cannot allocate process[file_id][call_ctr]]” during object based DB Replay
16993001 ORA-600 [1433] during object-based DB Replay on RAC

Database Resident Connection Pooling (DRCP)

18003413 ORA-600 [kss_get_owner: bad control] / ORA-7445 [kglLock] from DRCP pooled server

Datapatch Utility

17777061E Enhancement: Add datapatch parameters to operate on specific set of PDBs

Datapump Export/Import

8666020 IMPDP of user password history inserts extra rows into USER_HISTORY$
12646133 ORA-600 [qmcxeWSNQ1] when exporting a column of type “XMLType storage binary”
13609098 Datapump Import of small Securefile Lobs is slow
13768027 Datapump import raises KUP-11007 and ORA-1403
13851032 Internal fix for Datapump REMAP_DATA option
14202396 Datapump remap_data fails if used for more than 10 cols in a table
14260913 Resource Manager does not toggle Datapump export/import sessions to the correct consumer group
14560822 ORA-7445 [memcpy] handling XML data
14670675 Group for a file is created incorrectly if dNFS is enabled and setgid is set
14673948 EXPDP exits with return code 0 if DWnn process receives signal while exporting
14735446 impdp skip_constraint_error option does not work on PK with non unique index
14794472 expdp/impdp is slow with many tablespaces
15916457 Data pump fails to import REFERENCE partitioned tables if parent is in different schema (ORA-942)
16194160 OGG inbound server does not honor set_table_instantiation
16233001 expdp with network_link fails with ORA-39166
16281499 ORA-39127 from expdp after upgrade from 11.2.0.2 to 11.2.0.3
16310682 ORA-39126 / ORA-22813 from datapump export of PROCOBJ items
16369430 IMPDP reports ORA-39083/ORA-22808 when creating an index
16561657 Transport tablespace with DataPump does not preserve “add column optimization” flags
16579012 instantiation_scn incorrectly set via expdp/impdp
16707791 ORA-14223 during Datapump import for some tables with deferred segment creation
16769998 impdp with REMAP_SCHEMA fails with ORA-31693 and ORA-932 when schema name < 8 characters
16811897 USER_HISTORY$ records increase on every import
16815432 ORA-39126 ORA-6502 from DataPump export
16856028 Export datapump slow on dataguard standby instance
16897998 impdp returns unnecessary ORA-1 when SKIP_CONSTRAINT_ERRORS is used
16918087 expdp transportable tablespace gives ORA-39127 / ORA-1422
16981293 ORA-60 can occur when executing multiple impdp commands concurrently
16995929 DBMS_METADATA.GET_DDL generates incomplete DDL for nested tables / ORA-22913 from IMPDP
17036357 ORA-1438 from SQLLDR direct path on virtual column / ORA-600 [KUPDLS_RDDATA-01] from IMPDP with DIRECT_PATH
17488527 ImpDP remap_table of a partition over network_link does not remap the table name
17638567 expdp fails with ORA-7445 [kwqbcbfq] and ORA-7445 [kkxtcs]
18447188 ORA-1 has occured after applying the fix of bug:18163767

Datatypes (AnyData)

17487865 Poor performance extracting ANYDATA attribute

Datatypes (LOBs/CLOB/BLOB/BFILE)

13974665 ORA-24365 on replication push job with CLOB data
14582843 emory leak using getclobval on xmldata stored as binary
14789076 Wrong data due to column swapping using trigger and CLOB with bind size >4000
15865476 SQL spins with empty / null CLOB bind with AUDIT_TRAIL=xml, extended
16422541 ORA-7445 [kghssapage] reported while updating table containing a CLOB
16472716 ORA-22920 occurs when applying piece-wise lob operation in Logical standby – superseded
16473957 Abstract LOB leak using getClobVal/getBlobVal in OCI connection
16524926 ORA-1031 from LOB writes in stored Java (JDBC KPRB) in definers rights
16571785 High “KTC latch subh” SGA memory use due to “lobs commit callback”
16584684 Corrupt data / errors from OGG replicate of LOB to LONG in multibyte
17215306 ORA-600 [qmxptRewriteFro1] using XMLTABLE on CLOB storage xml column
17346671 ORA-3106 when selecting an empty LOB over the long interface
17348614 Logminer generates unsupported LCRs when mining XMLType table with out-of-line storage and LOB
17614134 ORA-600 [kglgtbo1] can occur reading a LOB in an Editioned environment
17634921 ORA-22926 for direct path operation on table with LOBS in Logical Standby
17753923 DBMS_XMLSTORE.insertxml on a table with a blob uses excess memory and fills temporary tablespace
17797700 Unwanted DV audit records from LOB access
18000422 ORA-7445 [memcpy] under kdd* functions processing chained inline LOB
18996843 Apply fails with ORA-7445 [kghfre] with fix for bug 16472716 present

Datatypes (Objects/Types/Collections)

15990359 ORA-600 [qeslinit1:null_colnum] from DROP table with logging
16187992 Public functions synonyms take precedence over the constructors of local object types – superseded
16369430 IMPDP reports ORA-39083/ORA-22808 when creating an index
16525731 ORA-600 [kecpsSetupSyncProcess:cannot allocate process[file_id][call_ctr]]” during object based DB Replay
16634207 Errors like ORA-21525 using collections of NVARCHAR2 between client and server with differing NLS settings
16689109 ALTER TYPE in upgrade script can product invalid objects in a CDB
16712501 Session heap leak using nested tables
16809786 Secure view merging does not occur when user defined operators are present
17079498 MERGE statement fails with ORA-7445 [koksObjOpnHasLob]
17086524 Private Memory leak from INSERT as SELECT with collections
17381384 ORA-1427 from multiple logminer sessions loading data for tables with REF columns
17460097 Sample seed with BLOCK gives wrong results with TABLE() functions / ORA-7445 [xtyopncb]
17801303 DBMS_METADATA returns two DDLs separated by semi-column for a User Defined Type
18176929 Wrong results selecting from user-defined table
18241194 ORA-904 still possible with fix for bug 16187992

Datatypes (TIMESTAMP)

14580303 Incorrect timestamp data inserted via instead-of trigger
16831411 Timestamp data in XML does not honour the nls_numeric_character setting
17810692 ORA-30757 on propagation between databases with different timezone files – superseded
17866746 ORA-600 [kope2uattr:datetime] processing TIMESTAMP in XMLType

Direct NFS (dNFS)

14670675 Group for a file is created incorrectly if dNFS is enabled and setgid is set
16542886 Huge trace files with dNFS “CH OUT of ORDER” messages
17620702 dNFS buffers not sized correctly for 256k rtmax / wtmax
17771733 DNFS unable to identify ZFSSA over management path using SNMP
18159793 Data corruption / ORA-600 from large I/Os to/from dNFS (eg using RMAN)

Direct Path Operations

16313881 ORA-600 [krvuatld] from Streams capture
16609749 HASH GROUP BY not used when expected for INSERT as SELECT with direct load
17036357 ORA-1438 from SQLLDR direct path on virtual column / ORA-600 [KUPDLS_RDDATA-01] from IMPDP with DIRECT_PATH
17634921 ORA-22926 for direct path operation on table with LOBS in Logical Standby

Domain Indexes

8250557 Unexpected deadlock involing DDL against functional index or domain index may happen
16809786 Secure view merging does not occur when user defined operators are present

Editions

14237793 ORA-7445 [kqlr_get_diana_ts] using Editioned objects
15922287 ORA-1427 from DBMS_METADATA for a view with Editions enabled
16663303 Incorrect privileges from upgraded DB with PDB
16710753 Excess shared pool memory use / ORA-4031 from DROP EDITION
16782193 ORA-38802 creating non Editioned object
16864048 ALTER USER .. ENABLE EDITIONS raises ORA-4030
16939612 Dropping edition gets ORA-600 [kqllod:no stub for dependency parent]
16993424 ORA-600 [kkaegen_get_edition_name_3] in PDB with Editions
17050888 ORA-600 compiling object in Edition after dropping covered objects
17216406 PLS-201 selecting from view using an Editioned Function if function not in ORA$BASE (ORA-6552 / ORA-6553)
17330580 Inherit privileges grants not usable by Editioned code
17478145 ORA-6540/ORA-900 when dropping library unit in old Edition
17614134 ORA-600 [kglgtbo1] can occur reading a LOB in an Editioned environment
17883081 ORA-7445 [kkdcnco] when Editioned objects are used
18436307 A trigger with a ‘WHEN’ condition that is created on an Editioned View (EV) does not fire when the EV has a VPD policy defined on it

Exadata

14398428+ Sporadic Wrong results from Exadata (duplicate rows)
17080436E Diagnostic enhancement to write out OSS map elements in Exadata
17230905E Improved diagnostics when ASM in Exadata receives a hard check failure from the Storage Server (ORA-27626)
18483595E Enhancement to support hair-trigger I/O timeout support for ASM
15882436 Smart scan is not enabled at SQL-PLSQL-SQL recursive call in Exadata
16057129 Exadata cell optimized incremental backup can skip some blocks to backup
16173738 Controlfile creation fails with ORA-27603/ORA-27626 “Offload library initialization failed” – superseded
16281499 ORA-39127 from expdp after upgrade from 11.2.0.2 to 11.2.0.3
16746889 Unwanted “kdstProcessSageData” trace in Exadata
16769943 diskgroup cannot mount on Exadata with cell down ( ORA-15080 )
16788832 ORA-27609 error in smart scan in rare cases
16838328 Wrong wait “db file sequential read” when Smart Scan downgraded to block IO
16845022 Discrepancy between “read” and “read total” stats with Smart Scan
16863422 ORA-600 [kxdam_notify_cell:ioctlFailed] in Exadata
16864864 Suboptimal Exadata fast file initialization
16910734 ORA-600 [kcfis_create_flcunkeep_payload:invalid reqtype0] in Exadata
16928832 Exadata reconnect diagnostics missing
16930325 ORA-600 [kcfis_translate0] during Smart Scan
17165204 Self deadlock while updating HCC compressed tables
17179261 Exadata management issues continuous online requests from auto management for already onlined disks
17277476 ORA-600 [kcfis_update_recoverable_val_3] in Exadata
17443671 Exadata block repair may invalidate cache lines
17469624 ORA-600 [kcfis_finalize_cached_sessions_2] / ORA-600 [kcfis_update_recoverable_val_3] during session cleanup
17501565 DBMS_STATS.gather_system_stats on Exadata gets inconsistent measurement of IOTFRSPEED
17546761 Exadata griddisk resilvering takes a long time
17561405 XDWK spins retrying automatic DISK ADD despite permanent ORA-15075
17602269 DISKMON master hang due to self deadlock
17867137 ORA-700 [Offload issue job timed out] on Exadata storage with fix of bug 16173738 present
17952061 diskmon repeatedly dumping various state information
18324129 ORA-600 [kfdxWork22]

External Tables

17446849 KUP-4094 from external table with PREPROSESSOR directive – affects DBMS_QOPATCH and OPATCH_XML_ENV

Flashback

12364061 Flashback Versions query fails intermittently with ORA-30054
14355775 ORA-7445 [ktrvleafrowsz] from “AS OF” query
14382117 ORA-4030 trying to allocate 488 bytes (callheap,kprbalo temp memory )
16844448 ORA-600 [3020] after flashback database in a RAC
17186905 Flashback database on standby reports ORA-38861 unnecessarily
17877323 ORA-600 [krbi_init_fra_metadata_not_backup_ctl] from active duplicate on standby database
18284763 ORA-600 [3020] on ASSM blocks in Standby Database after CONVERT TO PHYSICAL or ORA-8103 ORA-600 [4552] in non-standby after FLASHBACK

Flashback Data Archive (Oracle Total Recall)

14536110 ORA-600 [ktfaput: wrong pdb] / crash using PDB and FDA
16454223 Wrong results with flashback query (data archive)
16571443 ORA-60 deadlock inserting to SECUREFILE with FDA enabled
16744640 ORA-942 on a view on an FDA table with AS OF TIMESTAMP
16982702 NUMBER/NUMBER(38) datatype discrepancies between base table and FDA history table
17159920 Column precision mismatch on view created on table with flashback data archive
17663482 Errors from Flashback Data Archive if table includes a column named “OPERATION”

Function Based Index (Including DESC Indexes)

8250557 Unexpected deadlock involing DDL against functional index or domain index may happen
14652700 Wrong results from query with function based index with parallel plan
16283430 wrong results from inlist on partitioned table and index on virtual column
16623192 Wrong result from the first execution of a query that uses a function based index
16865352 ORA-7445 [qcsicrv] parsing SQL with both an XMLIndex and a functional index
16980523 ORA-7445 [evaopn3] from SQL with function based index if fix 7237571 enabled
17191791 Wrong results with functional indexes, GROUP BY and user supplied ROWID
17843019 Function based index not used with view merging when expected
18188293 ORA-12899 “value too large for date column” from INSERT as SELECT with GROUP BY and DESC index

Gateways / ODBC

16345970 ORA-2070 / ORA-600 [HO define: Long fetch] with DG4odbc

Global Temporary Tables

17761775+ ORA-600 [kclchkblkdma_3] ORA-600 [3020] or ORA-600 [kcbchg1_16] Join of temp and permanent table in RAC might lead to corruption
13253977 Wrong results or error with cursor-duration temp table and PLSQL function running on an active transaction
17217593 Various corruption related ORA-600 attempting to apply undo to a temporary table
17437634 ORA-1578 or ORA-600 [6856] transient in-memory corruption on TEMP segment during transaction recovery / ROLLBACK (eg: after Ctrl-C)
17767676 ORA-600 [kcbchg1_28] possible on temporary ASSM segment
18073792 Excess TO enqueues / “enq: TO – contention” using temporary tables with savepoints

Globalization Support (NLS)

9878501 Query wtih DISTINCT returns duplicate row with nlssort
11795985 PLSQL binds may fail with ORA-6502 in a multi-byte characterset
14090953 DBMS_SPACE.ASA_RECOMMENDATITON fails with ORA-6502 if NLS_NUMERIC_CHARACTERS set
14827309 LIKE gives wrong result (missing rows) for LINGUISTIC collation with _AI or _CI
15865476 SQL spins with empty / null CLOB bind with AUDIT_TRAIL=xml, extended
16584684 Corrupt data / errors from OGG replicate of LOB to LONG in multibyte
16605180 Schema validation fails / LSX-222 when database is NOT AL32UTF8
16618977 ORA-27163 can occur during XML parsing of non-USASCII / non-UTF8
16634207 Errors like ORA-21525 using collections of NVARCHAR2 between client and server with differing NLS settings
16675739 ORA-22921 / ORA-4088 during database character set conversion with PDB
16768092 ORA-600 [evacol:overflow] when using nls_sort=xgerman_din
16777689 ORA-6502 may occur due to improper sharing of a PL/SQL anonymous block cursor
16831411 Timestamp data in XML does not honour the nls_numeric_character setting
16841060 Wrong first day of the week for Bahrain, Kuwait and United Arab Emirates
16934803 Some analytic functions do not honour session NLS_SORT
17056988 Process spin using XML,EXTENDED auditing with a multi-byte database character
17314888 ORA-600 [19004] when stats have been gathered with NLS_SORT / NLS_COMP not default BINARY
17828499 Opening PDB hangs waiting for row cache lock on open UPGRADE
17848897 AQ propagation reports ORA-22337 with different database timezones or character sets
17910279 NLSSORT predicates generated with wrong NLS_SORT comparison
18270874 ORA-600 [kghstack_free1] using audit_trail=xml,extended in multibyte DB
18353141 Wrong result from analytical query with NLS_SORT set
18456514 ORA-12705 in Logical Standby database after upgrade to 11.2.0.4
18695733 ORA-600 [15851] from RANK() with NLS_SORT and DESC with fix for bug 15936924 present

Hash Join

17289787 ORA-600 [qeshQBNextPiece.1] from GROUP BY

Index Organized Tables (IOT)

13521413 Incorrect supplemental redo generated when using IOT with keys > 128 bytes long
14829250 ORA-7445 [ktbdbh] during diagnostic IOT output
16495802 Logminer ORA-16211 mining update of chained IOT rows with overflow

Instance Startup

15931893 ORA-338 may be written to the alert log on startup even though they are ignored
16271658 In RAC a starting instance can block some other instance wanting an anti-lock
16457621 ORA-600 [kkaegen_get_edition_name_3] after error during PDB open with Editions
16613964 Unwanted “Exadata” messages in ASM and DB alert logs on startup
16761566 Instance fails to start with ORA-600 [4000] [usn#]
16795944 PDB open crashes after LICENSE_MAX_USERS set to less than current
16836849 ORA-7445 [ktcAllocXcb] during database open
16864359 ORA-1157 signaled for tempfiles in a PDB that requires dictionary check
16978185 ORA-600 [KGHLATCH_REG4] in ASM on a system with many CPUs
16994576 ORA-600 [kqlbbotadd:3] when PDB is opened
17292630 ORA-16075 in RAC with maximum protection mode after restart
17308691 PDB open force does not throw a sync error while PDB open does
17496884 Clusterwide ASM hang possible when ASM instance tries to start up
17605638 ORA-16075 during restart of RAC instance in maximum protection
17828499 Opening PDB hangs waiting for row cache lock on open UPGRADE
18273830 ORA-7445 [kge_is_oserr] mounting diskgroup if ora.asm asm_diskstring>1024
18536647 New ADG instances are in MOUNT state after switchover by broker
18783969 Memory corruption / database does not start with cluster_database=true

Interoperability (Between Releases)

17892268 ORA-600 [koklread1-callback with conv flg] using 10.1 PLSQL client
18973907 Memory corruption / various ORA-600/ORA-7445 using database links between 11.2.0.4/12.1.0.1 and earlier versions

JavaVM / JSP / Corba etc..

7449468 “jar” files loaded with “loadjava -jarsasdbobjects” not dropped when user is dropped
15861775 ORA-1000 cursor leak from some V$ / X$ table accesses
16524926 ORA-1031 from LOB writes in stored Java (JDBC KPRB) in definers rights
16633815 Poor performance of stored Java on some platforms
17070459 ORA-600 [26599] using stored Java
17330788 ORA-7445 in Stored Java GC calls such as eoa_csvr_scan_newmem_stack()
17343514 Remove Java code from catbundle
17391312 ORA-7445 [ioc_IUflags] during CDB upgrade
17478811 ORA-600 [26599] using CDB_JAVA views in PDB
17528315 ORA-29532 on javamail API
17564984 Java stored procedure fails to compile when enum classes are used
17600719 ORA-7445 from repeat calls to DBMS_UTILITY.invalidate which compiles Java objects
17610418 ORA-29548 from plugged in different version non CDB as PDB
18166577 Java stored procedure fails with ORA-29532 in 11.2.0.4/12.1.0.1
18458318 Low quality font image file created using stored Java after upgrade to 11.2.0.4

Job Queues

16371304 DBMS_SCHEDULER.window does not close – jobs may not run
16613113 DBMS_SCHEDULER.add_job_email_notification does not work for JOB_DISABLED event
18155703 CJQ0 consumes a lot of CPU on CDB related queries
18292893 Jobs don’t execute per schedule with a large number of PDBs

Literal Replacement (CURSOR_SHARING)

16916051 ORA-600 [qknrSetCntForOpn:bfl for bind] or other ORA-600 ORA-7445 errors with cursor_sharing=force
17587063 ORA-600 [qerghFetch:inc] reported on query with CURSOR_SHARING=force
17588480 library cache mutex/shared pool latch deadlock
17852660 ORA-907 using indicator variables with CURSOR_SHARING if fix 14053457 present
18054363 Query through dblink fails with ORA-979 “not a group by expression” with literal replacement

LogMiner

8352043 Logminer generates incorrect LCR for update to compressed table with trailing null.
15913355 Supplementally logged column values incorrect for clustered tables
16240139 Comments truncated at end of CREATE USER/ALTER USER/GRANT statements in LogMiner
16286774 ORA-1405 restarting logminer when mining a PDB dictionary
16313881 ORA-600 [krvuatld] from Streams capture
16495802 Logminer ORA-16211 mining update of chained IOT rows with overflow
16747736 LogMiner memory leak / ORA-1341 “logminer out-of-memory”
17193825 Missing supplemental log data for update DML on a previously compressed table
17227277 ORA-1741 during LogMining certain DDLs
17348614 Logminer generates unsupported LCRs when mining XMLType table with out-of-line storage and LOB
17381384 ORA-1427 from multiple logminer sessions loading data for tables with REF columns
17477958 Logminer dictionary build can take very long time for large databases
17835627 Poor Logminer / OGG extract performance for large MERGE SQL
18456514 ORA-12705 in Logical Standby database after upgrade to 11.2.0.4

Merge SQL (MERGE .. USING)

14237433 ORA-918 from MERGE statement on partitioned table
16585527 Parallel MERGE statement produces ORA-60 on table with HCC partitions
17079498 MERGE statement fails with ORA-7445 [koksObjOpnHasLob]
17197563 ORA-600 [kkmupsViewDestFro_4] from MERGE SQL with STAR transformation
17397545 ORA-600 [kdtigetrow-2] from MERGE statement with LOG ERRORS INTO
17449815 ORA-8102 ORA-1499 after ORA-1/ORA-2291 by MERGE with DML ERROR LOGGING
17835627 Poor Logminer / OGG extract performance for large MERGE SQL
18192858 ORA-600 [ktssdrp1] on a MERGE statement in a RAC environment
18280356 ORA-7445 [kkmupd] on MERGE SQL

Migration / Upgrade / Downgrade

13866822 catbundle rollback does not update registry$history correctly
13991403 rootupgrade.sh should validate that ONS local/remote ports are different
16433869 ORA-955 during upgrade in XDB$RCLIST
16689109 ALTER TYPE in upgrade script can product invalid objects in a CDB
16709437 ORA-65074 during database upgrade
16761566 Instance fails to start with ORA-600 [4000] [usn#]
16913149 Pre-upgrade tool gives wrong path for removing OLAP from database
16924879 Obsolete QSMA synonyms are not dropped on upgrade from 10.2 to 11.2
16935643 ORA-600 [kqludp2] while upgrading a PDB
17005047 datapatch should call catbundle for 12.1.* psu
17032726 PDB upgrade does not populate old type OBJ$ signature properly (ORA-600 [kqludp2])
17042658 ORA-600 [kewrsp_split_partition_2] after upgrade from 11.2 to 12.1
17184721 QSMA specific public synonyms are present after upgrade from 10.2
17231267 Upgrade 10.2 to 11.2.0.3 with a large number of XDB resources never completes
17244462 ORA-600 [kspgsp2] on ALTER PLUGGABLE DATABASE .. OPEN UPGRADE
17280117 ORA-942 on DBMS_SCHEDULER during upgrade from 12.1.0.1
17343514 Remove Java code from catbundle
17361122 ORA-22324 / ORA-4045 / ORA-60 when upgrading from 9.2 with XDB
17391312 ORA-7445 [ioc_IUflags] during CDB upgrade
17563549 xdb.xdb_resource_t is not modified properly when upgrading from 10.2 to 11g or higher
17610418 ORA-29548 from plugged in different version non CDB as PDB
17828499 Opening PDB hangs waiting for row cache lock on open UPGRADE
17852660 ORA-907 using indicator variables with CURSOR_SHARING if fix 14053457 present
18200489 12c preupgrd.sql output does not display memory related recommendations
18240704 ORA-8103 during upgrade on ALTER TABLE kottd$ MOVE LOB
18255105 Patch for upgrade scripts to identify histograms affected by fix of bug 15898932
18828868 Too Many Qxxx Processes Maxing Out the Number of Processes with fix for bug 14602788 present

Multi Table Insert SQL

16362839 ORA-600 [more fun:qkaTableQueueTraverse1] from multi table insert with NOAPPEND if parallel DML enabled

Multimedia (Formerly interMedia) (Image)

18458318 Low quality font image file created using stored Java after upgrade to 11.2.0.4

Network

16572554 disabled local listener state remains ‘ready’ and causes ORA-12541

OCI

15946766 Instant Client OCIEnvCreate uses more memory in 11.2.0.2+ than 11.2.0.1
16443657 OCITransCommit() is able to commit from wrong container
16473957 Abstract LOB leak using getClobVal/getBlobVal in OCI connection
16634207 Errors like ORA-21525 using collections of NVARCHAR2 between client and server with differing NLS settings
17031322 OCIXmlDbRewriteXMLDiff returned bind variables are not whitespace preserving – affects OGG

Online DDL

16070351 ORA-7445 [ctcdrv] from “ALTER TABLE MOVE PARTITION .. ONLINE”
16783376 ORA-600 [kdstgr_ktid_not_ehcc_compressed] from ANALYZE of HCC compressed table ONLINE

Optimizer

18304693+ Suboptimal higher cost plan chosen for Cost-Based Query Transformation.
13692395D Or-expansion applied to join predicate could produce suboptimal plan
17368047D JPPD does not work for UNION views with just DUAL in one branch
17442009D Poor parse performance with many tables in join order when some are from unnested subquery/ies
12977599 CBO double-counting derived predicate selectivity
14085520 Wrong costing of non-mergable view with rejected OJPPD
14237433 ORA-918 from MERGE statement on partitioned table
14632583 ORA-7445 [kkeics] during view merge
14648222 Incorrect cardinality estimate for INDEX SKIP SCAN
15834345 DBMS_STATS.gather_database_stats_job_proc fails with ORA-942
16268425 Memory corruption / ORA-7445 / ORA-600 gathering statistics in parallel for table with virtual column/s
16283281 ORA-7445 / memory corruption from ANSI join with many columns
16346545 Automatic stats gather ignores the granularity table preference “ALL” for composite partitioned tables
16394467 SQL_Optimizer / 10053 diagnostic trace shows costs / cardinalities with only 2 digits of precision
16470836 High DML rate against MON_MODS$ related to DBMS_STATS
16507317 Poor cardinality calculations and slow performance for anti joins
16516751 Suboptimal execution plan for query with join and in-list using composite index
16516883 OR expansion does not occur with JPPD
16571451 sql plan directives aren’t used when optimizer_dynamic_sampling is default
16615686 Suboptimal plan with INLIST predicate and extended statistics
16622801 Underestimated cardinality from a join with repeated join clause
16690013 ORDERED hint not honoured with distinct aggregate transformation
16694280 Wrong results when joining composite partitioned tables
16698971 ORA-600 [19004] or inaccuracies on join of histogrammed columns
16725982 Dynamic sampling does not occur for level 4 if filter predicate involves virtual expression
16726844 Statistics may be regathered on partitions that have no changes
16747257 10053 index selectivity is printed as float instead of exponent showing 0.000000 instead of a true value
16751248 Wrong results from UNPIVOT operator
16774684 ORA-600 [kkoipt:invalid aptyp] from ANSI self join with USING keyword
16796185 subestimated cardinality in table expansion plan
16805362 ORA-1843 from predicate containing NVL and TO_DATE
16809786 Secure view merging does not occur when user defined operators are present
16848350 ORA-7445 [kkqjpdcvp] can occur optimizing a query
16851194 Growth of SYSAUX tablespace with incremental statistics without growth in table data
16851342 ORA-7445 [kkoatGetPreds] optimizing a query
16855292 Select on REFERENCE partitioned table using full piecewise joins spins during parse
16954950 Suboptimal plan for SQL accessing table with multiple empty partitions
16976121 View merging to performed in a materialized WITH subquery if the subquery is referenced in a lateral view
16988491 ORA-7445 [qerilcil] from query with multi-column inlist/s
17033499 ORA-7445 [kkqfppRelFilter] from SQL with PLSQL function
17080195 ORA-979 “not a group by expression” for a SQL with CASE operator and GROUP BY
17185558 ORA-600 [kkoipt:incorrect pwj] occurs on querying partitioned table
17191791 Wrong results with functional indexes, GROUP BY and user supplied ROWID
17258090 Recursive SQL fails with ORA-1008 even with fix for bug 14458214
17314888 ORA-600 [19004] when stats have been gathered with NLS_SORT / NLS_COMP not default BINARY
17332316 ORA-7445 [qksopVisitOpns] / ORA-600 [qkebValidateOpn:2] from SQL with invalid HAVING clause – should have reported ORA-979
17339455 ORA-7445 [kkorminl] or similar can occur when running Automatic tuning tasks / DBMS_SQLTUNE Index Advisor
17397506 SORT MERGE JOIN incorrectly chosen over HASH JOIN
17445370 Wrong result (duplicate) from a query with a subquery using nested loops
17458477 ORA-600 [kkesGetIOStat2] when a gather stats call fails (eg: due to Ctrl-C)
17534519 ORA-7445 [qkabxo] from query doing parallel table scan recost
17645326 Wrong Results with outer joins of subquery factoring having subqueries
17727676 optimizer hint ignored when using invisible indexes
17752995 ORA-4031 from explain of SQL with many subqueries and OR expansion
17785414 ORA-600 [qkssaGetSampleProb:!tmpOpnP] from SQL with SAMPLE clause
17809973 ORA-7445 [upduaw]
17812110 Wrong results from query using PARTITION REFERENCE ALL
17843019 Function based index not used with view merging when expected
17893931 ORA-7445 [kkobok] during filter pushdown in CONNECT BY .. PRIOR SQL
17918109 Wrong results (not sorted) with OR expansion and ORDER BY
17980980 Wrong results from subquery coalescing
18034871 Wrong results for query with ANSI join
18062715 ORA-600 [kkqtutlAddSelItem] with more than 1000 aggregate functions in select list
18090371 ORA-7445 [kkoioc] during bitmap plan processing
18244973 Deeply nested qesmaIterNext calls / ORA-7445 [qesmaIterNext] with low OS stack limit
18255105 Patch for upgrade scripts to identify histograms affected by fix of bug 15898932
18405192 ORA-7445 under qervwFetch() or qervwRestoreViewBufPtrs() when deleting from view with an INSTEAD OF trigger
18456944 Suboptimal plan for query fetching ROWID from nested VIEW with fix 10129357
18644187 Correlated set subquery not unnested with fix for 16765564
18685209 ORA-600 [kkogbro: no kkoaptyp] in FIRST_ROWS(k) mode with FULL OUTER JOIN
18973907 Memory corruption / various ORA-600/ORA-7445 using database links between 11.2.0.4/12.1.0.1 and earlier versions

Optimizer (SQL Plan Management)

16660242 ORA-4020 from CTAS with SQL profile and SPM

Optimizer (Stored Outlines)

16663465 ORA-600 [kkdlGetBaseUser2:authIdType] setting USE_STORED_OUTLINES in a PDB
17273405 Cursors not shared / increasing VERSION_COUNT when expected when using stored outlines
17537911 ORA-600 [qolHintPivAddSid:1] using outlines for plans with long OR chains (or long inlists)
17540469 ORA-600 [kgl-hash-collision] triggered by ALTER SYSTEM use_stored_outlines

Optimizer (Subquery Factoring – WITH clause)

9756271 Dump on kditpin
13253977 Wrong results or error with cursor-duration temp table and PLSQL function running on an active transaction
16342156 Wrong results from XMLTable in WITH clause
16976121 View merging to performed in a materialized WITH subquery if the subquery is referenced in a lateral view
17156148 Wrong results with query result cache using bind variable
17357979 ORA-942 from SQL when a factored subquery is referenced in multiple full joins
17360606 Wrong results for materialized subquery factoring (WITH clause) on Data Guard
17645326 Wrong Results with outer joins of subquery factoring having subqueries
18098207 TEMP space leak from SQL using temp table transformation in a PLSQL REF cursor
18516620 ORA-56904 / ORA-7445 from PIVOT query – superseded
18751855 ORA-600 [qcspCheckAggs.1] with PIVOT group by placement if fix for bug 18516620 is present

Oracle Data Mining

17036973 NULL resilts from CLUSTER_PROBABILITY or CLUSTER_SET
17221590 DBMS_DATA_MINING.rename_model cannot replace original atomically

Oracle Data Vault

13639209 TSPITR fails with ORA-376 when DB Vault installed if DVSYS user is not in SYSTEM/SYSAUX
16496977 return code 4067 seen in AUD$ for the operation using database link
16571244 DBMS_RLS reports ORA-1031 on DV protected opbjects
16675668 ORA-1031 querying Spatial data with DV
16718622 ORA-29877 / ORA-1031 using Oracle Text index type with Database Vault
17446849 KUP-4094 from external table with PREPROSESSOR directive – affects DBMS_QOPATCH and OPATCH_XML_ENV
17797700 Unwanted DV audit records from LOB access

Oracle Database Smart Flash Cache

16850996 Serial flashcache scan performance degraded
16964279 Instance hang / crash using server flash cache

Oracle Disk Manager

16343493 ORA-600 [ksfd_odmgo2] … [ODM ERROR V-41-4-4-51-22 Invalid argument]

Oracle Enterprise Manager

17405549 ORA-65125 can occur due to a problem with PDB metadata
17735933 Issues with metadata file name generation with PDB
17983042 Cannot alter user account in EM Express if the user is given a profile that is created by EM Express

Oracle GoldenGate (OGG) Integrated Extract

15913355 Supplementally logged column values incorrect for clustered tables
16170787 IR abend for EHCC enabled tables with parallelism>1
16194160 OGG inbound server does not honor set_table_instantiation
16228604 ORA-600 [kglUnlock-bad-lock] on restarting OGG Extract with missing/deleted REDO logs
16286774 ORA-1405 restarting logminer when mining a PDB dictionary
16320173 OGG Explicit table/schema in inclusion rule should override wildcard exclusion rule
16473934 ORA-600 from OGG delete collisions with many primary keys
16523150 OGG errors / missing info due to DML reordering
16584684 Corrupt data / errors from OGG replicate of LOB to LONG in multibyte
16590848 OGG add / delete supplemental logging fails with ORA-1031
16617325 Apply fails with ORA-2292 “integrity constraint error”
16621274 ORA-1422 from OGG inbound server with ALLOW_DUPLICATE_ROWS = Y
16634384 ORA-600 [krvuatla20] from OGG afer unregistering PDB
16674842 Apply hangs in “wait for next chunk” state after coordinator requested rollback.
16683859 OGG data divergence after piecewise LOB update on compressed Securefile LOB with deduplication
16741246 ORA-60 deadlock aborts apply process rather than rollback and retry
16769019 ORA-1403 in OGG with inline LOB and dedup fetch for PK update
16787973 OGG integrated replicat abends with OCI error ORA-1403 “no data found”
16796277 Capture does not send changes quickly
16816103 XIN aborts with ORA-4031 due to memory leak in OCIXStreamInCommit
16910001 Streams apply eager error not recorded causing OGG to have missing data
16912439 OGG-2028 failed to attach: knlciDumpCaptureVDollarViewInfo err 1403
16943711 OGG XStream inbound encounters ORA-60 deadlock error on EHCC tables
16956380 ORA-7445 [knalsalex] during LOB assembly error for integrated replicat
16964686 Lightweight capture generates unneccessary redo on the database
17027426 OGG IR does not abend when null values are used for delta resolution in cdr
17031322 OCIXmlDbRewriteXMLDiff returned bind variables are not whitespace preserving – affects OGG
17082359 ORA-60 deadlock from OGG apply (IR) into securefile columns with deduplicate on
17205719 OGG: IR shows incorrect DML stats not matching with actual DMLs applied
17208934 Automatic message tracking is not available for OGG Replicat
17214497 Parallel batching reduces OGG throughput
17260090 OGG deletes IR errors in CDB-RAC environment in non owning instance
17297939 OGG cursor leak during apply with Integrated Replicat
17298973 ORA-600 [krsa_geq_rel.2] from OGG downstream extract
17311728 Incomplete supplementally logged columns in OGG
17341326 Various ORA-600 / ORA-7445 from OGG replicat with XStreams
17346091 OGG Integrated extract abends with OGG-2077 extract encountered error code 15012
17381384 ORA-1427 from multiple logminer sessions loading data for tables with REF columns
17389192 OGG IR abends due to ORA-600 [knlqglcr:2] during repeated collisions handling
17390431 Downstream capture for OGG may downgrade to non RTM mode unnecessarily
17393683 OGG: IR reports negative daily/hourly stats & eventually total stats mistmatch
17545847 IEV2 capture aborts with ORA-7445 [knluCompareNumberArrayKnlpar] when EXCLUDEUSERID is specified
17596908 OGG integrated extract issues a fetch for NULL LOB/UDT columns
17655634 ORA-7445 [krvxInvokeCallbacks] from Logminer running under GoldenGate
17694209 OCI-21500 [knclprstr:str] from OGG
18228645 XStream capture REQUIRED_CHECKPOINT_SCN does not change
18293054 ORA-1426 when querying DBA_CAPTURE / V$GOLDENGATE_CAPTURE
18471685 ORA-7445 [knalkcdoce_fcfhdlrs] stopping OGG integrated replicat with handlers
18676416 ORA-600 [kghstack_finish 1] when DDL annotation is used with OGG
18762750 OGG cloned integrated extract fails with ORA-600 [knlogcStartLogminer: logminer start scn > captured_scn]

Oracle Label Security

16799763 The maxwritelabel entry in olsoidadmintool is not correctly validated

Oracle OLAP

16913149 Pre-upgrade tool gives wrong path for removing OLAP from database

Oracle Text (Formerly interMedia Text)

14595800 DRG-50857 / ORA-904 from CREATE of CONTEXT index on XMLType column with FGA policy on the table
16718622 ORA-29877 / ORA-1031 using Oracle Text index type with Database Vault
16836674 Parallel text indexing of binary XMLtype is slower than serial indexing

PL/SQL

16217962E Diagnostic enhancement to dump the PLSQL call stack for SQL parse errors from PLSQL
11795985 PLSQL binds may fail with ORA-6502 in a multi-byte characterset
13253977 Wrong results or error with cursor-duration temp table and PLSQL function running on an active transaction
14354737 Unexpected PLSQL compilation errors, such as PLS-206
15882436 Smart scan is not enabled at SQL-PLSQL-SQL recursive call in Exadata
16305657 Objects locked for incorrect duration when SQL run from PLSQL
16571244 DBMS_RLS reports ORA-1031 on DV protected opbjects
16634207 Errors like ORA-21525 using collections of NVARCHAR2 between client and server with differing NLS settings
16676109 Procedure referring to a public synonym still valid after EXECUTE privilege is revoked
16756136 MapMessage enqueued by AQ-JMS API throws ClassCastException when dequeued by PL/SQL
16777689 ORA-6502 may occur due to improper sharing of a PL/SQL anonymous block cursor
16784901 ORA-7445 after replacing Oracle-supplied common PLSQL object
16801799 SYS_CONTEXT use in an RPC over a database link gives inconsistent results
16929165 ORA-900 / ORA-4045 compiling PLSQL if error position > 32767
17033499 ORA-7445 [kkqfppRelFilter] from SQL with PLSQL function
17216406 PLS-201 selecting from view using an Editioned Function if function not in ORA$BASE (ORA-6552 / ORA-6553)
17308231 ORA-7445 [qctcopn] using XMLTable in PLSQL with a DEFAULT expression
17468141 ORA-7445 [kglobcl] with client side PLSQL (such as Forms)
17892268 ORA-600 [koklread1-callback with conv flg] using 10.1 PLSQL client
18015360 ORA-600 [12270] issuing dynamic ALTER DATABASE .. SWITCHOVER from PLSQL
18092127 Wrong results (or serial execution) for parallel query from PLSQL
18098207 TEMP space leak from SQL using temp table transformation in a PLSQL REF cursor
18291073 ORA-600 [kopocel10] when declaring cursor in PL/SQL package

PL/SQL (DBMS Packages)

5143510 Cannot run dbms_xdbt unless logged in as XDB
12650550 ORA-1436 on executing DBMS_STREAMS_ADVISOR_ADM.analyze_current_performance
14090953 DBMS_SPACE.ASA_RECOMMENDATITON fails with ORA-6502 if NLS_NUMERIC_CHARACTERS set
14307048 ORA-1427 from UTL_SPADV.collect_stats
15834345 DBMS_STATS.gather_database_stats_job_proc fails with ORA-942
15922287 ORA-1427 from DBMS_METADATA for a view with Editions enabled
15983996 ORA-600[kkzlpllg:5] during Online Redefinition or DROP of a snapshot log
15998585 DBMS_STATS may be slow for tables with a large number of columns
16268425 Memory corruption / ORA-7445 / ORA-600 gathering statistics in parallel for table with virtual column/s
16346545 Automatic stats gather ignores the granularity table preference “ALL” for composite partitioned tables
16371304 DBMS_SCHEDULER.window does not close – jobs may not run
16470836 High DML rate against MON_MODS$ related to DBMS_STATS
16584288 Space advisor job fails with ORA-6532
16599661 ORA-600 [kghfrf1] loading a SQLSET using DBMS_SQLTUNE
16613113 DBMS_SCHEDULER.add_job_email_notification does not work for JOB_DISABLED event
16622497 ORA-917 from DBMS_REDEFINITION when attempting to add a new column using a sequence
16634312 ORA-1426 “numeric overflow” from DBMS_STATS.gather_system_stats
16657378 ORA-20008 from DBMS_STATS.create_extended_stats
16726844 Statistics may be regathered on partitions that have no changes
16761566 Instance fails to start with ORA-600 [4000] [usn#]
16772060 DBMS_PDB.sync_pdb gets ORA-600 [kghstack_underflow_internal_1]
16800820 DBMS_METADATA.get_ddl generates faulty ddl for tables with temporal validity
16851194 Growth of SYSAUX tablespace with incremental statistics without growth in table data
16907774 When converting SXML for an index to DDL, the PARALLEL clause is omitted
16995929 DBMS_METADATA.GET_DDL generates incomplete DDL for nested tables / ORA-22913 from IMPDP
17068536 Set container via DBMS_SQL fails with ORA-600 [kkae_set_session_edition_step2]
17079301 ORA-6525 length mismatch from MMON job
17221590 DBMS_DATA_MINING.rename_model cannot replace original atomically
17334246 ORA-31181 when DBMS_XMLDOM.FREEDOCUMENT frees incorrect domdocument object
17339455 ORA-7445 [kkorminl] or similar can occur when running Automatic tuning tasks / DBMS_SQLTUNE Index Advisor
17446849 KUP-4094 from external table with PREPROSESSOR directive – affects DBMS_QOPATCH and OPATCH_XML_ENV
17458477 ORA-600 [kkesGetIOStat2] when a gather stats call fails (eg: due to Ctrl-C)
17469077 DBMS_REDEFINITION.SYNC_INTERIM_TABLE performance issue if table has many rows
17487358 dbms_object_apps_utils package for Ebusiness systems
17500493 DBMS_METADATA.get_ddl doesn’t show storage clause “store as securefile” for queue table
17501565 DBMS_STATS.gather_system_stats on Exadata gets inconsistent measurement of IOTFRSPEED
17561400 ORA-14004 during online redefinition (DBMS_REDEFINITION) of partitioned table
17600719 ORA-7445 from repeat calls to DBMS_UTILITY.invalidate which compiles Java objects
17753923 DBMS_XMLSTORE.insertxml on a table with a blob uses excess memory and fills temporary tablespace
17801303 DBMS_METADATA returns two DDLs separated by semi-column for a User Defined Type
18189036 ORA-600 [qkaffsindex3] from SQL Tuning task / advisor

Parallel Query (PQO)

14398428+ Sporadic Wrong results from Exadata (duplicate rows)
13837378 “alter system kill session immediate” does not kill QC sessions
14652700 Wrong results from query with function based index with parallel plan
15984414 Parallel slave process fail under kxfqdeq()
16186165 Various ORA-7445 from PQ with rollup pushdown and long VARCHAR
16268425 Memory corruption / ORA-7445 / ORA-600 gathering statistics in parallel for table with virtual column/s
16362839 ORA-600 [more fun:qkaTableQueueTraverse1] from multi table insert with NOAPPEND if parallel DML enabled
16448569 PQ hang/deadlock possible – “cursor: pin S wait on X” waits
16585527 Parallel MERGE statement produces ORA-60 on table with HCC partitions
16609749 HASH GROUP BY not used when expected for INSERT as SELECT with direct load
16698577 ORA-10387 and ORA-600 [kglReleaseHandleReference1] from PQ with PDB
17006727 ORA-600 [qerpxInitialize0] from SQL with UNION ALL and PARALLEL hint
17020894 Query warnings and unwanted trace files from PQ slaves that cannot join a query
17220460 parallel query hangs with ‘PX Deq: Execute Reply’
17264297 Serial DML with Parallel scan performs single block reads during full table scan when table has chained rows in 11.2
18092127 Wrong results (or serial execution) for parallel query from PLSQL
18192858 ORA-600 [ktssdrp1] on a MERGE statement in a RAC environment

Partitioned Tables

13506343 Split partition hangs on “pipe get” waits when restricted session enabled
13522189 Partition pruning does not happen for XMLExists query with XMLIndex
14237433 ORA-918 from MERGE statement on partitioned table
14648222 Incorrect cardinality estimate for INDEX SKIP SCAN
15916457 Data pump fails to import REFERENCE partitioned tables if parent is in different schema (ORA-942)
16042673 Database hang when system trying to add interval partition to the table
16070351 ORA-7445 [ctcdrv] from “ALTER TABLE MOVE PARTITION .. ONLINE”
16283430 wrong results from inlist on partitioned table and index on virtual column
16346545 Automatic stats gather ignores the granularity table preference “ALL” for composite partitioned tables
16482849 ORA-600 [kkpoxgsoh1]
16561657 Transport tablespace with DataPump does not preserve “add column optimization” flags
16570573 ORA-600 [qerbtRop:rowidIllegal] from SQL against compressed partitioned table
16585527 Parallel MERGE statement produces ORA-60 on table with HCC partitions
16694280 Wrong results when joining composite partitioned tables
16700693 ORA-600 [12406] after import compressed partition table via TTS
16726844 Statistics may be regathered on partitions that have no changes
16754830 ORA-600 [atbgdve] from exchange partition with fix 16533427 – superseded
16855292 Select on REFERENCE partitioned table using full piecewise joins spins during parse
16918087 expdp transportable tablespace gives ORA-39127 / ORA-1422
16954950 Suboptimal plan for SQL accessing table with multiple empty partitions
17037130 Excess shared pool “PRTMV” memory use / ORA-4031 with partitioned tables
17079498 MERGE statement fails with ORA-7445 [koksObjOpnHasLob]
17164360 ORA-600 [kkoipt:incorrect pwj] parsing SQL with partition wide join
17185558 ORA-600 [kkoipt:incorrect pwj] occurs on querying partitioned table
17258090 Recursive SQL fails with ORA-1008 even with fix for bug 14458214
17429556 ORA-7445 [lstclo] from query rewrite after partition maintenance
17436081 Wrong results when using “partition reference all”
17561400 ORA-14004 during online redefinition (DBMS_REDEFINITION) of partitioned table
17572606 SQL runs slow due to tbl$or$idx$part$num recursive query is repeatedly executed
17720709 High “latch: row cache objects” waits on dc_rollback_segments when using Securefiles
17760686 Bad Cardinality estimation with dynamic sampling
17812110 Wrong results from query using PARTITION REFERENCE ALL
17973301 Rare ORA-600 [kkqsgpmop: invalid # of values: 2] from partition maintenance with materialized views
18045331 ORA-7445 [atbepucs] during exchange partition
18230522 ORA-7445 [kkpamCheckTransJoin] from full partition-wise join on REFERENCE partitioned object
18384391 ORA-600 errors possible with fix for bug 16402712 present

Performance Monitoring

13396185E Diagnostic enhancement to capture OS information about memory / swap in traces / alert
13695011E Need a warning in alert log for lack of hugepages
13695236E New ORADEBUG PDUMP command to dump multiple stacks n seconds apart
13782248E Enhancement to expose parameter DEFAULT_VALUE in V$PARAMETER / V$SYSTEM_PARAMETER
16770399E Include obsolete cursor related information in AWR
17834663E Include SQL ID for statement that created a temporary segment in GV$SORT_USAGE
14852021 “spawrio” script shows wrong %Reads and %Opt values
15886837 CPU time samples from Resource Manager are incorrect for virtual threads
16039533 Histogram in summary reported by orion (Oracle IO numbers) is wrong
16043574 ORA-600 [rwoirw: check ret val] from aggregate on fixed view
16180753 V$SGA_TARGET_ADVICE has no rows
16242449 aqmonitor.sql does not report on 12c AQ performance views
16311211 ALTER INDEX .. REBUILD sets the MONITORING to OFF
16506031 Wrong data in V$SESSION_CONNECT_INFO for CLIENT_CHARSET / CLIENT_VERSION
16668584 V$SQL.SQL_FULLTEXT may show “garbled” SQL for some statements > 1000 bytes long
16803862 V$ASM_DISK.cold_used_mb and hot_used_mb shows wrong values
16838328 Wrong wait “db file sequential read” when Smart Scan downgraded to block IO
16845022 Discrepancy between “read” and “read total” stats with Smart Scan
17205719 OGG: IR shows incorrect DML stats not matching with actual DMLs applied
17393683 OGG: IR reports negative daily/hourly stats & eventually total stats mistmatch
17467075 Unpexpected ORA-4029 querying fixed tables/views
17493764 V$SQL_PLAN object_name is not populated for INSERT operations
17501565 DBMS_STATS.gather_system_stats on Exadata gets inconsistent measurement of IOTFRSPEED
17684143 Compression Advisor returns unrealistically small size for used space
18009564 RMAN overestimates backup size twice as much (False RMAN-3009 possible)

Physical Standby Database / Dataguard

16363060E Managed standby recovery should alert user when datafile is no longer valid
16727238E No information of primary timestamp that standby recovered up to during rolw transition
13829543 In DG auto resync from standby overwrites the standby controlfile – can cause resync/backup errors
14263190 A duplicate fails with RMAN-5531 when source is a standby
14382117 ORA-4030 trying to allocate 488 bytes (callheap,kprbalo temp memory )
16091872 ORA-01623 / ORA-01624 / ORA-01567 dropping ORL on a STANDBY database
16836849 ORA-7445 [ktcAllocXcb] during database open
16856028 Export datapump slow on dataguard standby instance
17006183 DB hang as Archiver confuses destinations for EOR archivelog upon role change to primary
17186905 Flashback database on standby reports ORA-38861 unnecessarily
17284817 Switchover to standby hang using broker via Siteguard
17292630 ORA-16075 in RAC with maximum protection mode after restart
17386756 ORA-600 [krsr_rfs_wda.9] reported by RFS
17753428 ORA-7445 [stsInitParams] during PDB open on ADG
17782561 ORA-16075 in maximum protection on RAC
17877323 ORA-600 [krbi_init_fra_metadata_not_backup_ctl] from active duplicate on standby database
18029658 ORA-600 [krccflu_1] on standby
18284763 ORA-600 [3020] on ASSM blocks in Standby Database after CONVERT TO PHYSICAL or ORA-8103 ORA-600 [4552] in non-standby after FLASHBACK
18304997 RMAN deletes archivelogs not applied to a deferred standby even with fix 16082541
18455956 RMAN “restore primary controlfile” doesn’t convert role of controlfile
18536647 New ADG instances are in MOUNT state after switchover by broker

Pluggable Database (PDB) / Container

16707927E Enhancement to allow a subset of tablespaces to be used for a CREATE PLUGGABLE DATABASE
16822629E SOURCE_FILE_NAME_CONVERT for PDBs in ASM is too long with many datafiles
17777061E Enhancement: Add datapatch parameters to operate on specific set of PDBs
18377764E Enhancement to dump full error message stack to the alert log on PDB open/close errors
17608025I catcdb_int.sql script from patch 17316776 has errors
14506328 Create PDB as clone syntax allows direct cloning from PDB$SEED
14536110 ORA-600 [ktfaput: wrong pdb] / crash using PDB and FDA
14664684 ORA-600 [kpdbCleanupTaskInt:taskid] from DBMS_PDB.CLEANUP_TASK if invalid task_id supplied
15886837 CPU time samples from Resource Manager are incorrect for virtual threads
15931910 Clone remote PDB by database link fails with ORA-17628/ORA-19505
16286774 ORA-1405 restarting logminer when mining a PDB dictionary
16406802 Datafile lost if a duplicate mapping provided in FILE_NAME_CONVERT clause
16443657 OCITransCommit() is able to commit from wrong container
16457621 ORA-600 [kkaegen_get_edition_name_3] after error during PDB open with Editions
16459685 ORA-7445 after failed “CREATE PLUGGABLE DATABASE” / ORA-44310
16483559 PDB Sync not happening on ALTER PLUGGABLE DATABASE OPEN FORCE
16512817 GRANT CONTAINER=ALL may hang with a PDB open in UPGRADE mode
16524968 ORA-600 [kccocx_02] from PDB
16527374 ORA-7445 [qervwRowProcedure] or similar from select on standard views in a container database
16551086 DBA_DIRECTORIES does not show PDB directories when PDB is in restricted mode
16634384 ORA-600 [krvuatla20] from OGG afer unregistering PDB
16660558 ORA-7445 [ksfd_io] in create PDB undo callback
16663303 Incorrect privileges from upgraded DB with PDB
16663465 ORA-600 [kkdlGetBaseUser2:authIdType] setting USE_STORED_OUTLINES in a PDB
16675710 ORA-7445 [ksuSdiInProgress] from close PDB
16675739 ORA-22921 / ORA-4088 during database character set conversion with PDB
16682595 SPFILE / V$SPPARAMETER problems with PDB
16689109 ALTER TYPE in upgrade script can product invalid objects in a CDB
16697600 ORA-65019 from “alter pluggable database all open instances = all”
16698577 ORA-10387 and ORA-600 [kglReleaseHandleReference1] from PQ with PDB
16705020 ORA-7445 [ksp_pdb_spfile_insert] when creating PDB
16712618 A CDB orphaned user can be unlocked
16715647 Restricted open force for multiple PDBs does not work
16730813 ORA-65144 when disabling restricted session in root
16757934 ORA-1461 using MAX_STRING_SIZE=EXTENDED with PDB
16772060 DBMS_PDB.sync_pdb gets ORA-600 [kghstack_underflow_internal_1]
16784143 ORA-600 [kcvfdb_pdb_set_clean_scn: cleanckpt] with PDBs
16784167 ORA-600 [2801] during PDB open / close
16784901 ORA-7445 after replacing Oracle-supplied common PLSQL object
16795944 PDB open crashes after LICENSE_MAX_USERS set to less than current
16825779 Common profile resource limit for password verify function displays from root
16836849 ORA-7445 [ktcAllocXcb] during database open
16859937 PDB local user converted to common
16864359 ORA-1157 signaled for tempfiles in a PDB that requires dictionary check
16874123 RMAN restore does not create GUID directory for pre-12c database
16888264 Plugin of PDB returns ORA-65149
16902138 ORA-7445 [rpidrv] after dropping a PDB
16921340 Non-CDB to PDB plugin hangs
16935643 ORA-600 [kqludp2] while upgrading a PDB
16946613 Common user which was local prior to sync not synced on PDB open
16946990 ORA-65050 creating a user in a local PDB if “_ORACLE_SCRIPT” is set
16993424 ORA-600 [kkaegen_get_edition_name_3] in PDB with Editions
16994576 ORA-600 [kqlbbotadd:3] when PDB is opened
17000176 Hang inside catcdb_int.sql called using catcon.pl
17016479 Wrong results from nested loops join to CDB view
17026503 ORA-7445 [kpdbdDropPdbApplyUndo] when drop PDB
17032726 PDB upgrade does not populate old type OBJ$ signature properly (ORA-600 [kqludp2])
17068536 Set container via DBMS_SQL fails with ORA-600 [kkae_set_session_edition_step2]
17174391 ORA-603 / ORA-600 [730] using ALTER SESSION SET CONTAINER
17182200 SET CONTAINER reports ORA-1035 even with restricted session privilege
17210416 ORA-600 [kpdbChangeCbk:inv pdb] can occur in GEN0 process
17217040 ORA-600 [kqlpgCallback: inv pdb] after PDB dropped and new PDB created
17244462 ORA-600 [kspgsp2] on ALTER PLUGGABLE DATABASE .. OPEN UPGRADE
17249820 ORA-7445 [kpdbSyncExec] with PDB
17260090 OGG deletes IR errors in CDB-RAC environment in non owning instance
17308691 PDB open force does not throw a sync error while PDB open does
17324822 PDB sync does not sync delegate option for existing common role
17391312 ORA-7445 [ioc_IUflags] during CDB upgrade
17394724 ORA-7445 [kpdbfDuplicateName] creating a PDB with tablespace containing multiple datafiles
17405549 ORA-65125 can occur due to a problem with PDB metadata
17443596 Disk space leak during repeated PDB create/unplug/drop
17461374 Create and drop of a single PDB repeatly fails with ORA-59
17462687 ALTER USER IDENTIFIED GLOBALLY/EXTERNALLY allowed for orphaned user
17478811 ORA-600 [26599] using CDB_JAVA views in PDB
17516005 Intermittent ORA-600 [kpdbObjLinkEndOfFetch] in PDB
17572720 ORA-2032 signalled when querying CDB views
17610418 ORA-29548 from plugged in different version non CDB as PDB
17735933 Issues with metadata file name generation with PDB
17750832 SET CONTAINER incorrectly enforces resource limit check for ADMIN users (ORA-2391)
17753428 ORA-7445 [stsInitParams] during PDB open on ADG
17762256 ORA-600 [kkdlGetCkyName1] in CDB environment
17828499 Opening PDB hangs waiting for row cache lock on open UPGRADE
17862404 User errors such as ORA-1543 not reported in alert.log in PDB
17888553 GRANT IDENTIFIED BY CONTAINER=ALL doesn’t properly sync password for read-only PDB
17898730 ORA-600 [kpdbChangeCbk-pdbid-notfound] during concurrent PDB DDL
17974104 CDB instance crash with ORA-600 [kpdbBeginSetCleanSCN-badlk]
17982838 ORA-60 during PDB rename
17997255 ORA-600 [kpdbaOpenClose: no IS enq] when open/close PDB
18292893 Jobs don’t execute per schedule with a large number of PDBs
18348157 Plugging a 12.1.0.1 PDB into higher version CDB does not put message in “pdb_plug_in_violations” when it should

Query Rewrite (Including Materialized Views)

13884774 Deadlock from concurrent select/ALTER SUMMARY and ALTER TABLE if query_rewrite_enabled set to true/force – superseded
14742832 ORA-2097 / ORA-1031 from MV refresh in non-atomic mode if _FIX_CONTROL has been set
15983996 ORA-600[kkzlpllg:5] during Online Redefinition or DROP of a snapshot log
16019728 ORA-600 [6891] / ORA-600 [kcbgcur_1] using materialized views
16071494 ORA-7445 [kkqsgGetEqvClassManager]
16188701 ORA-942 / ORA-7445 [ksscct] invoker right procedures run by users in parallel
16191248 Hang from concurrent drop of on-commit materialized views or using DBMS_REDEFINITION
16247011 ORA-7445 [qsmqFindScnCtrVal] recreating a materialized view
16346645 ORA-7445 [msqopnws] from DBMS_MVIEW.explain_rewrite on SQL with binds
16753981 Query rewrite does not occur when expected, even with REWRITE hint
16777840 ORA-600 [kkdlGetOnDiskDefVal : no MODV] from CREATE MATERIALIZED VIEW over a database link
16878635 Wrong result from enforced query rewrite with RELY ON due to Join Elimination
17020149 Wrong mview name is displayed in ORA-12048 error when DBMS_REFRESH encounters to remote error
17065035 ORA-600 [kkqsckjb:!sjo] from query rewrite
17246694 ORA-600 [rwoirw: check ret val] from CREATE MView selecting virtual column over database link
17255538 ORA-4030 (kxs-heap-c,chedef : qcuatc) on REFRESH of an INVALID materialized view
17314427 ORA-7445 [kkqsBuildJoinAdjMatrix] from query rewrite
17369347 ORA-1719 on query rewrite with outer join outside a disjunction
17429556 ORA-7445 [lstclo] from query rewrite after partition maintenance
17514321 ORA-12008 / ORA-4020 with fix for bug 17051587 present
17651484 ORA-30393 – query rewrite not happening in when expected for MV with ANSI join
17663668 Parse hangs/spins in kkqsPruneSelOfRlsView with RLS policy on table with virtual column and MVIEW
17705023 ORA-600 [kkzuasid] on MV refresh
17785817 Dictionary entry in SLOG$ is not removed if users other than owner drop a materialized view
17973301 Rare ORA-600 [kkqsgpmop: invalid # of values: 2] from partition maintenance with materialized views
18560427 MV refresh fails intermittently with ORA-4021 with fix for bug 13884774

RAC (Real Application Clusters) / OPS

17761775+ ORA-600 [kclchkblkdma_3] ORA-600 [3020] or ORA-600 [kcbchg1_16] Join of temp and permanent table in RAC might lead to corruption
14780541E Diagnostic enhancement to include “ORA-60” in alert text when a GES Deadlock is detected
16206952E Include messages related to OS load in the alert log file in RAC
16988464E Diagnostic enhancement to show RAC DLM lock history in text form
16996992E Diagnostic enhancement to Validate a DLM lock when replaying a resource in RAC
17043168E Diagnostic enhancement to add an additional argument to ORA-600 [kjbconsign:sender]
17043323E Diagnostic enhancement – Additional arguments for ORA-600 [kjbmiclo:creq]
17049117E Diagnostic enhancement to write RAC resource for ORA-600 [kjbwrdone:!op]
17049276E Diagnostic enhancement – Additional parameter in error ORA-600 [kjbmmchkinteg:from]
17049298E Diagnostic improvement for ORA-600 [kjblgolocal:g1]
17049676E Add additional argument to ORA-600 [kjbreqwr:xsp] error
17049773E Diagnostic enhancement to give additional parameter in error ORA-600 [ kjctr_pbmsg:badbmsg2]
17227541E Diagnostic enhancement for RAC to track stale “crstate”
17626607E Add new error “ORA-600 [kcl_le2flash_6]” to try to catch cause of ORA-600[kclfadb_2] earlier
17889599E Diagnostic enhancement to add additional arguments to ORA-600 [kjbrfixres:stalew] errors
17889691E Diagnostic enhancement – Additional parameters for ORA-600 [kjbldrmrpst:pkey] and ORA-600 [kjblpkeydrmqscchk:pkey]
17997497E Diagnostic enhancement for event 39505 to trace clusterware calls from RDBMS code
18047161E Diagnostic enhancement – additional arguments for ORA-00600 [kjrfnd1]
17376015PE Windows: Diagnostic enhancement to include .sym files for component skgxp
8325586 Client failover code queries GV$INSTNACE slowing failover
13869467 Many waits for ‘row cache lock’ in RAC while creating many tables with constraints
14054676 SYS.SYS$SERVICE_METRICS_TAB queue table fills up when a RAC node is down
15838437 ORA-7445 [kglbrk] from AQ dequeue / possible ORA-24033 on AQ enqueue
15986012 LMS crashes instance with ORA-600 [kjbmprlst:!rcfg]
15999982 ORA-600 [kcl_sanity_check_cr_1] ORA-600 [kclchkblkdma_3] in RAC or ORA-752 ORA-600 [3020] during recovery
16069901 Hang/spin in RAC looking up object affinity
16076097 ORA-600 [1433] during DB replay on RAC
16088176 RAC hang / LMD crashes instance with ORA-600[kjmscndscq:timeout]
16244191 ORA-600 [kjbmprcvass:rid] can occur in RAC crashing the instance
16271658 In RAC a starting instance can block some other instance wanting an anti-lock
16392068 ORA-600 [kjbmpocr:dsb] from LMS / instance crash
16465158 ORA-600 [kjbmpocr:dsb1] / instance crash in RAC
16524071 LMHB crashes the instance due to ORA-29770 during remastering with many locks
16529874 Frequent “LCK(ospid: ****) has not moved for 20 sec” trace messages
16543323 LMHB terminates instance with ORA-29770 due to LMS apparent slowness
16579084 LMS crashes instance with ORA-600 [kjbmprlst:shadow]
16589507 Hang manager may detect and resolve hangs quicker than expected
16668226 ORA-600 [723] / ORA-600 [15709] from hang manager in RAC
16674666 LMS crashes instance with ORA-600 [kclrecbst_9]
16685417 LMS hang and database instance termination by LMHB
16694728 ORA-600 [kjblpgorm:!antilock] in LMS in RAC
16698629 ORA-600 [kdsgrp1] executing SELECT on table modified by a loosely coupled clusterwide global transaction
16733884 RAC instance crash with ORA-600 [kjbmprlst:!rcfg]
16789573 ORA-600 [ktsl_format_ufs_hbb:objdchk_kcbnew_3] in RAC
16810361 ORA-600 [kjbmpocr:ds!b] in RAC
16819962 RAC instance crash due to many message tickets waiting to be recycled
16844448 ORA-600 [3020] after flashback database in a RAC
16851630 ORA-13917 ORA-6512 generated in oraagent_oracle.log notifydbopen() issue
16856570 LMS crashes RAC instance with ORA-600 [kjbrcvt:!S]
16991789 ORA-600 [kjbldrmrpst:invshad] and instance crash by RMV0 process
16993001 ORA-600 [1433] during object-based DB Replay on RAC
17062465 Client brownout delay due to delay between LMS/LMD stop and reconfiguration starting
17159968 ORA-600 [kjbrwrdone:sc2] / instance crash in RAC
17172902 Allow hang manager to resolve RAC related library cache hangs after a set delay (to allow normal time out)
17215647 ORA-600 [kjbrasr:pkey] in LMS during instance recovery of DROP/TRUNCATE operations
17232014 RAC startup with large buffer cache reserves too little space for GES causing shared pool issues
17260090 OGG deletes IR errors in CDB-RAC environment in non owning instance
17292630 ORA-16075 in RAC with maximum protection mode after restart
17442449 sqlpatch rollback can happen on the wrong node in certain cases
17452841 LMS fails with ORA-600 [kjctsrw:1] leading to instance crash in RAC
17532245 ORA-600 [kjblfr:!cln] / instance crash in RAC
17570819 Processes may consume many of KJC message buffers during DRM
17605638 ORA-16075 during restart of RAC instance in maximum protection
17672719 ORA-600 [kclgclks_3] with fix 17382536 present
17782561 ORA-16075 in maximum protection on RAC
17847764 RAC hangs / stalls / evictions / crashes if DLM processing runs out of flow control tickets
18192858 ORA-600 [ktssdrp1] on a MERGE statement in a RAC environment
18199537 RAC database becomes almost hung when large amount of row cache are used in shared pool
18280813 Process hangs in ‘gc current request’
18326617 ORA-600 [kclobj_5] can occur in RAC crashing the instance
18331944 Query fails with ORA-3171 during ADG instance recovery
18620694 ORA-600 [kjbmpclo:cvt] in RAC
18760484 RAC lock grant count can overflow causing ORA-600 errors
18783969 Memory corruption / database does not start with cluster_database=true

RMAN (Recovery Manager)

13117122E Enhance ORA-19625 error text
13117136E Enhance ORA-245 and ORA-19511 error text
13702947E Additional diagnostic trace for problems with network-file-transfer for RMAN active duplication
12611721 Archivelog deletion policy backed up N times to ‘sbt_tape’ ignored
12756248 RMAN-6004 ORA-1422 during RMAN restore on query from CATALOG tables: site_dfatt, df, node
13498382 ORA-1122 ORA-1208 RMAN Duplicate overwrites datafiles at original location despite db_create_file_dest
13639209 TSPITR fails with ORA-376 when DB Vault installed if DVSYS user is not in SYSTEM/SYSAUX
13829543 In DG auto resync from standby overwrites the standby controlfile – can cause resync/backup errors
14078947 Select from V$RMAN_STATUS very slow when database is open
14260913 Resource Manager does not toggle Datapump export/import sessions to the correct consumer group
14263190 A duplicate fails with RMAN-5531 when source is a standby
14285317 RMAN duplicate fails ORA-1507 if source has archivelog mode and cold backup
14489435 KBHS-715 “transfer-timeout” error restoring backups from S3 using RMAN
15979965 RMAN is aborted by resource manager with ORA-40
16057129 Exadata cell optimized incremental backup can skip some blocks to backup
16315398 PMON not cleaning ksfv slaves
16384983 RMAN bad backup – causes recovery to fail with ORA-600 [3020]
16406371 RMAN “restore database preview” does not check for missing logs
16692232 RMAN backup archivelog all not backed up / delete all input does not work as expect
16757715 RMAN backups throws ORA-27504 when copying a datafile to an NFS target
16874123 RMAN restore does not create GUID directory for pre-12c database
17011832 RMAN-6023, RMAN-6026 on tablespace point in time recovery
17025461 ORA-600 [krbbsThrottle_ zero_total_size] on RMAN backup
17059198 ORA-1 on TS_P1 during RMAN upgrade catalog
17348361 ORA-27028 / ORA-19511 from RMAN backup with “Object too large” message
17721778 RMAN via NFS on ACFS is slow due to zeroing
17877323 ORA-600 [krbi_init_fra_metadata_not_backup_ctl] from active duplicate on standby database
18009564 RMAN overestimates backup size twice as much (False RMAN-3009 possible)
18159793 Data corruption / ORA-600 from large I/Os to/from dNFS (eg using RMAN)
18304997 RMAN deletes archivelogs not applied to a deferred standby even with fix 16082541
18308717 ORA-600 [krbdlmt_dup] from RMAN running backup backupset to tape in catalog mode
18455956 RMAN “restore primary controlfile” doesn’t convert role of controlfile
18487753 ‘report obsolete’ improperly shows datafile copies as obsolete

Read Only Database

13947258 ORA-16000 Unable to drop restore point from ADG database

Recovery

16363060E Managed standby recovery should alert user when datafile is no longer valid
12940206 “Checker run found # new persistent data failures” in alert log in hot backup mode
13639209 TSPITR fails with ORA-376 when DB Vault installed if DVSYS user is not in SYSTEM/SYSAUX
14466785 Recovery fails after adding or dropping an encrypted tablespace
15999982 ORA-600 [kcl_sanity_check_cr_1] ORA-600 [kclchkblkdma_3] in RAC or ORA-752 ORA-600 [3020] during recovery
16057129 Exadata cell optimized incremental backup can skip some blocks to backup
16384983 RMAN bad backup – causes recovery to fail with ORA-600 [3020]
16844448 ORA-600 [3020] after flashback database in a RAC
16903084 ORA-7445 [ksfdpcl] in DBWR during media recovery
17011832 RMAN-6023, RMAN-6026 on tablespace point in time recovery
18304997 RMAN deletes archivelogs not applied to a deferred standby even with fix 16082541

Recycle Bin

13931087 RECYCLEBIN does not automatically purge under space pressure
18192858 ORA-600 [ktssdrp1] on a MERGE statement in a RAC environment

Replication

13974665 ORA-24365 on replication push job with CLOB data

Resource Manager

14260913 Resource Manager does not toggle Datapump export/import sessions to the correct consumer group
15886837 CPU time samples from Resource Manager are incorrect for virtual threads
15979965 RMAN is aborted by resource manager with ORA-40
17750832 SET CONTAINER incorrectly enforces resource limit check for ADMIN users (ORA-2391)

Result Cache

17156148 Wrong results with query result cache using bind variable

Row Level Security / FGA

14595800 DRG-50857 / ORA-904 from CREATE of CONTEXT index on XMLType column with FGA policy on the table
16469401 ORA-904 accessing an XMLtype object with row level security policy
16571244 DBMS_RLS reports ORA-1031 on DV protected opbjects
17663668 Parse hangs/spins in kkqsPruneSelOfRlsView with RLS policy on table with virtual column and MVIEW
17824637 A context sensitive cursor may be incorrectly shared leading to wrong results or errors
18436307 A trigger with a ‘WHEN’ condition that is created on an Editioned View (EV) does not fire when the EV has a VPD policy defined on it

SQL*Loader

14045842 SQL*Loader direct path load makes indexes unusable
17036357 ORA-1438 from SQLLDR direct path on virtual column / ORA-600 [KUPDLS_RDDATA-01] from IMPDP with DIRECT_PATH
17082869 SQLLDR show high memory usage and slow performance

SYSAUX Tablespace

14084247 Failed AWR purge can lead to continued SYSAUX space use
14754390 Orphan object entries on object statistics management tables after DROP OBJECT

Securefiles

13609098 Datapump Import of small Securefile Lobs is slow
16296213 ORA-600 [ktsladdfcb-bsz] creating segment for securefile if event 60063 set
16491477 Missing changes to Securefile LOB if session gets an error
16571443 ORA-60 deadlock inserting to SECUREFILE with FDA enabled
16683859 OGG data divergence after piecewise LOB update on compressed Securefile LOB with deduplication
16769019 ORA-1403 in OGG with inline LOB and dedup fetch for PK update
17082359 ORA-60 deadlock from OGG apply (IR) into securefile columns with deduplicate on
17346671 ORA-3106 when selecting an empty LOB over the long interface
17500493 DBMS_METADATA.get_ddl doesn’t show storage clause “store as securefile” for queue table
17622734 ORA-600 [kdliXfmCheck][xx][0][1] reading compressed Securefile
17720709 High “latch: row cache objects” waits on dc_rollback_segments when using Securefiles
17767224 ORA-600 [kdliReorgPE:1] from DBFS workload using Securefile

Security ( Authentication / Privileges / Auditing )

12414954 ORA-7445 [sltsmna] querying V$XML_AUDIT_TRAIL in Shared Server mode in 12c
15865476 SQL spins with empty / null CLOB bind with AUDIT_TRAIL=xml, extended
15953721 The failed login count of a proxy user increases when an ORA-1948 occurs
16496977 return code 4067 seen in AUD$ for the operation using database link
16524926 ORA-1031 from LOB writes in stored Java (JDBC KPRB) in definers rights
16571244 DBMS_RLS reports ORA-1031 on DV protected opbjects
16675668 ORA-1031 querying Spatial data with DV
16676109 Procedure referring to a public synonym still valid after EXECUTE privilege is revoked
16712618 A CDB orphaned user can be unlocked
16714031 Unified auditing: audit policy using “actions all” does not record audit trails
16718622 ORA-29877 / ORA-1031 using Oracle Text index type with Database Vault
16825779 Common profile resource limit for password verify function displays from root
16946613 Common user which was local prior to sync not synced on PDB open
16946990 ORA-65050 creating a user in a local PDB if “_ORACLE_SCRIPT” is set
17056988 Process spin using XML,EXTENDED auditing with a multi-byte database character
17330580 Inherit privileges grants not usable by Editioned code
17462687 ALTER USER IDENTIFIED GLOBALLY/EXTERNALLY allowed for orphaned user
17737485 data redaction feature returns the last day of the month wrongly
17888553 GRANT IDENTIFIED BY CONTAINER=ALL doesn’t properly sync password for read-only PDB
18264060 Incorrect bind audit data with 16817814 fix
18270874 ORA-600 [kghstack_free1] using audit_trail=xml,extended in multibyte DB

Shared Server (formerly MTS)

12414954 ORA-7445 [sltsmna] querying V$XML_AUDIT_TRAIL in Shared Server mode in 12c
16783586 ORA-7445[nau_sui] may be signaled by shared server
17390160 Small CPU overhead in ksusws->kcblsyncio for shared server sessions
17570240 CPU overhead in MTS under kpospfdrv due to use of sprintf()

Space Management

16584288 Space advisor job fails with ORA-6532
16621589 ORA-1426 “numeric overflow” from AUTO_SPACE_ADVISOR_JOB_PROC

Space Management (Locally Managed Tablespaces)

18284763 ORA-600 [3020] on ASSM blocks in Standby Database after CONVERT TO PHYSICAL or ORA-8103 ORA-600 [4552] in non-standby after FLASHBACK

Spatial Data

16675668 ORA-1031 querying Spatial data with DV
16918087 expdp transportable tablespace gives ORA-39127 / ORA-1422

Star Transformation

17000264 Wrong results from STAR transformation of SQL with multiple “IN(EXISTS)” subqueries
17197563 ORA-600 [kkmupsViewDestFro_4] from MERGE SQL with STAR transformation
17993995 ORA-7445 [kkeAdjFactColNdv] with star transformation
18090371 ORA-7445 [kkoioc] during bitmap plan processing

Star Transformation With Temp. Tables

13253977 Wrong results or error with cursor-duration temp table and PLSQL function running on an active transaction
16792070 ORA-600 [rwoirw: check ret val] from ANSI joins with star transformation

Streams / Logical Standby

12650550 ORA-1436 on executing DBMS_STREAMS_ADVISOR_ADM.analyze_current_performance
14255701 ORA-600 [knasdaFilter:1] in streams Apply
14338435 ORA-7445 [knasald] / memory corruption from Streams apply AS process
15913355 Supplementally logged column values incorrect for clustered tables
16240139 Comments truncated at end of CREATE USER/ALTER USER/GRANT statements in LogMiner
16275522 Streams may stall / give constraint errors after ALTER TABLE DDL
16313881 ORA-600 [krvuatld] from Streams capture
16370198 ORA-1031 or ORA-942 by Apply process during INSERT INTO SYSTEM.LOGSTDBY$APPLY_PROGRESS
16448848 Memory corruption / ORA-600[17147] from Capture
16472716 ORA-22920 occurs when applying piece-wise lob operation in Logical standby – superseded
16579012 instantiation_scn incorrectly set via expdp/impdp
16617325 Apply fails with ORA-2292 “integrity constraint error”
16674842 Apply hangs in “wait for next chunk” state after coordinator requested rollback.
16679874 Streams apply throughput significantly affected by dependency waits
16747736 LogMiner memory leak / ORA-1341 “logminer out-of-memory”
16842274 Logical Standby intermittently fail to make progress
16863989 Streams propagation sender does not reconnect after communications failure
16910001 Streams apply eager error not recorded causing OGG to have missing data
17016369 ORA-1 against SYS.STREAMS$_APPLY_ERROR_TXN_UNQ from Streams
17193825 Missing supplemental log data for update DML on a previously compressed table
17227277 ORA-1741 during LogMining certain DDLs
17348614 Logminer generates unsupported LCRs when mining XMLType table with out-of-line storage and LOB
17351122 Logical Standby terminates with ORA-1281 after consecutive automatic restarts
17389192 OGG IR abends due to ORA-600 [knlqglcr:2] during repeated collisions handling
17549937 ORA-23308 from DBMS_STREAMS_ADM.maintain_change_table
17634921 ORA-22926 for direct path operation on table with LOBS in Logical Standby
18193833 Logical Standby: SQL apply error ORA-10655 reported for shrink space check statement
18228645 XStream capture REQUIRED_CHECKPOINT_SCN does not change
18293054 ORA-1426 when querying DBA_CAPTURE / V$GOLDENGATE_CAPTURE
18456514 ORA-12705 in Logical Standby database after upgrade to 11.2.0.4
18996843 Apply fails with ORA-7445 [kghfre] with fix for bug 16472716 present

Supplemental Logging

8352043 Logminer generates incorrect LCR for update to compressed table with trailing null.
13521413 Incorrect supplemental redo generated when using IOT with keys > 128 bytes long
15913355 Supplementally logged column values incorrect for clustered tables
16523150 OGG errors / missing info due to DML reordering
16590848 OGG add / delete supplemental logging fails with ORA-1031
17193825 Missing supplemental log data for update DML on a previously compressed table

System Managed Undo (SMU)

17306264 Frequent ORA-1628 max # extents (32765) reached for rollback segment

Transparent Application Failover

8325586 Client failover code queries GV$INSTNACE slowing failover

Transparent Data Encryption

14466785 Recovery fails after adding or dropping an encrypted tablespace

Transportable Tablespaces

13591259 Wrong result from query on transported OLTP compressed table with column comparison predicate
16561657 Transport tablespace with DataPump does not preserve “add column optimization” flags
16700693 ORA-600 [12406] after import compressed partition table via TTS
16918087 expdp transportable tablespace gives ORA-39127 / ORA-1422

Triggers

14580303 Incorrect timestamp data inserted via instead-of trigger
14789076 Wrong data due to column swapping using trigger and CLOB with bind size >4000
16422541 ORA-7445 [kghssapage] reported while updating table containing a CLOB
16444683 ORA-600[delprecg1] during delete
16675739 ORA-22921 / ORA-4088 during database character set conversion with PDB
16802693 Incorrect ORA_DICT_OBJ_OWNER for grant/revoke DDLs on directory objects
17050888 ORA-600 compiling object in Edition after dropping covered objects
17809973 ORA-7445 [upduaw]
18405192 ORA-7445 under qervwFetch() or qervwRestoreViewBufPtrs() when deleting from view with an INSTEAD OF trigger
18436307 A trigger with a ‘WHEN’ condition that is created on an Editioned View (EV) does not fire when the EV has a VPD policy defined on it

Truncate

16610217 ORA-600 [ktspgsb3:kcbz_objdchk] during ROLLBACK against ASSM segment
17215647 ORA-600 [kjbrasr:pkey] in LMS during instance recovery of DROP/TRUNCATE operations
17720709 High “latch: row cache objects” waits on dc_rollback_segments when using Securefiles

Virtual Columns

16268425 Memory corruption / ORA-7445 / ORA-600 gathering statistics in parallel for table with virtual column/s
16283430 wrong results from inlist on partitioned table and index on virtual column
16444683 ORA-600[delprecg1] during delete
16725982 Dynamic sampling does not occur for level 4 if filter predicate involves virtual expression
17036357 ORA-1438 from SQLLDR direct path on virtual column / ORA-600 [KUPDLS_RDDATA-01] from IMPDP with DIRECT_PATH
17246694 ORA-600 [rwoirw: check ret val] from CREATE MView selecting virtual column over database link
17663668 Parse hangs/spins in kkqsPruneSelOfRlsView with RLS policy on table with virtual column and MVIEW
18665660 High child cursor counts due to OPTIMIZER_MISMATCH with Optimizer_features_enable=9.2.0

Workload repository / reporting

16770399E Include obsolete cursor related information in AWR
16551284P Incorrect number of CPU cores reported for AMD Opteron processors
12566247 DBMS_WORKLOAD_REPOSITORY.create_snapshot hangs for hours
14084247 Failed AWR purge can lead to continued SYSAUX space use
16818788 AWR report interconnect device statistics not populated while using infiniband
16903536 ORA-12751 in MMON during regular AWR purge
17042658 ORA-600 [kewrsp_split_partition_2] after upgrade from 11.2 to 12.1
17079301 ORA-6525 length mismatch from MMON job

XA / Distributed Transactions

16698629 ORA-600 [kdsgrp1] executing SELECT on table modified by a loosely coupled clusterwide global transaction
17374130 XA returns XAER_RMFAIL when the underlying Oracle error is ORA-28

XDB

5143510 Cannot run dbms_xdbt unless logged in as XDB
9100556 XMLSerialize with versioning not possible
12646133 ORA-600 [qmcxeWSNQ1] when exporting a column of type “XMLType storage binary”
12932757 XDB reinstall drops non-XDB objects (catqm.sql)
13522189 Partition pruning does not happen for XMLExists query with XMLIndex
13628110 ORA-600 [qmcxdsSspQn9] from XMLQuery with DTD – superseded
13768027 Datapump import raises KUP-11007 and ORA-1403
14560822 ORA-7445 [memcpy] handling XML data
14582843 emory leak using getclobval on xmldata stored as binary
14595800 DRG-50857 / ORA-904 from CREATE of CONTEXT index on XMLType column with FGA policy on the table
14636798 ORA-7445 [xvmCtxNDStackEnsurePush] / memory corruption / ORA-600 [17147] from XQuery with extractValue()
16342156 Wrong results from XMLTable in WITH clause
16382883 ORA-4030 (kolarsCreateCt,qmemNextBuf:Large Alloc) from XML query
16442354 Fix for bug 13628110 causes extra CPU time in qmcxdsSearch
16462998 XQuery fails with ORA-1704
16469401 ORA-904 accessing an XMLtype object with row level security policy
16473957 Abstract LOB leak using getClobVal/getBlobVal in OCI connection
16605180 Schema validation fails / LSX-222 when database is NOT AL32UTF8
16618977 ORA-27163 can occur during XML parsing of non-USASCII / non-UTF8
16749885 Wrong error message from XML validation
16803438 ORA-600 [qmxtrtBuildFSTFromGrpDesc1] from XML query involving RAW data
16831411 Timestamp data in XML does not honour the nls_numeric_character setting
16836674 Parallel text indexing of binary XMLtype is slower than serial indexing
16839930 ORA-600 [qmxtcEvalXMLConcat] when XMLSEQUENCETYPE is null
16855783 Memory leak in PGA on insert of XMLtype column
16864501 Empty tag when maintaindom false in registerschema when minoccurs is not specified
16865352 ORA-7445 [qcsicrv] parsing SQL with both an XMLIndex and a functional index
16907969 ORA-600 [qmxiStoreXobEl1] inserting into object relational storage
16911730 ORA-600 [qctbyt : bfc] from XMLTable on XMLSerialize
16926863 An XQuery statement gets ORA-600 [qmxqtmCompOccFromSchm:2]
17019107 ORA-600 [17147] reported on binary XML update – withdrawn
17157954 Converting boolean value to integer in XMLTable returns wrong results
17215306 ORA-600 [qmxptRewriteFro1] using XMLTABLE on CLOB storage xml column
17231267 Upgrade 10.2 to 11.2.0.3 with a large number of XDB resources never completes
17308231 ORA-7445 [qctcopn] using XMLTable in PLSQL with a DEFAULT expression
17334246 ORA-31181 when DBMS_XMLDOM.FREEDOCUMENT frees incorrect domdocument object
17348614 Logminer generates unsupported LCRs when mining XMLType table with out-of-line storage and LOB
17349973 ORA-7445 [qmxtrtBuildFSTFromGrpDesc] from XDB
17361122 ORA-22324 / ORA-4045 / ORA-60 when upgrading from 9.2 with XDB
17421340 sys.XDB_MIGRATESCHEMA.MOVESCHEMAS cannot migrate evolved XML schemas
17537657 Memory leak from XDB in oracle.xdb.SoftHashMap
17563549 xdb.xdb_resource_t is not modified properly when upgrading from 10.2 to 11g or higher
17654904 ORA-7445 [kauxalo] from EXPLAIN of an INSERT with XDB
17753923 DBMS_XMLSTORE.insertxml on a table with a blob uses excess memory and fills temporary tablespace
17758389 ORA-7445 [qmcxeEncStartElement] can occur with XDB
17775506 XML query fails with ORA-7445 [qmcxpmapGetPfxFromNspId]
17866746 ORA-600 [kope2uattr:datetime] processing TIMESTAMP in XMLType
17950169 ORA-7445 [qmuhshenum_init] from DBMS_XMLSTORE.insertXML
18106312 ORA-1830 when query or store XML with xs:date element containing timezone offset
18176929 Wrong results selecting from user-defined table
18509558 ORA-600 [qmcxdsGotoRoot1] or similar on XQuery with binary XML
18559920 Wrong results from XMLtype virtual column

XML

17031322 OCIXmlDbRewriteXMLDiff returned bind variables are not whitespace preserving – affects OGG

Miscellaneous

17186644 The ARCH process does not share open cached FOB of online logs
17487358 dbms_object_apps_utils package for Ebusiness systems

Undocumented Oracle Server

4576467 4611439 5043305 5277780 5929394 6044236 6155720 6901070 7677603 8258529 8536067 8604437 8643803 8736797 8768508 8776360 9016040 9132593 9199532 9219580 9232619 9287585 9388968 9407364 9413591 9525333 9552303 9648430 9727970 9837587 9869196 9924209 9937649 9959797 10038517 10066495 10130453 10145900 10166893 10169244 10169623 10307612 10322854 10417602 11066111 11744485 11770745 11781682 11798670 11803569 11827743 11838175 11839642 11885216 11906057 11938335 12349316 12546352 12572299 12573303 12601274 12722183 12777059 12851246 12869386 12885466 12933799 12942343 12964245 12975211 12977043 13007920 13035320 13077335 13090107 13100612 13245379 13248220 13263017 13331976 13342249 13345070 13375362 13386193 13404370 13478821 13481226 13507780 13513889 13533934 13567762 13570803 13571521 13613000 13622515 13640613 13641931 13649480 13655618 13683089 13717234 13720740 13722521 13738121 13786540 13791469 13794366 13798847 13799389 13812807 13814203 13824596 13829787 13842636 13848786 13880758 13891981 13906158 13943459 13945563 13950747 13983703 13990707 13991130 13997574 14007203 14018288 14067931 14068577 14073795 14104811 14107333 14119867 14120075 14127787 14133928 14176203 14197853 14207615 14221178 14223113 14223616 14238218 14242833 14249514 14254268 14254555 14282541 14283105 14302813 14311185 14313306 14320966 14322254 14344860 14346992 14348746 14348807 14351647 14354939 14360326 14381963 14385152 14392595 14400110 14401057 14401107 14458214 14465265 14467443 14467569 14469756 14476078 14512308 14513204 14513234 14517627 14525739 14539704 14539713 14542197 14542720 14559766 14569152 14572948 14577029 14579123 14601766 14605073 14609690 14610432 14613526 14619200 14626717 14626924 14630237 14632167 14638061 14638784 14647026 14658704 14667784 14668242 14680506 14684194 14684253 14684459 14700311 14702299 14703295 14703309 14723910 14725874 14747983 14750501 14752749 14752872 14756098 14758227 14764159 14764829 14764840 14772096 14776667 14784397 14792285 14796818 14798911 14805297 14805408 14810472 14812341 14821910 14822777 14824535 14826303 14827747 14836221 14842221 14846352 14846660 15831901 15832107 15836926 15841010 15842981 15848090 15850031 15851422 15856610 15858022 15862142 15866282 15866631 15873008 15873979 15874565 15875296 15889476 15898949 15901852 15902104 15903380 15905091 15908730 15909705 15910002 15911134 15914470 15917426 15920201 15920645 15921906 15922146 15923852 15926213 15927116 15927983 15932964 15933188 15933374 15933433 15935253 15935792 15935806 15936755 15936951 15936970 15947574 15948299 15951649 15951898 15954119 15955538 15961785 15962071 15973810 15975680 15978267 15980234 15980576 15981698 15982926 15983852 15987992 15989088 15991527 15996344 15996357 15996460 15996520 16002686 16005924 16007293 16007810 16009186 16010617 16015637 16023293 16023490 16025489 16034983 16035321 16037208 16040973 16041961 16042246 16053545 16053781 16054013 16063539 16067719 16069452 16082541 16084340 16084430 16091637 16092378 16097622 16104496 16167082 16180763 16191663 16195231 16196361 16203102 16206882 16212012 16213508 16216124 16217690 16220085 16220687 16220895 16221484 16221589 16226575 16226643 16226660 16228982 16236863 16237313 16245251 16247720 16248919 16263994 16267272 16268742 16269345 16270093 16273483 16274747 16278067 16282272 16284537 16292036 16297300 16298117 16299065 16301888 16303608 16307352 16314214 16322861 16323824 16338342 16342845 16346018 16346715 16357438 16360112 16362035 16367081 16368002 16370714 16382764 16396856 16399083 16400122 16401039 16402712 16403344 16405283 16405740 16412588 16415369 16416264 16419958 16423383 16424307 16425400 16434983 16436538 16437398 16443587 16446410 16449088 16453535 16455998 16456209 16457913 16461666 16463153 16466530 16470661 16472815 16473783 16475397 16476928 16480028 16483274 16485447 16494174 16494615 16494960 16496896 16497277 16503391 16509319 16519867 16520547 16521835 16539013 16544878 16545335 16546084 16547309 16547428 16552355 16554552 16555865 16562733 16564891 16568021 16571967 16576706 16580594 16591778 16607263 16610165 16612497 16613412 16625010 16633298 16653951 16672623 16673104 16674632 16674686 16678245 16680837 16689009 16689845 16692811 16702025 16703988 16705164 16709171 16709181 16710729 16718027 16728092 16730798 16731148 16733020 16739794 16742408 16760013 16761198 16762985 16765564 16766691 16780853 16785708 16787555 16792882 16794993 16802118 16804061 16804850 16807804 16810924 16812848 16815142 16817814 16818892 16820228 16821341 16825679 16833845 16835973 16837842 16841351 16843029 16850097 16859747 16861831 16863206 16865496 16865830 16876500 16876940 16885125 16885160 16891690 16893548 16897634 16898135 16911234 16914625 16915985 16919867 16920195 16922406 16923643 16934240 16936704 16939225 16943398 16952124 16953470 16953559 16954972 16958130 16970088 16974854 16990304 16999622 17000467 17000486 17008359 17010181 17010294 17017077 17023996 17033060 17033183 17037392 17039018 17039870 17040527 17041466 17047404 17051434 17051587 17051760 17062080 17066622 17068798 17070815 17156876 17162712 17162771 17164760 17172091 17189758 17192625 17197653 17202956 17205143 17207134 17209968 17210109 17215560 17218394 17228245 17233014 17234189 17238901 17242746 17253299 17254374 17261081 17265093 17268107 17268783 17270174 17270605 17271493 17274465 17274701 17276570 17278949 17284386 17287038 17292425 17293498 17298055 17301564 17301761 17308789 17309268 17315721 17320173 17323222 17337753 17340129 17340819 17352756 17354347 17362789 17371426 17373936 17379684 17382536 17382950 17385018 17388735 17398748 17401297 17401417 17402461 17404511 17433105 17433807 17435488 17435912 17443054 17466854 17469815 17477919 17482538 17483479 17488341 17495758 17500006 17510936 17511071 17533502 17533534 17534365 17535775 17537632 17543933 17545239 17549316 17557621 17560233 17561061 17561473 17564768 17564992 17565514 17567154 17569156 17572661 17577153 17584846 17590018 17595296 17597704 17603987 17604066 17605620 17614105 17618927 17622103 17627039 17631192 17632249 17633803 17642560 17644321 17644530 17647556 17653551 17691313 17694875 17715578 17732353 17739520 17759708 17769597 17777037 17781659 17781859 17782724 17784685 17787259 17797837 17798411 17804001 17805316 17809170 17818863 17819569 17823929 17827534 17833609 17842825 17843104 17843489 17848854 17850242 17852076 17863980 17865289 17866999 17875994 17882599 17885200 17896002 17896018 17906464 17908541 17916593 17922254 17922440 17927970 17928272 17931923 17932866 17936109 17940489 17941893 17945280 17950306 17954221 17965447 17966375 17968067 17968123 17970036 17971955 17972958 17973683 17980246 17982591 17987871 17995069 18017044 18018515 18020335 18035463 18035863 18036580 18053580 18053631 18055715 18058112 18059873 18061124 18066615 18067015 18069141 18073821 18073995 18074623 18082092 18084625 18086503 18091059 18095007 18095460 18096032 18103443 18107784 18112693 18121135 18122066 18128196 18135960 18143006 18143836 18146152 18151669 18151716 18152085 18153657 18159249 18162460 18169693 18171662 18179820 18180048 18180460 18182632 18195042 18196576 18203864 18221857 18221994 18224092 18229888 18229901 18231528 18231837 18239720 18252487 18258709 18266779 18268201 18268753 18269743 18269902 18273508 18282536 18284139 18285675 18288676 18293239 18306487 18308665 18309444 18315328 18317531 18323095 18323690 18325460 18329942 18346135 18346917 18348155 18356134 18362222 18367816 18388128 18388363 18390262 18392999 18409441 18413820 18418984 18425876 18429010 18430495 18433189 18441944 18449278 18455594 18461054 18469868 18480694 18493178 18508164 18508266 18512658 18513891 18514786 18528020 18554519 18610207 18610799 18646451 18665004 18671497 18680949 18691572 18717438 18759260 18779636 18820080

 

Oracle Spatial

Oracle Spatial

17422432 delete of compressed spatial data fails with ORA-29876 / ORA-13199

Undocumented Oracle Spatial

6518834 7708450 9501171 9788193 12716670 14471731 14669800 14690825 14822370 15927002 16031999 16072546 16178396 16223317 16339328 16391439 16465889 16465996 16467621 16509071 16582502 16622375 16657121 16761048 16814879 16928043 16946258 16952251 16997667 17036725 17063903 17242033 17256378 17279011 17307388 17478797 17496928 17577218 17583533 17596531 17646168 17656562 17736442 17736467 17740219 17752579 17774060 17795612 17799300 17827250 17974919 17984331 17996274 18015007 18085242 18089987 18196528 18197587 18296772 18304450 18328186 18331108 18393449 18414648 18427878 18435065 18466634 18513361 18614207 18923449

 

Oracle Text

Oracle Text

18002335 High memory consumption while creating CTXXPATH type index

Undocumented Oracle Text

5207819 10168916 12325237 13600652 13783516 13990588 14158130 14206800 14364541 14486029 15897755 15924589 16298591 16361129 16427680 16476018 16702608 16808156 16865813 16902031 16914935 17045501 17285215 17365236 17417877 17422554 17554728 17608228 17719983 17750761 17834496 17921190 18029305 18247972 18615607

 

Oracle Universal Installer

 

Oracle XML Developers Kit

Oracle XML Developers Kit

17158214 Excess LPX memory use / ORA-4031 processing XML (affects DataPump)
17308605 ORA-31011, ORA-19202 and lpx-240 from xml query

Undocumented Oracle XML Developers Kit

3785062 5018498 5353221 9011344 12625474 12665707 13068154 13886303 13960105 14293110 14739159 14822091 15909405 15923667 16179364 16245604 16280253 16539952 16858322 16869770 16921965 16940692 17048528 17294404 17550934 17569029 17609165 17728916 17751775 17762296 17804351 17804842 18181829 18228046

 

Oracle XML SQL Utility (XSU)

 

PL/SQL

PL/SQL

11935338E Diagnostic enhancement to dump PL/SQL register memory as well as pointers
16974592E Diagnostic enhancement to write PLSQL bind metadata
17445339E Enhance ORA-600 [15419] to contain actual PLSQL failure in arguments
17607958E Diagnostic enhancement to dump PLSQL arguments to trusted callouts
12578873 ORA-7445 [opiaba] when using more than 65535 bind variables
14536303 PLS-801 [assert in pdy5.c movpat target] when REGEXP_SUBSTR used in PLSQL
16202544 Returning NULL CLOB Against An AL32UTF8 Database Cause ORA-3113
16562269 Wrong results from PLSQL reference to a record or array component with plsql_optimize_level>=2
16630936 XML types can leak memory when operating under AQ
16738425 PLS-103 from CREATE OR REPLACE TYPE with FORCE OID option
16763016 DBMS_PARALLEL_EXECUTE causes row lock contention on DBMS_PARALLEL_EXECUTE_CHUNKS$
16982566 ORA-7445 [pfsadrc] reported using BULK fetch
16992075 Cannot drop package in ancestor Edition if package references a dead DB link
17174582 ORA-600 [kkt_ginfo_fobjn : missing trigger] during DROP EDITION
17209410 utlrp may be slow on systems with many CPUs
17282229 SQL developer hangs when debugging PL/SQL
17601659 Additional period appended in UTL_SMTP
17610798 PLSQL clients may get stale error handle (ORA-65020 in RMAN)
17811789 ORA-7445 [pevm_ncal_trace] or similar with fix 16471888 present
17858784 ORA-600 [kohfri924] executing stored Java from PLSQL with opaque OUT variable (like XMLType)
18316561 PLS-801 [hshuid:LU invalid] / ORA-600 [17090] compiling a library unit containing a SYNONYM

Undocumented PL/SQL

11935358 12346812 12678203 13788880 13952884 14023227 14312271 14492470 14514024 14514222 14572561 14588085 14727063 14842428 16403537 16471888 16520063 16684143 16936316 17637420 17668929 17804338 17901041 18199478 18229326 18314251 18327244 18990459

 

Precompilers

Undocumented Precompilers

658837 953338 1383600 1466269 2165348 2258824 5891984 6271125 6412329 6451465 9499220 9940354 10083052 10314992 12326274 13100843 13478294 13703008 14013076 14113014 14127422 14335958 14665008 14708769 15933787 16008103 16019471 16240019 16535494 16777164 16944014 16997856 17189633 18302329 18525297

 

SQL*Plus

Undocumented SQL*Plus

16371259

 

SQLJ

 

Universal Connection Pool

Undocumented Universal Connection Pool

14794935 15928641 16298836 16805157

 

Workspace Manager

Undocumented Workspace Manager

16555429 16807649 16872423 16921614 17950092 18140948 18492929 18769590

 

Port Specific Fixes

 

IBM AIX Power Based Systems (64bit)

14162505P AIX: Slow-speed write on ACFS running AIX
14799449P AIX: Diagnostic stack unwind can fail with ORA-7445 [sskgds_snm]
17043601P AIX: OSYSMOND.BIN may dump core

Linux X86-64bit

16551284P Incorrect number of CPU cores reported for AMD Opteron processors
17039197P CVU on RHEL 6 fails with “Reference data is not available for verifying prerequisites on this operating system distribution.”
17359415P Linux: Configuring ACFS reports that cannot execute ‘/usr/bin/lsb_release’
17428148P ACFS driver cannot install on SLES11 sp2: 3.0.80-0.7-default
17475946P root.sh or acfsroot install fails with ACFS-9109 on SLES11 SP3

Windows 64bit (AMD64/EM64T)

16773771P Windows: oracore11.dll may leak critical section on dllmain()
17068448P Windoes: Enhance Windows Oracle Fence Driver log information
17376015PE Windows: Diagnostic enhancement to include .sym files for component skgxp

Comment

*

沪ICP备14014813号

沪公网安备 31010802001379号