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)
Maximum Oracle connections in a parallel job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 21
- Joined: Wed Mar 12, 2008 4:05 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: