EZCONNECT - Easy Connect String
You can avoid having to use a TNSNAMES.ORA file by specifying the full connect string at the command prompt. The hostname is the only mandatory piece.
sqlplus username/password@ [//] hostname [:port] [/service_name]
Eg. sqlplus scott/tiger@10gserver:1521/ORCL
Ex :sqlplus scott/tiger@:1521/
Set up EZCONNECT in the sqlnet.ora file as follows:
NAMES.DIRECTORY_PATH = (TNSNAMES, EZCONNECT)
This gives us easy and secure way of connecting to databases from client machine without leaving the DB information in TNSNAMES.ORA
This information is taken from http://www.dba-village.com/
You can avoid having to use a TNSNAMES.ORA file by specifying the full connect string at the command prompt. The hostname is the only mandatory piece.
sqlplus username/password@ [//] hostname [:port] [/service_name]
Eg. sqlplus scott/tiger@10gserver:1521/ORCL
Ex :sqlplus scott/tiger@
Set up EZCONNECT in the sqlnet.ora file as follows:
NAMES.DIRECTORY_PATH = (TNSNAMES, EZCONNECT)
This gives us easy and secure way of connecting to databases from client machine without leaving the DB information in TNSNAMES.ORA
This information is taken from http://www.dba-village.com/
Posts
0 comments:
Post a Comment