Today, we moved them to our test server, and some of the jobs failed with a ORA-12545 Connect failed because target host or object failed. Approximately 20 out of 35 failed; the rest worked. If the server job was recompiled and run without using the sequencer, the job worked. The job is still receiving all its connection information from env variables.
We tried re-exporting the jobs and importing into a fresh project. Nothing appeared to have changed; jobs still fail. Recompiling the sequence job does not make any difference. The job still fails. The jobs that work do not appear to be significantly different in structure from the jobs that fail.
I examined the variables passed to the server job; they look ok.
I am baffled as to what might cause the problem or even how to diagnose what is happening at this point.
![Crying or Very sad :cry:](./images/smilies/icon_cry.gif)
Jeanne