Home » Server Options » RAC & Failsafe » the listener can not listen service (11.2.0.1)
the listener can not listen service [message #607570] Mon, 10 February 2014 00:46 Go to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
In my RAC env,i added a listener named MY_LISTENER by manual,but it can not listen any service,how can i fix it?

LSNRCTL> show current_listener
Current Listener is LISTENER

LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 07-FEB-2014 23:04:23
Uptime 0 days 0 hr. 56 min. 48 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/grid/11.2.0/network/admin/listener.ora
Listener Log File /u01/grid/diag/tnslsnr/node1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=listener)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.50.199)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.50.251)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "RACDB" has 1 instance(s).
Instance "racdb1", status READY, has 1 handler(s) for this service...
Service "racdbXDB" has 1 instance(s).
Instance "racdb1", status READY, has 1 handler(s) for this service...
Service "s1" has 1 instance(s).
Instance "racdb1", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> set current_listener my_listener
Current Listener is my_listener

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=MY_LISTENER)))
STATUS of the LISTENER
------------------------
Alias MY_LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 07-FEB-2014 23:04:29
Uptime 0 days 0 hr. 57 min. 41 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/grid/11.2.0/network/admin/listener.ora
Listener Log File /u01/grid/diag/tnslsnr/node1/my_listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=MY_LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.50.199)(PORT=1522)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.50.251)(PORT=1522)))
The listener supports no services
The command completed successfully
Re: the listener can not listen service [message #607572 is a reply to message #607570] Mon, 10 February 2014 01:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You have to first show your listener.ora and sqlnet.ora files, of course.

Re: the listener can not listen service [message #607573 is a reply to message #607572] Mon, 10 February 2014 01:43 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
[grid@node1 admin]$ more listener.ora
LISTENER=(DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = listener)))# line added by Agent
MY_LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=MY_LISTENER))))              # line added by Agent
# listener.ora Network Configuration File: /u01/app/grid/11.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1 = ON

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = listener))
  )

ADR_BASE_LISTENER = /u01/grid

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

LISTENER_SCAN1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN1))
  )

ADR_BASE_LISTENER_SCAN1 = /u01/grid

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_MY_LISTENER=ON           # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON


[grid@node1 admin]$ more sqlnet.ora
# sqlnet.ora.node1 Network Configuration File: /u01/app/grid/11.2.0/network/admin/sqlnet.ora.node1
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

ADR_BASE = /u01/grid
Re: the listener can not listen service [message #607579 is a reply to message #607573] Mon, 10 February 2014 02:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So the situation is as expected.
There is no static services on your new listener so no services in the output until some instances register some services to this listener.

Re: the listener can not listen service [message #607584 is a reply to message #607579] Mon, 10 February 2014 02:38 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Michel Cadot wrote on Mon, 10 February 2014 02:25

So the situation is as expected.
There is no static services on your new listener so no services in the output until some instances register some services to this listener.



Can you tell me how to make the service registe to new listener?
Re: the listener can not listen service [message #607587 is a reply to message #607584] Mon, 10 February 2014 02:44 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Your listener.or file is corrupted: it has two entries for LISTENER. What did you do when you created my_listener? What tools did you use? I really believe that it is best not to touch listener.ora in a GI environment, other than to include an ifile directive pointing to a file that you can edit as much as you like.

--update: typo

[Updated on: Mon, 10 February 2014 02:45]

Report message to a moderator

Re: the listener can not listen service [message #607589 is a reply to message #607587] Mon, 10 February 2014 02:50 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
I created my_listener by using the command NETCA.
Re: the listener can not listen service [message #607590 is a reply to message #607589] Mon, 10 February 2014 02:52 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I have never seen netca corrupt the file in this way. Is it the same on all nodes? Are you certain no-one has edited it by hand?

Re: the listener can not listen service [message #607593 is a reply to message #607590] Mon, 10 February 2014 03:01 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member

Just created it in one-node by netca.
Re: the listener can not listen service [message #607594 is a reply to message #607584] Mon, 10 February 2014 03:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
andy huang wrote on Mon, 10 February 2014 09:38

Can you tell me how to make the service registe to new listener?


Set LOCAL_LISTENER to point to the new listener on the instances you want they register to this one.

Re: the listener can not listen service [message #607596 is a reply to message #607593] Mon, 10 February 2014 03:08 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Andy, I was interested in this problem because I have NEVER seen a listener.ora file corrupted in this way. It would have been interesting to see if the corruption has been propagated to the the other nodes. But if you are not bothered, then neither am I.
Michel has given you one solution to your immediate problem - though you might want to consider whether you would be better off using the SCAN in the way it is meant to be used.
Previous Topic: some error in my crsd.lg
Next Topic: Get instance mapping
Goto Forum:
  


Current Time: Fri Mar 29 00:05:54 CDT 2024