We are setting up a new environment and database with Oracle encryption. Without encryption the database is Available in CSA, with encryption it's Not Available. How do we enable encryption correctly?
Release : Any
Component : CA PPM INTEGRATIONS & INSTALLATIONS
1. With DBA, open the sqlnet.ora file. Note the EncryptionLevel and EncryptionTypes
2. Now in CSA enable Use JDBC URL and append to the JDBC URL the attributes as follows (values should be the same as in the sqlnet.ora above):
Example (values will vary):
EncryptionLevel=required;EncryptionTypes=(AES256,AES192,AES128);DataIntegrityLevel=required;
3. Save and the database should become available.