Note
This view is available starting with V4.2.0.
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
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | The tenant ID.
|
| TENANT_NAME | VARCHAR2(128) | NO | The tenant name. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the server to which the system log stream replica belongs. |
| SQL_PORT | NUMBER(38) | NO | The SQL port number of the server to which the system log stream replica belongs. |
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.