This article about Open Wallet Automatically After Starting The Database. 

If encryption wallet is enabled, then every time 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;
/

About The Author

Comments

    1. Skant Gupta

      One issue with Oracle security and encryption prior to Oracle 11g was the requirement that someone had to open the wallet, passing in the password when doing so. This could be addressed with a login trigger, but this required more work on the part of the DBA and also required the creation of PL/SQL to manage the logon process.

Leave a Reply