| ORA-12541: TNS:no listener but instance showing in lsnrctl satus [message #506606] |
Tue, 10 May 2011 05:35  |
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 
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 #506615 is a reply to message #506611] |
Tue, 10 May 2011 05:53  |
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 |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
