Skip to Main Content

LiveLabs & Workshops

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12152: TNS:unable to send break message on database link to an autonomous database

TorOct 23 2020

Hi! I have a Oracle 18XE DB running on an Oracle Enterprise Linux server in Azure (Virginia). I also have an autonomous database running in the Oracle Cloud in Ashburn (also Virginia). I crated a DB link from the XE to the autonomous database. Most of the time the link works great but sometimes it just grounds to a halt, queries freeze and eventually fail with ORA-12152: TNS:unable to send break message. These are simple, normally sub second queries.
Any tips to help troubleshoot is greatly appreciated.

Comments

vdsadhi
Answer

Hi

Why don't you use Manual Insert and Update process as per your requirement?.. Give 'Never' for Automatic Processing for DML and try to create a manual process (PL/SQL blocks) and give condition.

Thanks

Lakshmi

Marked as Answer by Manas M · Sep 27 2020
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 26 2020
Added on Oct 23 2020
3 comments
486 views