Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
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.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

TNS:listener could not resolve SERVICE_NAME given in connect descriptor

Michele (Mike) Alberton
Regular Advisor

TNS:listener could not resolve SERVICE_NAME given in connect descriptor

Hi Folks,

I have an Oracle 9i on Host A and I would like to connect to it through Host B where I have another Oracle 9i.

I thought simply to add to sqlnet.ora my Host B IP address within the TCP.INVITED_NODES entry

How should I run the

Host B> sqlplus USER/PASSWORD@???

to reach Host A database ?

On Host A running

Host A> sqlplus USER/PASSWORD@NSMS

(NSMS being the Host A DB Service Name) works fine, but how am I supposed to run it from remote (Host B) ?

I know I should change my listener.ora and tnsnames.ora as well, but I'm not very familiar with it.

Thanks !

Mike
3 REPLIES
Claudio Cilloni
Honored Contributor

Re: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

Could you show your tnsnames.ora and sqlnet.ora files?

Ciao
Claudio
Michele (Mike) Alberton
Regular Advisor

Re: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

HI !

I've solved this one.

Host A sqlnet.ora shows:
##########################################################
# Filename......: sqlnet.ora
# Name..........:
# Date..........:
##########################################################
AUTOMATIC_IPC = ON
TRACE_LEVEL_CLIENT = ON
TRACE_FILE_CLIENT = /opt/oracle/product/9.2.0/network/trace/client.trc
SQLNET.EXPIRE_TIME = 10
#tcp.validnode_checking = yes
tcp.invited_nodes= (NSMS_R24,135.248.149.25)
tcp.excluded_nodes= (135.248.149.24)

Everything gpes fine from a remte host.

Thanks !

Mike
Michele (Mike) Alberton
Regular Advisor

Re: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

Just to be precise, forget the comment # before the
tcp.validnode_checking = yes


Cheers,

Mike