Re: SQLPlus & TNSListener

Are you doing tests while logged onto the server?

Are you doing tests while logged onto another machine/client-pc and does it have the correct tnsnames.ora file?

Can you ping (using TCP/IP ping command) the server from the client-pc?

Can you tnsping the databases ? Of course, sqlplus is the real/ultimate test if you have complete connectivity, but it could be useful info if you have good test with tnsping and not good tests with sqlplus.

Do you have any other *.ora files in the directory where you store the tnsnames.ora (other than listener.ora on the server)? Or, do you have any *.ora files anywhere else on the client-pc or server?

Are you mistakenly pointing to another location for tnsnames.ora other than the default? Do you have any TNS_ADMIN entries in the registry? Do you have any environment variable named TNS_ADMIN? Is your tnsnames.ora stored in the default location (ORACLE_HOME\network\admin)?

Include the listener.ora and tnsnames.ora files (and other *.ora files) in your reply if possible. If the tnsnames.ora is large, then maybe just cut/paste the databases you are having problems with.

-
"Malderez Cédric" <cedric.malderez_at_answork.com> wrote in message news:3f5df937$0$13301$626a54ce_at_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 !
>
>
Received on Tue Sep 09 2003 - 21:26:17 CDT