How to acquire all of IP Addresses of Oracle Data Guard Physical Standby on Primary Database using the SQL statement?

  • From: Quanwen Zhao <quanwenzhao@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 19 Sep 2022 15:01:54 +0800

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

Other related posts:

  • » How to acquire all of IP Addresses of Oracle Data Guard Physical Standby on Primary Database using the SQL statement? - Quanwen Zhao