Re: What is "TNS:name lookup failure"?

In article <01be439d$4ed941a0$c4d14090_at_wspc0117>,   "Miguel Pinto" <j-miguel-pinto_at_telecom.pt> wrote:
> Hi experts,
>
> ORA-12545 "TNS:name lookup failure"
> // *Cause: A protocol specific ADDRESS parameter cannot be resolved.
> // *Action: Ensure the ADDRESS parameters have been entered correctly;
> // the most likely incorrect value is the node name.
>
> What this means?
>
> thanx
> regards
> Miguel
>

Greetings, Manuel,

This message means that you have an error in your tnsnames.ora file. SQL*Net cannot figure out what database on which server you're trying to connect to. Since SQL*Net is EXTREMELY finicky about how this file is configured (one stray parenthesis, or equal sign, or space, and this file will not work), I suggest you use the SQL*Net Easy Configuration Utility included as part of the Oracle Client for Windows to configure this file. Oracle's stated policy is that they will not support you if you configure this file yourself.

As an example, for a database called 'dev1' on a server called 'picard' ( my example is for UNIX, TCP/IP; I haven't worked with Oracle on NT, and so I can't tell you about that). If you don't have DNS name resolution, you may have to use the IP address, in this example 134.77.177.50:

dev1.world =
  (DESCRIPTION =

     (ADDRESS_LIST =
        (ADDRESS =
           (COMMUNITY = tcp.world)
           (PROTOCOL = TCP)
           (Host = 134.77.177.50)
           (Port = 1521)
         )
      )
      (CONNECT_DATA  = (SID = dev1)
      )

For more information, you want to check out the "Understanding SQL*Net", "Oracle Network Products Troubleshooting Guide", and "Oracle Network Products" manuals. Hope this helps

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Jan 20 1999 - 17:06:35 CST