This is a real head scratcher, and i have no idea where else to look.
running the following:
Oracle Database 11g Enterprise Edition 184.108.40.206.0 64bit Production on a windows 2008 R2 standard VM.
Up until 4 days ago, everything was working fine, then came in tuesday morning, and could no longer connect my Eclipse IDE (4.2 Juno) to the DB. Ping fails with following stacktrace:
java.sql.SQLException: Io exception: Got minus one from a read call
This was work fine for months prior.
TNSPING also fails with the following: TNS-12537: TNS:connection closed
But, I can connect to the DB using SQL+ as well as SQL Developer (latest version). However, SQL Developer does lose the connection often and/or prompts that db is too busy and whether to abort or try again.
Also, running my java code in my local webserver also fails with the SQLException ( Got minus one from a read call)
I enabled tracing on my laptop and tnsping tracing revealed the following error: ntt2err: Read unexpected EOF ERROR on 1892
the listener.log on the server also reveals the following error, confirming my client isn't passing connect data i think..?
10-MAY-2013 15:08:31 * <unknown connect data> * (ADDRESS=(PROTOCOL=tcp)(HOST=< my workstation IP >)(PORT=5831)) * establish * <unknown sid> * 12525
TNS-12525: TNS:listener has not received client's request in time allowed
TNS-12535: TNS:operation timed out
TNS-12606: TNS: Application timeout occurred
I am on our intranet, and DB is also on the intranet, so shouldn't be any firewalls between me and DB.
Any ideas? Anything else I can enable to log and trace?
Thanks for your help!
Edited by: pl_sequel on May 10, 2013 3:19 PM
Edited by: pl_sequel on May 10, 2013 3:20 PM