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

book

Article ID: 194618

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - System Agent (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) CA 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