Error while Starting Listener Program

[Former Member]

Hi,

I have successfully installed the Oracle 10g in Windows 2003 server machine.
Now I am trying to connect this database from client machine .
When I have checked the status using LSRNCT STATUS I am getting the following error message

LSNRCTL> status

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)) )

TNS-12541: TNS:no listener

TNS-12560: TNSProtocol adapter error

TNS-00511: No listener

32-bit Windows Error: 2: No such file or directory

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=something.com)(PORT=1521)))

TNS-12541: TNS:no listener

TNS-12560: TNSProtocol adapter error

TNS-00511: No listener

32-bit Windows Error: 61: Unknown error

LSNRCTL>

So I try to start the listener I am getting the following error message

C:\Documents and Settings\XXXX>lsnrctl start

LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 12-FEB-2013 09:08:44

Copyright (c) 1991, 2004, Oracle. All rights reserved.

Starting tnslsnr: please wait...

TNS-12560: TNSProtocol adapter error
TNS-00530: Protocol adapter error

Can anyone tell me how to resolve this?

Thanks,

Chris

[former_member192421 · Accepted solution]

Hi Chris,

Could you please check if the Listener Service is up and running in the Windows Service window?

If not, it seems the installtion was not done properly. I faced this kind issue sometimes back.

Anyways, you can add this service using following steps.
Using Microsoft Resource Tool kit, Create the Service name exactly as OracleOraDb10g_<SID>TNSListener and called the TNSLSNR.exe with command line parameter of the LISTENER (Listener ora file name).
then start the service. At last reboot the system once.

Let me know if it helps.

Regards,

Rajkumar

[Former Member · Accepted solution]

Hi Guys,

Thanks for your help. The installation was not properly done.

As the system is a DEV system..so no worrys..

Thanks Again...

[Former Member · Accepted solution]

the Windows Service Oracle Listener Service is not created by the Oracle RDBMS installation.

It is created when you the first time start the listener using lsnrctl start.

regards

Peter