-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|