"ORA-28365: wallet is not open" starting Oracle instance in VCS
Article ID: 100061278
Updated On:
Description
Error Message
The following is reported in the /var/VRTSVCS/log/Oracle_a.log
2023/10/04 11:35:59 VCS INFO V-16-20002-385 Oracle:ora_instance:online:Oracle database startup custom script name is [start_custom_oracle.sql]
2023/10/04 11:36:24 VCS NOTICE V-16-20002-21 Oracle:ora_instance:online:Oracle startup returned the output
+--------------------------------------------------------------------+
LD_LIBRARY_PATH - /ora/product/19.0.0.0a/db/lib:/usr/lib:
ORACLE instance started.
Total System Global Area 1.5999E+11 bytes
Fixed Size 37246944 bytes
Variable Size 1.9864E+10 bytes
Database Buffers 1.3959E+11 bytes
Redo Buffers 499621888 bytes
Database mounted.
ALTER DATABASE OPEN
*
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00604: error occurred at recursive SQL level 1
ORA-28365: wallet is not open
Process ID: 3051952
Session ID: 56 Serial number: 47989
Cause
Transparent Database Encryption (TDE) wallets files (ewallet.p12 and ewallet.sso) were not found for the Oracle account.
Resolution
Add the ENCRYPTION_WALLET_LOCATION parameter to the the database Oracle Home sqlnet.ora i.e.
ENCRYPTION_WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATE=(DIRECTORY=/u01/app/oracle/admin/db1/wallet)))
The sqlnet.ora can be found in the following locations:
1. $ORACLE_HOME/network/admin
2. As defined by the environment variable $TNS_ADMIN. If this is set, it will over-rule the default location. Verify with the following command:
echo $TNS_ADMIN
Issue/Introduction
