Sample Header Ad - 728x90

SQL Loader intermittently throws "ORA-12516: TNS:listener could not find available handler with matching protocol stack"

1 vote
0 answers
1565 views
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
> 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
Asked by Abhinav Soni (11 rep)
Sep 4, 2017, 10:04 AM
Last activity: Sep 4, 2017, 01:12 PM