TNS-12500 TNS-12546 TNS-12560 TNS-00516 32-bit Windows Error: 5: Input/output error (Doc ID 1557213.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Net Services - Version 9.2.0.1 and later
Information in this document applies to any platform.

Symptoms

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 9.2.0.1.0 - Production on Tue May 21 13:56:24 2013

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

ERROR:
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 

Cause

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