ORA-12154: TNS: could not resolve service name from remote machine

From: Bobby <bobby.owens_at_talktalk.net>
Date: 9 Feb 2007 06:46:47 -0800
Message-ID: <1171032407.816930.159530@s48g2000cws.googlegroups.com>

Hi,

I've just started trying to write a .NET 1.1 prototype application to access an oracle database using the "Oracle Data Provider". If I run the application on the DB server, it works fine. Remotely from my development machine however, I get the error mentioned in the subject of this post. It "did" however work for a bit but stopped when I closed all the config windows on both machines.

I have looked at other postings but cant find any suggestions that help :-(

I've rebooted the server, but not the development machine "yet"

I've checked the following:

DB Server

---

SQLPlus works fine to <user>/<password>@demo9 .NET Application works fine
sqlnet.ora authentication changed to (NONE) listener.ora has:

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = test-anite)(PORT = 1521))
      )

    )
  )

tnsnames.ora has:
DEMO9 =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = test-anite)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = demo9)

    )
  )

Development machine

---

SQLPlus returns "could not resovle" error .NET Application returns "could not resovle" error tnsping to the name of the DB server returns OK listener.ora has:
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = DEV-WS4)(PORT = 1521))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )

    )
  )

tnrnames.ora has:
DEMO9 =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = test-anite)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = demo9)

    )
  )

Does anyone have any suggestions?

Thanks in advance

Bobby Received on Fri Feb 09 2007 - 08:46:47 CST