Prerequisites and process overview

Ensure that your environment meets the prerequisites for Oracle TDE and review the configuration process.
Ensure that your environment meets the following prerequisites:
  1. IBM OpenPages® is installed.
  2. The Oracle instance is open and accepting connections.
  3. All users must be off of the system until all steps in the Oracle TDE configuration process are complete.
  4. The database compatibility parameter is set to your version of Oracle:
    • For Oracle 19c, use 19.0.0
Complete the following process to configure Oracle TDE:
  1. Configure a software keystore. Refer to the Oracle documentation.
  2. Encrypt the OpenPages and Cognos® table spaces that support encryption:
    1. Verify the value of the database compatible parameter.
    2. Do a full backup of the OpenPages schema.
    3. Do a full backup of the Cognos schema.
    4. Shut down all OpenPages components.
    5. Drop the OpenPages and Cognos table spaces.
    6. Re-create the OpenPages and Cognos table spaces.
    7. Verify that the table spaces are encrypted.
    8. Restore the OpenPages schema.
    9. Restore the Cognos schema.