ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

DB or SQL job fails with Oracle 19c database, JDBC or listener issue


Article ID: 225161


Updated On:


Workload Automation Agent


User is trying to run a DB (SQL) job and gets the following messages.

XX/xx/2021 00:00:12.345-0400 1 DatabasePlugin.database Internal Thread.CybWOBRunSqlHandler.processWob[:82] - 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




The JDBC URL string is not correctly setup in agentparm.txt or in the job.


Release : 12.0

Component : CA Workload Automation Database Agent


The Oracle 19c now has services instead of SID.  The connection string will need to point to service name which can also be obtained from tnsnames.ora.

     (ADDRESS = (PROTOCOL = TCP)(HOST = = 1521))

The following is correct example of JDBC string with Oracle service name:     <-- Put Service name after port.  See tnsnames.ora for details.

Change the JDBC URL in agentparm.txt and restart the agent.

The JDBC URL may also be added in the job to override the agentparm.txt.