How to check the status of the Oracle listenser from a Windows Enforce Server.
ORA-12541: TNS:no listener
The root cause could be a number of issues ranging from listener stopped, incorrectly registered, and corrupt listener configuration files.
Perform the following steps to check the listener status and start it if it is not running.
- Open a elevated command prompt
- Type lsnrctl status
If the listener service "protect" does not appear to be READY then use the following command to start the listener.
After starting the listener, wait a few minutes and run the following command:
The expected result is the "protect" service is listed and has a status of READY.
Imported Document Id