2 Replies Latest reply: Apr 26, 2012 5:33 AM by viconstg RSS

    How to link 2 different database

    858574
      Hi,

      I'm having a problem. I have two databases name FLARE and MP5PROD. When I execute the triggers from FLARE DB, error displayed.
      ORA-04052: error occurred when looking up remote object MP5PROD.R5INSTALL@FINTOMP5.WORLD
      ORA--12203: ":TNS unable to connect to destination

      TNSNAMES

      MP5PROD.WORLD =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.2.222)(PORT = 1521))
      (CONNECT_DATA = (SID = MP5P))
      )

      FLARE_PROD.WORLD =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.222)(PORT = 1521))
      (CONNECT_DATA = (SID = PROD))
      )

      Here are the script for database links:

      FLARE_PROD
      Link Owner: MP5PROD
      Link Name: MP5PRODTOFIN.WORLD
      Host: PROD
      Username: MP5BAIM

      Link Owner: MP5BAIM
      Link Name: FINTOMP5.WORLD
      Host: MP5P
      Username: MP5PROD

      SCRIPT
      create database link "FINTOMP5.WORLD"
      connect to MP5PROD
      identified by "<pwd>"
      using 'MP5P';

      MP5PROD
      Link Owner: MP5PROD
      Link Name: MP5PRODTOFIN.WORLD
      Host: PROD
      Username: MP5BAIM

      SCRIPT
      create database link "MP5PRODTOFIN.WORLD"
      connect to MP5BAIM
      identified by "<pwd>"
      using 'PROD';
      Please help.

      Thanks,

      Regards,
      Diane