2 Replies Latest reply on Feb 6, 2013 5:58 AM by Billy~Verreynne

    SQL Developer Hostname - Network Error

    chillychin
    chillychin Feb 6, 2013 4:20 AM
      This is a pretty simple question that I am stumped at the moment

      I installed Oracle on my local desktop with SQL developer

      When first setting up a connection it asks for "host name"

      Thus far, "localhost" works and 127.0.0.1 works when I "test connection"

      But when I try to use my real host name it gives me a network protcol error.

      My hostname should be "oracle_test" by going into Start->Control Panel->System->Computer name thats what I see listed

      What am I missing in order to get SQL developer to recognize my "host name" as "oracle_test"?

      Do I need to pre qualify it with the domain or workgroup ID?

      This computer is part of a work group...

      Thanks in advance
      • 3430 Views
      • Tags:
        • 1. Re: SQL Developer Hostname - Network Error
          Billy~Verreynne
          Billy~Verreynne Feb 6, 2013 5:52 AM (in response to chillychin)
          The hostname requested is an IP network hostname (or alternatively a dotted IP address can be specified). It has nothing to do with a Windows NetBIOS name (though often this is also set to match the IP hostname).

          The hostname provided, need to refer to the IP host on which the Oracle Listener, for the specified database, is running on.

          The hostname provided also needs to be resolvable into a dotted IP address. If you for example say hostname is foo-pc, then the s/w needs to be able to resolve that to an IP address. It does so using the socket interface of the kernel's IP stack. So the s/w (e.g. SQL-Developer) does not determine the IP for that hostname. It asks the IP stack.

          Depending on the o/s configuration, the IP stack checks in the local hosts file, uses a DNS server, and so on, to determine the IP address of the host.

          Hostnames should always be given as FQDN (Fully Qualified Domain Names). This means that the hostname of OTN forums (see URL above) must not be specified as forums, but need to be fully qualified and specified as forums.oracle.com (domain included).

          Windows users and developers have the horrible and incorrect way of not using FQDN.

          So:
          - make sure that you use FQDN
          - make sure that the FQDN resolves to an IP address
          - make sure that this is the IP that the database Listener is listening on
          • 2. Re: SQL Developer Hostname - Network Error
            Billy~Verreynne
            Billy~Verreynne Feb 6, 2013 5:58 AM (in response to chillychin)
            chillychin wrote:

            What am I missing in order to get SQL developer to recognize my "host name" as "oracle_test"?
            Hostnames may NOT include underscore characters.



            RFC 952. DoD Internet host table specification and RFC 1123 Requirements for Internet Hosts -- Application and Support are very clear as to what is legal and illegal regarding host naming.

            RFC 952: 
            1. A "name" (Net, Host, Gateway, or Domain name) is a text string up
   to 24 characters drawn from the alphabet (A-Z), digits (0-9), minus
   sign (-), and period (.).  Note that periods are only allowed when
   they serve to delimit components of "domain style names". (See
   RFC-921, "Domain Name System Implementation Schedule", for
   background).  No blank or space characters are permitted as part of a
   name. No distinction is made between upper and lower case.  The first
   character must be an alpha character.  The last character must not be
   a minus sign or period.  A host which serves as a GATEWAY should have
   "-GATEWAY" or "-GW" as part of its name.  Hosts which do not serve as
   Internet gateways should not use "-GATEWAY" and "-GW" as part of
   their names. A host which is a TAC should have "-TAC" as the last
   part of its host name, if it is a DoD host.  Single character names
   or nicknames are not allowed.
            RFC 1123:
            >
            The syntax of a legal Internet host name was specified in RFC-952
            [DNS:4]. One aspect of host name syntax is hereby changed: the
            restriction on the first character is relaxed to allow either a
            letter or a digit.
            >

            RFC governs the specifications of the Internet. Ensures that we have compatibility and interoperability between all kinds of h/w, running all kinds of s/w, via all kinds of networking infrastructure. Standards are critically important on the Internet.

            Do not violate Internet Networking Standards And Specifications!

            And running an o/s from a company that infamously explicitly violates and warps and twists standards to lock one into their o/s, is not an excuse.