Oracle磁盘文件管理相关操作

Wallet文件生成

orapki工具生成

# 生成钱夹
orapki wallet create -pwd uxdb@123456 -wallet /home/oracle/tools/wallets
# 修改钱夹密码
orapki wallet change_pwd -wallet /home/oracle/tools/wallets
# 显示钱夹内容
orapki wallet display  -wallet /home/oracle/tools/wallets -pwd uxdb@123456
# 结果展示
[oracle@localhost wallet]$ orapki wallet display  -wallet /home/oracle/tools/wallets -pwd uxdb@123456
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.

Requested Certificates:
User Certificates:
Trusted Certificates:
[oracle@localhost wallet]$

# 查看masterkey
mkstore -wrl /home/oracle/wallet/ -viewEntry ORACLE.SECURITY.DB.ENCRYPTION.MASTERKEY

SQL命令行生成

使用SQL命令生成一个wallet

-- 生成钱包(该过程会产生一个主密钥存储在wallet中)：
ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "oracle123";
--打开钱包
ALTER SYSTEM SET ENCR