Error Writing To Server: [errno 32] Broken Pipe

Question: What causes this Linux error 32 broken pipe error:

TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe

How do I fix this error 32?

Answer: The Linux error 32 broken pipe indicates that the listener process could not create a dedicated server process to hand the client request.

This error is caused by a resource exhaustion issue, either within the OS or within the Oracle instance. Possible causes for the Linux error 32 include:

You may have reached the max processes limit set on the database and cannot spawn a new server connection process.
You have hit some RAM memory limit or some other OS issue that is preventing the server process from been created (spawned).
The log file for the listener (located at $ORACLE_HOME/network/log/listener.log) has reached the 2GB file size limit on Linux. To alleviate the problem, simply archive or delete the listener log file and restart the listener process with lsnrctl start.
This broken pipe error can also be a permission issue. If the sticky bit is not set up for the owner permission of @ORACLE_HOME/bin/oracle binary file, then the user could not complete the process required to handover the inbound connection to the database, which give the Linux error 32: broken pipe.

$ chmod 6751 /u01/app/oracle/product/12.1.0/dbhome_1/bin/oracle

Oracle Training from Don Burleson

The best on site " Oracle training classes" are just a phone call away! You can get personalized Oracle training by Donald Burleson, right at your shop!

Oracle consulting and training

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata? Oracle technology is changing and we strive to update our BC Oracle support information. If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just e-mail:

and include the URL for the page.