Troubleshooting
Problem
IBM Security Guardium: Database Test Connection is failing for Oracle database with Oracle Advanced Security enabled with error below: com.inm.guardium.jdbc.oraclebase.ddej: [guardium][Oracle JDBC Driver]The connect attemppt failed because the server requires Oracle Advanced Security. To enable the driver to use OAS, please use the "dataIntegrityLevel" and/or "encryptionLevel" connect option
Symptom
Test Connection fails with error:
com.inm.guardium.jdbc.oraclebase.ddej: [guardium][Oracle JDBC
Driver]The connect attemppt failed because the server requires Oracle
Advanced Security. To enable the driver to use OAS, please use the
"dataIntegrityLevel" and/or "encryptionLevel" connect option
Cause
Oracle is using Oracle Advanced Security which requires additional security parameters in the connection string.
Environment
Guardium v9.x or v10.x and Oracle datasource with Oracle Advanced Security
enabled
enabled
Diagnosing The Problem
You are in presence of this problem if:
1. You get this error when testing the database connection:
com.inm.guardium.jdbc.oraclebase.ddej: [guardium][Oracle JDBC
Driver]The connect attemppt failed because the server requires Oracle
Advanced Security. To enable the driver to use OAS, please use the
"dataIntegrityLevel" and/or "encryptionLevel" connect option
AND
2. The Oracle database has Oracle Advanced Security enabled
1. You get this error when testing the database connection:
com.inm.guardium.jdbc.oraclebase.ddej: [guardium][Oracle JDBC
Driver]The connect attemppt failed because the server requires Oracle
Advanced Security. To enable the driver to use OAS, please use the
"dataIntegrityLevel" and/or "encryptionLevel" connect option
AND
2. The Oracle database has Oracle Advanced Security enabled
Resolving The Problem
Specify one of the following options for the
Datasource , using the "Connection properties " field in the datasource configuration
window:
window:
EncryptionLevel=required
or
DataIntegrityLevel=required
or
EncryptionLevel=required, DataIntegrityLevel=required
or
DataIntegrityLevel=required
or
EncryptionLevel=required, DataIntegrityLevel=required
Sample screenshot of how the Datasource may look:
[{"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Guardium Appliances","Platform":[{"code":"PF016","label":"Linux"}],"Version":"10.0;10.0.1;10.1;10.1.2;10.1.3;9.0;9.1;9.5","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]
Was this topic helpful?
Document Information
Modified date:
26 April 2019
UID
swg22009449