DBA Hub

📋Steps in this guide1/1

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.

oracle configurationintermediate
by OracleDba
13 views
1

Overview

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.

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
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;
/

Comments (0)

Please to add comments

No comments yet. Be the first to comment!