Databases
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