My Oracle Support Banner

JDBC Connections Fail with Error: Not enough space TNS-12560 (Doc ID 220269.1)

Last updated on AUGUST 30, 2023

Applies to:

JDBC - Version 8.0.6.0 and later
Information in this document applies to any platform.

Symptoms

 JDBC connections are refused. From JDBC you see the following error:

java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=<VSNNUM>)(ERR=12500)(ERROR_STACK=(ERROR=(CODE=12500)(EMFI=4))(ERROR=(CODE=12540)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=510)(EMFI=4))(ERROR=(BUF='Solaris Error: 12: Not enough space'))))

In the trace file you may get the following type of error:

(CONNECT_DATA=(SID=<SID>)(CID=(PROGRAM=<PROGRAM>)(HOST=__jdbc__)(USER=<USER>))) * (ADDRESS=(PROTOCOL=tcp)(HOST=<HOSTNAME>)(PORT=<PORT>)) * establish * <INSTANCE> * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
Solaris Error: 12: Not enough space

After rebooting the server machine you can once again connect via JDBC.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.