How to access my Oracle database?
We are a having problems accessing our Oracle database through WAN. We are using ERP applications where the application server and the database server are placed on different locations. Both servers are connected via 2Mbps MPLS link (latency 4-5 MS). The problem is there are times when I could not log in to the application server.
I even get an error message saying “TNS packet writer failure error”.
This usually happens when I enter a user ID assigned with more tasks, making its profile quite heavy. Other applications such as RDP and web applications work just fine with the same link, and when I try using a user ID with a lighter work load, there are no problems with logging in.
I hope you can help me explain what’s wrong with the computer and what options I have to fix it.