DBA_OB_ACCESS_POINT

Purpose

This view displays the list of servers for the current tenant's access point. In the scenario of a physical standby database based on a network, it is primarily used to obtain the IP address and SQL port number of the OBServer node in the primary tenant's replica.

Columns

Sample query

Query the list of servers for the current tenant's access point.

obclient [SYS]> SELECT SVR_IP, SQL_PORT FROM SYS.DBA_OB_ACCESS_POINT;

The query result is as follows:

+----------------+----------+
| SVR_IP         | SQL_PORT |
+----------------+----------+
| 172.xx.xxx.xxx |     2881 |
+----------------+----------+
1 row in set

References

For more information about the physical standby database based on a network, see Physical standby database.