Re: newbe: ORA-12541: TNS:no listener

tjwatson_at_gmail.com wrote in
news:1121173876.235993.66460_at_f14g2000cwb.googlegroups.com:

> Hi, I know this error has been posted many times before but I really
> couldn't find anything that helped. I'd really appreciate any help in
> tracking down and resolving my problem:
>
> I put the 10_1 instant client on a Win2k server. I added the path to
> the executable to the PATH environment variable. When executing
> sqlplus I get an ORA-12541 error.
>
> I did this on an WinXP machine and it works, but I need it on the
> aforementioned Win2k box. Below is my tnsnames.ora file and one
> example from the sqlnet.log. For security I'v replaced hostnames etc
> with #.
>
> #please note the username passed to SQLPLUS is not the username
> #that is listed in the sqlnet.log file, that lists my windows
> #username: USER=twatson which I don't understand since I'm trying
> #to log in with USR123
> C:\oracle\instantclient10_1>SQLPLUS USR123/PASS123_at_WRS
>
> #tnsnames.ora file
> WRS =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = ###.##.###.##)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = RHDB)
> )
> )
>
> # example from sqlnet.log
> ***********************************************************************
> Fatal NI connect error 12541, connecting to:
>
> (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=###.##.###.##)(PORT=1521))(CO
> NNECT_DATA=(SERVICE_NAME=RHDB)(CID=(PROGRAM=C:\oracle\instantclient10_1
> \sqlplus.exe)(HOST=###)(USER=twatson))))
>
> VERSION INFORMATION:
> TNS for 32-bit Windows: Version 10.1.0.4.0 - Production
> Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version
> 10.1.0.4.0 - Production
> Time: 12-JUL-2005 07:39:27
> Tracing not turned on.
> Tns error struct:
> ns main err code: 12541
> TNS-12541: TNS:no listener
> ns secondary err code: 12560
> nt main err code: 511
> TNS-00511: No listener
> nt secondary err code: 61
> nt OS err code: 0
>
>

Which part of "TNS-12541: TNS:no listener" do you not understand?

What is returned by the following command... lsnrctl status Received on Tue Jul 12 2005 - 08:32:15 CDT