Page 1 of 1

Connecting in Direct mode to Oracle on UNIX fails after a few successful attempts

Posted: Thu 31 Jan 2008 13:21
by softrade
VB.NET 2005 Application works fine in the development environment - Oracle 10G on windows. On production environment - Oracle 10G on UNIX. The following eror occurs after many successful logins and logouts.


ORA-01017:invalid username/password; logon denied


Starts logging in again after about 20 minutes. User is able to login to the database using sqlplus when the login is denied.

Posted: Thu 31 Jan 2008 14:28
by Alexey.mdr
Do you have full access to the server?
What is the average server loading?
When the failure happens and you are able to login via SQL Plus. Are you able to login on the server side or on the client side?
How much time does the login denying usually take?

Check this page out:
http://www.cryer.co.uk/brian/oracle/ORA01017.htm
Probably there are some invalid settings in UNIX OS.

Posted: Fri 01 Feb 2008 12:03
by softrade
No errors when Connecting thru TNS mode. The problem appears only for Direct Mode...Any suggestions?

Posted: Fri 01 Feb 2008 13:38
by Alexey.mdr
Could you please reply on the questions in the previous post?
It is hard to locate the problem with a lack of information.