User:Anshul.pathak3/sandbox

Hi All,

EZCONNECT is Oracle's easy connect naming method. EZCONNECT eliminates the need for service name lookups in tnsnames.ora files when connecting to an Oracle database across a TCP/IP network. In fact, no naming or directory system is required when using this method as it provides out-of-the-box connectivity. It extends the functionality of the host naming method by enabling clients to connect to a database with an optional port and service name in addition to the host name of the database.

Syntax of the connect string: sqlplus username/password@[//]host[:port][/service_name]

where: 	// Optional. Specify // for a URL. 	host Required. Specify the host name or IP address of the database server computer. The host name is domain-qualified if the local operating system configuration specifies a domain. 	port Optional. Specify the listening port. The default is 1521. 	service_name Optional. Specify the service name of the database. The default is the host of the database server computer. Note that this might not be the same value that you entered in the connect string for the host.

For more information please read attached PDF

Thanks & Best Regards, Anshul Pathak