Error while running Parallely all the jobs

[jpraveen]

Hi,

I am getting an error (given below) while running all the jobs parallely, and the job is getting aborted.

Fatal Error: Fatal: ORA-28547: connection to server failed, probable Oracle Net admin error

my source is ORACLE and Target is SQL-SERVER
there is no Transformation logic. I am using DRS for SOURCE and ODBC for TARGET. There are more than 25+ tables in Source & Target. Each job will load data into each target table. I had developed 25+ jobs.

But if I am running the jobs (e.g., 5 jobs at a time) these are running successful. Can anyone help in this?

Thanks in advance,

Praveen

[chulett]

You've already answered this - run fewer jobs at the same time, your system does not have infinite resources and cannot handle the load when all run simultaneously.