| 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
|
|
|
|
|
|
| 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
|
|
|
|
|
|
| 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
|
|
|
|
| Re: No Listener [message #297109 is a reply to message #297096] |
Wed, 30 January 2008 03:03 |
 |
Michel Cadot
Messages: 68737
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
|
|
|
|
|
|
|
|
| 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
|
|
|
|
|
|
| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
