Error - Oracle Advanced Security. To enable the driver to use OAS, please use the "dataIntegrityLevel" and/or "encryptionLevel" connect options.

Error - Oracle Advanced Security. To enable the driver to use OAS, please use the "dataIntegrityLevel" and/or "encryptionLevel" connect options.

book

Article ID: KB0075066

calendar_today

Updated On:

Products Versions
Spotfire Server All Versions

Description

While using TIBCO Data direct driver either creating a bootstrap file or while creating a new Data source, you may get the following error if EncryptioLevel is set on the database. 

[tibcosoftwareinc][Oracle JDBC Driver]The connect attempt failed because the server requires Oracle Advanced Security. To enable the driver to use OAS, please use the "dataIntegrityLevel" and/or "encryptionLevel" connect options. 

Resolution

Update the JDBC URL as follows.

jdbc:tibcosoftwareinc:oracle://Servername:portnumber;ServiceName=Servicename;DataIntegrityLevel=accepted;EncryptionLevel=accepted;EncryptionType=AES256

You may also have to install  the Java policy JAR (JCE) files from the following link if you see the error below.

http://www.oracle.com/technetwork/java/javase/downloads/jce8-download-2133166.html

==================================================================
Unable to open a connection to database 'Servername:portnumber;ServiceName=Servicename;DataIntegrityLevel=accepted;EncryptionLevel=accepted;EncryptionType=AES256' using account 'username'.; caused by: tibcosoftwareinc.jdbc.oraclebase.ddej: [tibcosoftwareinc][Oracle JDBC Driver]Failure due to insufficient maximum key length according to the installed JCE jurisdiction policy files. Please install "Java Cryptography Extension (JCE) Unlimited Strength Jurisdiction Policy File.
=================================================================

Issue/Introduction

[tibcosoftwareinc][Oracle JDBC Driver]The connect attempt failed because the server requires Oracle Advanced Security. To enable the driver to use OAS, use the "dataIntegrityLevel" and/or "encryptionLevel" connect options.