Home » RDBMS Server » Networking and Gateways » No Listener
No Listener [message #296583] Mon, 28 January 2008 05:52 Go to next message
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
Re: No Listener [message #296593 is a reply to message #296583] Mon, 28 January 2008 06:22 Go to previous messageGo to next message
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.
Re: No Listener [message #296996 is a reply to message #296583] Tue, 29 January 2008 21:25 Go to previous messageGo to next message
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
Re: No Listener [message #297016 is a reply to message #296996] Tue, 29 January 2008 23:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: No Listener [message #297096 is a reply to message #296583] Wed, 30 January 2008 02:37 Go to previous messageGo to next message
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
Re: No Listener [message #297109 is a reply to message #297096] Wed, 30 January 2008 03:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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
Re: No Listener [message #297134 is a reply to message #297131] Wed, 30 January 2008 04:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Are you able to ping and tnsping the server?

Regards
Michel
Re: No Listener [message #297138 is a reply to message #296583] Wed, 30 January 2008 04:59 Go to previous messageGo to next message
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
Re: No Listener [message #297142 is a reply to message #296583] Wed, 30 January 2008 05:14 Go to previous messageGo to next message
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
Re: No Listener [message #297146 is a reply to message #297142] Wed, 30 January 2008 05:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ping FROM THE CLIENT.

Regards
Michel
Re: No Listener [message #297147 is a reply to message #296583] Wed, 30 January 2008 05:51 Go to previous message
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
Previous Topic: Not able to create tablespace
Next Topic: TNS-12541:No Listener
Goto Forum:
  


Current Time: Thu Mar 28 06:43:02 CDT 2024