-
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
Nallamothu
-
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][i]Originally posted by puneet [/i]
[B]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 [/B][/QUOTE]
even i tnsping to db same error
Nallamothu
-
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
Thanks
Kishore Kumar
-
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.
Nallamothu
-
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.
Rajesh
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|