| NO LISTENER [message #246853] |
Fri, 22 June 2007 04:38  |
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  |
joy_division
Messages: 4963
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
