Note: 283565.1

From: Ray Stell <stellr_at_cns.vt.edu>
Date: Wed, 16 Feb 2005 10:01:32 -0500
Message-ID: <20050216150132.GC16975@locust.cns.vt.edu>

Inside the Solaris 64 bit 9.2.0.6 patch is a readme that says don't patch until you read note 283565.1. The note is in a hidden, edit state and has been since Dec 2004. They gave it to me in a tar. Someone here may be interested:

Note 283565.1
Circulation: UNDER_EDIT (EXTERNAL)
Topic: Oracle 9i Data Guard Known Issues Title: ORA-2437 on SYSTEM.LOGMNRC_GTCS_PK during upgrade to 10g

ORA-2437 on SYSTEM.LOGMNRC_GTCS_PK during upgrade to 10g

---

Versions Affected

---

9.2.0.6 and below
10.1.0.2 and 10.1.0.3

Platforms Affected

---

GENERIC, All platforms affected

Description

---

If multiple DDLs are performed on a database for which system catalog statistics are not current, Streams users may find that their capture process stops with an error reporting the presence of an unsupported column. Steams or Logical Standby customers could see the Apply components of these products st op with errors reporting incompatible datatypes.

Likelihood of Occurrence

---

Streams and/or Logical Standby

Possible Symptoms

---

ORA-2437 : cannot validate (SYSTEM.LOGMNRC_GTCS_PK) - primary key violated

Workaround

---

No workarounds. However the problem can be avoided.

1. Check if the bug exists first.

select count(*)
from (select logmnr_uid
from system.logmnrc_gtcs
group by logmnr_uid, obj#, objv#, intcol# having count(1) > 1);

2) If the returned count is greater than 0 then the system in question has been affected.

If the returned count is less than 0, update system catalog statistics before executing DDL commands such as 'alter table drop column'.

For example, in sqlplus:

EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS(ownname=>'SYS');

Patches

---

Interim patches can be requested on top of 9.2.0.6 and 10.1.0.3.

References

---

Bug 3785754 : 9IR2->10.1 UPGRADE GETS ORA-2437 : CANNOT VALIDATE (SYSTEM.LOGMNRC_GTCS_PK)

---

Ray Stell stellr_at_vt.edu (540) 231-4109 28^D

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 16 2005 - 10:04:25 CST