Verifying the current encryption algorithm

If you have a legacy system, verify the name of the current encryption algorithm before you run the UPEA tool to change the algorithm to AES as follows.

Procedure

  1. Log on to a machine with SQL*Plus and access to the database server.
  2. Execute the following SQL statement: 
    select algorithmname from encryptionmodules where inactive=0;
  3. When you are finished, log out of SQL*Plus.

Results

If the SQL statement returns the name:

  • 3DES, then run the UPEA tool to change the encryption algorithm to AES.
  • AES, then you already have the AES encryption algorithm. If you want, you can use the UPEA tool to change the AES encryption key.