OGG-00662 OCI Error ORA-28374: 在 Wallet 中未找到键入的主键

ogg downstream中间库抽取进程报错：OGG-00662 OCI Error ORA-28374: 在 Wallet 中未找到键入的主键

原因是源端启用了TDE。

处理过程分析：
中间库创建TDE（参考https://www.modb.pro/db/655289），但发现masterkey为空

orapki wallet display -wallet /u01/app/oracle/admin/mid/wallet -pwd oracle1234

对比源端是有值的：

处理办法：
将wallet从源端拷贝替换，再重启数据库和ogg后正常同步。

[oracle@ora02 mid]$ mv wallet/ wallet.bak
[oracle@ora02 mid]$ pwd
/u01/app/oracle/admin/mid
[oracle@ora02 mid]$ scp -rp ora01:/u01/app/oracle/admin/jyc/wallet ./
oracle@ora01's password: 
ewallet.p12                                                                                                                                                            100% 5467     5.2MB/s   00:00    
ewallet_2023063005350398.p12                                                                                                                                           100% 2555     3.8MB/s   00:00    
cwallet.sso.bak                                                                                                                                                        100% 5512     7.3MB/s   00:00    
cwallet.sso.backup                                                                                                                                                     100% 5512     7.2MB/s   00:00    
cwallet.sso.backup1                                                                                                                                                    100% 5512     7.2MB/s   00:00    
cwallet.sso                                                                                                                                                            100% 5512     7.3MB/s   00:00    
ewallet.p12.lck                                                                                                                                                        100%    0     0.0KB/s   00:00    
cwallet.sso.lck                                                  
[oracle@ora02 mid]$ cd wallet
[oracle@ora02 wallet]$ ll
total 44
-rw------- 1 oracle oinstall 5512 Jun 30 14:16 cwallet.sso
-rw------- 1 oracle oinstall 5512 Jun 30 14:04 cwallet.sso.backup
-rw------- 1 oracle oinstall 5512 Jun 30 14:13 cwallet.sso.backup1
-rw------- 1 oracle oinstall 5512 Jun 30 13:35 cwallet.sso.bak
-rw------- 1 oracle oinstall    0 Jun 30 15:14 cwallet.sso.lck
-rw------- 1 oracle oinstall 2555 Jun 30 13:35 ewallet_2023063005350398.p12
-rw------- 1 oracle oinstall 5467 Jun 30 13:35 ewallet.p12
-rw------- 1 oracle oinstall    0 Jun 30 15:14 ewallet.p12.lck
[oracle@ora02 wallet]$ orapki wallet display -wallet /u01/app/oracle/admin/mid/wallet -pwd oracle1234
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.4.0.0.0
Copyright (c) 2004, 2023, Oracle and/or its affiliates. All rights reserved.

Requested Certificates: 
Subject:        CN=oracle
User Certificates:
Oracle Secret Store entries: 
ORACLE.SECURITY.DB.ENCRYPTION.AbMXI03rvU89v04DZQskRGoAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
ORACLE.SECURITY.DB.ENCRYPTION.AX3rYOf260+bvz8q8J0PUy4AAAAAAAAAAAAAAAAAAAAAAAAAAAAA
ORACLE.SECURITY.DB.ENCRYPTION.MASTERKEY
ORACLE.SECURITY.DB.ENCRYPTION.MASTERKEY.FE8826CEFA3C150CE0539ACFA8C0C81B
ORACLE.SECURITY.ID.ENCRYPTION.
ORACLE.SECURITY.KB.ENCRYPTION.
ORACLE.SECURITY.KM.ENCRYPTION.AbMXI03rvU89v04DZQskRGoAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
ORACLE.SECURITY.KM.ENCRYPTION.AX3rYOf260+bvz8q8J0PUy4AAAAAAAAAAAAAAAAAAAAAAAAAAAAA
Trusted Certificates: 
[oracle@ora02 wallet]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on 星期五 6月 30 15:25:17 2023
Version 19.19.0.0.0

Copyright (c) 1982, 2022, Oracle.  All rights reserved.


连接到: 
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.19.0.0.0

SQL> shutdown immediate
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。

Total System Global Area 2415915048 bytes
Fixed Size                  9166888 bytes
Variable Size             855638016 bytes
Database Buffers         1543503872 bytes
Redo Buffers                7606272 bytes
数据库装载完毕。
数据库已经打开。
SQL> select inst_id, con_id, wallet_type, status, wrl_parameter from gv$encryption_wallet order by 1,2;

   INST_ID     CON_ID WALLET_TYPE          STATUS
---------- ---------- -------------------- ------------------------------
WRL_PARAMETER
--------------------------------------------------------------------------------
         1          1 AUTOLOGIN            OPEN
/u01/app/oracle/admin/mid/wallet

         1          2 AUTOLOGIN            OPEN