Oracle connection faster with network connection, slow when in standalone
Posted on 2009-04-26
When I conect using sqlplus on the local machine running Oracle it connects to within a sec. However, if I pull out the network cable, and then try and connect, it takes over 20 sec. I have this repeatedly with the same results. Hence it is cumbersome for me to work with the computer in standalone. Where is the problem with the local connection (ie. without network connected?? I have even tried a loopback plug and a switch with only one machine with the same slow results. Only if the machine is part of a bigger network with my internet connection (ie. DNS setup with ISP addresses) does it work fast -- hence it leads me to believe that it has something to do with DNS. I have the machine defined in /etc/hosts as a private network machine, with a gateway and a firewall for external connection. Hence surely from a local perspective this connection should be fast. Is Oracle doing something else in resolving the name, like not looking in /etc/hosts first??