This content has been marked as final. Show 2 replies
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
chillychin wrote:Hostnames may NOT include underscore characters.
What am I missing in order to get SQL developer to recognize my "host name" as "oracle_test"?
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.
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.
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.