| Promlem in Listener in oracle [message #408131] |
Sun, 14 June 2009 10:01  |
souvik_roy
Messages: 16
Registered: June 2008
|
Junior Member |
|
|
Hi,
I have Oracle 9i database and Oracle 10g Developer Suite installed in my system.
I am able to connect to my database through Toad that means the listeners are working fine.
But while I am doing test connection through Net Manager, I am getting the error as "The test did not succeed.
ORA-12541: TNS:no listener".
Again if I am trying to get the status from LSNRCTL.exe it gives me the following:
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Produc
tion
Start Date 14-JUN-2009 12:17:44
Uptime 0 days 8 hr. 10 min. 28 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File F:\oracle\ora92\network\admin\listener.ora
Listener Log File F:\oracle\ora92\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tcs-60f6dcade89)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tcs-60f6dcade89)(PORT=8080))(Present
ation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tcs-60f6dcade89)(PORT=2100))(Present
ation=FTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 2 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully.
Could anyone tell me what can be the reason for the error TNS No Listener.
Thanks in advance,
Souvik
|
|
|
|
| Re: Promlem in Listener in oracle [message #408133 is a reply to message #408131] |
Sun, 14 June 2009 10:09  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
>Could anyone tell me what can be the reason for the error TNS No Listener.
Software is picky.
It appears you have at least 2 if not 3 different ORACLE_HOME folders on this system.
The V9.2 listener is active on port 1521.
This will prevent any V10 listener from running and also listening on PORT=1521.
V9.2 was obsoleted before eXpress Edition (XE) was released.
You need to be smarter than the software you are (ab)using.
[Updated on: Sun, 14 June 2009 10:10] Report message to a moderator |
|
|
|
| Re: Promlem in Listener in oracle [message #408141 is a reply to message #408133] |
Sun, 14 June 2009 14:18 |
souvik_roy
Messages: 16
Registered: June 2008
|
Junior Member |
|
|
Hi,
I have only one Oracle 9i DB and two 10gDS installed.
The SQLNET.ora file from 9i DB folder contains:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT, ONAMES, HOSTNAME)
And the 10g DS(2) folder sqlnet.ora file contains:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)
The 10g DS(1) has no file in ../network/admin location.
Is there anything amiss in those 2 files?
|
|
|
|
| Re: Promlem in Listener in oracle [message #408142 is a reply to message #408131] |
Sun, 14 June 2009 14:28 |
|
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
Other than NetManager complaining, do other problems exist?
12541, 00000, "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.
CUT the following commands
lsnrctl service
set
pwd
PASTE them into command window
CUT commands & results from command window & PASTE back here
>But while I am doing test connection through Net Manager,
Yes, but from which ORACLE_HOME was this done?
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
