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.
Syntax of EZCONNECT:
sqlplus username/password@[//]host[:port][/service_name]
To enable EZCONNECT “sqlnet.ora” should have naming methods “ezconnect” specified in NAMES.DIRECTORY_PATH Parameter. “sqlnet.ora” is located in $ORACLE_HOME/network/admin
Example:
NAMES.DIRECTORY_PATH=(ezconnect, tnsnames)
EZConnect without command line password
Connecting without a password on the command line is very common in order to be prompted for a password such as with:
% sqlplus [username]/@[net_alias]
With the EZCONNECT naming adapter, the following similar syntax will fail with an ORA-12514 error:
% sqlplus [username]/@[hostname]:[port]/[servicename]
Based on parsing rules, the service name is being interpreted as the password. The supplied hostname is being interpreted as the SERVICE_NAME and therefore returning the ORA-12514 error.
In order to be prompted for a password while using the EZCONNECT naming adapter, use the following syntax:
% sqlplus [username]@\"[hostname]:[port]/[service name]\"