12541 no listener ..error message i try to connect from sqlplus

Hi i'm trying connect from sql plus i'm getting error message like ..no listener..but i can able to connect from telnet database is running fine can someone help me out.


thanks you

On client side, use tnsping first to see whether you can ping.
On server side, use ps command to see whether listerner process is there.

Hi

telnet to your server . Write LSNRCTL START and then your listener will start .
Then you will be able to connect to your database..

Inc ase any error , Let us know

Quote:

---

Originally posted by puneet
Hi

telnet to your server . Write LSNRCTL START and then your listener will start .
Then you will be able to connect to your database..

Inc ase any error , Let us know

---

even i tnsping to db same error

hi listener is running still do i need to stop and start listener...

Does not hurt to reload.

lsnrctl-->reload-->status

to see whether your ORACLE_SID is listed under
your Services Summary...

If you cannot TNSPING then may be problem with your network

i reload the listener eventhought it's not connect from sqlplus and i check the listenr process runnig
ps -ef | grep tnslsnr ...it is fine,i try tnsping to db it says ..no listener.

Make sure your service is using the same port to conenct to that listener is listening at.
The default port is 1521 but there may be a chance that it's using some other port.

- Rajeev

do you have a firewall between u'r machine and server ? In which case you need to open the port 1521 unless otherwise. Also check if u'r client is having multiple oracle home and the tnsnames is updated with the server you are connecting to.

i just copy the tnsnames .ora file and put it in my mechine those are same parameters and port no is also 1521. actually i have firewall so i use the secureCRT to connect from my mechine to dbs

Could you cut-and-paste the following info --

1. lsnrctl status

2. the Service descriptor from the tnsnames.ora file

- Rajeev