Note: 283565.1
- From: Ray Stell <stellr@xxxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 16 Feb 2005 10:01:32 -0500
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@xxxxxx (540) 231-4109 28^D
--
//www.freelists.org/webpage/oracle-l
Other related posts:
