TNS-12500 TNS-12546 TNS-12560 TNS-00516 32-bit Windows Error: 5: Input/output error
Last updated on AUGUST 25, 2017
Applies to:Oracle Net Services - Version 18.104.22.168 and later
Information in this document applies to any platform.
Dedicated connections were failing with I/O error. Listener not able to spawn a oracle server process.
Connections to Windows database via TNS listener, start to fail reporting error code TNS-12500.
Bequeath connections on the server work fine
SQL*Plus: Release 22.214.171.124.0 - Production on Tue May 21 13:56:24 2013
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ORA-12500: TNS:listener failed to start a dedicated server process
Listener log shows full error stack for failing connection as:
21-MAY-2013 14:06:10 * (CONNECT_DATA=(SERVER=DEDICATED)(SID=DMS)(CID=(PROGRAM=E:\oracle\ora92\bin\sqlplus.exe)(HOST=myhostname)(USER=ghantak))) * (ADDRESS=(PROTOCOL=tcp)(HOST=XX.XXX.X.XX)(PORT=3914)) * establish * DMS * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
32-bit Windows Error: 5: Input/output error
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 hundreds of Community platforms