ORA-28365: wallet is not open

发布时间 2023-12-27 17:42:25作者: ritchy

RAC 数据库启动遇到ORA-28365
Oracle使用了TDE功能,加密了,没有正确打开wallet时会出现下面错误,打开钱包即可,以使用 alter system set encryption wallet open;命令完成。如果打开钱包时遇到任何问题,那么可以尝试使用 alter system set encryption wallet open identified by "yourpassword"; 而不是尝试手动打开钱包。
如果在执行任何涉及证书的操作时发生ORA-28365,那么用户必须尝试重新导入或更新wallet中的密钥和证书。

[oracle@racol01 ~]\$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Dec 26 15:56:34
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SYS@rac01> startup
ORACLE instance started.
Total System Global Area 4.0486E+10 bytes
Fixed Size 2261968 bytes
Variable Size 9126808624 bytes
Database Buffers 3.1273E+10 bytes
Redo Buffers 84606976 bytes
Database mounted.
ORA-28365: wallet is not open

查看WALLET状态
select * from gv\$encryption_wallet;
INST_ID WRL_TYPE WRL_PARAMETER STATUS
---------- -------------------- ---------------------------------------- ------------------
2 file /oracle/product/11.2.0/wallet OPEN
1 file /oracle/product/11.2.0/admin/ynras1/wallet CLOSED

1节点wallet没有打开,2节wallet点正常

--RAC只需在一个节点执行
sys@rac01> alter system set wallet open identified by Sdatde123#\$;
system altered.

sys@rac01> alter database open;
database altered.

另外应及时对钱包文件备份
cp ewallet.p12 /tmp/ewallet.p12.bak