How to configure secure DB connection in ADF-config.xml for deploying the SOA artifacts into MDS.
Recently we have moved from non-ssl to SSL both from the application database and when trying to deploy SOA artifacts to MDS store getting SSL handshake error.
below are the property passed in ADF-config.xml
<metadata-store class-name="oracle.mds.persistence.stores.db.DBMetadataStore">
<property value="PROD_MDS" name="jdbc-userid"/>
<property value="******" name="jdbc-password"/>
<property value="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=xxxxxxxxxx)(PORT=1535))(CONNECT_DATA=(SERVICE_NAME=xxxxx)))" name="jdbc-url"/>
<property value="$storelocation/truststore_aiadb.jks" name="javax.net.ssl.trustStore"/>
<property value="********" name="javax.net.ssl.trustStorePassword"/>
<!--<property value="/app/local/softwares/jdk1.7.0_80/jre/lib/security/cacerts" name="javax.net.ssl.trustStore"/>
<property value="*******" name="javax.net.ssl.trustStorePassword"/>-->
<property value="jks" name="javax.net.ssl.trustStoreType"/>
<property value="1.2" name="oracle.net.ssl_version"/>
<property value="10000" name="oracle.net.CONNECT_TIMEOUT"/>
<property value="soa-infra" name="partition-name"/>
</metadata-store>
Error:-
[scac] MDS-01370: MetadataStore configuration for metadata-store-usage "mstore-usage_3" is invalid.
[scac] MDS-01259: The metadata store "oracle.mds.persistence.stores.db.DBMetadataStore" cannot be instantiated.
[scac] MDS-00003: error connecting to the database
[scac] Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: Remote host closed connection during handshake
regards,
Tarak.