How to solve Oracle's 12541 error

Method: 1. Right-click the bottom taskbar, select Task Manager, and enter the service panel interface; 2. Find the "OracleOraDb11g_home1TNSListener" and "OracleServiceORCL" services in the service panel and open them, and reconnect to the server. Can.

The operating environment of this tutorial: Windows 10 system, Oracle version 12c, Dell G3 computer.

Causes and solutions for Oracle’s 12541 error

The following error occurs: ORA-12541:TNS:no listener, as shown in the figure below:

The reason for the error is that we did not open the Listener service.

Solution

Enable this service in the service, as shown in the figure below.

1. Find the specified service in the task manager

Right-click on the taskbar, select Task Manager, and enter the service panel interface

##2. Enter the service to see if OracleOraDb11g_home1TNSListener and OracleServiceORCL are open. If not, open them.

Extended knowledge:

The following error occurred: ORA-12514: TNS: The listener does not currently recognize the service requested in the link descriptor. As shown in the figure below:

The solution is to open the service OracleServiceORCL, as shown in the figure below:

An error occurred : ORA-01017: invalid username/password;logon denied.

Solution: When configuring the database connection, the user name and password were both root and root configured when Oracle was installed. However, the above error will occur. Later, I can successfully log in using the username: scott and password: tiger. This scott account was also configured when installing the database.

Recommended tutorial: "

Oracle Video Tutorial"

The above is the detailed content of How to solve Oracle's 12541 error. For more information, please follow other related articles on the PHP Chinese website!