"ORA-28353: failed to open wallet" After Database Cloud Service Restart
(Doc ID 2445472.1)
Last updated on OCTOBER 05, 2021
Applies to:
Oracle Database Cloud Service - Version N/A to N/A [Release 1.0]Linux x86-64
Symptoms
After VM restart open database failed with "ORA-28365: wallet is not open" error.
From Alert.log:
2018-08-22T02:50:33.358267+00:00
Starting ORACLE instance (normal) (OS id: 16207)
2018-08-22T02:50:33.361242+00:00
...........
2018-08-22T02:50:41.235889+00:00
Database mounted in Exclusive Mode
Lost write protection disabled
Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST
Completed: ALTER DATABASE MOUNT
2018-08-22T02:50:41.698532+00:00
ALTER DATABASE OPEN
2018-08-22T02:50:41.743918+00:00
Block change tracking file is current.
.....
2018-08-22T02:50:42.007517+00:00
Recovery of Online Redo Log: Thread 1 Group 2 Seq 818 Reading mem 0
Mem# 0: /u04/app/oracle/redo/redo02.log
2018-08-22T02:50:42.062028+00:00
Slave encountered ORA-28365 exception during crash recovery
Slave exiting with ORA-28365 exception
2018-08-22T02:50:42.062343+00:00
......
ORA-28365: wallet is not open
2018-08-22T02:50:42.093615+00:00
Starting ORACLE instance (normal) (OS id: 16207)
2018-08-22T02:50:33.361242+00:00
...........
2018-08-22T02:50:41.235889+00:00
Database mounted in Exclusive Mode
Lost write protection disabled
Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST
Completed: ALTER DATABASE MOUNT
2018-08-22T02:50:41.698532+00:00
ALTER DATABASE OPEN
2018-08-22T02:50:41.743918+00:00
Block change tracking file is current.
.....
2018-08-22T02:50:42.007517+00:00
Recovery of Online Redo Log: Thread 1 Group 2 Seq 818 Reading mem 0
Mem# 0: /u04/app/oracle/redo/redo02.log
2018-08-22T02:50:42.062028+00:00
Slave encountered ORA-28365 exception during crash recovery
Slave exiting with ORA-28365 exception
2018-08-22T02:50:42.062343+00:00
......
ORA-28365: wallet is not open
2018-08-22T02:50:42.093615+00:00
From trace file:
.............
*** 2018-08-22T02:50:41.944246+00:00 (CDB$ROOT(1))
*** SESSION ID:(245.24116) 2018-08-22T02:50:41.944286+00:00
*** CLIENT ID:() 2018-08-22T02:50:41.944296+00:00
*** SERVICE NAME:() 2018-08-22T02:50:41.944318+00:00
*** MODULE NAME:(sqlplus@DB01 (TNS V1-V3)) 2018-08-22T02:50:41.944326+00:00
*** ACTION NAME:() 2018-08-22T02:50:41.944337+00:00
*** CLIENT DRIVER:() 2018-08-22T02:50:41.944345+00:00
*** CONTAINER ID:(1) 2018-08-22T02:50:41.944355+00:00
........
kcbtse_get_tbskey: decrypting encrypted key for pdb 3 tablespace 0 without opening the wallet
kcbtse_get_tbskey: wallet is not opened (ts 3/0)
kcbtse_encdec_tbsblk: DIAG DUMP tsn 3/2 rdba 37799351, afn 11, mode 4
kcbz_encdec_tbsblk<-kcbtse_encdec_tbsblk_pdb1<-kclcaio<-kclrechk<-kcbtema<-kcrpap<-kcrpdv<-kxfprdp_int<-ksbdispatch<-opirip<-opidrv<-sou2o<-opimai_real<-ssthrdmain<-main<-__libc_start_main.
buffer tsn: 2 rdba: 0x0240c5b7 (9/50615)
scn: 0x1be9d30 seq: 0x15 flg: 0x14 tail: 0x9d300215
frmt: 0x02 chkval: 0xe562 type: 0x02=KTU UNDO BLOCK
.........
*** 2018-08-22T02:50:41.944246+00:00 (CDB$ROOT(1))
*** SESSION ID:(245.24116) 2018-08-22T02:50:41.944286+00:00
*** CLIENT ID:() 2018-08-22T02:50:41.944296+00:00
*** SERVICE NAME:() 2018-08-22T02:50:41.944318+00:00
*** MODULE NAME:(sqlplus@DB01 (TNS V1-V3)) 2018-08-22T02:50:41.944326+00:00
*** ACTION NAME:() 2018-08-22T02:50:41.944337+00:00
*** CLIENT DRIVER:() 2018-08-22T02:50:41.944345+00:00
*** CONTAINER ID:(1) 2018-08-22T02:50:41.944355+00:00
........
kcbtse_get_tbskey: decrypting encrypted key for pdb 3 tablespace 0 without opening the wallet
kcbtse_get_tbskey: wallet is not opened (ts 3/0)
kcbtse_encdec_tbsblk: DIAG DUMP tsn 3/2 rdba 37799351, afn 11, mode 4
kcbz_encdec_tbsblk<-kcbtse_encdec_tbsblk_pdb1<-kclcaio<-kclrechk<-kcbtema<-kcrpap<-kcrpdv<-kxfprdp_int<-ksbdispatch<-opirip<-opidrv<-sou2o<-opimai_real<-ssthrdmain<-main<-__libc_start_main.
buffer tsn: 2 rdba: 0x0240c5b7 (9/50615)
scn: 0x1be9d30 seq: 0x15 flg: 0x14 tail: 0x9d300215
frmt: 0x02 chkval: 0xe562 type: 0x02=KTU UNDO BLOCK
.........
Wallet status:
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 |