Installation Guide for Oracle Self-Service E-Billing > Configuring the Oracle Database >

Process of Implementing Tablespace Encryption

Tablespace Encryption encrypts the tablespaces identified in two SQL files during the creation of the Oracle Self-Service E-Billing database.

By default, Tablespace Encryption is disabled in Oracle Self-Service E-Billing. You must identify the tablespaces you want to encrypt and enable them in two SQL files as described in the following steps to implement Tablespace Encryption.

To set up Tablespace Encryption, perform the following tasks:

1. For each tablespace you want to encrypt, change the encrypted field value from FALSE to TRUE in the corresponding insert statements in the following two files. In the paths, EDX_HOME is the directory where you installed Oracle Self-Service E-Billing:
   • OLTP database:
     • UNIX. EDX_HOME/db/eStatement/oracle/estatblspace_list.sql
     • Windows. EDX_HOME\db\eStatement\oracle\estatblspace_list.sql
   • OLAP database:
     • UNIX. EDX_HOME/db/ebilling/oracle/olap/setupdatabaseolap.sql
     • Windows. EDX_HOME\db\ebilling\oracle\olap\setupdatabaseolap.sql

       In the following example of an insert statement, EDX_REPORT_IDX is the tablespace name. In the last two field values, FALSE and 3DES168, FALSE means this tablespace will not be encrypted by default, and 3DES168 is the encryption algorithm used for the Tablespace Encryption. Change the encrypted field value from FALSE to TRUE to enable encryption for this tablespace.

   :insert into "edocs_tablespace" (name, location, tablespace_size, auto_extend, auto_allocate, uniform_size, encrypted, encrypt_algorithm)

   value ('EDX_REPORT_IDX', '$L_DB_EDX_INDX_TB_FILE_LOC/edx_report_idx_01.dbf', '28M', 'TRUE', 'FALSE', '1m', 'FALSE', '3DES168');

2. Specify the Oracle Wallet Location using the steps in Specifying the Oracle Wallet Location.
3. Follow Step 1 through Step 9 in Creating the Oracle Self-Service E-Billing Database Using Ant to create the OLAP database instance. In the same procedure, follow Step 12 through Step 15 to create the OLTP database instance.
4. Follow the steps in Setting the Master Encryption Key to set the master encryption key.
5. Follow the steps in Opening the Encrypted Wallet to open the encrypted wallet.
6. Run the Ant script again. Select Option 1, Install the OLAP database. Select Option 4, Create OLAP tablespaces. Then select Option 5, Create an OLAP schema, and Option 6, Create OLAP database objects. Return to the Main Menu, and select Option 2, Install the OLTP database. Select Option 4, Install Application Database - Create tablespace and user and Option 5, Create the OLTP database objects.
7. Complete Step 19 through Step 23, in Creating the Oracle Self-Service E-Billing Database Using Ant. It is critical to follow these steps to load the seed data and to perform the ETL installation process. For information about installing ETL, see Installing the ETL Module for Oracle Self-Service E-Billing.

This process is a step in Roadmap for Configuring the Oracle Self-Service E-Billing Database.