<<Back to DB Administration Main Page
ORA-28365: wallet is not open Encountered while Starting the Database
$ srvctl start instance -d CDB001 -i CDB0011PRCR-1013 : Failed to start resource ora.cdb001.db
PRCR-1064 : Failed to start resource ora.cdb001.db on node node1.oracle.com
CRS-5017: The resource action "ora.cdb001.db start" encountered the following error:
ORA-28365: wallet is not open
. For details refer to "(:CLSN00107:)" in "/u01/app/oracle/diag/crs/node1.oracle.com/crs/trace/crsd_oraagent_oracle.trc".
CRS-2674: Start of 'ora.cdb001.db' on 'node1.oracle.com' failed
Solution:
Start the instance in mount mode
SQL> startup mount;
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 2926472 bytes
Variable Size 1392511096 bytes
Database Buffers 738197504 bytes
Redo Buffers 13848576 bytes
Database mounted.
Check Wallet status
set linesize 200
col WALLET_DIR for a32
col status for a21
select STATUS,WRL_PARAMETER WALLET_DIR,WALLET_TYPE from V$ENCRYPTION_WALLET;
STATUS WALLET_DIR WALLET_TYPE
--------------------- -------------------------------- ------------------------------------------------------------
CLOSED +DATAC4/CDB001/wallet/ UNKNOWN
Open the Keystore
SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY "xxxxx";
keystore altered.
Open the database
SQL> alter database open;
Database altered.
Thanks for taking the time to discuss this, I feel strongly about it and love learning more on this topic. If possible, as you gain expertise, would you mind updating your blog with extra information? It is extremely helpful for me.
ReplyDeleteJob listing site for host bar
Hi There,
ReplyDeleteThank you for sharing the knowledgeable blog with us I hope that you will post many more blog with us:-
Very potent opioid! FLUONITAZENE is an analgesic drug related to etonitazene, which was first reported in 1957, and has been shown to have approximately 20 times the potency of morphine by central routes of administration, but if used orally it has been shown to have approximately 1~2times the potency of morphine…:
Email: mackush387@gmail.com
Click here for more information:
Wickr: realchemsupply
WhatsApp: +12132939141
Telegram: @realchemsupplier_bot
DBA Training
ReplyDeleteFollowing industry standards for optimizing SQL query performance understanding your back-end architecture
You can build better applications if you have a better understanding of the technology. We also train our Database Engineers and SREs regularly so that we can stay on top of the latest technologies
https://genexdbs.com/