| Unable to start listener [message #496339] |
Sun, 27 February 2011 01:13  |
AviatoR
Messages: 43
Registered: February 2009
|
Member |
|
|
Hi gurus,
I could not able to start the listener if i have named it other than the default name: LISTENER and the default Port:1521
if I name it list and port : 9999 it is throwing an error as
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 27-FEB-2011 13:02:23
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /oraeng/app/oracle/product/11.1.0/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.1.0.6.0 - Production
System parameter file is /oraeng/app/oracle/product/11.1.0/listener.ora
Log messages written to /oraeng/app/oracle/product/11.1.0/log/diag/tnslsnr/server1/list/alert/log.xml
TNS-01151: Missing listener name, list, in LISTENER.ORA
Listener failed to start. See the error message(s) above...
Should i have to do some changes in sqlnet.ora for overriding the default settings? pls help me
|
|
|
|
|
|
| Re: Unable to start listener [message #496342 is a reply to message #496340] |
Sun, 27 February 2011 02:43  |
AviatoR
Messages: 43
Registered: February 2009
|
Member |
|
|
My listener name is List
Port : 9999
SID=joe
$lsnrctl start list
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 27-FEB-2011 13:02:23
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /oraeng/app/oracle/product/11.1.0/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.1.0.6.0 - Production
System parameter file is /oraeng/app/oracle/product/11.1.0/listener.ora
Log messages written to /oraeng/app/oracle/product/11.1.0/log/diag/tnslsnr/server1/list/alert/log.xml
TNS-01151: Missing listener name, list, in LISTENER.ORA
Listener failed to start. See the error message(s) above...
default Listener name in Oracle:Listener
Default Port Number:1521
but when i start the listener with the default name it still gets started and associates itself with the instance which is currently running.
Note: This entry of the default listener is not at all present inside the listener.ora file.
[oracle11g@server1 ~]$ lsnrctl start listener
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 27-FEB-2011 14:30:47
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /oraeng/app/oracle/product/11.1.0/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.1.0.6.0 - Production
System parameter file is /oraeng/app/oracle/product/11.1.0/listener.ora
Log messages written to /oraeng/app/oracle/product/11.1.0/log/diag/tnslsnr/server1/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server1)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias listener
Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date 27-FEB-2011 14:30:48
Uptime 0 days 0 hr. 0 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oraeng/app/oracle/product/11.1.0/listener.ora
Listener Log File /oraeng/app/oracle/product/11.1.0/log/diag/tnslsnr/server1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server1)(PORT=1521)))
The listener supports no services
The command completed successfully
Note: This entry of the default listener is not at all present inside the listener.ora file.
[oracle11g@server1 ~]$ lsnrctl status listener
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 27-FEB-2011 14:31:56
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias listener
Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date 27-FEB-2011 14:30:48
Uptime 0 days 0 hr. 1 min. 8 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oraeng/app/oracle/product/11.1.0/listener.ora
Listener Log File /oraeng/app/oracle/product/11.1.0/log/diag/tnslsnr/server1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server1)(PORT=1521)))
Services Summary...
Service "joe" has 1 instance(s).
Instance "joe", status READY, has 1 handler(s) for this service...
Service "joe_XPT" has 1 instance(s).
Instance "joe", status READY, has 1 handler(s) for this service...
The command completed successfully
Listener.ora
LIST =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.1)(PORT=9999))
(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))
)
)
)
SID_LIST_LIST =
(SID_LIST=
(SID_DESC=
(SID_NAME=joe)
(ORACLE_HOME=/oraeng/app/oracle/product/11.1.0)
)
)
[Edit MC: remove lines in comment in listener.ora and format the post]
[Updated on: Sun, 27 February 2011 02:51] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
| Re: Unable to start listener [message #496351 is a reply to message #496344] |
Sun, 27 February 2011 03:40 |
AviatoR
Messages: 43
Registered: February 2009
|
Member |
|
|
still the same error...
$lsnrctl start LIST
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 27-FEB-2011 15:41:23
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /oraeng/app/oracle/product/11.1.0/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.1.0.6.0 - Production
System parameter file is /oraeng/app/oracle/product/11.1.0/listener.ora
Log messages written to /oraeng/app/oracle/product/11.1.0/log/diag/tnslsnr/server1/list/alert/log.xml
TNS-01151: Missing listener name, list, in LISTENER.ORA
Listener failed to start. See the error message(s) above...
[Updated on: Sun, 27 February 2011 03:41] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
| Re: Unable to start listener [message #496386 is a reply to message #496342] |
Sun, 27 February 2011 11:03 |
John Watson
Messages: 8966
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Hi - if I were you, I would re-create the listener.ora file, and make it much simpler. Delete it, and create a new one with one line:
LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.1)(PORT=9999)))
and now try to start it.
|
|
|
|
|
|
| Re: Unable to start listener [message #496469 is a reply to message #496392] |
Mon, 28 February 2011 06:55 |
AviatoR
Messages: 43
Registered: February 2009
|
Member |
|
|
Quote:Hi - if I were you, I would re-create the listener.ora file, and make it much simpler. Delete it, and create a new one with one line
I STEPPED IN AS 'YOU' AND DID THE SAME THING BY MAKING IT AS ONE LINE. IT BECAME A FLOP. TRY TO GIVE SOME RESOLVING ANSWERS INSTEAD OF WASTING TIME.
Quote:And even you had not to scan the 100 comment lines I deleted
MICHEAL I THOUGHT YOU COULD SOLVE THIS ISSUE, BUT I WAS WRONG.
NOTE: IF SOMEONE COMES WITH A PROBLEM TRY TO RESOLVE THAT WITHOUT MOCKING AND PRICKING LIKE HOW JOHN HAS WRITTEN IF WERE U!! I BECAME LIKE HIM AND NOTHING HAPPENED!!
[Updated on: Mon, 28 February 2011 06:58] Report message to a moderator |
|
|
|
| Re: Unable to start listener [message #496472 is a reply to message #496469] |
Mon, 28 February 2011 07:27 |
 |
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
I will no more waste my time to try to help you but will remind you to read the OraFAQ Forum Guide and not post in UPPER case and not use IM/SMS speak but be polite and patient, we do not owe you anything; remember we spent time from our sunday morning for you.
You know you should not feedback ONLY when you don't get a complete answer to your question but you should also, or better only, feedback when you do get one and then thank people that helped you (review all your previous topics).
Regards
Michel
[Updated on: Mon, 28 February 2011 07:32] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
