Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2009
    Posts
    4

    Unanswered: question about dblinks

    Hi to all.

    At first excuse me because my english is not very good.

    Any person known if there any tool which automatically paint dblinks? I have a lot of databases and i dont know how i can paint the dblinks.

    A lot of thanks.

    Regards.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    What does it mean, to "paint a DB link"?

  3. #3
    Join Date
    Feb 2009
    Posts
    4
    sorry again for my english.

    Paint a DB Link = for example in a network there programs which auto discover, mapping and paint all the network by SNMP. I want to know if there any tool which do something like this, "auto discover and paint" the db liniks over de databases of my network.

    a lot of thanks.
    Regards.

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    see the dba_db_links view.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  5. #5
    Join Date
    Feb 2009
    Posts
    4
    thanks, im going to view it

  6. #6
    Join Date
    Feb 2009
    Posts
    4
    but, how can i draw the dblinks? this option not draw it...

  7. #7
    Join Date
    Sep 2002
    Location
    Ohio
    Posts
    204
    A database link is really nothing more than a connection definition stored in a database. It is only used when a query runs that accesses an object in the remote database.

    As such, I know of no way to dynamically map database links. The best you can do is visit all of your databases and document the db_links that exist there. You can then manually create an overlay to put on top of your network topology map.

    As an added layer of complexity, you must realize that the db_link definition actually points to an entry in the local tnsnames.ora file. So the entry in the tnsnames.ora file determines which actual database the link points to. For instance, in a dev database, the dblink will be called to PRODDB2. However, we don't really want to point a dev database to a production database, so the PRODDB2 entry in the tnsnames file will point to DEVDB2. We do this so the code that uses the database link does not have to change as it moves from dev to QA to production. The point being, you can't just look at the database link definition in the database, you have use tnsnames.ora to verify where that link is pointing.

Posting Permissions

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