Hi Team,
We have an application with data residing in Oracle DB. We need to connect to the oracle database using jdbc url over ssl to collect accounts and entitlements (In other words need to configure ADC and EDC).
Can any one suggest is there a way to connect? If so what are the steps needs to be taken such as.....
1. Import SSL certificate into Keystore
2. Any configuration changes on jdbc driver used in the collector? etc..
Thanks.
As per the Oracle Collector Data Sheet below is the process to import the certificate for SSL Configuration for Oracle Database
WildFly Application Server:
1. Download/retrieve the Oracle SSL certificate in PEM format e.g. erpm.pem and save at some location.
2. cd /jre/lib/security.
3. Add certificates in cacerts by using keytool: keytool -import -file oracle.pem -alias oracle -keystore cacerts
4. Password for keystore (unless you have made any changes) : changeit
5. Restart the server: a. Run : afx stop b. Run : acm stop c. Run : acm start d. Run : afx start
Want to check if this alone is sufficient with no other changes. I cannot try this n my lab as I dont have that Oracle DB setup. So, want to check if anyone has tried this Oracle DB Collector authentication over SSL.