Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!news.maxwell.syr.edu!sn-xit-03!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: "Sybrand Bakker" Newsgroups: comp.databases.oracle.server,comp.databases.oracle.tools Subject: Re: SQLPlus & TNSListener Date: Tue, 9 Sep 2003 19:03:28 +0200 Organization: Posted via Supernews, http://www.supernews.com Message-ID: Reply-To: "Sybrand Bakker" References: <3f5df937$0$13301$626a54ce@news.free.fr> X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Complaints-To: abuse@supernews.com Lines: 32 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:242706 comp.databases.oracle.tools:82896 "Malderez Cédric" wrote in message news:3f5df937$0$13301$626a54ce@news.free.fr... > Hello !! > > I've just installed Oracle 8.1.7 on W2k Pro > I've created 2 database Base1 & Base2 > And I need to access to them using SQLPlus > > But I keep having the following error code ORA 12541: TNS : No Listener > > I dont understand .. the TNSListener service is running > It's configuration file "tnslistener.ora" is well formated > "tnsname.ora" is also well formated > > Anyone has an idea ? > > Thanks ! > > The correct configuration file for TNSlistener is *listener.ora*, not tnslistener.ora -- Sybrand Bakker Senior Oracle DBA to reply remove '-verwijderdit' from my e-mail address