Listener error ORA-12541

I am getting the above error when trying to connect to the database from my desktop.

The listener is up and working. I can ping the server from my desktop, but cannot tnsping the database. I get TNS-12541: TNS:no listener.

Here is what the trace file looks like. It is long, but it is for one session only. Looks like it is not able to connect to socket 120. What does that mean?

• TRACE CONFIGURATION INFORMATION FOLLOWS --- New trace stream is "c:\oracle\ora81\network\log\sqlnet.trc" New trace level is 16
• TRACE CONFIGURATION INFORMATION ENDS --- nigini: entry nigini: Count in NI global area now: 1 nigini: Count in NI global area now: 1 nrigbi: entry nrigbni: entry nrigbni: Unable to get data from navigation file tnsnav.ora nrigbni: exit nrigbi: exit nigini: exit niqname: Using nnfsn2a() to build connect descriptor for (possibly remote) database. nnftboot: entry nnftboot: exit nnfoboot: entry nnfoboot: exit nnfoboot: entry nnfoboot: exit nnfhboot: entry nnfhboot: exit nncpmlf_make_local_addrfile: construction of local names file failed nncpmsf_make_sys_addrfile: system names file is c:\Oracle\Ora81
  \network\admin\tnsnames.ora
  nncpcin_maybe_init: first request sent to name server will have ID 444 nncpcin_maybe_init: initial retry timeout for all name servers is 1500 csecs nncpcin_maybe_init: max request retries per name server is 1 nngsini_init_streams: initializing stream subsystem, cache size is 10 nngtini_init_msg: initializing PDU subsystem, initial pool size is 2 nncpcin_maybe_init: default name server domain is lakeland.homepagecorp.com nnfun2a: entry nlolgobj: entry nnfgrne: entry nnftqnm: entry nnfcagmd: entry nnfcagmd: Attempting to find metadata for type a.smd nnfcagmd: Attribute name a.smd is a predefined meta type, syntax is 4. nnfcagmd: exit nnfotran: Checking local tnsnames.ora file nnfotran: Checking local tnsnames.ora file nncpldf_load_addrfile: initial load of names file c:\Oracle\Ora81
  \network\admin\tnsnames.ora
  nncpldf_load_addrfile: success nnftqnm: Using tnsnames.ora address (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(HOST = hpqwestdb.br8.com)(PORT = 1521))) (CONNECT_DATA = (SID = baseline))) for name baseline.world nnfcraa: entry nnftans: entry nnfcran: entry nnfcran: 64 rrs requested, 1 remaining, 1 total nnfcran: exit nnfgrne: exit nlolgserv: entry nnfggav: entry nnfggav: exit nnfgfrm: entry nnfgfrm: exit nlolgserv: exit nlolgobj: exit nlolfmem: entry nlolfmem: exit nnfgdei: entry nngsdei_deinit_streams: deinit nngscls_close_stream: UID 0 not established, ignored nngscls_close_stream: UID 0 not established, ignored nngscls_close_stream: UID 0 not established, ignored nngscls_close_stream: UID 0 not established, ignored nngscls_close_stream: UID 0 not established, ignored nngscls_close_stream: UID 0 not established, ignored nngscls_close_stream: UID 0 not established, ignored nngscls_close_stream: UID 0 not established, ignored nngscls_close_stream: UID 0 not established, ignored nngscls_close_stream: UID 0 not established, ignored nsbfrfl: entry nsbfrfl: normal exit nnfgdei: exit nladini: entry nladini: exit niotns: entry niotns: niotns: setting up interrupt handler... niotns: Not trying to enable dead connection detection. niotns: Calling address: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS= (COMMUNITY=tcp.world)(PROTOCOL=TCP)(HOST=hpqwestdb.br8.com)(PORT=1521))) (CONNECT_DATA=(SID=baseline)(CID=(PROGRAM=C:\ORACLE\ORA81
  \BIN\SQLPLUSW.EXE)(HOST=9428H)(USER=berj))))
  nladget: entry nladget: exit nscall: entry nscall: connecting... nsc2addr: entry nttbnd2addr: entry nttbnd2addr: port resolved to 1521 nttbnd2addr: looking up IP addr for host: hpqwestdb.br8.com nttbnd2addr: exit nsc2addr: normal exit nsopen: entry nsmal: entry nsmal: 412 bytes at 0xed9e50 nsmal: normal exit nsopenmplx: entry nsmal: entry nsmal: 1676 bytes at 0xdf6ed8 nsmal: normal exit nsopenmplx: normal exit nsopen: opening transport... nttcon: entry nttcon: toc = 1 nttcnp: entry ntvlin: entry ntvllt: entry ntvllt: No PROTOCOL.ORA file is found ntvllt: exit ntvlin: exit nttcnp: Validnode Table IN use; err 0x0 nttcnp: creating a socket. nttcnp: exit nttcni: entry nttcni: trying to connect to socket 120. ntt2err: entry ntt2err: soc 120 error - operation=1, ntresnt[0]=511, ntresnt[1]=61, ntresnt[2]=0 ntt2err: exit nttcni: exit nttcon: exit nserror: entry nserror: nsres: id=0, op=65, ns=12541, ns2=12560; nt[0]=511, nt[1]=61, nt[2]=0 nsopen: unable to open transport nsbfr: entry nsbfr: normal exit nsmfr: entry nsmfr: 1676 bytes at 0xdf6ed8 nsmfr: normal exit nsmfr: entry nsmfr: 412 bytes at 0xed9e50 nsmfr: normal exit nsopen: error exit nscall: error exit nioqper: error from nscall nioqper: nr err code: 0 nioqper: ns main err code: 12541 nioqper: ns (2) err code: 12560 nioqper: nt main err code: 511 nioqper: nt (2) err code: 61 nioqper: nt OS err code: 0 niqme: entry niqme: reporting ns (2) error: (12541) as rdbms err (12541) niqme: exit nladget: entry nladget: exit nladtrm: entry nladtrm: exit niotns: Couldn't connect, returning 12541 nsbfrfl: entry nsbfrfl: normal exit nigtrm: Count in the NI global area is now 0 nnfgdei: entry nrigbd: entry nrigbd: exit nigtrm: Count in the NL global area is now 0

--
Out the Ethernet, past the firewall, through the router, down the
T1...nothing but Net

In order to email me remove the '_not' from my email address.


Sent via Deja.com http://www.deja.com/
Before you buy.