Re: How to validate static Listener entries?

From: Rich J <rjoralist3_at_society.servebeer.com>
Date: Tue, 26 Feb 2019 11:39:33 -0600
Message-ID: <c3a9fad400131d2a3b967e64423b9b68_at_society.servebeer.com>



On 2019/02/26 11:18, Rich J wrote:

> Hey all,
>
> I'm testing upgrading an Active Data Guard setup with a physical standby from 11.2 to 12.1. I have two static entries in the listener.ora file for the primary and secondary, with the ORACLE_HOME specified. In my testing, I had issues due to a missed "lsnrctl reload" after changing the listener.ora to move the databases to the new OH.
>
> Is there a way to validate which OH the static entries are currently pointing to? I can't find anything in "lsnrctl" nor "tnsping".
>
> Thanks,
> Rich

Got it:

$ lsnrctl

LSNRCTL> set displaymode verbose
LSNRCTL> services

Thanks!
Rich

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 26 2019 - 18:39:33 CET

Original text of this message