Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Unanswered: DataBase Link Problem

    Hi Everyone,

    I'm try to connect 2 physical db server using database links but unable to do architecture information is as follow.

    server 1
    Operating system = windows NT 4.0
    system name = nt_server
    SID(DB) name = shifa

    server 2
    Operating system = windows XP
    system name = dbserver
    SID(DB) name = shifa

    Connection Strings (Developer 6i SQL)

    NTS for server 1
    DBS for server 2

    DataBase names are same in both servers i.e "Shifa".

    Please tell me the Query to create DATABASE LINK
    what changes i should make in the server(s) settings.
    and how to verify that DataBase link is working.

  2. #2
    Join Date
    Apr 2003
    Greenville, SC (USA)
    Ensure you have GLOBAL_NAME=TRUE in you init file for both databases.

    Create database link as follows: on server 1

    sql> Create database link globalnameofotherdatabase connect as userid identified by password using 'tnsnameentry';

    globalnameofotherdata - this is the identification of the other database
    userid = user that you want to connect thru the dblink
    password = above user's password

    tnsnameentry = tnsnames.ora service name ...

    Change the global name of the databases to match the links... ie

    alter database rename global_name to;

    change to match your dblink....


Posting Permissions

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