Berj,
try using IP address in both listener.ora and tnsnames.ora (server/client)
to see if there are problems with name resolution.
Check also the port and the domain settings.
--
be happy
Eugenio
remove _nospam from reply address
Opinions are mine and do not necessarily reflect those of my company
=======================================================
berj_kacherian_not_at_hotmail.com wrote in message
<8im1ri$2vl$1_at_nnrp1.deja.com>...
>Yes, I have checked that. The listener.ora file on the server is
>configured correctly. I am able to connect to the database directly on
>ther server with both server manager and sql*plus.
>
>The local tnsnames.ora file also seems to be configured correctly
>because I have many entries in there and I can hit the other databases
>on different boxes, just not the one on this particular box. As an
>added note, I can ping this box, I just cannot tnsping it.
>
>Berj
>
>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.
Received on Tue Jun 20 2000 - 00:00:00 CDT
