Home » RDBMS Server » Networking and Gateways » ORA-12541: TNS:no listener but instance showing in lsnrctl satus (11.2.0.1.0/WinXP/Oracle Personal Edition)
ORA-12541: TNS:no listener but instance showing in lsnrctl satus [message #506606] Tue, 10 May 2011 05:35 Go to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
Hi all,

Its been ages since I've looked at this so I think its me being stupid, however if one of you folks could point out where, that'd be lovely Smile


I've got two instances of oracle on this PC for teting/messing around with. The second one is a recent addition and its causing me some connection headaches.


Both instances are running on the same physical PC (this one) and there is a single listener.

C:\Documents and Settings\mkr02\Desktop>sqlplus scott/tiger@ora11ggg

SQL*Plus: Release 11.2.0.1.0 Production on Tue May 10 11:19:02 2011

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

ERROR:
ORA-12541: TNS:no listener



Results of lsnrctl status
C:\Documents and Settings\mkr02\Desktop>lsnrctl status

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 10-MAY-2011 11:19:07

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=LIVLT0132117.bskyb.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
Start Date                10-MAY-2011 07:48:34
Uptime                    0 days 3 hr. 30 min. 37 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\ORA11G\product\11.2.0\dbhome_1\network\admin\listener.ora
Listener Log File         c:\ora11g\diag\tnslsnr\LIVLT0132117\listener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=LIVLT0132117.bskyb.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "ORA11GGGXDB" has 1 instance(s).
  Instance "ora11ggg", status READY, has 1 handler(s) for this service...
Service "ORA11GMKXDB" has 1 instance(s).
  Instance "ora11gmk", status READY, has 1 handler(s) for this service...
Service "ora11ggg" has 1 instance(s).
  Instance "ora11ggg", status READY, has 1 handler(s) for this service...
Service "ora11gmk" has 1 instance(s).
  Instance "ora11gmk", status READY, has 1 handler(s) for this service...
The command completed successfully


Results of lsnrctl service
C:\Documents and Settings\mkr02\Desktop>lsnrctl service

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 10-MAY-2011 11:19:10

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=LIVLT0132117.bskyb.com)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "ORA11GGGXDB" has 1 instance(s).
  Instance "ora11ggg", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER <machine: LIVLT0132117, pid: 4652>
         (ADDRESS=(PROTOCOL=tcp)(HOST=LIVLT0132117.bskyb.com)(PORT=1205))
Service "ORA11GMKXDB" has 1 instance(s).
  Instance "ora11gmk", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER <machine: LIVLT0132117, pid: 4568>
         (ADDRESS=(PROTOCOL=tcp)(HOST=LIVLT0132117.bskyb.com)(PORT=1204))
Service "ora11ggg" has 1 instance(s).
  Instance "ora11ggg", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:273 refused:6 state:ready
         LOCAL SERVER
Service "ora11gmk" has 1 instance(s).
  Instance "ora11gmk", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:268 refused:5 state:ready
         LOCAL SERVER
The command completed successfully


listener.ora
# listener.ora Network Configuration File: 
C:\ORA11g\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\ORA11g\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:\ORA11g\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = LIVLT0132117.bskyb.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = C:\ORA11g


sqlnet.ora
# This file is actually generated by netca. But if customers choose to 
# install "Software Only", this file wont exist and without the native 
# authentication, they will not be able to connect to the database on NT.

NAMES.DIRECTORY_PATH=(TNSNAMES)
SQLNET.AUTHENTICATION_SERVICES = (NTS)




As I said, I have no doubt I've done something stupid, but any advice would be gratefully received, if you need anything else posted just say the word.

Thanks.

[Updated on: Tue, 10 May 2011 05:38] by Moderator

Report message to a moderator

Re: ORA-12541: TNS:no listener but instance showing in lsnrctl satus [message #506611 is a reply to message #506606] Tue, 10 May 2011 05:40 Go to previous messageGo to next message
Michel Cadot
Messages: 67462
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
tnsnames.ora is missing and this is the starting point to investigate your problem.

Regards
Michel
Re: ORA-12541: TNS:no listener but instance showing in lsnrctl satus [message #506615 is a reply to message #506611] Tue, 10 May 2011 05:53 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
tnsnames.ora
ORA11GMK=
   (DESCRIPTION=
            (ADDRESS=(PROTOCOL=TCP)(Host=127.0.0.1)(Port=1521))
            (CONNECT_DATA=(SID=ORA11GMK))
)

ORA11GGG =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1522))
    (CONNECT_DATA =(SID = ORA11GGG))
  )


I did note a couple of oddities, which I've altered to above, issue persists after restarting listener however.


Edit: Gut feel is its something I've not done with the ports.

Edit2: Correcting the port in the second entry to 1521 resolves it, however I had thought [clearly in error] that the different instances had to sit on different ports? Was that maybe just for enterprise manager?

[Updated on: Tue, 10 May 2011 05:58]

Report message to a moderator

Re: ORA-12541: TNS:no listener but instance showing in lsnrctl satus [message #506619 is a reply to message #506615] Tue, 10 May 2011 05:58 Go to previous messageGo to next message
Michel Cadot
Messages: 67462
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Your entry ORA11GGG asks for listener on port 1522, your listener port is 1521 so one is listening to your request.

Regards
Michel
Re: ORA-12541: TNS:no listener but instance showing in lsnrctl satus [message #506620 is a reply to message #506619] Tue, 10 May 2011 05:59 Go to previous messageGo to next message
Michel Cadot
Messages: 67462
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I had thought [clearly in error] that the different instances had to sit on different ports?

No they do not need to.

Regards
Michel
Re: ORA-12541: TNS:no listener but instance showing in lsnrctl satus [message #506623 is a reply to message #506620] Tue, 10 May 2011 06:06 Go to previous message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
Now to find the damned place I read something like that for to get it cleared up in my mind!

Thanks for confirming (nicely) I was being thick though Very Happy


Edit: Can't find exact quote but it was definitely in regard to database control/enterprise manager needing multiple ports, not the instance.

Stupid aging memory.

[Updated on: Tue, 10 May 2011 06:15]

Report message to a moderator

Previous Topic: TNS-01106
Next Topic: ORA 12514
Goto Forum:
  


Current Time: Sat Oct 24 15:44:58 CDT 2020