Dell PowerEdge 2950
Oracle RHEL 5
Oracle DB 11g
After installing the DB, when testing we noticed that the first connection to the DB takes a long time, and whats worst, while it waits no other connection can go in!. Trying this on 2 windows locally,
window A: tnsping to the DB, immediate (0 ms)
window B: sqlplus to the same database, taking 10-20 seconds.
Window A: try the tnsping again, stuck until the sqlplus from window B connects.
The sqlnet definition for the listener is very simple, TNSNAMES only, everything is local, not even NFS volumes.
This is happening on 2 identical machines with same software and DB.
I have replaced window B with a remote client trying a JDBC connection test, and I get the same results. If I keep trying the same test connection then apparently is reuses the same connection because there is no delay. The moment I force a new connection then I get stuck again.
Anyone has seen such behavior?