DBA_OB_ACCESS_POINT

Purpose

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

Columns

Sample query

Query the Server list of the tenant entry of the user tenant.

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 physical standby databases based on a network, see Physical standby database.