此内容已被标记为最终。 显示 8 条回复
Are you using SCAN (Single Client Access Name) feature? If yes, there are LISTENER_SCANs running on your machines.
Check with command from your $GRID_HOME
srvctl status scan_listener
I think this is a great doc for you --> 11gR2 Grid Infrastructure Single Client Access Name (SCAN) Explained [ID 887522.1]
Yeah I'm using scan addressing for the cluster and it works.
I use the 'srvctl status scan_listener' all the time to check it.
I use this too: srvctl status listener -l LISTENER -n <nodename>
And it tell me it's enabled and running.
If I switch my ORACLE_HOME to grid home I can use 'lsnrctl status LISTENER'
I'm just confused about which lsnrctl to run from where and with which parameter file.
I got two running but only one has a listener.ora file.
I guess the one that has a parameter is good candidate but this is contrary to
what the oracle message is suggesting. It tells me to stop the grid home one and
run the db home one.
So should the listener (LISTENER) be running from grid home or db home ?
In that Metalink note id that I said to check we can see a SCAN DEMO at
Please seet it to clarify about SCAN feature and check the picture to in this doc about SCAN infrastructure.
to manage your listener configuration
Yes, the (LISTENER) runs at $ORACLE_HOME, and SCAN_LISTERNER inside $GRID_HOME
The following command adds a listener named listener112 that is listening on port 1341 and runs from the /ora/ora112 home directory on every node in the cluster:
*$ srvctl add listener -l listener112 -p 1341 -o /ora/ora112*
That was VERY helpful.
I disabled the old listener and then
I was able to create a new listener with the correct settings.
I can see the instances on each node using this
lsnrctl status NEW_LISTENER
However this shows on the first node that +ASM1, DM3, DM31
are available on the second node I see only +ASM2 but nothing else.
I was expecting DM3, DM32 .
Now when I first created the new listener I read that the 'local_listener'
setting need NOT be set. When I attemptied to unset that parameter then
I lost the local instances. I reset the local_listener as before
and the local instance on node one returned. Not on node two however.
My question: Do I need to set the 'local_listener' on each instance to the same
value or to different values to reflect which node they are configured for ?
I cannot see it now but I remember there is a section that references the
first node 'node_one-vip' .
Should the second node's local_listener section be 'node_two-vip' ?
Now if it need not be set this then something else has to occur to make it work.
Sorry for not being more brief,
You're Welcome!!! I'm glad that my answer helps u!!!
Check this documentation about local_listener and remote_listener configuration
The Database Agent takes care of this for you --> LOCAL_LISTENER initialization parameters is set automatically.
Only setup REMOTE_LISTENER to the SCAN port and SCAN, check the doc above for set it.
Thanks for that link. So what happens when you have a 10g database or 11gr1 database runing on your 11gR2 Grid Infrastructure? Should you have additional listeners named "listener_hostname" on each node running from those 11gr1 or 10g homes?