here's a few things to check (and maybe post back to the list).
on EACH node:
- SQL> show parameter LOCAL_LISTENER
- SQL> show parameter REMOTE_LISTENER
- double-check that TNS_ADMIN is not set to something non-standard
- contents of ORACLE_HOME/network/admin/tnsnames.ora -- all entries
matching <LOCAL/REMOTE LISTENER>
keep in mind that the LOCAL_LISTENER parameter should be different on
each node; it should always point to the "local" listener for that
node.
if you figure out what it is, let us know - might help someone in the
future. :)
-J
--
http://about.me/jeremy_schneider
On Fri, Nov 13, 2015 at 3:30 PM, K R <kp0773@xxxxxxxxx> wrote:
Hi All,--
on a 11gR2 RAC node . the node listener and scan listenr are running form
grid/asm home .
I have configured the local listener on database running on db home but the
database services are not getting regisered on node listener . The other
node in the cluster seems to be fine without any issue . I am not able to
figure out what i am mising
thanks in advance
-Kart