Home » RDBMS Server » Networking and Gateways » I cannot start the Listener
I cannot start the Listener [message #122306] Sun, 05 June 2005 10:15 Go to next message
Nov2005
Messages: 1
Registered: June 2005
Junior Member
hi

i am using Oracle 10g on win2000, local database.

I cannot start listener.

From DOS,
when I use LSNRCTL> START LISTENER, i have following errors.
Starting tnslsnr: please wait...

Failed to start service, error 1058.
TNS-12536: TNS:operation would block
TNS-12560: TNS:protocol adapter error
TNS-00506: Operation would block
32-bit Windows Error: 997: Unknown error

I cannot start from services either.

My listener.ora setting is
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_4)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl2)
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_4)
(SID_NAME = orcl2)
)



)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
)

tnsnames.ora setting as below.

# tnsnames.ora Network Configuration File: C:\oracle\product\10.1.0\Db_4\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl2)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

Please help me.
Thank You.

Nov
Re: I cannot start the Listener [message #122343 is a reply to message #122306] Mon, 06 June 2005 01:11 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
no action is required. Just restart the server. Error 997 in windows means "Overlapped I/O operation is in progress."
icon1.gif  Re: I cannot start the Listener [message #250040 is a reply to message #122306] Sat, 07 July 2007 03:38 Go to previous messageGo to next message
rvemuri
Messages: 1
Registered: July 2007
Junior Member
Solution Description
--------------------

Step 1 : Go to control panel, services.
Step 2 : Click on the TNSListener service and select 'hardware profiles' button.
Step 3 : Enable the profile and validate it by OK .
Step 4 : You should now be able to start the TNSListener service.


Explanation
-----------

If you already have a service 'Oracle<SID>TNSListener' and you try to recreate it
it could be disabled.
You must delete the service from the registry before it can be recreated.

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Oracle<SID>TNSListener

Regards
Oracle Experts Group
Flint Solutions
APAC
Re: I cannot start the Listener [message #250109 is a reply to message #250040] Sat, 07 July 2007 23:32 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
With the thread being over two years old, I surely hope the OP got his problem solved by now.
Re: I cannot start the Listener [message #250112 is a reply to message #250109] Sun, 08 July 2007 01:09 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Brian,
Ramesh reported his message was just to help if someone will have the same problem one day.
I should keep this at least 24 hours before deleting it to let time enough to all moderators to read it.

Ramesh,
Sorry for that.

Regards
Michel
Previous Topic: TNS-12560: TNS:protocol adapter error
Next Topic: is this enough to build up my tnsnames.ora ?
Goto Forum:
  


Current Time: Fri Dec 09 05:49:21 CST 2016

Total time taken to generate the page: 0.11351 seconds