Database Software

Hello Oracle Maniacs,

I am trying to implement TDE on my databases.

I have Oracle Database 11.1.0.7.0 installed.

Previously there was no open wallet. And I tried following steps:

1.  alter system set encryption key identified by "password"

2. Now we have wallet opened as I can check using following command

SQL> select * from v$encryption_wallet;

WRL_TYPE             WRL_PARAMETER                            STATUS

--------------------         ----------------------------------------                      ---------

file                          /u01/app/oracle/admin/t003/wallet            OPEN

3) Now when I am trying to create encrypted tablespace using following command, I am getting error.

SQL> create tablespace test_gsra_enc

D  2  ATAFILE '/u11/t003/temp_gsra/enc_df.dbf' size 100M

  3  ENCRYPTION USING 'AES256'

  4  DEFAULT STORAGE (ENCRYPT);

create tablespace test_gsra_enc

*

ERROR at line 1:

ORA-28374: typed master key not found in wallet

Could any please help me in rectifying this error?

Thanks,

Gursimran