This discussion is archived
5 Replies Latest reply: Nov 24, 2012 5:21 AM by Osama_Mustafa RSS

TNS:protocol adapter error

User347578 Newbie
Currently Being Moderated
Hi All,

I've an problem with the listener in oracle 10g database on linux environment .

i can see the listener is up and running as show below. but however the status is some thing different as show below .

vsv(oracle)[cmsp]/var/opt/oracle$: ps -ef | grep lsnr
oracle 1510 1 0 21:46 ? 00:00:00 /opt/oracle/10.2.0.2/bin/tnslsnr cmsp -inherit
oracle 4082 6726 0 22:07 pts/1 00:00:00 grep lsnr



LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused


Any possible solution to this would be highly appreciated

Thanks in advance

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points