Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Monday, December 06, 2010

Connecting DB with Connect Naming

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)

SQL@ OR11/HOME> conn scott/tiger@OR1/HOME

No comments: