Oracle listening service startup in Windows

The installation is oracle9i, and the platform is 2000 windows.

You can use SQL plus, but PL/SQL developer 6.0,

Login error: ora-12541 TNS no listener.

It is useless to re-add it in the Listener Configuration.

Start OracleOraHome90TNSListener manually under management/service,

Error message: the specified path cannot be found.

What is the reason? How can this problem be solved?

There are several situations that will cause this problem. If you have used optimization masters, viruses, host name changes, and so on, take anti-virus first, and then:

1. Check whether your host name is consistent with the host name in the listener

2. Check whether the executable file path in the TNSLSNR attribute in the service is correct. If not, enter the registry and change it.

3. check whether all ports of TNSLSNR conflict or are blocked (especially in xp ),

The ports include 1521, 2100, 8080, and 1027. If you install rising, you can check the network activity.

4. Check which of the following are commonly used in the local connection/properties/advanced/settings. If it is disabled,

If it is an exception, check whether there is any TNSLSNR service in the exception.

Solution to the second situation:

Open the Registry first, and find OracleOraHome92TNSListener. Open this item at the listener location. Double-click ImagePath to check whether there is any value. As you said, it should not. You should write "E: oracleora92BINTNSLSNR ", to be accurate, it should be the path on your machine, and "OK" will be OK.