Slow to connect to oracle w/ JDBC & SQLPLUS over network
Posted on 2002-04-03
We're having a problem where it takes up to 12 seconds to establish a new connection over network to a Oracle Database (running on a 16 processor HP box). The Client runs on Win2k. Both JDBC and SQLPLUS takes 8-12 seconds to connect to Oracle, but after the connection is established, the queries are lightning fast (so the problem is solely in the connect area).
I assume it can be the TNS listner. Running tcp sniffers we can see the connection is trying to be established. The client sends a TCP message "ACK TOO LONG" then Oracle responds with keep alive. Nothing happens for about 6-10 seconds before Oracle asks to retransmit and at that time a new connect is sent.
Does anyone know what can be wrong? Could it help to setup a seperate TNSListner for this? Is there an ultimate setup? Could it be something else than the TNS listner?
Any help would be appriciated greatly!