Ora-12541: TNS: no listener
- Error when connecting to database:
Error: ora-12541: TNS: no listener
The listening service of the database is not started normally.
OracleServiceORCLWhether the service is started. If not, click start and modify it to self start.
2. If the problem still cannot be solved after startup, stop the above services first. Find the listening configuration file according to the installation path
listener.oraAnd TNS profiles
tnsnames.ora, change the value of host to
localhostAfter saving, as shown in Figure 4
listener.oraAfter it has been loaded, it is automatically obtained as the local name
3. Reconfigure the listening service and save the network configuration after configuration. Due to the older version, the interface is retro, but it does not affect the configuration. After configuration, restart the service and connect again. Success!!