ORA-12514: TNS: service resolution that the listener currently cannot identify requests in the connection Descriptor

Solution:

Open the listener. ora file under the directory H: \ oracle \ product \ 11.2.0 \ dbhome_1 \ Network \ ADMIN (different machine directories may be different). The file content is as follows:

1. # Listener. ora network configuration file:
2. H: \ oracle \ product \ 11.2.0 \ dbhome_1 \ Network \ admin \ listener. ora
3. # Generated by Oracle configuration tools.
5. Sid_list_listener =
6. (Sid_list =
7. (Sid_desc =
8. (Sid_name = clrextproc)
9. (ORACLE_HOME = H: \ oracle \ product \ 11.2.0 \ dbhome_1)
10. (Program = EXTPROC)
11. (Envs = "extproc_dlls = only: H: \ oracle \ product \ 11.2.0 \ dbhome_1 \ bin \ oraclr11.dll ")
12. )
13. )
15. Listener =
16. (Description_list =
17. (Description =
18. (Address = (Protocol = IPC) (Key = extproc1521 ))
19. (Address = (Protocol = TCP) (host = localhost) (Port = 1521 ))
20. )
21. )
23. Adr_base_listener = H: \ oracle

Change to the following content (note the content in red ):

# Listener. ora network configuration file:

H: \ oracle \ product \ 11.2.0 \ dbhome_1 \ Network \ admin \ listener. ora

# Generated by Oracle configuration tools.

Sid_list_listener =

 (Sid_list =

(Sid_desc =

(Global_dbname = orcl)

(ORACLE_HOME = H: \ oracle \ product \ 11.2.0 \ dbhome_1)

(Sid_name = orcl)

)

(Sid_desc =

(Sid_name = clrextproc)

(ORACLE_HOME = H: \ oracle \ product \ 11.2.0 \ dbhome_1)

(Program = EXTPROC)

(Envs = "extproc_dlls = only: H: \ oracle \ product \ 11.2.0 \ dbhome_1 \ bin \ oraclr11.dll ")

)

)

Listener =

(Description_list =

(Description =

(Address = (Protocol = IPC) (Key = extproc1521 ))

(Address = (Protocol = TCP) (host = localhost) (Port = 1521 ))

)

)

Adr_base_listener = H: \ oracle

Note: The Oracle installation directory and Instance name of each computer are different. Modify the ORACLE_HOME (local Oracle Installation Directory) and sid_name of this file according to your own settings.

For details about Sid, refer to the figure below:

 

ORA-12514: TNS: service resolution that the listener currently cannot identify requests in the connection Descriptor