this is a similar question as the below thread.
here I have a database in rhel server. I have another database in ubuntu server, both over a network.
I am loading from cursor on a table rhel server to database ubuntu server. it is all fine loading, no issues.
the question is how to make load from cursor resilient to brief network outages. suppose network goes down for 1.5 minutes, after that it comes back. but load from cursor fails with socket error.
it is tolerating only less than a minute of network down time. how to configure this limit.
please let me know even if it is a os level setting related to tcpip sockets. I am also searching tcp socket time out in google. this is for learning purposes only.
Harishkumar .Pathangay[Organization Members] @ Feb 16, 2019 - 11:16 AM (Asia/Calcutta)