Open Wallet Automatically After Starting The Database
Kiran Dalvi
11 Oct, 2023
0 Comments
28 Secs Read
Open Wallet Automatically After Starting The Database
If encryption wallet is enabled, then everytime we start the database, we have to open the wallet manually.
So to avoid this, we can create one trigger which will open the wallet automatically , once you start the database.
Below is the trigger :
CREATE or replace TRIGGER OPEN_WALLET
AFTER STARTUP ON DATABASE
BEGIN
--execute immediate 'ALTER SYSTEM SET ENCRYPTION WALLET CLOSE identified by “password”';
--execute immediate 'ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY “password”';
execute immediate 'ALTER SYSTEM SET ENCRYPTION WALLET OPEN identified by “password”';
END;
/