Skip navigation

The Announcement made at the beginning of CY2018:

 

If you're running an older version of the Oracle Database and you have applications that are actively using DB Links to connect to other databases, regardless of their version, you may need to take action to ensure your database applications continue to work as expected. We are strongly encouraging users of these older databases to consider upgrading to a supported release, or at a minimum, verify the latest patch recommendations have been applied.

 

The issue applies to the following Oracle Databases versions:

10g release 2 (10.2.0.5 and lower)

11g release 1 (11.1.0.7 and lower)

11g release 2 (11.2.0.3 and lower)

12c release 1 (12.1.0.1)

 

If you are on one of the following Database versions, this issue will not affect you:

11g release 2 (11.2.0.4)

12c release 1 (12.1.0.2)

12c release 2 (12.2.0.1)

18c

19c

 

The detailed instructions with the required patches that you need to apply incase you can't upgrade your databases to recommended versions are outlined in DOC ID 2335265.1

 

These patches will increase the Database’s SCN Rate limit automatically from 16K/s to 96K/s, and enable databases to support much higher transaction rates. This fix is already present in 11.2.0.4, 12.1.0.2, 12.2.0.1 and all versions above 12.2.0.1. This SCN rate increase also knows as SCN rollover was slated to happen automatically on June 23rd 2019 on all the above versions and also the lower versions patched to recommended levels.

 

If the patches are not applied, the unpatched database will have a lower SCN rate or lower current max SCN limit.

 

Sometimes, there can be a scenario where in the patched database can be at higher SCN level while the unpatched database is at much lower SCN level due to these rate limit allowance differences. When there is a requirement to connect these patched and unpatched databases, the SCN sync has to happen and if this sync needs the SCN to increase more than the Current max SCN limit in the unpatched database, the dblink connection will fail.

 

Current Status:

 

For 11.2.0.4 & above versions and for patched lower versions, the automatic SCN Rate Limit Increase from 16K/s to 96K/s has already happened on June 23rd, 2019. No major issues were reported.

You would have noticed a message similar to below in the alert log of the databases that are at the recommended patch levels on June 23rd, 2019.

"Database SCN compatibility changed from 1 to 3 due to auto-rollover"

Even if the database was down during this autorollover period, the rollover would have automatically happened whenever the database started after June 23rd, 2019. You would see the same message immediately after the database startup.

 

Action:

 

If you haven't already upgraded the databases or moved them to the recommended patch levels, please do so as soon as possible to eliminate the potential risk on your database links (refer DOC ID 2335265.1). Until then, please monitor the 16k/s SCN headroom of the patched/upgraded database(that has dblinks pointing to lower/unpatched databases) using the script from the DOC ID 1393363.1. If this headroom falls below 20, please remove the dblink connections to unpatched databases and upgrade/patch the unpatched database immediately for the dblink connections to work.

The 16k/s SCN headroom can be monitored using the script from the DOC ID 1393363.1

 

If you want to verify if your database is already running at 96K/s limit(or compatibility 3), you can use the below procedure. If the "Current SCN Compatibility" shows 3, you are at 96K/s SCN rate limit. Please make a note that this procedure may not work in some of the older database versions.

set serveroutput on;

declare

cur_scn_compat number;

max_scn_compat number;

begin

dbms_scn.GetCurrentSCNParams(cur_scn_compat,max_scn_compat);

dbms_output.put_line('Current SCN Compatibility=' || cur_scn_compat);

dbms_output.put_line('max_scn_compat=' || max_scn_compat);

end;

/

 

Thank you for reading this blog post.  Let us know if you have any questions or if there are other areas you would like to see discussed in this forum. 

Welcome to the My Oracle Support Community! We highly encourage you to personalize your community display name to make your activity more memorable. Please see https://community.oracle.com/docs/DOC-1022508 for instructions.