Re: TNS no listener Oracle10g redhat es

>
> A few remarks
> 1 there are two identical tns service names in your tnsnames.ora
> I'm not sure Oracle is going to buy that.
> 2 The listener.ora doesn't support your SID, the sid_list_listener is
> incomplete, and needs a
> > (SID_DESC =
> >
> > (SID_NAME = vino)
> >
> > (ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1)
> >
> > )
> in it.
>
> Right now the listener.ora will support the service_name = vino in
> your tnsnames.ora only, provided the service_name (defaults to db_name
> if db_domain is '' and db_name||'.'||db_domain when db_domain is non
> blank) is actually vino.
> If the service_name isn't vino, no joy.
>
> The listener.ora needs to be corrected, I would make sure the
> tnsnames.ora is corrected as well (different tns service_names)
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

OK,

I added the lines SID_DESC etc as you described, still no go. But also changing the host name into the IP adress: bingo!

Might this be related to the fact that I'm using DHCP for IP adress assigning? Btw, I always assigning the same addres!

Left the tnsnames on the client as is!

OK, many thanks Sybrand (and the others) for all the input!

Raymond Received on Thu Jul 07 2005 - 15:52:17 CDT