My Oracle Support Banner

ORA-28365 while opening 19c database in OCI VM DB System (Doc ID 2882397.1)

Last updated on JULY 16, 2022

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Getting ORA-28365 while opening 19c database in OCI VM DB System:

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-28365: wallet is not open

+ v$encryption_wallet shows database is not able to find the TDE wallet :

INST_ID     WRL_TYPE     WRL_PARAMETER     STATUS        WALLET_TYPE     WALLET_OR     KEYSTORE     FULLY_BAC     CON_ID
 1               FILE           NOT_AVAILABLE     UNKNOWN      SINGLE       NONE         UNDEFINED                   1

+ TNS_ADMIN environment variable is not set and wallet is present in location specified by ENCRYPTION_WALLET_LOCATION in sqlnet.ora :

cat $ORACLE_HOME/network/admin/sqlnet.ora|grep ENCRYPTION_WALLET_LOCATION
ENCRYPTION_WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/opt/oracle/dcs/commonstore/wallets/tde/$ORACLE_UNQNAME)))

cd /opt/oracle/dcs/commonstore/wallets/tde/$ORACLE_UNQNAME
ls -l *wallet*
-rw------- 1 oracle oinstall 9672 Jun 15 15:48 cwallet.sso
-rw------- 1 oracle oinstall    0 May  9 17:37 cwallet.sso.lck
-rw------- 1 oracle asmadmin 9627 Jun 15 15:48 ewallet.p12
-rw------- 1 oracle oinstall    0 May  9 17:37 ewallet.p12.lck

Changes

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.