Re: database services not getting registered on node listener

From: Jeremy Schneider <jeremy.schneider_at_ardentperf.com>
Date: Fri, 13 Nov 2015 19:35:50 -0600
Message-ID: <CA+fnDAZt7W88rLg6p+NgMMTEY2wf0PeF7C_-NM2uGYFJXFJJSw_at_mail.gmail.com>

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_at_gmail.com> 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

>

>

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Nov 14 2015 - 02:35:50 CET