SSL port 2484 to connect to Oracle with the APM database

Products

• CA Application Performance Management Agent (APM / Wily / Introscope)
• CA Application Performance Management (APM / Wily / Introscope)
• INTROSCOPE
• DX Application Performance Management

Issue/Introduction

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.

https://www.oracle.com/technetwork/database/enterprise-edition/wp-oracle-jdbc-thin-ssl-130128.pdf

 

Environment

Application Performance Management 10.7

Resolution

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.

Additional Information

The documents say it is up to customer and their DBA to configure Oracle, SSL, and the APM Database.