OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » No Listener

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

No Listener [message #296583]

Mon, 28 January 2008 05:52

rinwan
Messages: 7
Registered: January 2008
Location: Thimphu, Bhutan

Junior Member

Dear Experts

I have a oracle 8.1.7 installed on Windows XP (Computer Name=Server). I can connect to oracle in the local host when the network cable is removed from the system. But the problem is after connecting the network cable, I cannot connect to oracle. The error message is ORA-12541 TNS:no listener.

Can anybody help me with this.

Thanks in Advance

Rinchen

Report message to a moderator

Re: No Listener [message #296593 is a reply to message #296583]

Mon, 28 January 2008 06:22

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

ORA-12541: TNS:no listener

Cause: The connection request could not be completed because the listener is not running.

Action: Ensure that the supplied destination address matches one of the addresses used by the listener - compare the TNSNAMES.ORA entry with the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to go by way of an Interchange). Start the listener on the remote machine.

Report message to a moderator

Re: No Listener [message #296996 is a reply to message #296583]

Tue, 29 January 2008 21:25

rinwan
Messages: 7
Registered: January 2008
Location: Thimphu, Bhutan

Junior Member

Dear Mohammad

Thanks for your response but I did both the things you have mentioned. I mean compared the tnsnames.ora and listener.ora. Every thing seems fine there. Also the listener is up and running.

Is there anything else which could have caused the problem.

rinchen

Report message to a moderator

Re: No Listener [message #297016 is a reply to message #296996]

Tue, 29 January 2008 23:02

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

Senior Member
Account Moderator

Do you do this:

Quote:

Start the listener on the remote machine.

Have you another tnsnames.ora or listener.ora?
Does TNS_ADMIN environment variable set?
Post "lsnrctl status"
Post relevant lines of files
...

Regards
Michel

Report message to a moderator

Re: No Listener [message #297096 is a reply to message #296583]

Wed, 30 January 2008 02:37

rinwan
Messages: 7
Registered: January 2008
Location: Thimphu, Bhutan

Junior Member

Dear Michel

here are the information you are asking for.
.................................................................
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = cas.world)
(PRESENTATION = http://admin)
)
)

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

CAS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = cas.world)
)
)
................................................................
# LISTENER.ORA Network Configuration File: C:\oracle\ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora81)
(PROGRAM = extproc)
)
)

.................................................................
LSNRCTL for 32-bit Windows: Version 8.1.7.0.0 - Production on 30-JAN-2008 12:00:
06

(c) Copyright 1998 Oracle Corporation. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> start
TNS-01106: Listener using listener name LISTENER has already been started
LSNRCTL>
...............................................................

And what does TNS_ADMIN environment variable mean.

Thanks and regards

Rinchen

Report message to a moderator

Re: No Listener [message #297109 is a reply to message #297096]

Wed, 30 January 2008 03:03

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

Senior Member
Account Moderator

"status" or "services" not "start".

TNS_ADMIN is a variable like ORACLE_HOME that points to the directory containing tnsnames.ora file.

I need information on client machine not server one.

Regards
Michel

[Updated on: Wed, 30 January 2008 03:05]

Report message to a moderator

Re: No Listener [message #297131 is a reply to message #296583]

Wed, 30 January 2008 04:39

rinwan
Messages: 7
Registered: January 2008
Location: Thimphu, Bhutan

Junior Member

Dear Michel

here is the response for status and service from LSNRCTL.
.................................................................
LSNRCTL for 32-bit Windows: Version 8.1.7.0.0 - Production on 30-JAN-2008 15:23:
41

(c) Copyright 1998 Oracle Corporation. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server)(PORT=1521)))
TNS-12535: TNS:operation timed out
TNS-12560: TNS:protocol adapter error
TNS-00505: Operation timed out
32-bit Windows Error: 60: Unknown error
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Produc
tion
Start Date 30-JAN-2008 14:13:19
Uptime 0 days 1 hr. 10 min. 57 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File C:\oracle\ora81\network\admin\listener.ora
Listener Log File C:\oracle\ora81\network\log\listener.log
Services Summary...
PLSExtProc has 1 service handler(s)
cas has 2 service handler(s)
The command completed successfully
LSNRCTL> service
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server)(PORT=1521)))
TNS-12535: TNS:operation timed out
TNS-12560: TNS:protocol adapter error
TNS-00505: Operation timed out
32-bit Windows Error: 60: Unknown error
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
Services Summary...
PLSExtProc has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
cas has 2 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
D000 <machine: SERVER, pid: 1336>
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=3006))(PRESENTATION
=oracle.aurora.server.SGiopServer)(SESSION=RAW))
Presentation: oracle.aurora.server.SGiopServer
The command completed successfully
LSNRCTL>
...............................................................

I am not able to run SQLPLUS in the server only, i.e. after connecting the network cable.

Anyways, in the client side I use D2K, for which I need to do SQL Net Easy Configuration. The same same is done perfectly fine.

Thanks and Regards

Rinchen

Report message to a moderator

Re: No Listener [message #297134 is a reply to message #297131]

Wed, 30 January 2008 04:45

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

Senior Member
Account Moderator

Are you able to ping and tnsping the server?

Regards
Michel

Report message to a moderator

Re: No Listener [message #297138 is a reply to message #296583]

Wed, 30 January 2008 04:59

rinwan
Messages: 7
Registered: January 2008
Location: Thimphu, Bhutan

Junior Member

Yes, I can ping the server and also ping from the server...

Thanks

Rinchen

Report message to a moderator

Re: No Listener [message #297142 is a reply to message #296583]

Wed, 30 January 2008 05:14

rinwan
Messages: 7
Registered: January 2008
Location: Thimphu, Bhutan

Junior Member

But I cannot do tnsping. The details are as follows:

Server without network cable:
replies in 10 msec

Server after connecting the network cable:
No Listener

In the client:
No Listener

Thanks and Regards

Rinchen

Report message to a moderator

Re: No Listener [message #297146 is a reply to message #297142]

Wed, 30 January 2008 05:41

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

Senior Member
Account Moderator

ping FROM THE CLIENT.

Regards
Michel

Report message to a moderator

Re: No Listener [message #297147 is a reply to message #296583]

Wed, 30 January 2008 05:51

rinwan
Messages: 7
Registered: January 2008
Location: Thimphu, Bhutan

Junior Member

yes, I can ping from the client also. Also file sharing is working fine.

Thanks

rinchen

Report message to a moderator

Previous Topic:	Not able to create tablespace
Next Topic:	TNS-12541:No Listener

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 09:01:47 CDT 2025