Open Wallet Automatically After Starting The Database

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarKiran 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!