Re: Listener error ORA-12541

Perhaps this is a stupid question but is your listener.ora-file on the server configured right? Are you able to connect to the datbase direct on the server with both Server Manager and SQL*Plus? If that works and connection from the client is still not possible check the (local) tnsnames.ora for any errors.

Bert Jan Meinders
Oracle DBA
ASR-ICT In article <8ibb12$b27$1_at_nnrp1.deja.com>,   berj_kacherian_not_at_hotmail.com wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jun 16 2000 - 00:00:00 CDT