Error ORA-12505 while configuring Oracle DB extension on Infrastructure agent against Oracle 19c

Products

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

Issue/Introduction

Trying to deploy Oracle DB extension on APM Infrastructure agent against an Oracle 19c database and it is failing to connect with the following error in the log

1/27/21 08:49:44 AM GMT [ERROR] [IntroscopeAgent.DBMonitor]
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

 We have verified in the bundle.properties the value for the property

introscope.agent.dbmonitor.oracle.profiles.db1.instanceName=

and it is correct 

Environment

Release : 20.x

Component : APM Infrastructure Agent Oracle DB extension

 

 

Cause

Oracle 19c connection url has a different format compared to Oracle 12c

"jdbc:oracle:thin:@{hostName}:{port}/{instanceName}"

instead of 

"jdbc:oracle:thin:@{hostName}:{port}:{instanceName}"

Resolution

In the APMIA_HOME/extensions/oracledb-xxxx-20.x.x.x/config folder edit the file schema.json and change

"jdbcUrl":"jdbc:oracle:thin:@{hostName}:{port}:{instanceName}" 

to

"jdbcUrl":"jdbc:oracle:thin:@{hostName}:{port}/{instanceName}"

 

Additional Information

As of 8 Mar 2021 Oracle 19c is not officially certified and supported for use with APM IA Orace DB monitor extension