Tag Archives: No-listening routine

Oracle11gr2 database suddenly “TNS no listener” protocol adapter error

Just to be clear, this one is so fucking stupid.
lsnrctl status
TNS-12541 no listening program
TNS-12560 protocol adapter error
TNS-00511 no listener program
 
According to the online solution I have various reconfiguration listening, but none of them work.
Finally, I saw a post where he accidentally found that the listening log had reached 4G. I looked at mine and sure enough it was the same. I didn’t hesitate to delete it and restart the service. Solve the problem.
 
Log position app/administrator/diag/TNSLSNR/XXXXXX/listener/trace/listener. The log