OraFAQ Forum: Networking and Gateways » OracleOraDB11g

Home » RDBMS Server » Networking and Gateways » OracleOraDB11g_home1TNSListener Service (11.1.0.7.0)

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

OracleOraDB11g_home1TNSListener Service [message #583324]

Mon, 29 April 2013 11:30

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

Report message to a moderator

Re: OracleOraDB11g_home1TNSListener Service [message #583325 is a reply to message #583324]

Mon, 29 April 2013 11:39

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?

Report message to a moderator

Re: OracleOraDB11g_home1TNSListener Service [message #583326 is a reply to message #583325]

Mon, 29 April 2013 11:49

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

Report message to a moderator

Re: OracleOraDB11g_home1TNSListener Service [message #583327 is a reply to message #583326]

Mon, 29 April 2013 11:54

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

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

Senior Member
Account Moderator

Quote:

OS Installed: Windows ServicePack 2

Which Windows version? Which Windows edition?

Regards
Michel

Report message to a moderator

Re: OracleOraDB11g_home1TNSListener Service [message #583329 is a reply to message #583328]

Mon, 29 April 2013 12:16

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

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

Report message to a moderator

Re: OracleOraDB11g_home1TNSListener Service [message #583332 is a reply to message #583330]

Mon, 29 April 2013 12:47

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

Report message to a moderator

Re: OracleOraDB11g_home1TNSListener Service [message #583333 is a reply to message #583332]

Mon, 29 April 2013 12:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.lmgtfy.com/?q=oracle+windows+listener+service

Report message to a moderator

Re: OracleOraDB11g_home1TNSListener Service [message #583334 is a reply to message #583329]

Mon, 29 April 2013 12:56

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

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

Report message to a moderator

Re: OracleOraDB11g_home1TNSListener Service [message #583336 is a reply to message #583334]

Mon, 29 April 2013 13:19

GaneshAnanth
Messages: 34
Registered: January 2011
Location: Thanjavur

Member

Hi Michel,

It worked Yesterday Itself

Thanks,
Ganesh

Report message to a moderator

Re: OracleOraDB11g_home1TNSListener Service [message #583337 is a reply to message #583336]

Mon, 29 April 2013 13:24

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?

Report message to a moderator

Re: OracleOraDB11g_home1TNSListener Service [message #583338 is a reply to message #583336]

Mon, 29 April 2013 14:25

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 22:06:27 CST 2024