Database not Available in CSA when using Oracle Encryption

Products

• Clarity PPM On Premise
• STARTER PACK-CLARITY PPM

Issue/Introduction

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? 

Environment

Release : Any

Component : CA PPM INTEGRATIONS & INSTALLATIONS

Resolution

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. 

Additional Information

For more information check the documentation: https://techdocs.broadcom.com/us/en/ca-enterprise-software/business-management/clarity-project-and-portfolio-management-ppm-on-premise/15-9-1/installing-and-upgrading/configure-clarity-ppm-with-oracle-database-encryption.html