Re: SQLPlus & TNSListener

[Quoted] [Quoted] Are you doing tests while logged onto the server?

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

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

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

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

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

[Quoted] Include the listener.ora and tnsnames.ora files (and other *.ora files) in [Quoted] your reply if possible. If the tnsnames.ora is large, then maybe just [Quoted] [Quoted] 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 Wed Sep 10 2003 - 04:26:17 CEST