Home » RDBMS Server » Server Administration » DB Links may stop working after June 2019 (Minimum Patch levels)
DB Links may stop working after June 2019 [message #669888] Wed, 23 May 2018 01:11 Go to next message
Frank Naude
Messages: 4570
Registered: April 1998
Senior Member
Have you guys seen the announcement from Oracle Support w.r.t DB Links that may stop working in the near future?

In short DATABASE LINKS on Oracle 9i and earlier, unpatched 10g, and 11g and 12c releases that are not on the latest patch-set may fail from June 2019. For more info, read MOS Doc ID 2361478.1.
Re: DB Links may stop working after June 2019 [message #669896 is a reply to message #669888] Wed, 23 May 2018 05:03 Go to previous messageGo to next message
Flyby
Messages: 188
Registered: March 2011
Location: Belgium
Senior Member
Seen it. Quite a major item.
Luckily our company version is/should not be affected.
Re: DB Links may stop working after June 2019 [message #669904 is a reply to message #669888] Wed, 23 May 2018 08:03 Go to previous messageGo to next message
joy_division
Messages: 4961
Registered: February 2005
Location: East Coast USA
Senior Member
I read the note. Do you happen to know how it may affect client software? Although our databases are in compliance, we do have client software as old as 10.2.0.1.0 on some *nix machines that we use to access the databases. I will probably put in an SR asking this very question if no one knows.

They are quite vague as to "why" it "may" happen. Is there some time bomb built into the database that will cause this, because I don't know how it can all of a sudden trigger in say a 9i or 10g database. If you are so far behind the times, you are not installing anything new patches to the database, so what will trigger it to stop working?

[added] oh, ok, I re-read it. Somehow I missed that they are talking about inseparability with newer releases.

[Updated on: Wed, 23 May 2018 12:47]

Report message to a moderator

Re: DB Links may stop working after June 2019 [message #670109 is a reply to message #669904] Wed, 06 June 2018 07:28 Go to previous messageGo to next message
Frank Naude
Messages: 4570
Registered: April 1998
Senior Member
joy_division wrote on Wed, 23 May 2018 15:03
Do you happen to know how it may affect client software?
"The interoperability of database clients with database servers is not impacted."

More info on this subject:

1. http://blog.enmotech.com/2018/03/26/suggestion-and-solution-to-scn-compatibility-and-db-link-interconnection-issue/

2. http://blog.enmotech.com/2018/03/26/read-this-before-patching-by-april-2019/
Re: DB Links may stop working after June 2019 [message #670111 is a reply to message #670109] Wed, 06 June 2018 07:51 Go to previous message
joy_division
Messages: 4961
Registered: February 2005
Location: East Coast USA
Senior Member
Thank you Frank.
Previous Topic: Control file
Next Topic: patching 12c database in read only mode ?
Goto Forum:
  


Current Time: Sun Dec 05 06:07:15 CST 2021