Listener fails to process any new connections for some reason multiple listeners start up listening on the same port and running for the same service, this new listener is started by already running listener process which can be checked by looking at the parent process id of the new listener. This issue so far we have seen on 10.2.0.1 and 10.2.0.2 $ ps -ef | … Continue reading Listener hang issue
To avoid inadvertent stopping of your listener or to prevent unauthorized access to your listener, you may set up password protection for your listener. If you forget the password, do the worst. – hard kill the listener process from the OS – modify the listener.ora file by taking out the “PASSWORDS_LISTENER” parameter. – Restart the listener – Proceed with one of the following methods 1. … Continue reading How to password protect your listener?
For some reason if the listener.log was renamed (mv) or removed and listener will stop logging information to the logfile, one way to fix this issue is to restart the listener but it would require taking an outage. If one can’t restart the listener you can work around this issue by turning off log and turning it back on. $ rm listener.log $ touch listener.log … Continue reading How to re-establish logging if the listener.log isn’t logging without restarting listener?
The listener log file can grow over time and archive the listener log file one can’t move the file and create a new file using touch as the listener has a open/active file handle to log file causes the listener to no longer update the log file. So work around this issue one would need to do the following steps to archive the file and so … Continue reading Archiving/Purge listener logfile