2 Replies Latest reply: Feb 5, 2013 11:58 PM by Billy~Verreynne RSS

    SQL Developer Hostname - Network Error

      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 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
        • 1. Re: SQL Developer Hostname - Network Error
          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.

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