How to access my Oracle database?

Asked By 0 points N/A Posted on -
qa-featured

 Hello!

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.

Thank you

SHARE
Answered By 20 points N/A #105900

How to access my Oracle database?

qa-featured

Hello Kevin West,

I guess the error you are having is as a result oracle not being able to start the ADI and that is because the ORA-12571 is intervening, and the way this is happening is as shown below:

logon to adi fails with ORA-12571: tns : packet writer failure

adi ->signon->enter username/password

The cause for the error is usually a problem with oracle and the other applications that you are running; they may be interfering with each other's operations. A possible application to be causing such a problem is an antivirus application which is preventing the ADI in oracle to work.

To troubleshoot the problem, you will need to disable the antivirus you are using and the restart ADI again and see what the response is.

Hope this helps.

__

Regards
Mahesh Babu

 

Related Questions