Database Administration (MOSC)

MOSC Banner

Cannot view tde keystore contents from OS

edited Jun 30, 2022 8:09AM in Database Administration (MOSC) 2 comments

Hi

Oracle 19.9

I have created tde keystore in ASM, opened it and set master keys.

SQL> alter system set wallet_root='+DATA/cdb' scope=spfile sid='*';
shutdown immediate;
startup;
alter system set tde_configuration='keystore_configuration=file';
administer key management create keystore identified by "supersecretpass";
administer key management set keystore open identified by "supersecretpass" container=all;
administer key management set key identified by "supersecretpass" with backup using 'my_bkp_key' container=all;
administer key management create auto_login keystore from keystore identified by "supersecretpass";

Also note that wallet_type did not change to AUTOLOGIN. I need to restart database to achieve this, or is there some other way ..?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center