newbe: ORA-12541: TNS:no listener

From: <tjwatson_at_gmail.com>
Date: 12 Jul 2005 06:11:16 -0700
Message-ID: <1121173876.235993.66460@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))(CONNECT_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 Received on Tue Jul 12 2005 - 08:11:16 CDT