Home » RDBMS Server » Networking and Gateways » Promlem in Listener in oracle (Oracle 9i)
Promlem in Listener in oracle [message #408131] Sun, 14 June 2009 10:01 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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.


Previous Topic: Problem in Remote Connection
Next Topic: Database connection Problem
Goto Forum:
  


Current Time: Thu Mar 28 18:21:40 CDT 2024