Oracle 视图 V$IP_ACL 官方解释,作用,如何使用详细说明

本站中文解释

Oracle视图V$IP_ACL是一个传输控制协议(TCP)配置的视图,它反映系统参数文件(SPFILE)中定义的IP访问控制列表(ACL)清单。通过它可以查看被添加到ACL中的IPv4/IPv6地址、子网掩码地址、访问模式,以及相关实例等信息。

使用方法:

1. 使用SQL*Plus连接到Oracle数据库,然后使用SELECT语句从V$IP_ACL视图中查询IP访问控制列表:

SELECT * FROM V$IP_ACL;

2. 使用ALTER SYSTEM语句添加或删除IP访问控制:

ALTER SYSTEM SET ip_acl_parameters = ‘{ip_address,mask_size,[ALLOW|DENY]}'[,…] SCOPE=SPFILE;

官方英文解释

V$IP_ACL provides information about access control to database services from network hosts.

Column Datatype Description

SERVICE_NAME

VARCHAR2(512)

The database service name

HOST

VARCHAR2(64)

The host being granted access to the SERVICE_NAME. The host can be a hostname, dotted-decimal IPv4 or heximal IPv6 address. Wildcard “*” for IPv4 and Classless Inter-Domain Routing (CIDR) format is allowed.

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs

  • 1: This value is used for rows containing data that pertain only to the root

  • n: Where n is the applicable container ID for the rows containing data


数据运维技术 » Oracle 视图 V$IP_ACL 官方解释,作用,如何使用详细说明