Easy Connect
Oracle Database 10g allows for a simpler client configuration, in that in some cases it is not necessary to have a TNSNAMES file at all. This is possible using . In doing so, the client may connect by simply specifying the connect string in the form of //<vipname:port>/<service_name>.
Using the Easy Connect syntax in Oracle Database 10g Release1, instead of a tnsnames.ora file, means that you will not be able to take advantage of advanced features, such as TAF or client-side load balancing. However, the listener load balancing is still possible.
CONNECT
username@[//]host[:port][/service_name][:server][/instance_name]
Enter password: password
NAMES.DIRECTORY_PATH
This parameter specifies the order of naming methods Oracle Net can use to
resolve connect identifiers to connect descriptors.
By default, when this parameter is not set in sqlnet.ora, all naming methods
(including Easy connect naming) are enabled for Net name resolution. In other
words, Easy connect naming is available and used by default.
If this parameter is set, please ensure that EZCONNECT is specified as one of the
values in order to use Easy connect naming method.