OraFAQ Forum: Networking and Gateways » I cannot start the Listener

Home » RDBMS Server » Networking and Gateways » I cannot start the Listener

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

I cannot start the Listener [message #122306]

Sun, 05 June 2005 10:15

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

Report message to a moderator

Re: I cannot start the Listener [message #122343 is a reply to message #122306]

Mon, 06 June 2005 01:11

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."

Report message to a moderator

Re: I cannot start the Listener [message #250040 is a reply to message #122306]

Sat, 07 July 2007 03:38

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

Report message to a moderator

Re: I cannot start the Listener [message #250109 is a reply to message #250040]

Sat, 07 July 2007 23:32

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.

Report message to a moderator

Re: I cannot start the Listener [message #250112 is a reply to message #250109]

Sun, 08 July 2007 01:09

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 10:37:04 CST 2025