Oracle connection faster with network connection, slow when in standalone

Posted on 2009-04-26
Last Modified: 2013-11-11

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??


Question by:harrichr
    LVL 47

    Accepted Solution

    You have to activate the Loopback adapter and to make it first adapter in the list as explained here:
    2.4.5 Installing a Loopback Adapter


    Author Closing Comment

    The link provided valuable information  understanding the network/standalone operation of Oracle. However, for now I just remove the DNS setting and Oracle works fine in standalone. However, when I get on to network I add DNS values in again.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Article by: Swadhin
    From the Oracle SQL Reference ( we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now