Oracle教程 2023-02-24

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

本站中文解释

V$ENCRYPTION_WALLET视图显示现有的Oracle Net服务中的Oracle访问钱包的信息。访问钱包在数据库实例中使用带有Oracle Advanced Security的技术，以用于加密传输。

Oracle提供了一种安全机制，称为访问钱包，它可以使用应用程序和数据库实例之间在网络上传输时保护密码。钱包存储受保护的信息，例如客户端的共享密钥，但仅暴露它们的加密形式。当程序或服务连接到数据库实例时，将使用这些凭证，使程序可以安全与数据库交互。

要检索V$ENCRYPTION_WALLET视图，必须从sys用户查询其查看权限。它返回一个含有一个字段的行，即wallet_status，它表示访问钱包的当前状态是否为Open或Close。

例：

SELECT * FROM V$ENCRYPTION_WALLET;

WALLET_STATUS
_____________
Open

官方英文解释

V$ENCRYPTION_WALLET displays information on the status of the wallet and the wallet location for Transparent Data Encryption. In a multitenant container database (CDB), this view displays information on the wallets for all pluggable database (PDBs) when queried from CDB$ROOT. When queried from a PDB, this view only displays wallet details of that PDB.

Column	Datatype	Description
`WRL_TYPE`	`VARCHAR2(20)`	Type of the wallet resource locator (for example, `FILE`)
`WRL_PARAMETER`	`VARCHAR2(4000)`	Parameter of the wallet resource locator (for example, absolute directory location of the wallet or keystore, if `WRL_TYPE` = `FILE`)
`STATUS`	`VARCHAR2(30)`	Status of the wallet. Possible values: `CLOSED`: The wallet is closed `NOT_AVAILABLE`: The wallet is not available in the location specified by the `WALLET_ROOT` initialization parameter `OPEN`: The wallet is open `OPEN_NO_MASTER_KEY`: The wallet is open, but no master key is set `OPEN_UNKNOWN_MASTER_KEY_STATUS`: The wallet is open, but the database could not determine whether the master key is set. This situation can occur when the database is in the mounted state and cannot check if the master key for a hardware keystore is set because the data dictionary is not available. `UNDEFINED`: The database could not determine the status of the wallet
`WALLET_TYPE`	`VARCHAR2(20)`	Displays the type of keystore being used, `HSM` or `SOFTWARE_KEYSTORE`. If the keystore was created with the `mkstore` utility, then the `WALLET_TYPE` is `UNKNOWN`. Oracle recommends that you create keystores with the `ADMINISTER` `KEY` `MANAGEMENT` statement.
`WALLET_ORDER`	`VARCHAR2(9)`	Possible values: `SINGLE` – When only a single wallet is configured, this is the value in the column. `PRIMARY` – When more than one wallet is configured, this value indicates that the wallet is primary (holds the current master key). `SECONDARY` – When more than one wallet is configured, this value indicates that the wallet is secondary (holds old keys). The lookup of master keys happens in the primary keystore first, and then in the secondary keystore, if required. If there is only one type of keystore (Hardware Security Module or Software Keystore) being used, then `SINGLE` will appear. If both types are used, then the value in this column shows the order in which each keystore will be looked up.
`KEYSTORE_MODE`	`VARCHAR2(8)`	Displays the keystore mode: `NONE`: This value is seen when this column is queried from the `CDB$ROOT`, or when the database is a non-CDB. The keystore mode does not apply in these cases. `UNITED`: The PDB is configured to use the wallet of the `CDB$ROOT`. To open the wallet in this configuration, the password of the wallet of the `CDB$ROOT` must be used. `ISOLATED`: The PDB is configured to use its own wallet. To open the wallet in this configuration, the password of the isolated wallet must be used.
`FULLY_BACKED_UP`	`VARCHAR2(9)`	Indicates whether all the keys in the keystore have been backed up
`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 to only the root n: Where n is the applicable container ID for the rows containing data

本站中文解释

官方英文解释

相关推荐