How to validate static Listener entries?
From: Rich J <rjoralist3_at_society.servebeer.com>
Date: Tue, 26 Feb 2019 11:18:50 -0600
Message-ID: <37c559d1d83d7d1868f4c2571d172ad9_at_society.servebeer.com>
Hey all,
Date: Tue, 26 Feb 2019 11:18:50 -0600
Message-ID: <37c559d1d83d7d1868f4c2571d172ad9_at_society.servebeer.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 26 2019 - 18:18:50 CET