mysql的rowscn_10.2.0.5PatchSetUpdates-ListofFixesineachPSU(DocID1337394.1)

10.2.0.5 Patch Set Updates - List of Fixes in each PSU (Doc ID

1337394.1)

APPLIES TO:

Oracle

Database - Enterprise Edition - Version 10.2.0.5.0 and

laterOracle Database Cloud Schema Service

- Version N/A and later

Oracle Database Exadata Cloud

Machine - Version N/A and later

Oracle Database Exadata Express

Cloud Service - Version N/A and later

Oracle Cloud Infrastructure -

Database Service - Version N/A and later

Information in this document applies

to any platform.

MAIN

CONTENT

Bugs

fixed in each 10.2.0.5 Patch Set Update

·

Seefor information about Patch Set

Updates

·

Seefor Support Status and Alerts affecting

10.2.0.5 releases.

This document lists the non-security fixes included in each

10.2.0.5 Patch Set Update (PSU). PSU patches are cumulative and so

each PSU includes fixes from all previous PSU patches for the same

Patch Set. eg: 10.2.0.5.3 PSU includes all fixes from the

10.2.0.5.2 and 10.2.0.5.1 PSUs in addition to the fixes added in

10.2.0.5.3

10.2.0.5 Patch Set Update Patches

The table below shows the database Patch Set Update patches

available for 10.2.0.5. Each link takes you to a document with more

information about that specific Patch Set Update, including a list

of fixes added by that particular PSU.

Document

Version

Download link

Included in Windows Bundle

10.2.0.5.12 (Jul 2013) Database Patch Set Update

(PSU)

10.2.0.5 Patch 22

10.2.0.5.11 (Apr 2013) Database Patch Set Update

(PSU)

10.2.0.5 Patch 21

10.2.0.5.10 (Jan 2013) Database Patch Set Update

(PSU)

10.2.0.5 Patch 20

10.2.0.5.9 (Oct 2012) Database Patch Set Update

(PSU)

10.2.0.5 Patch 19

10.2.0.5.8 (Jul 2012) Database Patch Set Update

(PSU)

10.2.0.5 Patch 17

10.2.0.5.7 (Apr 2012) Database Patch Set Update

(PSU)

10.2.0.5 Patch 15

10.2.0.5.6 (Jan 2012) Database Patch Set Update

(PSU)

10.2.0.5 Patch 14

10.2.0.5.5 (Oct 2011) Database Patch Set Update

(PSU)

10.2.0.5 Patch 13

10.2.0.5.4 (Jul 2011) Database Patch Set Update

(PSU)

10.2.0.5 Patch 10

10.2.0.5.3 (Apr 2011) Database Patch Set Update

(PSU)

10.2.0.5 Patch 8

10.2.0.5.2 (Jan 2011) Database Patch Set Update

(PSU)

10.2.0.5 Patch 5

10.2.0.5.1 (Oct 2010) Database Patch Set Update

(PSU)

10.2.0.5 Patch 1

10.2.0.5 Patch Set Update Fixes

The table below lists all of the non-security fixes

included in the latest Patch Set Update.

·

Bugs are listed

by category

·

The version

column indicates the Patch Set Update that a fix was first included

in - the fix is included in that PSU and all subsequent PSU

versions.

·

Each bug number

is hyperlinked to a

·

To see only fixes

added in a particular PSU version please click on the relevant

tracking bug number in the previous section.

Database Control

10.2.0.5.2

Database Control Certificates Expire After 180

Days

10.2.0.5.9

Unix: kfd.o missing from PSU versions 10.2.0.5.6

10.2.0.5.7 and 10.2.0.5.8 - affects ASM

10.2.0.5.6

Diskgroup dismounted when storage cable pulled out

on the other node

10.2.0.5.3

10gr2 instance crash OERI [kffmunlock_3] with 11g

ASM

10.2.0.5.8

Fix for bug 13916709

10.2.0.5.7

RAC hang possible

Fix for bug 12748240

Fix for bug 12780098

Fix for bug 13503598

10.2.0.5.5

"WARNING:Could not increase the asynch I/O limit

..." messages in trace file

10.2.0.5.4

More "direct path read" operations /

OERI:kcblasm_1

10.2.0.5.2

Needless "WARNING:Could not lower the asynch I/O

limit to .. for SQL direct I/O It is set to -1"

messages

10.2.0.5.12

14459552

Fix for bug 14459552

16279211

Fix for bug 16279211

16279401

Fix for bug 16279401

10.2.0.5.10

11856395

For resource manager, switch action should only

list consumer groups in the plan

14023636

Fix for bug 14023636

14205448

Fix for bug 14205448

14258925

Fix for bug 14258925

14469008

Fix for bug 14469008

14546638

Fix for bug 14546638

14546673

Fix for bug 14546673

10.2.0.5.11

ORA-600 [kqlrelod:2] on DDL

10.2.0.5.8

Problem with choosing a child cursor with

binds

Cursors not shared due to DIFF_CALL_DURN even

though they should share

10.2.0.5.7

Dump [kqlchg] intermittently during REFRESH of

MV

Excessive child cursors / high VERSION_COUNT /

OERI:17059 due to bind mismatch

Hang / deadlock between "cursor: pin S wait on X"

and "library cache lock" involving dictionary

objects

Bind related memory corruption / ORA-600 (near

kxs-heap-b heap)

10.2.0.5.6

High shared pool use due to frequent ADD/EXCHANGE

partition operations

PMON dump [koklcom]

Fast split of LIST subpartition with COMPRESS KEY

index produces corrupt index

Shared cursor graduated bind array can become

inconsistent (ORA-1460)

False ORA-54 from concurrent EXCHANGE partitio and

SPLIT partition on same table

The fix for bug 7526851 / bug 8494071 can get

false ORA-904 errors or Wrong Results

ORA-600 [kokegPinLob1] from aggregate returning a

LOB

Wrong results / bad materialized view content

after fast refresh if MV has an OUTER join

ORA-600[kokcup:05] / ORA-600 [KGHFRE3] during

session cleanup with MAX_IDLE_TIME set

Wrong child cursor may be executed - SQL executes

in a wrong schema

ALTER INDEX [no]PARALLEL requires unneccessary

X-lock

ORA-600 [7999] [9] [1] [] / ORA-1555 double

allocated LOB block

ORA-600 [kkslmtl-valnotfound] with fix for bug

9767674 (eg After applying PSU 10.2.0.5.5)

10.2.0.5.5

DBMS_STATS causes deadlock between 'cursor: pin S

wait on X' and 'library cache lock'

Rebuild index of a subpartitioned index fails with

ORA-1 or produces a corrupt index

High row cache latch contention in

RAC

Improve concurrent mutex request

handling

Dump [under kxspoac] / ORA-1722 as SQL uses child

with mismatched BIND metadata

Dump [kkslmtl] using CURSOR_SHARING -

superceded

ORA-600 [kcbo_unlink_q_1] / ORA-600 [504] from

Ctrl-C / interrupt

Process spin querying V$OPEN_CURSOR - causes

"latch: library cache" waits

Internal errors in 10.2.0.5.4 in HP

TRU64

10.2.0.5.4

Dump [ttcfopr] from PLSQL using a database link

with SESSION_CACHED_CURSORS

SGA corruption / ORA-600 [ktcccenxt] / dump using

Lobs

Wrong results using ORA_ROWSCN pseudocolumn with

ANSI join

Corrupt index after PDML executed in serial. Wrong

results. OERI[kdsgrp1]/ORA-1499 by analyze

Parallel query / DML does not run in parallel in

deep nesting of a DBMS_JOB and PLSQL procedure

Excessive PQ slaves spawned for parallel query in

10.2.0.5

10.2.0.5.3

Recursive cursors for MV refresh not

shared

DBMS_LOB.SUBSTR truncates LOBs > 8191 in

multibyte - superceded

ORA-600[kksfbc-reparse-infinite-loop] can

occur

ORA-4031 for "temporary tabl" using temporary

table transformations (STAR / WITH)

OERI [kqlidpfgr: depobpo] on drop

partition

ABORT_REDEF_TABLE can be slow for rowid based

redefinition

ORA-600 [20022] with bitmap

indexes

Upgrade to 10.2.0.5 gets ORA-600 [17069] when

running catupgrd.sql with MultiMedia (intermedia)

installed

LOB segment has null data after long to lob

conversion in parallel mode (eg

DBMS_REDEFINITION).

10.2.0.5.2

Dump [xtyqbcb] / OERI:17147 from SQL with >

32000 OR predicates. SGA memory corruption, instance may

crash

ORA-32696 from a parallel GROUP BY with no

aggregates or COUNT(DISTINCT)

ORA-997 from SQL with CONNECT BY and

UNION

10.2.0.5.1

ORA-8102/ORA-1499/OERI[kdsgrp1] Composite

Partitioned Index corruption after rebuild ONLINE in

RAC

OERI [kdiss_uncompress: buffer length] on key

compressed index

10.2.0.5.7

RAC instance crash "TIMEOUT in DRM FREEZE

step"

"gcs drm freeze in enter server mode" waits in

RAC

Fix for bug 13554409

10.2.0.5.6

V$DATAGUARD_STATS may return misleading or

inconsistent results

ORA-600 querying V$LOGMNR_CONTENTS for logs

without supplemental logging

Excessive archive logging when required logfile

deleted

LMON dump ORA-7445 [kjrchc] / ORA-600

[504]

LOB showing incorrect data on standby database or

after recovery. This bug is alerted

inNote:1206814.1

RAC instance crash with ORA-600 [kjmchkiseq:!seq]

after ORA-4031

ORA-481 during DRM results in LMS communication

issues between nodes / hang

LMD crashes the instance with ORA-600

[kjccgmb:1]

10.2.0.5.5

V$ARCHIVE_DEST_STATUS STANDBY_LOGFILE_COUNT

incorrect

RMAN Autobackup fails with unable to obtain

snapshot enqueue (ORA-230)

ORA-19883 ORA-1115/ORA-27091/ORA-27069 in alert

log while running RMAN backup

OERI[kfioTranslateIO01] / OERI[kffSendMap_2] by

RMAN Block Change Tracking file

Session dump with stack memcpy

RAC env

ORA-600 [kcrruli.3] / ORA-600 [kcrrpsrl.7] after

COMMIT TO SWITCHOVER TO PRIMARY

10.2.0.5.4

GES resource increases continuously in

RAC

Cross instance archival fails in

10.2.0.5

10.2.0.5.1

Streams table and schema rules not consistently

applied for DDL on view/synonym

Message file change for ORA-600

Message file change for ORA-7445

10.2.0.5.9

Database Vault Administrator UI gets "500 internal

error" after apply PSU

10.2.0.5.6

Dump from materialized view refresh or procedure

call over DB link with Audit enabled

10.2.0.5.5

EUS connections get OERI [kzldsearch2] [rdbms to

ldap characterset conversion failed]

10.2.0.5.7

ORA-600[16622] when synonym is specified in

DBMS_SPACE.UNSUSED_SPACE

SMON spins in rollback of LOB due to double

allocated block like bug 11814891

10.2.0.5.5

GV$FILESPACE_USAGE returns invalid entry for

dropped file in RAC

ASSM search for free space may revisit blocks if

HWM is raised

10.2.0.5.4

ASSM_TABLESPACE_VERIFY reports false inconistency

messages

Index leaf block corruption possible after

plugging in transportable tablespace

ORA-600 [kddummy_blkchk] [6106] / corruption on

COMPRESS table in TTS

10.2.0.5.3

Wrong results of ORA_ROWSCN in a full scan of

table with ROWDEPENDENCIES enabled

DBMS_SPACE.ISDATAFILEDROPPABLE_NAME throws

ORA-1426

OERI [kdimstart:kdignbk-loop] during ALTER INDEX

COALESCE

Large trace file for ORA-8103

10.2.0.5.1

Larger trace than needed for ORA-8103 under

kteinicnt1

Table segment growth (blocks are not reused) with

ASSM

ORA-600 [ktsptrn_fix-extmap] / ORA-600

[kdblkcheckerror] during extent allocation caused by bug 8198906.

This bug is alerted inNote:1229669.1

10.2.0.5.11

13561951

Fix for bug 13561951

10.2.0.5.10

Fix for bug 14035825

10.2.0.5.8

ORA-600 [ktrgcm_3] in 10.2.0.5.3 -

10.2.0.5.7

10.2.0.5.6

Wrong result from ORA_ROWSCN

"WITH" subqueries cannot be materialized inside a

global transaction

10.2.0.5.3

OERI [kdsgrp1] during CR read

10.2.0.5.4

Dump [kdblailb] from impdp direct_path of a

COMPRESSed table

10.2.0.5.7

High "resmgr:cpu quantum" but CPU has idle

time

10.2.0.5.6

PQ slaves may get stuck or abort

OERI:kgskexitsch / crash from Resource

Manager

ORA-7445 [ksldclt_cln] using Resource

Manager

10.2.0.5.4

"unspecified wait event" and/or "ksfd: async disk

IO" after applying patches that include fix for Bug

7510766

10.2.0.5.3

Shared pool latch contention when shared pool is

shrinking

"WARNING:Could not lower the asynch I/O limit"

messages

ORA-27300 / ORA-27302 killing a non existing

session

10.2.0.5.2

Linux: Process spin under ksfdrwat0 if OS Async IO

not configured high enough

10.2.0.5.4

PLSQL concatenation (||) slow with mixed

VARCHAR2/NVARCHAR2 arguments

DBMS_SQL.PARSE leaks session heap memory in

10.2.0.5

10.2.0.5.11

14841558

Fix for bug 14841558

10.2.0.5.8

TCP handlers block if listener registration is

restricted to IPC with COST

10.2.0.5.7

AWR Snapshot collection hangs due to slow inserts

into WRH$_TEMPSTATXS.

10.2.0.5.5

ORA-1 on SYS.WRH$_TEMPSTATXS_PK when collecting

AWR snapshot - superceded

10.2.0.5.11

14220725

Fix for bug 14220725

10.2.0.5.5

XML parser may fail with LPX-287

Miscellaneous

Issues

10.2.0.5.12

6690853

Fix for bug 6690853

12710774

Fix for bug 12710774

13015379

Fix for bug 13015379

13561750

Fix for bug 13561750

13596521

Fix for bug 13596521

13791364

Fix for bug 13791364

16306019

Fix for bug 16306019

16382448

Fix for bug 16382448

16703112

Fix for bug 16703112

16817117

Fix for bug 16817117

10.2.0.5.4

Solaris-X86-64 and IBM Linux System Z: 10.2.0.5.4

before 22/Jul/11 contains wrong lib32/libnnz10.so

10.2.0.5.2

AIX: "no message file for product=rdbms" after

installing PSU 10.2.0.5.1 on AIX

Solaris-X86: Patch Set Update re-released on

3-Mar-2011

'*'indicates that an alert exists for that

issue.

'+'indicates a particularly notable issue /

bug.

'P'indicates a port specific

bug.

"OERI:xxxx" may be

used as shorthand for ORA-600

[xxxx].

REFERENCES

- Bug 10076669 - RAC instance crash with

ORA-600 [kjmchkiseq:!seq] after ORA-4031- Bug 10091698 - Upgrade to 10.2.0.5 gets

ORA-600 [17069] when running catupgrd.sql with MultiMedia

(intermedia) installed- Bug 10092858 - Wrong results / bad

materialized view content after fast refresh if MV has an OUTER

join- Bug 10132870 - Index leaf block

corruption possible after plugging in transportable

tablespace- Bug 10139235 - ORA-600[kokcup:05] /

ORA-600 [KGHFRE3] during session cleanup with MAX_IDLE_TIME

set- Bug 10157402 - LOB segment has null

data after long to lob conversion in parallel mode (eg

DBMS_REDEFINITION).- Bug 10159846 - ORA-1 on

SYS.WRH$_TEMPSTATXS_PK when collecting AWR snapshot -

superceded- Bug 10162036 - ORA-600 [kcrruli.3] /

ORA-600 [kcrrpsrl.7] after COMMIT TO SWITCHOVER TO

PRIMARY- Bug 8211733 - Shared pool latch

contention when shared pool is shrinking- Bug 8224558 - Excessive archive logging

when required logfile deleted- Bug 8277300 - Dump [xtyqbcb] /

OERI:17147 from SQL with > 32000 OR predicates. SGA memory

corruption, instance may crash- Bug 8354642 - ORA-19883

ORA-1115/ORA-27091/ORA-27069 in alert log while running RMAN

backup- Bug 8394351 - ORA-32696 from a parallel

GROUP BY with no aggregates or COUNT(DISTINCT)- Bug 8412426 - "WARNING:Could not lower

the asynch I/O limit" messages- Bug 8488233 - OERI[kfioTranslateIO01] /

OERI[kffSendMap_2] by RMAN Block Change Tracking

file- Bug 8528171 - High shared pool use due

to frequent ADD/EXCHANGE partition operations- Patch Set Updates for Oracle

Products- Bug 8544696 - Table segment growth

(blocks are not reused) with ASSM- Bug 8546356 -

ORA-8102/ORA-1499/OERI[kdsgrp1] Composite Partitioned Index

corruption after rebuild ONLINE in RAC- Bug 8636407 - OERI:kgskexitsch / crash

from Resource Manager- Bug 8650138 - PMON dump

[koklcom]- Bug 8660422 - "unspecified wait event"

and/or "ksfd: async disk IO" after applying patches that include

fix for Bug 7510766- Bug 8664189 - OERI [kdiss_uncompress:

buffer length] on key compressed index- Bug 8666117 - High row cache latch

contention in RAC- Bug 8771916 - OERI [kdsgrp1] during CR

read- Bug 8822531 - RAC hang

possible- Bug 8865718 - Recursive cursors for MV

refresh not shared- Bug 8882576 - GES resource increases

continuously in RAC- Bug 8966823 - LMON dump ORA-7445

[kjrchc] / ORA-600 [504]- Bug 8970313 - GV$FILESPACE_USAGE

returns invalid entry for dropped file in RAC- Bug 9020537 - DBMS_LOB.SUBSTR truncates

LOBs > 8191 in multibyte - superceded- Bug 9024850 - Wrong results of

ORA_ROWSCN in a full scan of table with ROWDEPENDENCIES

enabled- Bug 9308296 - ASSM_TABLESPACE_VERIFY

reports false inconsistency messages. ORA-600 [ktspgfb-1] may also

occur for SQL statements- Bug 9320130 - ORA-4031 for "temporary

tabl" using temporary table transformations (STAR /

WITH)- Bug 9322219 - Session dump with stack

memcpy

[kzldsearch2] [rdbms to ldap characterset conversion

failed]- Bug 9337325 - OERI [kqlidpfgr: depobpo]

on drop partition- Bug 9360157 - Wrong results using

ORA_ROWSCN pseudocolumn with ANSI join- Bug 9390484 - OERI

[kdimstart:kdignbk-loop] during ALTER INDEX

COALESCE- Bug 9399589 - "WITH" subqueries cannot

be materialized inside a global transaction- Bug 9448311 - RAC instance crash

"TIMEOUT in DRM FREEZE step"- Bug 9469117 - Corrupt index after PDML

executed in serial. Wrong results. OERI[kdsgrp1]/ORA-1499 by

analyze- Bug 9499302 - Improve concurrent mutex

request handling- Bug 9532911 - LOB showing incorrect

data on standby database or after recovery- Bug 9548269 - ABORT_REDEF_TABLE can be

slow for rowid based redefinition- Bug 9586877 - The fix for bug 7526851 /

bug 8494071 can get false ORA-904 errors or Wrong

Results- Bug 9659614 - Large trace file for

ORA-8103- Bug 9672816 - ORA-7445 [ksldclt_cln]

using Resource Manager- Bug 9689310 - Excessive child cursors /

high VERSION_COUNT / ORA-600 [17059] due to bind

mismatch- Bug 9694101 - Hang / deadlock between

"cursor: pin S wait on X" and "library cache lock" involving

dictionary objects- Bug 9711859 - ORA-600

[ktsptrn_fix-extmap] / ORA-600 [kdblkcheckerror] during extent

allocation caused by bug 8198906- Bug 9713537 - Message file change for

ORA-600- Bug 9714832 - Message file change for

ORA-7445- Bug 9726739 - ORA-997 from SQL with

CONNECT BY and UNION- Bug 9735237 - Dump [under kxspoac] /

ORA-1722 as SQL uses child with mismatched BIND

metadata- Bug 9767674 - Dump [kkslmtl] using

CURSOR_SHARING - superceded- Bug 9770451 - ORA-600 [20022] with

bitmap indexes- Bug 9772888 - Needless "WARNING:Could

not lower the asynch I/O limit to .. for SQL direct I/O It is set

to -1" messages- Bug 9824435 - ORA-600 [kokegPinLob1]

from aggregate returning a LOB- Bug 9842573 - Dump from materialized

view refresh or procedure call over DB link with Audit

enabled- Bug 9949948 - Linux: Process spin under

ksfdrwat0 if OS Async IO not configured high

enough- Bug 9952230 - 10.2.0.5.1 (Oct 2010)

Database Patch Set Update (PSU)- ORA-600 [7999] [9] [1]

[] DOUBLE ALLOCATED LOB

BLOCK