"ORA-12154: TNS: could not resolve the connect identifier specified", only on one machine!

Last post 11-06-2009 2:39 PM by nishapd. 6 replies.

Sort Posts:

  • "ORA-12154: TNS: could not resolve the connect identifier specified", only on one machine!

    12-22-2006, 10:21 AM
    • Member
      325 point Member
    • Cameron
    • Member since 06-18-2002, 10:17 AM
    • Posts 68

    Hi,

    I am using two development machines connecting to a separate server in our organization. I am trying to connect to an Oracle database (9i) from VWD Database Explorer. On one of the development machines, everything is fine, no problem. On the other machine, I get:

    ORA-12154: TNS: could not resolve the connect identifier specified

    So, I am assuming the problem is with one of the development machines, but I can't figure out what the difference is between the two development computers. Does anyone ahve any ideas?

     

  • Re: "ORA-12154: TNS: could not resolve the connect identifier specified", only on one machine!

    12-22-2006, 10:39 AM
    • All-Star
      26,551 point All-Star
    • Caddre
    • Member since 06-23-2003, 9:53 AM
    • Indy
    • Posts 5,308

    I don't use VWD but check this thread for cause and possible solutions.  Hope this helps.

    http://forums.asp.net/thread/1498691.aspx

    Kind regards,
    Gift Peddie
  • Re: "ORA-12154: TNS: could not resolve the connect identifier specified", only on one machine!

    12-22-2006, 11:20 AM
    • Member
      325 point Member
    • Cameron
    • Member since 06-18-2002, 10:17 AM
    • Posts 68

    Sorry, but that thread deals with setting up two versions of Oracle on the same machine, which is not my case.

    I am connecting to the SAME oracle server from two machines. One machine is successful, the other ne is not.

  • Re: "ORA-12154: TNS: could not resolve the connect identifier specified", only on one machine!

    12-22-2006, 11:49 AM
    • All-Star
      26,551 point All-Star
    • Caddre
    • Member since 06-23-2003, 9:53 AM
    • Indy
    • Posts 5,308

    (Sorry, but that thread deals with setting up two versions of Oracle on the same machine)

    We don't know that, I think the original poster got his to work because he had the same version in his box. Here are two possible solutions.  Hope this helps.

    http://www.orafaq.com/forum/t/24165/0/

    http://www.embarcadero.com/jive/entry.jspa?externalID=337&categoryID=2

    Kind regards,
    Gift Peddie
  • Re: "ORA-12154: TNS: could not resolve the connect identifier specified", only on one machine!

    12-22-2006, 12:39 PM
    • Member
      325 point Member
    • Cameron
    • Member since 06-18-2002, 10:17 AM
    • Posts 68

    Thanks a lot, it is solved!!

  • Smile [:)] Re: "ORA-12154: TNS: could not resolve the connect identifier specified", only on one machine!

    12-22-2006, 12:40 PM
    • All-Star
      26,551 point All-Star
    • Caddre
    • Member since 06-23-2003, 9:53 AM
    • Indy
    • Posts 5,308
    Cameron:

    Thanks a lot, it is solved!!

    I am glad I could help.

    Kind regards,
    Gift Peddie
  • Re: "ORA-12154: TNS: could not resolve the connect identifier specified", only on one machine!

    11-06-2009, 2:39 PM
    • Member
      3 point Member
    • nishapd
    • Member since 04-09-2009, 10:17 AM
    • Posts 22

    How could you solved it ? I am having the same issue....

Page 1 of 1 (7 items)