Easy Connect Naming methods were introduced in Oracle 10g. The benefits were simple. The need to do a service name lookup in the tnsnames.ora files for TCP/IP environment was eliminated, a directory naming system is no longer needed and clients are connected automatically. Connecting is also fairly simple:
SQL@ > conn scott/tiger@OR1/ASMDB (ASMDB is the service - instance, OR1 is the DB server)
Connected.
SQL@ OR1/ASMDB>
SQL@ OR11/HOME> conn scott/tiger@OR1/HOME
Connected.
SQL@ > conn scott/tiger@OR1/ASMDB (ASMDB is the service - instance, OR1 is the DB server)
Connected.
SQL@ OR1/ASMDB>
SQL@ OR11/HOME> conn scott/tiger@OR1/HOME
Connected.
No comments:
Post a Comment