Data-At-Rest Encryption for Oracle database
As part of database security, DBA need to enable encryption for the database. In this blog, we will go through the steps for encryption at rest in oracle database. Step 1) Add following entry in sqlnet.ora on all node of RAC cluster. Step 2) Create TDE directory on all the nodes on the cluster. mkdir -p $ORACLE_BASE/tde/$ORACLE_SID Step 3) Create Wallet and Encrption key. SQL> prompt Creating the Password based Key Store prompt administer key management create keystore '$ORACLE_BASE/tde/$ORACLE_SID' identified by "<Master Key>; prompt Opening the Password based Key Store prompt administer key management set keystore open identified by "<Master Key>"; prompt Creating and Setting the Master Encryption Key prompt administer key management set key identified by "<Master Key>" with backup using 'TDE'; prompt Creating the auto-login for Key Store prompt administer key management create auto_login keystore from keystore ...