DB Links
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: DB Links

Hybrid View

  1. #1
    Join Date
    Aug 2000
    Posts
    163
    I've heard there are 3 types of database linksrivate, public, and global. Who can tell me what global db link is?

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    A database link that links each database in a network to all other databases. This enables any user of any database in the network to specify a global object name in a SQL statement or object definition. An Oracle Names server can store global database links.

    A global database link that is the same as the global database name is automatically registered with the Oracle Names server.
    For example, if the global database name is sales.us.acme.com, a global link with the same name is registered with the Oracle Names server. You verify a global database link is working correctly by performing a SELECT statement on a table, for example:
    SQL> SELECT * from emp@sales.us.acme.com

    Unless you want to specify user name and password credentials for a global database link, no additional configuration is required to use the global database link.

    To define a user name and password for a global database link, use either Net8 Assistant or the NAMESCTL control utility. Because the NAMESCTL utility is limited in global database link registration functionality, Oracle Corporation recommends you use Net8 Assistant.
    Reddy,Sam

  3. #3
    Join Date
    Aug 2000
    Posts
    163
    What is Oracle Names Server?

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    When CLient connects to service_name saying @xyz it should be resolved to get connect to a database to which the service_name has been registered.

    You have couple of methods for names resolution:

    tnasnames.ora where you describe what service_name connecting to what database on a server. When you make a connection to the client it will search tnsnames.ora nad resolve what database is supposed to connect.... in simple we call its local names resolution method.

    You can have very weel name server where there are entries for all these names stored in a network. this is called names resolution using names server.

    Have a read on Net8 Naming documents.

    http://otn.oracle.com/docs/products/...cts.htm#439896
    Reddy,Sam

  5. #5
    Join Date
    Feb 2001
    Posts
    41
    Good Input
    Best Regards,
    Harsh Shah

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width