Home » RDBMS Server » Networking and Gateways » OracleOraDB11g_home1TNSListener Service (11.1.0.7.0)
OracleOraDB11g_home1TNSListener Service [message #583324] Mon, 29 April 2013 11:30 Go to next message
GaneshAnanth
Messages: 34
Registered: January 2011
Location: Thanjavur
Member
Hi

Please help on starting the OracleOraDB11g_home1TNSListener service.


Error Message the TNSListener throws:
=====================================

The OracleOraDB11g_home1TNSListener service on Local Computer started and stopped.
Some services stop automatically if they have no work to do, for example, the performance Logs and Alerts service.

EventViewer Messages:

The OracleOraDB11g_home1TNSListener service was successfully sent a start control.
The OracleOraDb11g_home1TNSListener service entered the running state.
The OracleOraDb11g_home1TNSListener service entered the stopped state.

________________________________

C:\>lsnrctl status

LSNRCTL for 32-bit Windows: Version 11.1.0.7.0 - Production on 29-APR-2013 21:54
:15

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=target)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
32-bit Windows Error: 1001: Unknown error

________________________________

C:\> lsnrctl start

LSNRCTL for 32-bit Windows: Version 11.1.0.7.0 - Production on 29-APR-2013 21:56
:33

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

Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 11.1.0.7.0 - Production
System parameter file is D:\app\Ganesh\product\11.1.0\db_1\network\admin\listene
r.ora
Log messages written to d:\app\ganesh\diag\tnslsnr\NANDHU\listener\alert\log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521
ipc)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=target)(PORT=1521)
))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
32-bit Windows Error: 1001: Unknown error

Listener failed to start. See the error message(s) above...


Thanks,
Ganesh
Re: OracleOraDB11g_home1TNSListener Service [message #583325 is a reply to message #583324] Mon, 29 April 2013 11:39 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
which Edition of Windows is installed on this system?

when was the last time that the listener successfully started?
What changed since then?

>32-bit Windows Error: 1001: Unknown error
OS/networking mis-configuration

Both OS Services for database & listener must have been started & still running.
Is this true on your system?
Re: OracleOraDB11g_home1TNSListener Service [message #583326 is a reply to message #583325] Mon, 29 April 2013 11:49 Go to previous messageGo to next message
GaneshAnanth
Messages: 34
Registered: January 2011
Location: Thanjavur
Member
Hi BlackSwan,

THanks for the quick reply.

Its run fine yesterday itself.
Istalled a Software(Networking Wizard) to access internet through mobilephone. Facing issue after this installation.


Could you please explain more on your query how to check.

"Both OS Services for database & listener must have been started & still running."

Thanks,
Ganesh
Re: OracleOraDB11g_home1TNSListener Service [message #583327 is a reply to message #583326] Mon, 29 April 2013 11:54 Go to previous messageGo to next message
GaneshAnanth
Messages: 34
Registered: January 2011
Location: Thanjavur
Member

OS Installed: Windows ServicePack 2

Other Services OracleDBConsoleorcl, OracleJobSchedulerORCL, OracleServiceORCL are running fine.

Thanks,
Ganesh

[Updated on: Mon, 29 April 2013 11:59]

Report message to a moderator

Re: OracleOraDB11g_home1TNSListener Service [message #583328 is a reply to message #583327] Mon, 29 April 2013 12:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
OS Installed: Windows ServicePack 2


Which Windows version? Which Windows edition?

Regards
Michel
Re: OracleOraDB11g_home1TNSListener Service [message #583329 is a reply to message #583328] Mon, 29 April 2013 12:16 Go to previous messageGo to next message
GaneshAnanth
Messages: 34
Registered: January 2011
Location: Thanjavur
Member
OS Name: Microsoft Windows XP Professional.
Version : 5.1.2600 Service Pack 2 Build 2600

[Updated on: Mon, 29 April 2013 12:16]

Report message to a moderator

Re: OracleOraDB11g_home1TNSListener Service [message #583330 is a reply to message #583329] Mon, 29 April 2013 12:20 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Other Services OracleDBConsoleorcl, OracleJobSchedulerORCL, OracleServiceORCL are running fine.
I don't see any service for the Listener
Re: OracleOraDB11g_home1TNSListener Service [message #583332 is a reply to message #583330] Mon, 29 April 2013 12:47 Go to previous messageGo to next message
GaneshAnanth
Messages: 34
Registered: January 2011
Location: Thanjavur
Member
Hi BlackSwan,

Could you please explain me what I need to check for your above query.

Thanks,
Ganesh
Re: OracleOraDB11g_home1TNSListener Service [message #583333 is a reply to message #583332] Mon, 29 April 2013 12:55 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.lmgtfy.com/?q=oracle+windows+listener+service
Re: OracleOraDB11g_home1TNSListener Service [message #583334 is a reply to message #583329] Mon, 29 April 2013 12:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
GaneshAnanth wrote on Mon, 29 April 2013 19:16
OS Name: Microsoft Windows XP Professional.
Version : 5.1.2600 Service Pack 2 Build 2600


You MUST upgrade to Service Pack 3.

Regards
Michel

Re: OracleOraDB11g_home1TNSListener Service [message #583336 is a reply to message #583334] Mon, 29 April 2013 13:19 Go to previous messageGo to next message
GaneshAnanth
Messages: 34
Registered: January 2011
Location: Thanjavur
Member
Hi Michel,

It worked Yesterday Itself

Thanks,
Ganesh
Re: OracleOraDB11g_home1TNSListener Service [message #583337 is a reply to message #583336] Mon, 29 April 2013 13:24 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>It worked Yesterday Itself
How the fact above help, change, or impact what occurs now?
Things changed & now you have a different reality.

Does OS listener service exist?
What happens when you try to start it now?
Re: OracleOraDB11g_home1TNSListener Service [message #583338 is a reply to message #583336] Mon, 29 April 2013 14:25 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
GaneshAnanth wrote on Mon, 29 April 2013 20:19
Hi Michel,

It worked Yesterday Itself

Thanks,
Ganesh


This is the case with uncertified and unsupported configuration one day it works and the other one it does not.

Regards
Michel

[Updated on: Mon, 29 April 2013 14:26]

Report message to a moderator

Previous Topic: when creating new listener response is port already used
Next Topic: oracle 9i to Sql server 2008 R2 migration
Goto Forum:
  


Current Time: Fri Mar 29 03:55:02 CDT 2024