7 Mayıs 2014 Çarşamba

[EN] ORA-19706: invalid SCN

ERROR:

During a select through a database link we got the following error;

===> select sysdate from dual@TARGET_DBX
select sysdate from dual@TARGET_DBX
                         *
Error at line 1
ORA-19706: invalid SCN
ORA-02063: önceki line, kaynağı TARGET_DBX Script Terminated on line 1.

Also we noticed the following message in the alert.log;

*********************************************************************************
Rejected the attempt to advance SCN over limit by 8 hours worth to 0x0ca5.1y0772c8, by distributed transaction remote logon, remote DB: TARGET_DBX.WORLD.
 Client info : DB logon user USERX, machine hostx program JDBC Thin Client, and OS user app_usr1 *********************************************************************************


SOLUTION:

You should first read the following documents on Oracle Support to understand the problem.

System Change Number (SCN), Headroom, Security and Patch Information (Doc ID 1376995.1)

Bug 12371955 - Hot Backup can cause increased SCN growth rate leading to ORA-600 [2252] errors

Then we solved the problem by applying the following steps on TARGET_DBX side.

First, execute the following command and note the selected value. This is the value, that we will change with the second command.

===> select x.ksppinm name,y.ksppstvl value
from sys.x$ksppi x,sys.x$ksppcv y
where x.inst_id = userenv('Instance') and y.inst_id = userenv('Instance') and x.indx = y.indx and
x.ksppinm in ('_external_scn_rejection_threshold_hours')

NAME                                                    VALUE  
------------------------------------------- --------
_external_scn_rejection_threshold_hours     744
1 row selected.

Then execute the following command and restart the database.

alter system set "_external_scn_rejection_threshold_hours" = 24 scope=spfile; -- sid = '*';

===> select x.ksppinm name,y.ksppstvl value
from sys.x$ksppi x,sys.x$ksppcv y
where x.inst_id = userenv('Instance') and y.inst_id = userenv('Instance') and x.indx = y.indx and
x.ksppinm in ('_external_scn_rejection_threshold_hours')

NAME                                                    VALUE  
------------------------------------------- --------
_external_scn_rejection_threshold_hours     24
1 row selected.

Regards.






Hiç yorum yok:

Yorum Gönder