Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!news.tele.dk!news.tele.dk!small.news.tele.dk!newsgate.cistron.nl!feeder1.cambrium.nl!feed.tweaknews.nl!62.58.50.20.MISMATCH!nntpfeed.zonnet.nl!newsfeeder.wxs.nl!divide.nova.planet.nl!posting.nova.planet.nl!not-for-mail From: "Raymond" Newsgroups: comp.databases.oracle.server References: <42cb0556$0$17812$ba620dc5@text.nova.planet.nl> <42cc50f5$0$2453$ba620dc5@text.nova.planet.nl> <55loc1dmf05cmb2a2psfip23solvtbtmd0@4ax.com> <42ccc6fd$0$2944$ba620dc5@text.nova.planet.nl> <8mrqc1te2mk40glrfs7gl4jd8hnb6v26ej@4ax.com> Subject: Re: TNS no listener Oracle10g redhat es Date: Thu, 7 Jul 2005 22:52:17 +0200 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Lines: 46 Message-ID: <42cd95ca$0$16007$ba620dc5@text.nova.planet.nl> NNTP-Posting-Host: 62.131.5.105 X-Trace: 1120769482 text.nova.planet.nl 16007 62.131.5.105:65181 X-Complaints-To: abuse@planet.nl Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:246798 > > 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