Standby Reported ORA-28365 After Primary Adding Datafile Even TDE NOT Enabled?
(Doc ID 3035285.1)
Last updated on JULY 16, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.16.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
1.After adding new datafile to the primary database, we saw the following errors reported on the standby.:
e.g
2024-06-18T18:05:07.262022+08:00
KZTDE:kzekmaow: attempted to open auto login wallet..
KZTDE:failed with error 28365.
KZTDE:kzekmaow: attempted to open auto login wallet..
KZTDE:failed with error 28365.
PR00 (PID:364521): MRP0: Background Media Recovery terminated with error 28365
2024-06-18T18:05:07.332033+08:00
Errors in file /xx/diag/rdbms/xx/xx1/trace/xx1_pr00_364521.trc:
ORA-28365: wallet is not open
2024-06-18T18:05:07.333653+08:00
.... (PID:387981): Managed Standby Recovery not using Real Time Apply
2024-06-18T18:05:08.103989+08:00
Recovery interrupted!
2024-06-18T18:05:18.871780+08:00
2.In trace file(PR0X) , we could see the function kcbz_populate_tbskey() was looking for MK rekey even TDE was not enabled
----- Abridged Call Stack Trace -----
<Skipped 2 stack frames>
kztsminit<-kzekmisxwp<-kzekmisx2<-kzekmisx1_nonpdb<-kzekmisx<-kzekmaow<-kzekmaow_pdb<-kcbz_populate_tbskey<-kcbtse_populate_tbskey_pdb1<-kcvadc1
----- End of Abridged Call Stack Trace -----
Partial short call stack signature: 0xcba8a8b67becc0c7
KZTDE:kzekmisxwp3: Failed to open wallet
KZTDE: kzekmisx2: Wallet initialization failed with error 28365
KZTDE:kzekmisx1_nonpdb: open keystore failed, error 28365
KZTDE: kzmkrrcv: Recover wallet operation failed, gbcmsg_status=4
Changes
In current case, the customer upgraded the DB version to 19.22 using XTTS from 11.2 then created data guard standby and got issues.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |