Urgent: ORA-12541: TNS:no listener issue

Hi All,

I am facing a wierd issue. When I am trying to connect to oracle through SQLPlus from my laptop, I receive a ORA-12541: TNS:no listener error. The wierd thing is I could connect oracle thorugh Toad and its working fine. Also other applications(Siebel) are able to find tnsnames.ora and connect to the database.

I have installed and uninstalled Oracle multiple times and i recieve the same error. I am using the same tnsnames.ora thats used by my other team mates, which is working fine for them.

TNSPING also gives me the same error.

I used tracing to see the problem.

The following are the trace file snapshot.
=================================================
NOV-2006 10:46:28:923] nttbnd2addr: entry
[07-NOV-2006 10:46:28:923] nttgetport: entry
[07-NOV-2006 10:46:28:923] nttgetport: port resolved to 1522
[07-NOV-2006 10:46:28:923] nttgetport: exit
[07-NOV-2006 10:46:28:923] nttbnd2addr: looking up IP addr for host: dmnsiebel.tdmn.belo.com
[07-NOV-2006 10:46:28:933] nttbnd2addr: exit
[07-NOV-2006 10:46:28:933] nsmal: 492 bytes at 0xd73ad0
[07-NOV-2006 10:46:28:933] nsmal: 2348 bytes at 0xd73cc8
[07-NOV-2006 10:46:28:933] nsopen: opening transport...
[07-NOV-2006 10:46:28:933] nttcon: entry
[07-NOV-2006 10:46:28:933] nttcon: toc = 1
[07-NOV-2006 10:46:28:933] nttcnp: entry
[07-NOV-2006 10:46:28:933] ntvlin: entry
[07-NOV-2006 10:46:28:933] ntvllt: entry
[07-NOV-2006 10:46:28:933] ntvllt: tcp.validnode_checking not turned on
[07-NOV-2006 10:46:28:933] ntvllt: exit
[07-NOV-2006 10:46:28:933] ntvlin: exit
[07-NOV-2006 10:46:28:933] nttcnp: Validnode Table IN use; err 0x0
[07-NOV-2006 10:46:28:933] nttcnp: exit
[07-NOV-2006 10:46:28:933] nttcni: entry
[07-NOV-2006 10:46:28:933] nttcni: trying to connect to socket 1860.
[07-NOV-2006 10:46:29:053] ntt2err: entry
[07-NOV-2006 10:46:29:053] ntt2err: soc 1860 error - operation=1, ntresnt[0]=511, ntresnt[1]=61, ntresnt[2]=0
[07-NOV-2006 10:46:29:053] ntt2err: exit
[07-NOV-2006 10:46:29:053] nttcni: exit
[07-NOV-2006 10:46:29:053] nttcon: exit
[07-NOV-2006 10:46:29:053] nserror: nsres: id=0, op=65, ns=12541, ns2=12560; nt[0]=511, nt[1]=61, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[07-NOV-2006 10:46:29:053] nsopen: unable to open transport
[07-NOV-2006 10:46:29:053] nsmfr: 2348 bytes at 0xd73cc8
[07-NOV-2006 10:46:29:053] nsmfr: 492 bytes at 0xd73ad0
[07-NOV-2006 10:46:29:053] nladget: entry
[07-NOV-2006 10:46:29:053] nladget: exit
[07-NOV-2006 10:46:29:053] nsmfr: 164 bytes at 0xd65ef0
[07-NOV-2006 10:46:29:053] nladtrm: entry
[07-NOV-2006 10:46:29:053] nladtrm: exit
[07-NOV-2006 10:46:29:053] nioqper: error from nscall
[07-NOV-2006 10:46:29:053] nioqper: nr err code: 0
[07-NOV-2006 10:46:29:053] nioqper: ns main err code: 12541
[07-NOV-2006 10:46:29:053] nioqper: ns (2) err code: 12560
[07-NOV-2006 10:46:29:053] nioqper: nt main err code: 511
[07-NOV-2006 10:46:29:053] nioqper: nt (2) err code: 61
[07-NOV-2006 10:46:29:053] nioqper: nt OS err code: 0
[07-NOV-2006 10:46:29:053] niomapnserror: entry
[07-NOV-2006 10:46:29:063] niqme: entry
[07-NOV-2006 10:46:29:063] niqme: reporting NS-12541 error as ORA-12541
[07-NOV-2006 10:46:29:063] niqme: exit
[07-NOV-2006 10:46:29:063] niomapnserror: returning error 12541
[07-NOV-2006 10:46:29:063] niomapnserror: exit
[07-NOV-2006 10:46:29:063] niotns: Couldn't connect, returning 12541
[07-NOV-2006 10:46:29:113] niotns: exit
[07-NOV-2006 10:46:29:113] nigtrm: Count in the NI global area is now 0
[07-NOV-2006 10:46:29:113] nrigbd: entry
[07-NOV-2006 10:46:29:113] nrigbd: exit
[07-NOV-2006 10:46:29:113] nigtrm: Count in the NL global area is now 0

Can anybody help as I am with this problem for almost a week now.

Thanks in advance for your respone.

Regards
Prem

I'm assuming your using Windows. What are the values for your PATH and ORACLE_HOME environment variables?

They should point to the location you installed the client and under which your tnsnames.ora file is located.

Thanks for the response.

Yes I am using windows client and the following are the details:
Path=C:\oracle\product\9.2.0\client_3\bin
ORACLE_HOME=C:\oracle\product\9.2.0\client_3 (Infact I created this ORACLE_HOME variable since it was not installed default, but still toad was working).

Thanks

Well, one thing is sure, Toad is not using the same connection driver.

Can you ping the host listed in your tnsnames.ora file?

Both client and server are 9.2.x, right?

I can ping the host listed in tnsnames.ora and only thsping gives me the same error.

The server version of Oracle is 10.2 and every one in the team is using Oracle 9.2.x client to connect since its compatable with Toad (the version we use) and everybody else is able to connect.

Something is different!

Maybe I'm smokin crack here, but it looks like the server rejected the request (according to Oracle's published error text):

ORA-12541: TNS:no listener
Cause:
The connection request could not be completed because the listener is not running.
Action:
Ensure that the supplied destination address matches one of the addresses used by the listener - compare the TNSNAMES.ORA entry with the appropriate LISTENER.ORA file.

Is there a way that we can track as what exactly is going wrong apart from the normal tracing?

Is the database installed on your laptop or it is on another machine (server).
The TOAD maigth connect using other protocol or if it is TCP/IP the port where the listener listens could be different.
Log to the server and issue
lsnrctl status
(If it is windows do it in dos window)
see where exactly the listener listens ( protocol host port) and fix that in the tnsnames.ora

Good Luck

I even see the error in your trace
port resolved to 1522

Usually the listener listens on 1521

Change that in the tnsnames

the database is running on a different box and the port is configured to listen only at 1522. The listerner is up and running and I could connect with the same tnsnames.ora from other client machines as well.

Check if you have more than one ORACLE_HOME in your PATH environment variable.

It's got to be something simple.

Hi,
Well, the only thing I still can propose is
1) Change all host names with IPs - maybe host name is resolvd wrong
2) Try setting TRACE_LEVEL_CLIENT=16 in SQLNET.ORA. This is going to dump the entire network packages into the trace file and hopefully will help
3) Try connecting to the server, using easy connect ( I assume you use 10g)
That means instead of connect string specify host: port/service
4) Put here the output of lsnrctl status and the fragment of the tnsnames.ora you use

Good Luck

Hi,
If the host name or IP is incorrect, then the error would be TNS couldnt resolve service name. Thats fine and the client process is not finding any server process listening in the mentioned port. I suggest to try connect using sqlplusw and paste the error along with the error no in the forum. Pls ensure that u check the port number in the correct file.

I would disagree here! "TNS couldnt resolve service name" is an error, appearing when the string you entered in the 'connect string' field cannot be found in the tnsnames.ora (or to be precise - cannot be resolved to host:port:service_name) In case if tnsnames.ora contains such string and the string is resolved to HOST_NAME:port:sid, however DNS maps the host name to wrong IP address, where no database is installed at all, the error will be "No Listener" - I am pretty sure about that.
Anyway, the poster seems lost interes in that thread :-)

Regards

Thank you very much for the reply..but the problem was different.

The problem was I have the Check Point firewall in my system and it was blocking, but somehow other applications could overrode it. When I tried shutting down the firewall, it still didnt work, and I found out there is one more service is running at the background preventing it.

So finally I reinstalled the firewall and now I am able to connect.

Thanks every much for everyone who has responsed.

Regards