Oracle SQLPlus connection take 2-3 minutes

[Jean-Luc Oudart · Accepted solution]

Ok

when you use ORACLE_SID (and not the @connectionstring) you bypass sqlnet. Also, if DP is affected (is this to the same extent ie 2-3 mns more for each session ?) sounds like a network issue.
Anything in the log ? have you trace enabled so you can analyze with netfmt ?

if you try ftp on the localhost what's happening ?

regards
Jean-Luc

[Paul Skerry]

Hi Jean-Luc,

On a hunch, I commented out the name servers in /etc/resolv.conf and tried SQLPlus again. It came up immediately!

It seems that the network engineers probably did a little too much blocking at the weekend! I've turned it over to them.

Thank you so much for your help. You got me on the right track when bypassing SQL*Net made the problem go away.

Best regards,
- Paul

[Paul Skerry]

Problem attributed to changes to DNS settings causing disruption to Oracle connectivity.