Oracle 10g Database "ORA-12541: TNS: No listener" error Solution

1. The oracleorahome92tnslistener service is not displayed in the computer> Management> service, but the service has started 2, C:/> LSNRCTL start, and an open service error is reported. Then you can view the oracleorahome92tnslistener service in the computer> Manage> service. 3. Run regedit.exe to start the Registry Editor. Locate the oracleorahome92tnslistener item under services and CurrentControlSet/services under HKEY_LOCAL_MACHINE/system/controlset002/. Right-click the item in the window on the right and create a new/string named ImagePath. Double-click "CREATE", and enter "D:/Oracle/ora92/bin/tnslsnr. EXE" in "value data" (modify according to your actual situation. Double-click the oracleorahome92tnslistener service in the service and you will see that its "executable file path" column shows its correct value. Now you can start the listener. 4. C:> tnsping database Sid. Check whether the TNS service is unavailable. If not, use the following command C:/> LSNRCTL LSNRCTL> Start starts the service. C:/> the error of open service error disappears after LSNRCTL start, but one of the examples is in the unknown state and the other is ready. The command is successfully executed.