Open Wallet Automatically After Starting The Database - Learnomate Technologies

Wakad : +919325408926 Icon

kalewadi : +918983069523 Icon

kharadi : +919325408926

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;
/

Hope it Helps!