SQL> shutdown abort .com

About DBA Queries DBA Scripts Quick Guides Nooleus Other Stuff Contact
Andy only 
 

How does tnsManager work?

tnsManager


  1. The client PC initiates a connection to HR_DB. Because the Oracle client has been configured to use LDAP instead of tnsnames, a request is sent to tnsManager.

  2. tnsManager responds with a connection string for HR_DB.

  3. The client PC disconnects from tnsManager and makes a direct connection to HR_DB - just as if it had used a tnsnames.


If, in the future, the DBA decides to move HR_DB to a new server called 'Server2', all that is required is an update to the central tnsnames.ora held on the tnsManager server.

<< Back



Copyright© 2007-2010 Andrew Barry