ORA-12505 message after restart of System Agent after Peoplesoft plugin installation

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - System Agent (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• Workload Automation Agent
• CA Workload Automation AE

Issue/Introduction

After installation of the Peoplesoft plugin on the System Agent, following error message is found back in the peoplesoft log under the system agent log directory:

"ORA-12505, TNS:listener does not currently know of SID given in connect descriptor" 

Environment

Release : 11.3

Component : CA Workload Automation System Agent

Resolution

Modify following parameter in the agentparm.txt file

ps.db.url=jdbc:oracle:thin:@:<hostname>:<port>:<dbname>

to  

ps.db.url=jdbc:oracle:thin:@://<hostname>:<port>/<dbname>

Additional Information

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/intelligent-automation/workload-automation-agent-for-peoplesoft/12-0/plug-in-specific-parameters.html