My Oracle Support Banner

Potential 'System Change Number' (SCN) / database link connectivity issues with older versions of the Oracle Database. (Doc ID 2536259.1)

Last updated on JUNE 07, 2021

Applies to:

Oracle Clinical - Version 4.6 and later
Oracle Clinical Remote Data Capture Option - Version 4.6.0 and later
Oracle Thesaurus Management System - Version 4.6.0 and later
Information in this document applies to any platform.

Goal

The purpose of this note is to provide details on a potential issue which can surface from June 2019 onwards and affect the interoperability of database links between older and newer RDBMS versions. The following notes provide more details / what action should be taken :

Some Oracle Clinical releases are certified with affected RDBMS versions i.e

and database links can exist in such environments (i.e replication is set up). Also there maybe a custom setup in place which extracts data from say a source Oracle Clinical '12.1.0.2' database using database links and the target database pulling the data is running on say rdbms 11.2.0.3. In such cases the required patches should be applied.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.