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

On Feb 9, 8:46 am, "Bobby" <bobby.ow..._at_talktalk.net> wrote:
> 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

Is that the tnsnames.ora on the remote machine?

Show us:

1) the tnsnames.ora on the remote (client) machine
2) the sqlnet.ora on the client machine
3) the output of 'lsnrctl status' on the db server machine.