DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Database Link

  1. #1
    Join Date
    Feb 2001
    Location
    Bangalore, India
    Posts
    109
    If two databases have the users by the same name with different passwords, how should I proceed to create database link?

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    where is the problem ???
    when you create a db link, the password you supply is the one of the user you will connect to (not the one you connect from) ...

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by pipo
    when you create a db link, the password you supply is the one of the user you will connect to (not the one you connect from) ...
    You can create a database link without specifying the username and password. Oracle will then try to authenticate against the target DB with the username/password of the connected user. However, the username/password must be the same on both instances for this to work.
    Jeff Hunter

  4. #4
    Join Date
    Aug 2000
    Location
    Peru
    Posts
    7
    Hi friend:
    I had these problems. After I implemented several replication system, i comment you the following:

    * It's not necesary that the same users exist in the other database.
    * You could create un private database link.
    For it, first create public database link

    create public database link TARGET.WORLD using 'TARGET.WORLD';

    Then for the user connected to SOURCE database with which want to access to other Database:
    create database link TARGET.WORLD connect to USER_TARGET identified by PASSWORD_TARGET;

    Then in the database target must be exist the user USER_TARGET with the password equal to PASSWORD_TARGET.
    If yuo need that other user acced with a database link, must be create a private database link using the user USER_TARGET.

    if you need more help, write me to jcullas@belcorporation.com





    Javier Cullas
    Master Oracle
    Enterprise DBA - Networked &
    Distributed DBA Specialist
    http://education.oracle.com/latinamerica/masters_cert/mt.names.html

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