Enforce installer fails while Oracle database is in cloud.

Products

• Data Loss Prevention
• Data Loss Prevention Core Package
• Data Loss Prevention Enforce

Issue/Introduction

Enforce installation results in error and failure while installation is for DB placed in Oracle cloud.

Log reports similar errors:

Caused by: org.apache.ojb.broker.PersistenceBrokerException: Could not get key value
    at org.apache.ojb.broker.util.BrokerHelper.setAutoIncrementValue(BrokerHelper.java:338)
    at org.apache.ojb.broker.util.BrokerHelper.getValuesForObject(BrokerHelper.java:373)
    at org.apache.ojb.broker.Identity.init(Identity.java:216)
    ... 9 more
Caused by: org.apache.ojb.broker.util.sequence.SequenceManagerException: 
Could not grab next id, failed with 
Used ConnectionManager instance could not obtain a connection
Creation of new sequence failed with 
Used ConnectionManager instance could not obtain a connection

    at org.apache.ojb.broker.util.sequence.SequenceManagerNextValImpl.getUniqueLong(SequenceManagerNextValImpl.java:137)
    at org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueValue(AbstractSequenceManager.java:140)
    at org.apache.ojb.broker.util.BrokerHelper.setAutoIncrementValue(BrokerHelper.java:325)
    ... 11 more
Caused by: org.apache.ojb.broker.PersistenceBrokerException: Used ConnectionManager instance could not obtain a connection
    at org.apache.ojb.broker.accesslayer.StatementManager.getGenericStatement(StatementManager.java:598)
    at org.apache.ojb.broker.util.sequence.SequenceManagerNextValImpl.createSequence(SequenceManagerNextValImpl.java:206)
    at org.apache.ojb.broker.util.sequence.SequenceManagerNextValImpl.getUniqueLong(SequenceManagerNextValImpl.java:133)
    ... 13 more
Caused by: org.apache.ojb.broker.accesslayer.LookupException: Could not get connection from DBCP DataSource
    at org.apache.ojb.broker.accesslayer.ConnectionFactoryDBCPImpl.checkOutJdbcConnection(ConnectionFactoryDBCPImpl.java:119)
    at org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnection(ConnectionFactoryAbstractImpl.java:139)
    at org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:121)
    at org.apache.ojb.broker.accesslayer.StatementManager.getGenericStatement(StatementManager.java:594)
    ... 15 more
Caused by: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:903)
    at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:820)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:80)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:820)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:624)
    at java.sql.DriverManager.getConnection(DriverManager.java:664)
    at java.sql.DriverManager.getConnection(DriverManager.java:208)
    at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:78)
    at org.apache.ojb.broker.accesslayer.ConnectionFactoryDBCPImpl$ConPoolFactory.createConnection(ConnectionFactoryDBCPImpl.java:447)
    at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
    at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1148)
    at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
    at org.apache.ojb.broker.accesslayer.ConnectionFactoryDBCPImpl.checkOutJdbcConnection(ConnectionFactoryDBCPImpl.java:115)
    ... 18 more
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
    at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:720)
    at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:586)
    at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:729)
    at oracle.net.ns.NSProtocol.connect(NSProtocol.java:340)
    at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1702)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:627)
    ... 30 more
Caused by: oracle.net.ns.NetException: Unable to initialize ssl context.
    at oracle.net.nt.CustomSSLSocketFactory.createSSLContext(CustomSSLSocketFactory.java:434)
    at oracle.net.nt.CustomSSLSocketFactory.getSSLContext(CustomSSLSocketFactory.java:358)
    at oracle.net.nt.CustomSSLSocketFactory.getSSLContext(CustomSSLSocketFactory.java:326)
    at oracle.net.nt.TcpsNTAdapter.newSSLEngine(TcpsNTAdapter.java:624)
    at oracle.net.nt.TcpsNTAdapter.connect(TcpsNTAdapter.java:210)
    at oracle.net.nt.ConnOption.connect(ConnOption.java:195)
    at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:653)
    ... 35 more
Caused by: oracle.net.ns.NetException: Unable to initialize the key store.
    at oracle.net.nt.CustomSSLSocketFactory.keyStoreFailure(CustomSSLSocketFactory.java:730)
    at oracle.net.nt.CustomSSLSocketFactory.createSSLContext(CustomSSLSocketFactory.java:382)
    ... 41 more
Caused by: java.security.KeyStoreException: SSO not found
    at java.security.KeyStore.getInstance(KeyStore.java:851)
    at oracle.net.nt.CustomSSLSocketFactory.getKeyStoreInstance(CustomSSLSocketFactory.java:984)
    at oracle.net.nt.CustomSSLSocketFactory.loadKeyStore(CustomSSLSocketFactory.java:1121)
    at oracle.net.nt.CustomSSLSocketFactory.createSSLContext(CustomSSLSocketFactory.java:376)
    ... 41 more
Caused by: java.security.NoSuchAlgorithmException: SSO KeyStore not available
    at sun.security.jca.GetInstance.getInstance(GetInstance.java:159)
    at java.security.Security.getImpl(Security.java:695)
    at java.security.KeyStore.getInstance(KeyStore.java:848)
    ... 44 more

Environment

Enforce installation that use Autonomous DB located in Oracle cloud. 

Resolution

Currently we do not support Autonomous DB  as it does not allow to run DLP script to create the protect user.