Home » RDBMS Server » Networking and Gateways » Unable to start listener (Oracle 11g (11.1.0) RHEL 4 32 bit)
Unable to start listener [message #496339] Sun, 27 February 2011 01:13 Go to next message
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 #496340 is a reply to message #496339] Sun, 27 February 2011 01:33 Go to previous messageGo to next message
Michel Cadot
Messages: 67462
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post
1/ The command you executed
2/ The content of listener.ora

Regards
Michel
Re: Unable to start listener [message #496342 is a reply to message #496340] Sun, 27 February 2011 02:43 Go to previous messageGo to next message
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 #496343 is a reply to message #496342] Sun, 27 February 2011 02:48 Go to previous messageGo to next message
Michel Cadot
Messages: 67462
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ When you post something, please remove the lines in comment, they are just misleading.
2/ Are you sure you posted /oraeng/app/oracle/product/11.1.0/listener.ora

Regards
Michel
Re: Unable to start listener [message #496344 is a reply to message #496343] Sun, 27 February 2011 02:54 Go to previous messageGo to next message
Michel Cadot
Messages: 67462
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is this not clearer without the comments and when post is formatted?

3/ Try LIST in upper case.

Regards
Michel
Re: Unable to start listener [message #496351 is a reply to message #496344] Sun, 27 February 2011 03:40 Go to previous messageGo to next message
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 #496353 is a reply to message #496351] Sun, 27 February 2011 03:42 Go to previous messageGo to next message
AviatoR
Messages: 43
Registered: February 2009
Member
sorry hereafter i'll follow the format...

I tried already the upper case... anyhow for your sake i did it again... the same error which is displayed above.. do we have to change anything in the sqlnet.ora file???

[Updated on: Sun, 27 February 2011 04:14]

Report message to a moderator

Re: Unable to start listener [message #496358 is a reply to message #496353] Sun, 27 February 2011 04:19 Go to previous messageGo to next message
Michel Cadot
Messages: 67462
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
do we have to change anything in the sqlnet.ora file???

No?

Quote:
2/ Are you sure you posted /oraeng/app/oracle/product/11.1.0/listener.ora?


Regards
Michel
Re: Unable to start listener [message #496376 is a reply to message #496358] Sun, 27 February 2011 07:01 Go to previous messageGo to next message
AviatoR
Messages: 43
Registered: February 2009
Member
Quote:
Are you sure you posted /oraeng/app/oracle/product/11.1.0/listener.ora?


YES
Re: Unable to start listener [message #496382 is a reply to message #496376] Sun, 27 February 2011 09:04 Go to previous messageGo to next message
BlackSwan
Messages: 26747
Registered: January 2009
Location: SoCal
Senior Member
a single listener.ora can support multiple listeners so why does default listener not appear in posted listener.ora?
Re: Unable to start listener [message #496386 is a reply to message #496342] Sun, 27 February 2011 11:03 Go to previous messageGo to next message
John Watson
Messages: 8394
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 #496392 is a reply to message #496386] Sun, 27 February 2011 12:24 Go to previous messageGo to next message
Michel Cadot
Messages: 67462
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And even you had not to scan the 100 comment lines I deleted. Wink

Regards
Michel
Re: Unable to start listener [message #496469 is a reply to message #496392] Mon, 28 February 2011 06:55 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 67462
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: Unable to start listener [message #496476 is a reply to message #496472] Mon, 28 February 2011 08:18 Go to previous messageGo to next message
AviatoR
Messages: 43
Registered: February 2009
Member
Thank you micheal. I was polite and acknowledging my mistakes but what happened in turn mocking and pricking?!! anyhow thanks for your time.
Re: Unable to start listener [message #496477 is a reply to message #496476] Mon, 28 February 2011 08:24 Go to previous messageGo to next message
Michel Cadot
Messages: 67462
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There was no mocking, just people that take some ease on week-end, nothing against you personally.

Regards
Michel
Re: Unable to start listener [message #499251 is a reply to message #496477] Mon, 14 March 2011 05:04 Go to previous messageGo to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
1. echo $TNS_ADMIN
2. vi /oraeng/app/oracle/product/11.1.0/listener.ora


Ridhi Sundar
Re: Unable to start listener [message #500534 is a reply to message #496339] Tue, 22 March 2011 01:39 Go to previous message
AviatoR
Messages: 43
Registered: February 2009
Member
thanks guyz issue solved... especially micheal,john, sundar... thanks for your time

[Updated on: Tue, 22 March 2011 01:39]

Report message to a moderator

Previous Topic: Urgent:Getting intermitant connection to DB
Next Topic: ORA-12154: TNS:could not resolve the connect identifier specified
Goto Forum:
  


Current Time: Sat Oct 24 16:27:31 CDT 2020