Re: Listener error ORA-12541

Yes, I can connect to the database with both server manager and SQL*PLUS while on the server. So the listener.ora file is configured correctly. The local tnsnames.ora file I also believe is configured correctly because I can log into other databases on different servers just fine and they are all configured the same way.

In article <8icp98$9rp$1_at_nnrp1.deja.com>,   sigdock_at_my-deja.com wrote:
> 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.
>

--
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.