| the listener can not listen service [message #607570] |
Mon, 10 February 2014 00:46  |
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 #607573 is a reply to message #607572] |
Mon, 10 February 2014 01:43  |
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 #607584 is a reply to message #607579] |
Mon, 10 February 2014 02:38 |
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 |
John Watson
Messages: 8962
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 #607596 is a reply to message #607593] |
Mon, 10 February 2014 03:08 |
John Watson
Messages: 8962
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
