The ORA-12154 TNS cannot parse the specified connection identifier

ORA-12154 TNS cannot parse the specified connection identifier. This error is reported today when the database suddenly connects, plsql connection fails, application connection fails, but SQL can be connected. I searched for it online for half a day and changed it to half a day. In fact, my listener. ora file has never been moved. People on the Internet say they can restart the service after the change.

The directory structure is as follows:

# Listener. ora Network Configuration File: D: \ Oracle \ product \ 10.1.0 \ db_1 \ network \ admin \ listener. ora
# Generated by Oracle configuration tools.
# I added the following (SID_DESC =
# (GLOBAL_DBNAME = ORCL)
# (ORACLE_HOME = d: \ oracle \ product \ 10.1.0 \ db_1)
# (SID_NAME = ORCL)
#)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D: \ oracle \ product \ 10.1.0 \ db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = d: \ oracle \ product \ 10.1.0 \ db_1)
(SID_NAME = ORCL)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC ))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521 ))
)
)
)

In fact, there is no need to change anything. You only need to restart the Oracle listener service to solve the problem.