Hi Gurus,
I'm stumped with this problem, no one else is having issue connecting to this database except one user who always get "ORA-03135: connection lost contact" when trying to login to both Test and Prod environment.
oracle@PATEST> sqlplus user@testDB
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Dec 23 13:21:08 2015
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Enter password:
ERROR:
ORA-03135: connection lost contact
Get the same error when trying to connect through EDIVIEW (application) or through the command prompt or cygwin terminal directly.
tnsping is working fine and returning proper connect identifier information
Here's what troubleshooting I have done:
1. Made sure that user is not locked in the database
2. Put the database in restricted mode and granted this user restricted access and tried login as this user, no luck.
3. Bounced the listener
4. Bounced the database
5. Some online forums suggest to increase timeout parameter in sqlnet.ora, in our environment we are using OID and the sqlnet.ora is on central directory. So this can't be the issue as everyone else can connect.
6. I checked the sqlnet.log file and there seems to be no incoming connections coming from this user or machine.
System and database information
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
SunOS mna3dbts 5.10 Generic_150400-27 sun4u sparc SUNW,SPARC-Enterprise
Any advise would be appreciated