Home » RDBMS Server » Server Administration » NO LISTENER
NO LISTENER [message #246853] Fri, 22 June 2007 04:38 Go to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Hi Dear

I m using oracle 10.1.0.2.0 on linux. While i m trying to connect the database from client it shows no listener TNS - 12541.

Howevery if i m checking the status of listener on server it shows.


Start Date 22-JUN-2007 08:36:04
Uptime 0 days 6 hr. 31 min. 30 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/product/10.1.0/db_1/network/admin/listener.ora
Listener Log File /home/oracle/product/10.1.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8080))(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=2100))(Presentation=FTP)(Session=RAW))
Services Summary...
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


Kindly Help. It's urgent and on production


Regards

Tarun Mittal
Re: NO LISTENER [message #246924 is a reply to message #246853] Fri, 22 June 2007 08:28 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
I don't believe you. Show us a cut and paste of your session from the time you enter the fist command through the appearance of the error.
Re: NO LISTENER [message #246960 is a reply to message #246924] Fri, 22 June 2007 11:10 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Compare this parameter (PORT = 1521) In youe LISTENER.ORA and TNSNAMES.ORA weather THEY ARE SAME
Previous Topic: Error while creating spfile from pfile on standby
Next Topic: Here is How to Identify Performance Bottleneck
Goto Forum:
  


Current Time: Mon Dec 05 04:30:29 CST 2016

Total time taken to generate the page: 0.18000 seconds