TNS:could not resolve service name

[Lalo Weng]

Hi, Pls.give me a hand.
There is a Oracle 8 database in the HP-UX server. And I have been trying to access the database from my NB base on Win98. I have all oracle client package installed including Sql*net easy config. and sqlplus,etc. I config the service name with sql*net easy config.which is correct as I can issue the command: tnsping service-name on my NB successfully. The problem is I can't access the database in sqlplus on my NB, I got the error message is: TNS: could not resolve service name. Pls. help.

Thanks.

[Printaporn_1]

Hi,

Another 2 points that have to think about is

1. sqlnet.ora file for db domain.
2. oracle client version

first isolate problem by try sqlplus in db server , if this work , copy tnsnames.ora to NT.

[Lalo Weng]

Thanks. I tried sqlplus on db server as your advice,and copied tnsnames.ora to my NB. Same error message when I launch sqlplus on my Win98....

[Joseph Loo]

Are you able to ping the DB server by hostname as well as by IP address depending on your tnsnames.ora?

By the way, your tnsnames.ora may be the one causing the problem. So would you be able to send me the sqlnet.log file as well as the tnsnames.ora?

[Steve Slade]

Hi,

Another thought is that could be something to do with versions or something. Other than that as far as I remember Oracle looks in two places.

1. If the registry key TNS_ADMIN is defined then it will look in that location.
2. Otherwise it will look in the location ORACLE_HOME/network/admin again where ORACLE_HOME is as defined by as the default Oracle Home.

Another option might be to switch on tracing in the sqlnet.ora file. Change the entry from
TRACE_LEVEL_CLIENT = OFF
to
TRACE_LEVEL_CLIENT = ADMIN

That might give you some more info.