The easy connect naming method can eliminate the need for service name lookup in the tnsnames.ora files for TCP/IP environments. Easy connect naming provides out-of-the-box TCP/IP connectivity to databases. The easy connect naming method extends the functionality of the host naming method by enabling clients to connect to a database server with an optional port number, service name, and instance name in addition to the host name of the database:
CONNECT username/password@host[:port][/service_name][/instance _name]
The easy connect naming connect string converts into the following connect descriptor:
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST= host)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=service_name)
(INSTANCE_NAME=instance_name)))
For example, the following connect identifiers connect the client to database service sales.us.example.com with a listening endpoint of 1521 on database server sales-server:
These connect strings convert into the following connect descriptor:
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=sales.us.example.com)))
Note: Oracle Net Configuration Assistant provides basic configuration. For more advanced configuration operations, or to configure other portions of Oracle Net that this tool does not cover, use the Oracle Net Manager.
For information about using the easy connect naming method, see Chapter "Configuring Naming Methods" in the Oracle Net Services Administrator's Guide.
Oracle Net Services Configuration Overview
Copyright © 1996, 2011, Oracle and/or its affiliates.All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.