Database not Available in CSA when using Oracle Encryption

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

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

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 file you retrieved above):

For: 

SQLNET.ENCRYPTION_SERVER & SQLNET.ENCRYPTION_CLIENT in sqlnet.ora Equivalent Parameter is EncryptionLevel

SQLNET.CRYPTO_CHECKSUM_SERVER & SQLNET.CRYPTO_CHECKSUM_CLIENT in sqlnet.ora Equivalent Parameter is DataIntegrityLevel

SQLNET.ENCRYPTION_TYPES_SERVER & SQLNET.ENCRYPTION_TYPES_CLIENT in sqlnet.ora Equivalent Parameter is EncryptionTypes

SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER & SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT in sqlnet.ora Equivalent parameter is DataIntegrityTypes

 

Ex :- EncryptionLevel=required;EncryptionTypes=AES256;DataIntegrityLevel=required;DataIntegrityTypes=SHA1

3. Save and the database should become available. 

Additional Information

For more information check the documentation: Configure Clarity with Oracle Database Encryption