Your suggested change has been received. Thank you.

close

Suggest A Change

https://thales.na.market.dpondemand.io/docs/dpod/services/kmo….

back

Oracle Transparent Data Encryption (TDE)

Integrating TDE with CipherTrust Manager on Oracle 12c RAC

search

Integrating TDE with CipherTrust Manager on Oracle 12c RAC

This section explains how to integrate TDE with CipherTrust Manager on Oracle 12c RAC. This chapter covers the following topics:

Verifying Oracle RAC Installation

To verify the Oracle RAC Installation and configuration, refer to the Oracle Documentation.

To check the status of database instances on each node, execute the following command:

1
$ srvctl status database -d <db_name>

Output:

1
2
Instance ORCL1 is running on node orcl1
Instance ORCL2 is running on node orcl2

Ensure that database instances are up and running.

Configuring Manual HSM Wallet on Fresh Setup

To configure HSM wallet on an Oracle RAC setup, perform the steps mentioned in the Configure Manual HSM Wallet‌ section.

Configuring Auto-login Wallet

  1. Perform the steps mentioned in the Configure Auto-login Wallet‌ section.

  2. Copy the sqlnet.ora and cwallet.sso file from the configured node to all other nodes at the same location.

  3. Access the data from the other node(s).

Migrating from Software Wallet to HSM Wallet

  1. Perform the steps mentioned in the Migrating from Software Wallet to HSM Wallet section.

    A key is created on the CipherTrust Manager.

  2. Access the data from the encrypted tablespace and tables.

    1
    2
    SELECT * FROM EMPLOYEES;
    SELECT * FROM CUSTOMERS;
    

For other node(s), perform the same steps as mentioned above.

Migrating Manual Software Wallet to Auto-login HSM Wallet‌

  1. Perform the steps mentioned in the Migrate Manual Software Wallet to Auto-login HSM Wallet section.‌

  2. Copy the sqlnet.ora and cwallet.sso file from the configured node to all other nodes at the same location.

  3. Connect to the database instance and access the data from the encrypted tablespace and tables.

    1
    2
    SELECT * FROM EMPLOYEES;
    SELECT * FROM CUSTOMERS;
    

Migrating Auto-login Software Wallet to Auto-login HSM Wallet‌

  1. Perform the steps mentioned in the Migrate Auto-login Software Wallet to Auto-login HSM Wallet section.

  2. Copy the sqlnet.ora and cwallet.sso file from the configured node to all other nodes at the same location.

  3. Connect to the database instance and access the data from the encrypted tablespace and tables.

    1
    2
    SELECT * FROM EMPLOYEES;
    SELECT * FROM CUSTOMERS;