Home » SQL & PL/SQL » Client Tools » ORA-12541: TNS :No listener (Oracle 10g, Toad 9.1)
ORA-12541: TNS :No listener [message #606419] Thu, 23 January 2014 11:03 Go to next message
thelearner
Messages: 110
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.
Re: ORA-12541: TNS :No listener [message #606420 is a reply to message #606419] Thu, 23 January 2014 11:13 Go to previous messageGo to next message
BlackSwan
Messages: 22542
Registered: January 2009
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.
Re: ORA-12541: TNS :No listener [message #606421 is a reply to message #606420] Thu, 23 January 2014 11:29 Go to previous messageGo to next message
thelearner
Messages: 110
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
Re: ORA-12541: TNS :No listener [message #606422 is a reply to message #606421] Thu, 23 January 2014 11:32 Go to previous messageGo to next message
BlackSwan
Messages: 22542
Registered: January 2009
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?
Re: ORA-12541: TNS :No listener [message #606423 is a reply to message #606422] Thu, 23 January 2014 11:39 Go to previous messageGo to next message
thelearner
Messages: 110
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?
Re: ORA-12541: TNS :No listener [message #606424 is a reply to message #606423] Thu, 23 January 2014 11:50 Go to previous message
Michel Cadot
Messages: 58632
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

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


Current Time: Thu Jul 31 04:45:07 CDT 2014

Total time taken to generate the page: 0.13773 seconds