5 Replies Latest reply on Nov 24, 2012 1:21 PM by Osama_Mustafa

    TNS:protocol adapter error

      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/ 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