Re: Rejected to advance the SCN Issues

From: Ryan January <rjjanuary_at_multiservice.com>
Date: Tue, 25 Jun 2013 08:13:04 -0500
Message-ID: <51C99760.5070106_at_multiservice.com>

It would help to have information such as version and patch level. Have you applied the Jan 2012 CPU?

http://blogs.ioug.org/2012/01/17/oracle-scn-bug-revealed-cpu-jan-2012-to-address-it/

System Change Number (SCN), Headroom, Security and Patch Information [ID 1376995.1]
Master Note: Overview for SCN issues [ID 1503937.1] Installing, Executing and Interpreting output from the "scnhealthcheck.sql" script [ID 1393363.1]

On 06/25/2013 02:29 AM, Bala Krishna wrote:
> Hi All,
> Almost all our Databases are affected with below errors , we suspect that
> its because of our distrubuted transactions .
>
> Rejected the attempt to advance SCN over limit by 212 hours worth to
> 0x0c2c.ae9cc069, by distributed transaction remote logon, remote DB:
> XXXXX.xxxx.com.
> Client info : DB logon user APPS, machine XXXXXXX, program , and OS user
> XXXXXXX
>
> As if now we've mitigated this issue by setting below parameters.
>
> _external_scn_rejection_threshold_hours=24
>
> My question:-
>
> 1. Distrubuted Transactions are being failed sometimes with ORA-600 ,
> ORA-19706:
> invalid SCN & some instance crashes are also observed.
>
> I've read in this blog (
> http://www.orainternals.com/2012/01/20/scn-what-why-and-how/) and it says
> that
>
> At commit time, a co-ordinated SCN is needed for the distributed
> transaction and maximum SCN value from all participating databases is
> chosen.
>
> So which means , since there is a increase in SCN number we should be
> facing this kind of issues even for local transactions rather than
> distrubted transactions right ? but we're not facing such issues as such ?
>
> Regards
> Bala
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

-- 


------------------------------------------------------------------
This email is intended solely for the use of the addressee and may
contain information that is confidential, proprietary, or both.
If you receive this email in error please immediately notify the
sender and delete the email..
------------------------------------------------------------------

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

Received on Tue Jun 25 2013 - 15:13:04 CEST