Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

TNS:could not resolve service name

Lalo Weng
Contributor

TNS:could not resolve service name

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.
4 REPLIES
Printaporn_1
Esteemed Contributor

Re: TNS:could not resolve service name

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.
enjoy any little thing in my life
Lalo Weng
Contributor

Re: TNS:could not resolve service name

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
Honored Contributor

Re: TNS:could not resolve service name

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?
what you do not see does not mean you should not believe
Steve Slade
Frequent Advisor

Re: TNS:could not resolve service name

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.
If at first you do not succeed. Destroy all evidence that you even attempted.