Oracle数据库11.2.0.3的PSU补丁修复的BUG汇总

已于 2024-03-02 10:38:05 修改
阅读量1.6k 收藏 33
点赞数 36
文章标签： 数据库 oracle bug
于 2024-03-02 10:37:05 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_42519572/article/details/136411429
版权

Oracle数据库11.2.0.3的PSU补丁修复的BUG汇总，可以从中找到可能遇到BUG的问题。

Advance Queuing

11.2.0.3.812747437ORA-600 [ktspfmdb:objdchk_kcbnew_3] after purging single consumer queue table
12899768Processed messages remain in Queue causing space issues
11.2.0.3.413484963ORA-3146 from AQ propogation from 11.2.0.3 to 11.2.0.2


Automatic Storage management

11.2.0.3.1212387467instance crash by ORA-600 [kffmxpget]
11.2.0.3.1114408859EAdd additional diagnosability trace in ASM when calling ASMLib
15994107ORA-600 [kfcDeadlockAvoid01] from "asmcmd rm -rf" if fix for bug 15900104 present
11.2.0.3.1015981698ORA-600 [kcfis_process_completed_req_invalid_element] if _EXTENT_COUNTS is set in a diskgroup
11.2.0.3.915996344ORA-600 [kffbAddBlk04] creating files in ASM
11.2.0.3.812748538Onlining Disks in 11.2 ASM Can Cause 10.2 DB Clients to Fail
13483354ORA-7445 [kfkrqDump] in ASM dumping PROCESSSTATE
14003090ORA-4031 with high memory utilization in the 'init_heap_kfsg' subheap / "ASM map headers" under 'init_heap_kfsg'
14523004ASM hang during database drop operation if control files are located on ASM
11.2.0.3.71446706111.2 fixes for bug 10621169 are incomplete - replacement fix
11.2.0.3.616231699Adding a new disk on ODA appliance hits ORA-600 [kfgpset3]
16299830ORA-15072 from CREATE DISKGROUP on ODA
16382353Query against v$asm_attribute produces ORA-600 [kfexvContentCb0]
11.2.0.3.512857027Drop directory in asmcmd fails with ORA-600[kfaDelTree00]
13448206Many alert messages "NOTE: attempting voting file .." in RAC with ASM
13559697EIntegrate ASM with OAK lib
11.2.0.3.413476583After rebalance a disk goes offline in multi-node ASM
11.2.0.3.19703627ASMCMD alert log created with wrong ownership
12620823ASM file creation may take a long time to detect it is out of space
12797765ASM background tasks may hang / not complete
12905058Rare ASM corruption after disk resync
12938841ORA-600 [kfgUseNum01] from concurrent diskgroup dismount and disk add in ASM
12950644ASM instance crash due to ORA-7445 [kfdGlobalOpen] in RBAL


Buffer Cache Management

11.2.0.3.1520777150Fix for bug 20777150
11.2.0.3.1219259446ORA-600[kcbo_switch_cq_1] during force undo CR generation in RAC
11.2.0.3.1112747740Node join reconfiguration does not scale with more LMS's
13839336ORA-600 [kjblreplvalid:!replay] / instance crash in RAC
15901852LMS waits too long for 'SGA: allocation forcing component growth' with Flash Cache on
17767676ORA-600 [kcbchg1_28] possible on temporary ASSM segment
11.2.0.3.914121009EManagement, Security and Monitoring of Database SCN
14497307ORA-600 [ktsbifmt:clschk_kcbnew_14] can occur
15883525ORA-600 [kcbo_switch_cq_1] can occur causing an instance crash
17437634ORA-1578 or ORA-600 [6856] transient in-memory corruption on TEMP segment during transaction recovery / ROLLBACK (eg: after Ctrl-C) - superseded
17752121+EORA-600 [kclchkblkdma_3] ORA-600 [3020] RAC diagnostic/fix to avoid a block being modified in Shared Mode and prevent corruption - Superseded
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 - superseded
11.2.0.3.814791477Instance eviction in RAC due to lock element shortage (Pseudo Reconfiguration reason 3)
11.2.0.3.715869211ORA-600 [kclfwrite1_2] cause DBWR to crash the database
11.2.0.3.613098318ORA-600 [6856] on interrupt / kill using a global temporary table - superseded
11.2.0.3.513038684Per process Async IO Max limit is reached very quickly in processes
13534412ORA-600 [kclchkblkdma_3] can occur in RAC crashing the instance
13807411ORA-600 [kcbchg1_38] using XA in RAC
11.2.0.3.413397104Instance crash with ORA-600 [kjblpkeydrmqscchk:pkey] or similar - superseded
14409183ORA-600 [kjblpkeydrmqscchk:pkey] or similar / session hangs on "gc buffer busy acquire"
11.2.0.3.313457582ora-600 [kclantilock_8]
13467683+Join of temp and permanent tables in RAC might cause corruption of permanent table. Regression by bug 10352368
13916709Fix for bug 13916709
11.2.0.3.212919564ORA-600 [ktbesc_plugged] executing SQL against a Plugged in (transported) tablespace
13503598Fix for bug 13503598
11.2.0.3.112748240Fix for bug 12748240
12780098Fix for bug 12780098


Enterprise Manager Database Control

11.2.0.3.1520004021Fix for bug 20004021
20004087Fix for bug 20004087
20334344Fix for bug 20334344
11.2.0.3.1218673304Fix for bug 18673304
18673325Fix for bug 18673325
18673342Fix for bug 18673342
19211724Fix for bug 19211724
11.2.0.3.816344758Fix for bug 16344758
16710324Fix for bug 16710324
16710363Fix for bug 16710363
11.2.0.3.716279211Fix for bug 16279211
16279401Fix for bug 16279401
11.2.0.3.614273397Fix for bug 14273397
14459552Fix for bug 14459552
11.2.0.3.514023636Fix for bug 14023636
14205448Fix for bug 14205448
14258925Fix for bug 14258925
14262913Fix for bug 14262913
14263036Fix for bug 14263036
14263073Fix for bug 14263073
14469008Fix for bug 14469008
14546575Fix for bug 14546575
14546638Fix for bug 14546638
14546673Fix for bug 14546673


Generic

11.2.0.3.125144934Wrong oereof value returned when error occurs in a batch - can cause ORA-600
9163477error ora-39726 while dropping column on compressed partitioned table
9812682ORA-600 [qkebCreateConstantOpn1] from DML on table with optimized added column
11732473flashback query which passes scn value via bind variable fails with ora-8181
12320556High version count for child cursors referencing a remote object due to AUTH_CHECK_MISMATCH - superseded
12411746RAC waits for "library cache pin" do not time out (do not trigger ORA-4021)
12591399ORA-600[qesmagetpamr-nullctx] / ORA-14091 with distributed query with local partition table
12596444Cursor not shared with CURSOR_SHARING if SQL has a CASE expression or set operation (UNION)
14799269Information in V$SQL/V$SQLAREA are incorrect once _CURSOR_OBSOLETE_THRESHOLD is reached
16505333ORA-38802 from CREATE TABLE in Editioned environment
16710753Excess shared pool memory use / ORA-4031 from DROP EDITION
17050888ORA-600 compiling object in Edition after dropping covered objects - superseded
11.2.0.3.117276499ORA-1400 raised when bind variables are not bound as expected
12940637MERGE statement consumes high CPU in 11.2
13066936Instance does not register services when scan fails over
13429702ORA-7445 [kgidlt] during shutdown after running utlrp.sql
13849733ORA-600 [15574] / ORA-7445 on parallel query with MAX/MIN of a constant virtual column expression
13931044ORA-600 [13009] / ORA-600 [13030] with Nested Loop Batching
14123213ORA-942 using LOB through Editioned View across schema boundary
14237793ORA-7445 [kqlr_get_diana_ts] using Editioned objects
14489591ORA-3137 [3149] on server due to bad bind attempt in client
14609690ORA-600 [qks3tInit] from Parallel Query on ADG
16929165ORA-900 / ORA-4045 compiling PLSQL if error position > 32767
11.2.0.3.1010359307High number of sleeps for the "kokc descriptor allocation" latch
12797620High gets on "kokc descriptor allocation latch" with high users
12813641ORA-14403 on select with WITH clause and concurrent partition DDL
13146182ORA-1499 ORA-8102 ORA-600 [kdsgrp1] Bitmap Index / Table mismatch
13259364CLOB -> string conversion errors for NULLs with UPI client
13839641Wrong entries for description column in DBA_TRIGGERS using synonyms
13853126Dispatchers/new PQ slaves can get mutex with same session id - SGA memory corruption - superseded
14052871Resource Manager SWITCH_FOR_CALL switches plans sooner than expected
14158012Orphan rows in SNAP_LOGDEP$ causes ORA-600 [kkzlpllg:5]
16101465Incorrect data in DBA_TRIGGER_COLS with editioning
17468141ORA-7445 [kglobcl] with client side PLSQL (such as Forms)
11.2.0.3.912571991Wrong ORA-14403 raised by SELECT FOR UPDATE SKIP LOCKED - superseded
13369579dump on evaopn3 with function base index and ORDER BY
14207902Select query fails with ORA-600[qkebCreateConstantOpn1]
14230270ORA-976 in 11.2.0.3 on query with ANSI join that ran successfully in 11.2.0.2
14637368ORA-7445 from INDEX SKIP SCAN on IOT
16019955Improved fix for bug 14633213 to avoid errors during tablespace transport
16944698Parallel Query running from SYSDBA raises ORA-1031
11.2.0.3.89547706Logical corruption with triggers and foreign key constraints
12621588ORA-7445 [koksOpnHasObjWTempLob2] from query containing lots of ANSI joins
12755231Assorted Dumps when querying V$MUTEX_SLEEP
12815057ORA-600/ORA-7445/ UGA memory corruptions using PLSQL callouts (such as SYS_CONTEXT)
13040943Drop Materialized View log fails to clear out SYS.SNAP_LOADERTIME$ dependencies
13060271ORA-600 [qesmaInitMetadataCtx-thisCtxP1] from DML on partitioned table
13092220Using DRCP creates trace files containing "kppslFixUpSession : setting edition..." entries
13642044Orphan rows in MV metadata can cause ORA-32422 on DBMS_REDEFINITION.start_redef_table
13686047Unexpected ORA-1427 error with single row subquery
13945708Attempts to drop views in old Editions results in ORA-4063
14007968MV refresh slow with many rows in MV log
14095982"latch free" waits when result cache is used
14191508Slow row cache load due to SEG$ and INDSUBPART$ queries
14198511MV log not purged when ON DEMAND and ON COMMIT MV exists on same table
14751895False ORA-6508 errors in Editioned environment
16024441Dictionary corruption when invalidating Editioned synonym
17230530ORA-600 [kkzqid2fro] after apply 11.2.0.3.7 DB PSU
17332800Wrong results with IOTs and fix of bug 13705338 present
11.2.0.3.711071989View invalidated when adding columns to base table with functional index
12395918ORA-7445 [kkscsAddChildNode] / ORA-7445 [kksfbc] during stress testing
12974860ORA-600[qkeIsExprReferenced1] with projection_pushdown
13493847ORA-600 [15709] can occur with Parallel Query
13579992Creation of in memory temporary table produces too much recursive SQL
13790109Refresh produces wrong results for ON-COMMIT MV in specific case
13814739Excessive KQR X PO" allocations in a RAC environment (can cause ORA-4031)
13855490PGA memory leak by CJQ in RAC environment
13857111ORA-600 [15709] trace produces very large systemstate trace
13923995ORA-14403 from CREATE TABLE as SELECT operation against a partitioned table
14053457ORA-917 parsing SQL with indicator binds with CURSOR_SHARING - superseded
14127231dbms_shared_pool.purge raised ora-6570 on obsoleted child cursors
14207317"latch: row cache objects" latch contention for LANGUAGE_MISMATCH cursors with VPD policies
14398795ORA-7445 [evakdustoopn] on delete from table with add column optimization
14512189ORA-12008 / "ORA-1426 numeric overflow" on MV refresh
14668670+Wrong results when execution plan shows nested loop batching
16530565Self deadlock in 'library cache pin' in a function using type and Edition
11.2.0.3.68547978Online redefinition corrupts dictionary / ORA-600[kqd-objerror$] from DROP USER
10242202ora-22992 when creating materialized view with remote lob column
13496884ORA-600 [qcsfbdnp:1] from Merge Statement with Bind Variables
13582702ORA-600 [kkmmctbf:bad intcoln] from DELETE with FK constraints and compound trigger
13584130ORA-7445 compiling library unit with _LOAD_WITHOUT_COMPILE in non-base Edition
13616375ORA-600 [qkaffsindex5] on a query with ORDER BY DESC and functional index on DESC column from SQL tuning index advisor job
13786142+Cannot drop/replace trigger in editioning environment
13810393Deadlock waiting for 'library cache: mutex x' while producing an ORA-4031 diagnostic dump
13812031Wrong results /ORA-600 from query/DML on partitioned table
13860201Dump on kkspbd0
13911821ORA-7445 [kksLockDelete] then Instance crash from PMON
14110275ORA-600 / ORA-7445 from parse of query with table that has undergone ADD COLUMN optimization
14226599Increase dc_rollback_segs hash buckets to reduce 'latch: row cache objects' waits
14644185Part of fix 12531263 missing from 11.2.0.3 - disabled deadlock detection for Cursor build locks (on $BUILD$)
16175381Process spin in kkscsSearchChildList() -> kkshGetNextChild() with fix for bug 14613900 present
16344871Wrong results / Mismatch in cursor shareability with VPD/RLS policy with fix 13080778 present
11.2.0.3.510263668ORA-600 [kokegPinLob1] selecting a CLOB
12345082ORA-600 [kkzgbtcols] creating materialized view on table with Object / UROWID / BFILE types
12791981ORA-4030 due to "KGL Iterator information"
12873183Wrong results from query with ROWNUM on partitioned table
12964067DBMS_REDEFINITION fails with ORA-600 [kkzucmvl_ChkMVLog: kkzlglnm]
13011409ORA-600 [kglLock-bad-byd] can occur
13026410Select against V$ACCESS / V$OPEN_CURSORS fails with ORA-4029
13454210BUILD lock is not released on error ('library cache lock' waits)
13524899Creation of Cursor-Duration in-memory temporary table produces too much recursive SQL
13645875ORA-7445[qerixFetchFastFullScan] on update of IOT with secondary index
13719081Upgrade invalidate of views is slow in utlrvw.sql
13936424SELECT FOR UPDATE not returning values for added column with NOT NULL and default value
14040433Cursors not shared due to DIFF_CALL_DURN even though they should share
14052474Wrong Results with NULLIF using constants in JOINs
11.2.0.3.412693626High CPU use for select on INTERVAL partitioned table
12971775OERI:[ktsircinfo_num1] with concurrent parallel DML and online index creation
13059165UTLRP does not report the correct number of "OBJECTS WITH ERRORS"
13080778ORA-942 / ORA-1031 / corruption for SQL using same object name in multiple schemas - superseded
13099577ora-12801 and ORA-1460 with parallel query
13250244Shared pool leak of "KGLHD" memory when using multiple subpools
13358781dba_hist_sqlstat.ccwait_delta is zero always
13384182ORA-600 [delrow:iot1] from DELETE or MERGE..DELETE with an IOT
13550185+Hang / SGA memory corruption / ORA-7445 [kglic0] when using multiple shared pool subpools - superseded
13566938ORA-600 [kcbgtcr_1] / ORA-600 [kkpo_rcinfo_defstg:objnotfound] / ORA-600 [25027] against a Partitioned Table during Dynamic Sampling
13572659DBMS_REDEFINITION disables Foreign Keys used for REFERENCE partitioning
13705338Wrong results / ORA-7445 on IOT secondary index - superseded
14076523ORA-600 [kgxRelease-bad-holder] can occur in rare cases
14613900ORA-7445 [kkscsSearchChildList] with fix of bug 12976376 present - superseded
11.2.0.3.39761357ORA-600 [qkeisexprreferenced1] using pseudo-columns on DUAL/X$ tables
12535346ORA-7445 [kxccexi] using referential integrity constraints with deferred segments or interval partitions
12617123ORA-1 on SYS.I_TABPART_BOPART$ When Doing SPLIT SUBPARTITION on Table with a Child Reference-Partitioned Table
12646784ALTER TABLE fails with ORA-600 [kkpoffoc] for ADD column
12658411Large result cache can cause sessions to spin / instance to hang
12678920ORA-7445 [kkpobifd_build_idx_frag_descrs] on ALTER TABLE ... split partition ...
12797420"library cache: mutex X" waits on DB instance handle with CURSOR_SHARING
12913474Disabled invalid table trigger can still block DML with Editions (ORA-4098)
12976376High VERSION_COUNT for SQL with binds, including recursive dictionary SQL - superseded
13035360Unexpected ORA-2303 creating a TYPE in a child Edition - superseded
13370330ORA-600 [qkeIsExprReferenced1] From Query With Virtual Column
13419660DBMS_REDEFINITION can leak memory due to not sharing package state correctly
13502183Valid package body in child Edition marked as INVALID during UTL_RECOMP
13588248"library cache: mutex X" contention for objects with very many library cache locks
13657605ORA-600 [kkzgbtcols] creating a BUILD DEFERRED materialized view with ROWID involving a database link
11.2.0.3.210350832DBMS_REDEFINITION.FINISH_REDEF_TABLE can take a while as it waits for DML X lock NOWAIT repeatedly
11063191ORA-4031 with hint /*+ CURSOR_SHARING_EXACT */ - excessive "KKSSP^nn" memory
11877623ORA-600 [17273] from rename of a TRIGGER
12612118ORA-7445 [qsmqbtss_build_table_inlineview_subordsets] during MV creation or during compilation
12764337ORA-7445 [kgldtin] can occur with stale SYNONYM pointer in library cache
12780983Unable to actualize objects into child Edition - ORA-955 - superseded
12845115ORA-4020 / deadlock dropping a materialized view
12849688Export / Import of a Materialized View log gives corrupt including / excluding New Values option
12960925ORA-932 on OCIStmtExecute after online redefinition of LONG to CLOB column
13070939ORA-1790 from DESCRIBE of query with a SET operation and a BIND in the select list
13332439UTL_RECOMP.RECOMP_PARALLEL can deadlock in an Editioned environment
11.2.0.3.19873405IORA-600 [21028] during fast refresh after upgrade


High Availability

11.2.0.3.1521146680ORA-600 [kjccqmg:esm] in CTWR during reconfiguration
11.2.0.3.1413840711ORA-353 in Standby / Streams Data Capture or ORA-272 in PRIMARY: Redo log corruption by ASYNC redo shipping
11.2.0.3.1311883252ERedo transport streaming not supported with all mixed version configurations
15856660Sending redo logs from 11.2 to a 12.1 OAM gets error 16047 (DGID mismatch).
16923127Standard Edition Primary is unable to ship redo to AvM
11.2.0.3.1210182005ORA-600 [krbrrd_krbrddo_fails] or ORA-19599 Small compressed backups fail to restore
10256843Hang manager may trigger unnecessary SYSTEMSTATE dumps on ASM instance
12588237RMAN-3002 ORA-1: unique constraint (ckp_u1) violated after dataguard switchover
14182835Process fails with ORA-600 [kjbrchkpkeywait:timeout]
19517437ORA-600 [kjbmmchkinteg:from] or ORA-600 [kjblpcm:nd] on RAC if fix 14558880 present
11.2.0.3.1113503204instance evictions during reconfiguration when disk mirroring is used for control files
13736413ORA-600 [krfw_enforce_min_format_2] in RVWR with Flashback
13794550Redo missing for ALLKEYS_ON supplementally logged columns
14193240ORA-600[KGHLKREM1] from LMS in RAC
14558880Excessive latch gets during DRM in RAC
14588746ORA-600 [kjbmprlst:shadow] in LMS in RAC - crashes the instance
16088176RAC hang / LMD crashes instance with ORA-600[kjmscndscq:timeout]
11.2.0.3.1012977562Capture dies with ORA-1346 after source database fails over to standby or hangs after OPEN RESETLOGS
13719292Logminer slow during database upgrade - calling dictionary build twice
13912931Logical standby lag increases over time
14098509Infinite reconfiguration timeout in RAC
16747736LogMiner memory leak / ORA-1341 "logminer out-of-memory"
11.2.0.3.912898558"V$FS_FAILOVER_STATS" not updated until all bystanders have started apply
13042639LMS hangs with "SGA: allocation forcing component growth" wait event when auto SGA tuning is enabled
13553883EArchiver stuck but no ORA-19xxx error in alert log (messages need changing)
13890080RAC crash due to ORA-600 [kjbrclo:gq]
14222403ORA-600 [kjbrsrping:sc] with patch 14043417
16563678Excessive 'kjmvalidate: drop an invalid old message' messages in RAC during reconfiguration
16844448ORA-600 [3020] after flashback database in a RAC
16850197Instance crash due to ORA-600 [kjruch:resp] with fix for bug 13602883 present - superseded
11.2.0.3.811868640ORA-600 [kjucvl:!busy] possible in PMON in RAC
12312133Standby DB crashes with ORA-600 [krcccb_busy] /Ora-00600 [krccckp_scn] with block change tracking
12744759DIA0 process fails with "Fail to allocate buffer due to incompletion of previous mcpy"
12865902NOWAIT lock requests could hang (like Parallel Queries may hang "enq: TS - contention") in RAC
13591624Apply proces stops with ORA-1918 "user 'xx' does not exist"
13843646Long latch wait on "gcs resource validate list" with many LMS processes
14351566ORA-600 [kclchkblk_4] ORA-600 [2662] when doing flash back
15910002RAC Instance is terminated by ORA-600 [kjbrupdwr:wr3]
11.2.0.3.79095696"log file sync" wait time spikes with ARCHIVE_LAG_TARGET set
13489024ORA-600 [kccugg_end] if error occurs during archival
13724193ORA-1089 over database link involving transitioned primary
11.2.0.3.69706792ORA-600 [kcrpdv_noent] during STARTUP in Crash Recovery with Parallelism
11715084EActive duplicate should work when connected to Standby as source DB
12983611ORA-600 [krsw_redo_complete.1] can occur (rare)
13632809RMAN BZ2 compression backup hangs
13680405PGA consumption keeps growing in DIA0 process
14088346LMS crashes with ORA-600 [kjbrwrdone:sc3]
11.2.0.3.512959852RAC instance crash due to ORA-600[kjbrscping:slsend] in LMS
13399435RAC instance eviction due to "TIMEOUT in DRM FREEZE step" or "SYNC TIMEOUT ..."
13593999RAC Instance eviction during dynamic remastering or cluster reconfiguration.
13645917+PMON block recovery loop - instance hang
13685544Starting up instance may be evicted in RAC
13732226RAC node eviction dur to "TIMEOUT in DRM FREEZE step" or "SYNC TIMEOUT"
11.2.0.3.412794305ORA-600 [krsr_pic_complete.8] on standby database
13377816Excessive memory use by DIAG / DIA0
13385346GCR0 trace files continuously created with "kjgcr_DeleteSO" message
13718279DB instance terminated due to ORA-29770 in RAC
13737746Recovery fails with ORA-600 [krr_assemble_cv_12] or ORA-600[krr_assemble_cv_3]
11.2.0.3.310133521Logical Standby Apply stops for some NLS_SORT values (ORA-26674)
12879027LMON gets stuck in DRM quiesce causing intermittent pseudo reconfiguration
13366202DBNEWID [ nid ] does not allow TARGET=/ (NID-106)
11.2.0.3.212829021Switchover fails with ORA-1093
12894807ORA-16000 from SELECT FOR UPDATE with database link on Active Data Guard
11.2.0.3.112718090ORA-600 [kclchkblk_3] can occur in RAC
12834027ORA-600 [kjbmprlst:shadow] / ORA-600 [kjbrasr:pkey] with RAC read mostly locking
12847466RAC hang with waits 'gc current request'<='gc buffer busy acquire'
12861463RAC node join reconfiguration slow due to default affinity lock optimization
12917230Query with temp table transformation runs slow in RAC
12998795RAC hang with signature 'gc current request'<='gc buffer busy acquire'
13035804RAC DLM pseudo reconfiguration needs textual reasons
13554409Fix for bug 13554409
17470495ORA-600 [kjbmmchkinteg:from] on RAC


Oracle Internet Directory

11.2.0.3.812784406SSL connection fails with LDAP Java SDK when used with IBM JDK


Oracle JVM

11.2.0.3.1319827973ORA-600 [psd_validate:argc] during upgrade from 11.2 with October 2014 DB PSU (or equivalent) installed
11.2.0.3.1219289642Fix for bug 19289642
19638161postdeinstall.sql of DB PSU for Oracle JavaVM fails with ORA-29537


Oracle Multimedia

11.2.0.3.1218262334ProcessCopy to JPEG image fails for index color image
11.2.0.3.916338983"com.sun.image.codec.jpeg.ImageFormatException: JPEG lib error"


Oracle Net Services

11.2.0.3.1112985237Internal fix to support a reconnect option for nsgr
11.2.0.3.716694777Diagnostic enhancement to support dynamic network trace at process level
11.2.0.3.614841558Fix for bug 14841558
11.2.0.3.312880299TCP handlers block if listener registration is restricted to IPC with COST


Oracle OLAP

11.2.0.3.1520558005Fix for bug 20558005
11.2.0.3.1319309466Fix for bug 19309466


Oracle Secure Files

11.2.0.3.1112614359ORA-600 [kssdel: bad live] using Securefile
11.2.0.3.914343501ORA-22294 during copy of a Securefile
11.2.0.3.89397635ORA-600 [koklcpb2c-read_src2] or ORA-22294 from DBMS_LOB.CONVERTTOCLOB
11.2.0.3.715841373ORA-600 with fix for bug 14500723 present


Oracle Security

11.2.0.3.1113866372ORA-1017 while connecting as SYSDBA with enterprise users
13918644ORA-7445 with AUDIT_SYS_OPERATIONS=true on create Text index
18325460EXEMPT ACCESS POLICY not working correctly in RAC
11.2.0.3.1014508968ORA-600 [504] [ges process parent latch] during logon in RAC
11.2.0.3.914369664Spin with multibyte bind variable and AUDIT_TRAIL='XML','EXTENDED'
14488943ORA-9925 can occur writing audit if ORACLE_PATH is set
11.2.0.3.813723052ORA-7445 [kglbrk] / ORA-600 using multiple DBMS contexts
13834065ORA-7445 [kzaSysAudit] with auditing (AUDIT_SYS_OPERATIONS)
14189694ORA-600 [kzaxgchr:lxgcnv] on select from XML audit with multibyte characterset
14695377Wrong values in V$XML_AUDIT_TRAIL.COMMENT_TEXT (and possibly other columns)
11.2.0.3.712772404Significant "row cache objects" latch contention when using VPD - superseded
13848402Querying V$XML_AUDIT_TRAIL fails with ORA-600[kzaxgclob:lxgcnv1]
11.2.0.3.411708510ORA-28267 from JDBC issuing SQL over DB link to 10g DB ( relates to E2E_CONTEXT namespace)
11.2.0.3.311840910ORA-604/ORA-3212 during startup by SYSOPER
13340388ORA-600 [kzaxpopr14 -Error in decoding xml text] when querying V$XML_AUDIT_TRAIL
11.2.0.3.212923168ORA-28112 using mixed case identifiers for RLS policy function
13036331ORA-1031 "insufficient privileges" when granting privileges


Oracle Security Service

11.2.0.3.1017865671Fix for bug 17865671
11.2.0.3.91684408611g Database cannot be started with a 12c Clusterware
11.2.0.3.812796518Fix for bug 12796518
16212405Fix for bug 16212405


Oracle Space management

11.2.0.3.1213871316Wnnn space background process may be periodically CPU bound
15826962High "reliable message" wait due to "RBR channel"
11.2.0.3.1113366199ORA-600 [4097] or [ktugin_cr:1] after plugging a Transportable Tablespace with Securefiles
13840704ORA-12012 / ORA-6502 from Segment Advisor (DBMS_SPACE/DBMS_ADVISOR) for LOB segments
11.2.0.3.913737888Online DDL gets ORA-600[kghstack_underflow_internal_3]
13916549ORA-600 [ktspsrch_addl1-max] can occur with ASSM
14318397Deadlock between ALTER TABLE ... SHRINK SPACE and concurrent SELECT
14383007Sort runs out of temp space in RAC even when temp space is available
16347904Corrupt block with check code 6101, 6110 or 6255 on compressed table with DML workload
16761566Instance fails to start with ORA-600 [4000] [usn#]
11.2.0.3.813440516Index skip scan cannot be interrupted - can block shutdown
13725395ORA-600 [kdzhFindHeadPiece: unnewed > 1] from load into HCC table
13972394Unnecessary segment header block re-reading during select with concurrent DML (GC buffer busy waits)
14393728Bad supplemental redo for UPDATE / Streams capture aborts with ORA-600 [knglcflassert], [2751]
14755945Insert into compressed table spins
14762511EExcessive buffer gets by UPDATE on OLTP compressed table
11.2.0.3.712731940Analyze fails with ORA-600 [kghfrh:ds] / ORA-600 [17147] / ORA-1499
12755116ORA-959 after DEFAULT tablespace of schema dropped / renamed
12940620Cached block/extent counts in SEG$ not updated after ADD extent
13063120Inserts of chained rows to COMPRESSed table do unnecessary single block reads
14301592Several errors by corrupt blocks shifted by 2 bytes in buffer cache during recovery caused by INDEX redo apply
11.2.0.3.613910420ORA-8103 during insert / update of basicfile LOB in assm segment using space search cache
13913630INSERT ... SELECT does not compress some rows
13958038Abnormal segment growth with unformatted blocks when using space search cache
14176879Extensive growth of Securefiles segments undergoing updates
14207163ORA-17503 from create EHCC tablespace on ZFS
14472647Wrong results on IOT secondary index after DML
14589750TRUNCATE table hangs in RAC with "reliable message" wait if fix 14144283 present
11.2.0.3.59659614Large trace file for ORA-8103
13544396Corruption / ORA-600 after ALTER TABLE of a LONG to CLOB
11.2.0.3.412583611Excessive TX enqueue contention with heavy Securefile insert workload on RAC
13464002ORA-600 [kcbchg1_12] or ORA-600 [kdifind:kcbget_24]
13649031ORA-10637 occurs on SHRINK of a partitioned table with deferred segments
13773133ORA-600 [ktsflmerge-cycle-1] during inserts into freelist managed segment
11.2.0.3.312401111ORA-600 [kdliXfmCheck]
13103913ORA-600 [25027] [ts#] [1] or false ORA-1 during dml while index is being rebuilt online
13326736*Dictionary corruption / ORA-959 due to DROP TABLESPACE. This bug is alerted in Note:1390632.1
13981051ORA-7445 [tbsafl] creating a tablespace with compression - superseded
11.2.0.3.212582664Deduplication attribute used in "Create table" statement does not compress as compared to usage with "Alter table"
12588744securefile waste storage when specify initial extent
12656535ORA-1555 / unexpected space use for partitioned Securefile Lob
12662040Securefile LOB segment keeps growing even when segment has free space
11.2.0.3.113041324EEnhancement to allow HCC on ZFS and Pillar Storage - superseded
13492735It is possible to add a non-HCC datafile to an HCC tablespace


Oracle Streams

11.2.0.3.1114138823Propagation receiver slow between 10.2 and 11.2 databases
11.2.0.3.1012905053Capture process creates LCR with NULL value when table is compressed / cannot mine redo
13499412Logminer raises OERI:krvxruts004 / GoldenGate raises ORA-26914
13783957Streams apply fails with ORA-7445 [knalspSpillLcr]
13853654required_checkpoint_scn not moving forward due to parallel dml
13878246Streams rule conditions like get_command_type() = 'delete' do not work
11.2.0.3.513787482CDC purge routine invalidating custom indexes
11.2.0.3.412594032Call Memory corruption / ORA-600 [17114] with CDC


Oracle Transaction Management

11.2.0.3.1212595606Intermittent ORA-7445 [k2sibg] using XA in RAC
11.2.0.3.1112945879VERSIONS query with a non constant start SCN includes rows after the barrier SCN
15931756ORA-4031 / Queries against SYS_FBA_TRACKEDTABLES not shared (do not use binds)
17165204Self deadlock while updating HCC compressed tables
11.2.0.3.1014774091ORA-1466 in read only transaction after upgrade from 9i
11.2.0.3.913065099xa_commit() returns XA_RBROLLBACK but prepared transaction remains on server
13780035Updated fix for bug 13340182 to address additional ORA-7445
11.2.0.3.813605839*ORA-600 [ktbsdp1] ORA-600 [kghfrempty:ds]. Corruption in Rollback with Clusterwide Global Transactions in RAC. This bug is alerted in Note:1527740.1
11.2.0.3.712912137Instance crashed by SMON with ORA-600[4032] for distributed transaction
13907462ORA-7445 [ktcn_find_ObjInv] can occur
11.2.0.3.514138130SGA memory corruption / ORA-7445 when modifying uncompressed blocks of an HCC-compressed segment
15853081Slow DML when HCC has initrans=255
11.2.0.3.413430938ORA-4031 with high "KTC latch subh" memory usage
11.2.0.3.313903046DML raises ora-600 [4417] on hcc compressed table - superseded


Oracle Utilities

11.2.0.3.1013424216ORA-2372 / ORA-26093 ORA/-2374 during datapump import
11.2.0.3.39858539Data pump import fails for logon trigger with "ORA-4072 invalid trigger type"
13001379*Datapump transport_tablespaces produces wrong dictionary metadata causing errors like ORA-7445 [qeaeMinmax] / ORA-1858 etc.... This bug is alerted in Note 1440203.1


Oracle Virtual Operating System Services

11.2.0.3.1213647945DNFS batch size needs to be managed to avoid overwhelming the server
11.2.0.3.1114657740ORA-600 [510] ... [cache buffers chains]
11.2.0.3.910625145EDBMS_RESOURCE_MANAGER.SWITCH_CONSUMER_GROUP_FOR_SESS does not accept CANCEL_SQL
12391034ORA-7445 [kgnfsgetmnthdl] during RMAN backup to NFS mount
13043012"Direct NFS: .. PING timeout" messages
13551402High "log file parallel write" and "log file sync" after upgrading 11.2 with Veritas/Symantec ODM
15987992Hangs in read workloads using Driect NFS with multipath configs
16038929Direct NFS breaks down multiblock reads causing performance degradation
11.2.0.3.812821418Direct NFS appears to be sending zero length windows to storage device. It may also cause Lost Writes
13072654Unnecessary ORA-4031 for "large pool","PX msg pool" from PQ slaves
14128555Database hang due to Direct NFS ping timeouts
14188650ORA-15287 setting ASM "storage.type" to "zfssa"
11.2.0.3.77509451SGA memory leak possible for "KSN WaitID" memory when using shared servers
12925089ORA-600 [ksxp_rm_check0] can occur on process startup
13427062ORA-308 cannot open archived log when dNFS is enabled
11.2.0.3.613914613Excessive time holding shared pool latch in kghfrunp with auto memory management
11.2.0.3.412585543Slow rman backup / IO Slaves not spawned
11.2.0.3.213354082ACFS replication may fail after ASM instance crash (ORA-27038)
13420224DB crashes during recovery when disk in mirror becomes unavailable
11.2.0.3.113362079HCC compression should not be allowed on dNFS with non ZFS or Pillar


PL/SQL

11.2.0.3.1318440047ORA-600 [kglGetSO-null-parent] while invalidating objects in an Editioned database
18641451Fix for bug 18641451
18641461Fix for bug 18641461
11.2.0.3.1218641419Fix for bug 18641419
11.2.0.3.1116992075Cannot drop package in ancestor Edition if package references a dead DB link
11.2.0.3.910400244PLS-801 [ph2_cly out of bounds in ph2pop] compiling objects
14163397Trigger on editioning view can get ORA-600 [kkmmctbf:bad intcoln]
11.2.0.3.714571027Native compiled files for PL/SQL in 11.2.0.3 are significantly larger than earlier versions
11.2.0.3.413612575ORA-600 [15419] / PLS-801 using REFCURSOR bind with PLSQL
13624984IMPDP or IMP hangs on compilation of PLSQL containing a pipelined function
13804294Internal errors, corruptions, using pipelined function whose rows raise exceptions


Patch Automation

11.2.0.3.1320074391PSU post-deinstallation catbundle returns ORA-20000 / ORU-10027
11.2.0.3.1219727057Internal fix to handle jvmpsu.sql in catbundle.sql
11.2.0.3.913866822catbundle rollback does not update registry$history correctly
17343514Remove Java code from catbundle


Server Manageability

11.2.0.3.1110110625DBSNMP.BSLN_INTERNAL reports ORA-6502 running BSLN_MAINTAIN_STATS_JOB
13834436awrextr.sql extracts too much data
11.2.0.3.1013872868ORA-600[keomnReadGlobalInfoFromStream:magic] from V$SQL_MONITOR
13901201WRH$_SQL_PLAN not purged leading to excessive SYSAUX tablespace growth
11.2.0.3.99797851WRM$_SNAPHOST_DETAILS is never purged
11.2.0.3.413257247AWR Snapshot collection hangs due to slow inserts into WRH$_TEMPSTATXS.
13699124AWR Compare Period takes a long time to generate
11.2.0.3.313338048ORA-1476 while outputting the AWR report
13527323ORA-6502 generating HTML AWR report using awrrpt.sql in Multibyte characterset database


Workspace Manager

11.2.0.3.1319006849Fix for bug 19006849
11.2.0.3.614220725Fix for bug 14220725
16368108ORA-955 from Workspace Manager script owmv1120.plb


XML Utilities

11.2.0.3.1417762296Fix for bug 17762296
11.2.0.3.1319197175Fix for bug 19197175
11.2.0.3.715905421Fix for bug 15905421


XML database

11.2.0.3.1419358317Fix for bug 19358317
11.2.0.3.1113361350ORA-7445 from Xquery with non constant string for namespace
13911711No element tag for an inner xmlagg(xmlelement(xmlforest()))
14406648Binary XML storage returns wrong results with multiple namespaces
14781609XMLType.getclobval() returns a temporary lob when a persistent LOB is expected
16048375LOB descriptor leak doing XMLserialize
11.2.0.3.1013477790ORA-7445 [kghalo] / memory errors / ORA-4030 from XMLForest / XMLElement
13596581Slow XML query parse / first DBMS_SQLTUNE.report_sql_monitor may be slow
16272008ORA-4030 (qmcxdDecodeIni,qmemNextBuf:Large Alloc) using INSERTCHILDXML


Miscellaneous Issues

11.2.0.3.1516872333Fix for bug 16872333
19699191Fix for bug 19699191
20331945Fix for bug 20331945
20657441Fix for bug 20657441
11.2.0.3.1414692762Some patch scripts required DV to be disabled
19915271Fix for bug 19915271
20296213Make jox_on fails with error after applying PSU
11.2.0.3.1318436647Fix for bug 18436647
11.2.0.3.1216524926ORA-1031 from LOB writes in stored Java (JDBC KPRB) in definers rights
19458377Internal check to ensure compatibility of "Oracle JavaVM Component Database PSU" patches
19554106Internal fix required to support "Database PSU for Oracle JavaVM Component" Patches
11.2.0.3.1118096714Fix for bug 18096714
11.2.0.3.1017716305Fix for bug 17716305
17721717Fix for bug 17721717
11.2.0.3.913944971Fix for bug 13944971
16450169Fix for bug 16450169
16462834Fix for bug 16462834
16721594Fix for bug 16721594
16864562Fix for bug 16864562
17019974Fix for bug 17019974
17088068Fix for bug 17088068
11.2.0.3.816362358Fix for bug 16362358
16372203Fix for bug 16372203
11.2.0.3.76690853Fix for bug 6690853
13015379Fix for bug 13015379
13561750Fix for bug 13561750
13791364Fix for bug 13791364
16014985Fix for bug 16014985
16306019Fix for bug 16306019
16382448Fix for bug 16382448
16703112Fix for bug 16703112
11.2.0.3.613561951Fix for bug 13561951
13596521Fix for bug 13596521
14841812Fix for bug 14841812
11.2.0.3.514035825Fix for bug 14035825

weixin_42519572
关注
  • 36
    点赞
  • 踩
  • 33
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Oracle 10g客户端v10.2.0.3.0中文精简版(支持32 x64位).rar
09-05
软件介绍: Oracle 10g客户端v10.2.0.3.0 64位/32位是一款非常好用且功能强大的主要用于oracle数据库的开发和编辑等操作的软件，这个精简版本从官方的oracle客户端中提取，软件解压后就可以运行，操作方法也比较简单，可以直接连接oracle服务器进行数据库的浏览、编辑和导出等操作，非常方便。加入了sqlplus，支持命令行输入数据库操作。 修正了SQLplus 启动不正确问题。注意：如果是第一次运行本程序请重启计算机，否则程序显示的汉字为乱码或问号。
Oracle_10.2.0.3.zip
02-24
Oracle_10.2.0.3.zip
ftpserver使用oracle验证,【实验】使用ftp方法下载Windows版本Oracle 10.2.0.3补丁全记录...
weixin_36455562的博客
04-11 85
230- "Paste the above copied address here in quotes"230-230- For example, the wget command for patch# 6880880, for Linux Platform230-230- wget -http-user=john.doe@oracle.com -http-password=xxxxxx...
oracle database 9i/10g/11g 及补丁（patch）下载地址
Lixora's DB Home
11-12 2302
oracle9i/10g/11g各种下载 以下资源均收集自互联网，非本人主动提供，如若侵权，请留言，本人会尽快删除本文。以下资料仅供个人学习，研究之用，请勿用作商业目的。 把下面的地址复制到讯雷里就可以下载 , 包括了最新的 10.2.0 .5 的补丁 ----------------------------------------------------------------
Oracle 客户端下载
Angel_He的专栏
09-11 2209
Oracle 客户端下载
Oracle驱动包ojdbc6-11.2.0.3
03-01
Oracle驱动包ojdbc6-11.2.0.3 下载
ojdbc6-11.2.0.3.jar下载包.rar
11-23
ojdbc6-11.2.0.3.jar 解压缩即可用
Oracle 11.2.0.3 使用 ADG 搭建Data Guard 案例
04-20
Oracle 11.2.0.3 使用 ADG 搭建Data Guard 案例
Oracle 11G 11.2.0.3 Client for windows 64位
12-13
Oracle 11G 11.2.0.3 Client for windows 64位 确保资源可用。 【下载之后的用户，可留言获取更多下载资源】
oracle 11.2.0.3 最后的GI（包含DB的） PSU补丁（版本.15）：p20996944_112030_Linux-x86-64.zip
01-13
oracle 11.2.0.3 最后的GI（包含DB的） PSU补丁（版本.15） p20996944_112030_Linux-x86-64.zip
oracle 升级 10.2.0.3,oracle--10.2.0.3升级到11.2.0.4
weixin_32307021的博客
04-07 165
一，环境01，待升级的系统升级仅支持10.2.0.2版本之后的系统，如果不是，请把10G升级至高版本！本次实验环境10.2.0.3 02，挂载11G系统03，升级须知1) 做好备份二，DBUA升级升级步骤：在数据库服务器上关闭10.2.0.3数据库监听与数据库创建oracle 11.2.0.3数据库相关环境变量与目录在数据库服务器上安装oracle11.2.0.3数据库软件在orale11.2.0...
Oracle下载地址备忘
hanjiangduzhuo的专栏
03-05 1113
记录一下ORACLE 10gR2的软件下载地址，备用。 下载OTN上的这些软件，你需要一个OTN免费帐号，不过如果通过迅雷进行下载，就不用登陆OTN了：Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit) http://download.oracle...
【课堂练习】
最新发布
JacksonLeo的博客
04-29 311
虽然现代JVM的垃圾回收机制已经非常高效，但是在性能敏感的场合，仍然需要注意对象的创建频率。例如，在SysLogininforMapper中的deleteLogininforByIds方法，如果处理大量ID时，应考虑使用批处理技术，而不是循环单条处理。例如，在SysMenuMapper中的查询方法，如果涉及到复杂的查询条件或者大量数据的查询，应确保SQL语句的优化和索引的使用。异常处理：代码中应该有更明确的异常处理逻辑，比如使用try-catch块捕获可能的异常，并进行适当的处理，如记录日志、回滚事务等。
探秘MySQL主从复制的多种实现方式
todoitbo的博客
04-26 1045
本文将深入探讨MySQL主从复制的多种实现方式，包括基于语句、基于行和混合模式等。无论您是初学者还是有经验的数据库管理员，都能通过本文全面了解MySQL主从复制技术的多样化选择，从而提高数据库的可用性和性能。
SpringCloudAlibaba：2.nacos
m0_63040701的博客
04-26 929
Nacos是阿里巴巴开源的服务注册中心以及配置中心Nacos=注册中心Eureka + 服务配置Config + 服务总线Bus。
ubuntu18源码安装postgresql15.2数据库
04-27 377
由于官方的源只能安装到pg10这个版本，整了好一会没有成功就改为源码安装了。
SpringBoot JPA使用
gochenguowei的博客
04-25 991
是 Spring 框架提供的一个模块，用于简化与关系型数据库的交互和数据访问。它基于JPA（Java Persistence API）标准，并提供了一组易于使用的API和工具，帮助开发人员更轻松地进行数据库操作。通过Spring Data JPA，开发人员可以通过编写简洁的代码来执行常见的 CRUD 操作，同时还支持高级查询、分页、事务管理等功能。它的目标是提供一种更简单、更高效的方式来处理数据库操作，减少开发人员的工作量，并提高应用程序的可维护性和可扩展性。
superset部署与实践
m0_60125201的博客
04-29 641
本博客简要介绍了superset这个BI工具，使用两种方法来部署superset，并简单介绍了superset的使用。
Linux系统安装Redis7（详细版）
weixin_43154319的博客
04-27 840
gcc是linux下的一个编译程序，是C程序的编译工具。GCC(GNU Compiler Collection) 是 GNU(GNU’s Not Unix) 计划提供的编译器家族，它能够支持 C, C++, Objective-C, Fortran, Java 和 Ada 等等程序设计语言前端，同时能够运行在 x86, x86-64, IA-64, PowerPC, SPARC和Alpha 等等几乎目前所有的硬件平台上。
oracle 11.2.0.3 psu15
08-06
Oracle 11.2.0.3 PSU15是Oracle数据库的一个特定版本和补丁集合。这意味着它是版本号为11.2.0.3的Oracle数据库经过了15个补丁的更新。 每个补丁集合都是为了解决Oracle数据库中的已知问题和漏洞，并提供更高的稳定性和性能。PSU（Patch Set Update）是包含这些补丁的发布单位。 Oracle 11.2.0.3是Oracle数据库的一个主要版本，而PSU15是在此版本的基础上安装的第15个补丁集合。这意味着PSU15是在该版本的11.2.0.3之后发布的，它修复了11.2.0.3中已知的一些问题，增强了数据库的安全性和性能。 安装PSU15可以带来多种好处。首先，它会修复先前版本中的已知漏洞和错误，提供更高的可靠性和稳定性。其次，它还提供了性能改进，使数据库能够更高效地处理数据和查询。 另外，安装最新的补丁集合也是数据库安全性的重要方面，因为它能修复已知的漏洞，并阻止潜在的攻击。 总之，Oracle 11.2.0.3 PSU15是Oracle数据库的一个特定版本，其中包含了15个补丁，通过安装和应用这些补丁，可以提高数据库的稳定性、安全性和性能。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值