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


Article ID: 207767


Updated On:


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


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 the value for the property

and it is correct 


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


instead of 



Release : 20.x

Component : APM Infrastructure Agent Oracle DB extension




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





Additional Information

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