TransWikia.com

Can an Oracle 19c database dblink to an Oracle 10.2.3 database?

Database Administrators Asked by Darcy Dommer on December 17, 2021

I have an Oracle 12.1.0.2 database that dblinks to an Oracle 10.2.0.3.0 database.
I am upgrading the Oracle 12.1.0.2 database to 19c (12.2.0.3).

Will my dblinks to the Oracle 10.2.0.3.0 database continue to work?

2 Answers

Yes. I am upgrading from 11.2 to 19 and my link to 10.2.0.3 works:

SQL> select * from v$version@MYDBLINK;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi

SQL> select banner from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

I have a link to a 9.2 database and it does not work, but I have a work around.

Bobby

Answered by Bobby Durrett on December 17, 2021

Based on this document from Oracle Support, the answer appears to be "No". A 19c client (the owner of your DB Link) is only supported/compatible with a server version of 11.2 or greater.

Conversely, a 10.2 database can only support a client as new as 12.1, so any upgrade of your 12.1 database to any newer version will break your db link.

Answered by pmdba on December 17, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP