We are trying to establish a TLS/SSL connection between wily app servers and wily DB server by using port 2484. Currently, we are using port 1521.
The necessary settings have been made from the Oracle DB end.
We have made relevant changes to tess-db-cfg.xml but it fails to connect to database.
We are following the steps mentioned in below link which talks about SSL for encryption only.
Release : 10.7.0
Component : APM Agents
Customer found third-party solution:
We downloaded and installed the Oracle Database19c client from https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html.
Post installation, we created sqlnet.ora and tnslisterner.ora to test the connection with port 2484 in our working session.
We also created wallets on the APM server and exchanged certs between wily application and the database server.
I then made the necessary changes to tess-db-cfg.xml file to test JDBC connection to use port 2484 and the connection is now successful.
The documents say it is up to customer and their DBA to configure Oracle, SSL, and the APM Database.