13 Replies Latest reply: Oct 1, 2009 7:51 AM by 718040 RSS


      I have created one public database link using the followin command

      create public database link ROGEM_110000
      connect to REPMGR Identified By REPMGR
      using '(DESCRIPTION =
      (ADDRESS =
      (HOST =
      (PORT =1521))
      (CONNECT_DATA =(SID=GEM)))';

      After successfull creation when I am tryin to select * from dual@ROGEM_110000 it is giving "ORA-12560-TNS Protocol Adaptaer Error".
      Please suggest what to check?