I am running a weekly batch job which is loading data from txt/csv files to database using SQL Loader. But SQL Loader intermittently throws below error:

SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
ORA-12516: TNS:listener could not find available handler with matching protocol stack.

As understood from similar posts, we have increased maximum number of sessions/connections limit which reduced the failure cases to lower side, but not totally resolved the similar issue. Do we also need to increase the maximum number of concurrent processes, as in the below screen shot I can see that oracle concurrent processes are exhausted? If not, please share your thought process if any other solution to the cause.

enter image description here

  • Unless you're running on hardware that's 30 years old & have a sane reason for having the limits so low, increase the limits significantly. – Philᵀᴹ Sep 4 '17 at 10:11
  • Yes, you increasing the number of processes is one way of handling this. But that is just treating the symptom, and you should still investigate the root cause = why 400 processes are needed? – Balazs Papp Sep 4 '17 at 14:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.