Maximum Oracle connections in a parallel job
Posted: Mon Apr 13, 2009 3:38 am
We are facing the following error when we run the job containing more than 10 simultaneous oracle connections [ Oracle Enterprise stage ]
ERROR:
Oracle_Enterprise_9,2: ORA-12537: TNS:connection closed
Oracle_Enterprise_9,2: The call to sqlldr failed; the return code = 256;
eg., Oracle Source -----> Oracle_Target1, Oracle_Target2, Oracle_Target3, Oracle_Target4, Oracle_Target5 (Each target has two statements, one for insert and other as update)
ERROR:
Oracle_Enterprise_9,2: ORA-12537: TNS:connection closed
Oracle_Enterprise_9,2: The call to sqlldr failed; the return code = 256;
eg., Oracle Source -----> Oracle_Target1, Oracle_Target2, Oracle_Target3, Oracle_Target4, Oracle_Target5 (Each target has two statements, one for insert and other as update)