ORA-12514 Error: Listener refused the connection with the following&

ORA-12514 Error: Listener refused the connection with the following errorOrcale Learning-Unable to listen (Listener refused the connection with the Follo ...

Recently learning Orcale encountered the following problems:

Listener refused the connection with the following error:
ORA-12514, Tns:listener does not currently know to service requested in Connect descriptor
The Connection descriptor used by the client is:
Localhost:1521/ecmis

Yesterday was normal, and today I reported a mistake;

Looked up a lot of information on the Internet, although wasted a lot of time, but still solved

"Ora-12541:tns: No Listener" error caused by an IP address change

Workaround :

To view the contents of Listener.ora:
# Listener.ora Network Configuration File:d:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = Plsextproc)
(Oracle_home = D:\oracle\product\10.2.0\db_1)
(program = Extproc)
)
)
LISTENER =
(Description_list =
(DESCRIPTION =
(address = (PROTOCOL = IPC) (KEY = EXTPROC1))
(address = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))
)
)

The original IP of this machine changed, then appeared the above problems, change the database listening IP address:
Put (address = (PROTOCOL = TCP) (HOST =localhost) (PORT = 1521))
Change into
(address = (PROTOCOL = TCP) (HOST = computer name) (PORT = 1521))

It's OK to reboot the listener.