Jobs are stuck in READY / Starting state in Oracle EBS Agent

Products

• Workload Automation Agent
• ESP dSeries Workload Automation - System Agent (dSeries)
• ESP dSeries Workload Automation - Scheduler (dSeries)
• ESP dSeries Workload Automation - Business Agents (dSeries)

Issue/Introduction

Jobs are in running state for the OASG Oracle.  Jobs complete in another another node2  for the same Oracle instance

Environment

Workload Automation Agent: 12.1 or above 

OS: Any

Cause

The Agent logs may will show error like this:

oracle.net.ns.NetException: ORA-12514: Cannot connect to database. Service TEST is not registered with the listener at host oracle-scan.example.com port 7900. (CONNECTION_ID=##########)
https://docs.oracle.com/error-help/db/ora-12514/

 

Resolution

The error "ORA-12514" is coming from Oracle JDBC.  Check to make sure your Oracle Apps DB is up and accessible from the WA Agent host / machine.  In DB has multiple nodes / scan then point your jobs to a different node.  The error can be due to either connections are being blocked or throttled by some process.