OraFAQ Forum: Client Tools » ORA-12541: TNS :No listener

Home » Other » Client Tools » ORA-12541: TNS :No listener (Oracle 10g, Toad 9.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12541: TNS :No listener [message #606419]

Thu, 23 January 2014 11:03

thelearner
Messages: 133
Registered: April 2013
Location: INDIA

Senior Member

Hi,

I changed my computer Name(system). after that it showing
ORA-12541: TNS :No listener

I updated the system name in Tnsnames file.....
I restarted all the services also....
But it showing the above error

How to resolve this issue.

Report message to a moderator

Re: ORA-12541: TNS :No listener [message #606420 is a reply to message #606419]

Thu, 23 January 2014 11:13

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

post results from OS command below that run on DB Server

lsnrctl status

12541, 00000, "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 (or TNSNAV.ORA if the connection is to
// go by way of an Interchange). Start the listener on the remote machine.
This error can result when listener has not been started or Firewall exists between client & DB server.

Report message to a moderator

Re: ORA-12541: TNS :No listener [message #606421 is a reply to message #606420]

Thu, 23 January 2014 11:29

thelearner
Messages: 133
Registered: April 2013
Location: INDIA

Senior Member

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 23-JAN-2014 22:55
:13

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 23-JAN-2014 22:25:09
Uptime 0 days 0 hr. 30 min. 9 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File H:\app\system\product\11.2.0\dbhome_1\network\admin\
listener.ora
Listener Log File h:\app\system\diag\tnslsnr\Oracle-PC\listener\alert\
log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1522ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1522)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully

Report message to a moderator

Re: ORA-12541: TNS :No listener [message #606422 is a reply to message #606421]

Thu, 23 January 2014 11:32

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1522)))
no remote client can ever connect to listener using 127.0.0.1
why using non-standard port 1522?

Report message to a moderator

Re: ORA-12541: TNS :No listener [message #606423 is a reply to message #606422]

Thu, 23 January 2014 11:39

thelearner
Messages: 133
Registered: April 2013
Location: INDIA

Senior Member

Actually I installed two DBs in one Opearting system(windows 7).
One is 10g and another one is 11g

10g for normal purpose (port number:1521).
11g for OBIEE purpose (port number:1522).

Is there is any conflicts will come?

Report message to a moderator

Re: ORA-12541: TNS :No listener [message #606424 is a reply to message #606423]

Thu, 23 January 2014 11:50

Michel Cadot
Messages: 68506
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You don't need 2 listeners. Keep only the 11g one.

Report message to a moderator

Previous Topic:	TOAD with Oracle and MS SQL Server
Next Topic:	set serverouput off in sql developer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 27 23:41:41 CDT 2023