Ora-12541: TNS: no listener

Time:2021-10-22

Ora-12541: TNS: no listener

  • Error when connecting to database:
    Error: ora-12541: TNS: no listener
  • Interpretation:
    The listening service of the database is not started normally.
  • Idea:
    1.Win+R——>services.msc——>CheckOracleOraDB12Home1TNSListenerOracleServiceORCLWhether 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 pathlistener.oraAnd TNS profilestnsnames.ora, change the value of host tolocalhostAfter saving, as shown in Figure 4listener.oraAfter it has been loaded, it is automatically obtained as the local nameLVS1
    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!!
    Ora-12541: TNS: no listener
    Ora-12541: TNS: no listener
    Ora-12541: TNS: no listener
    Ora-12541: TNS: no listener
    Ora-12541: TNS: no listener
    Ora-12541: TNS: no listener

End

Reference blog:
https://blog.csdn.net/tmx0123…

https://blog.csdn.net/yztezhl…