Database not Available in CSA when using Oracle Encryption
search cancel

Database not Available in CSA when using Oracle Encryption

book

Article ID: 209388

calendar_today

Updated On:

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