I got the following message when I start the listener in Window 2000:
Failed to start service, error 1058.
TNS-12536: TNS: operatioin would block
TNS-12560: TNS: protocol adapter error
TNS-00506: operation would block
32-bit windows error: 997: unknow error
My listener file:
# LISTENER.ORA Network Configuration File: D:\oracle\ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.
A Windows bug is one reason per MetaLink. Here is one solution:
CODE CONNECT_TIMEOUT_LISTENER = 30 IN LISTENER.ORA
Code CONNECTION_TIMEOUT_LISTENER = 30 in listener.ora file. This allows more connections and resolves the problem.
12-16-2002, 02:58 PM
Thanks for your response.
I updated the CONNECT_TIMEOUT_LISTENER = 30 IN LISTENER.ORA and rebooted the server, but still got the same error message.
12-16-2002, 04:42 PM
Blu. you dont have to reboot your server everytime you change your listener.ora. you just have to bounce the listener..
Q1. was the listener working before?
Q2. Did you make changes to permissions?
12-16-2002, 04:43 PM
1. first check if u can connect to the database locally, ( NOT FROM THE CLIENT). try c:\sqlplus username/password2. Ensure that the LOCAL and TWO_TASK environment variable are not defined 3. The database installation may have failed to make a registry entry for ORACLE_SID. Try adding the string value ORACLE_SID and modifying its data to the proper sid name. Verify that ORACLE_HOME and ORACLE_SID are entered into the registry properly in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEx. The bequeath adapter attempts to connect to the default ORACLE_SID in the default ORACLE_HOME.