Friday, January 21, 2011

HOW TO CREATE WALLET FOR TDE(ASO)

STEP 1:CREATE THE WALLET DIRECTORY:
===================================
mkdir -p /oracle/dbtools/TDE/10.2.0/wallet

STEP 2:CHANGE THE WALLET PERMISSIONS:
====================================
chmod 0700 wallet

STEP 3:EDIT THE SQLNET.ORA FILE:
===============================
SQLNET.EXPIRE_TIME =5

ENCRYPTION_WALLET_LOCATION = (SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY = /oracle/dbtools/TDE/10.2.0/wallet/)))

STEP 4:STOP & START THE LISTENER:
=========================
LSNRCTL STOP LISTENERNAME & LSNRCTL START LISTENER NAME

STEP 5:CREATE THE ENCRYPTION KEY:
=================================
ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "********";

STEP 6:CONFIRM WHETHER ENCRYPTION KEY IS CREATED IN WALLET DIRECTORY:
====================================================================

STEP 7:OPEN THE WALLET IF ITS NOT OPEN:

alter system set wallet open identified by "********";

No comments: