How to acquire all of IP Addresses of Oracle Data Guard Physical Standby on Primary Database using the SQL statement?
From: Quanwen Zhao <quanwenzhao_at_gmail.com>
Date: Mon, 19 Sep 2022 15:01:54 +0800
Message-ID: <CABpiuuS5s4NAOH9N1rtrh9uxWGue8fQr9trE5W1OAZJLFjHrKA_at_mail.gmail.com>
Hello everybody :-),
Date: Mon, 19 Sep 2022 15:01:54 +0800
Message-ID: <CABpiuuS5s4NAOH9N1rtrh9uxWGue8fQr9trE5W1OAZJLFjHrKA_at_mail.gmail.com>
Hello everybody :-),
I've known that using "select utl_inaddr.get_host_address from dual;" to be able to get local ip address directly on local oracle data guard primary database, but how to acquire all of IP Addresses of Oracle Data Guard Physical Standby on Primary Database using the SQL statement?
Very appreciated if any help, thanks in advance.
Best Regards
Quanwen Zhao
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Sep 19 2022 - 09:01:54 CEST