5 Replies Latest reply: Apr 10, 2013 3:21 AM by Mkirtley-Oracle RSS

    Public Database Link Is Not working

    kiddoo_81
      Hi,

      I want to create a public database link between 2 database server in different physical place but under one intranet. After i create the public database link.. i keep having this error



      ORA-12154: TNS:could not resolve service name
      12154. 00000 - "TNS:could not resolve the connect identifier specified"


      *(Server 1 - German - 11gR2)*
      TNS:

      server1 =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 178.44.44.45)(PORT = 15210))
      )
      (CONNECT_DATA =
      (SID = server1)
      (SERVER = DEDICATED)
      )
      )




      *(Server 2 - Malaysia - 9iR2)*
      TNS:

      server2 =
      (DESCRIPTION =
      (FAILOVER = ON)
      (LOAD_BALANCE = OFF)
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 178.44.44.35)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 178.44.44.81)(PORT = 1521))
      )
      (SDU = 32777)
      (CONNECT_DATA =
      (SERVICE_NAME = PROD_server2 )
      )
      )



      I just want to create one way database link where server 2 can grab data on server 1, so I create my database link at server 2. However, i still having the problem. The following TNSi provided here is sample, but is work fine in here when connect using sql developer and sql navigator. (i think nothing wrong with the tns) but somehow the error message given is TNS:could not resolve service name. So i really don't know what went wrong.. PLEASE HELP~~



      ~Vincent.