ORA-12514: TNS: The Listener currently cannot identify the service solution requested in the connection Descriptor

Environment: Oracle11gR2 + PLSQLDeveloper + SQLPlus problem: Oracle master service and listener service has been started, use SQLPlus can be connected normally, use PLSQLDeveloper connection reported error: ORA-12514: TNS: the listener cannot identify the Service requested in the connection descriptor. Solution: open H: Oraclepr

Environment: Oracle11g R2 + pl SQL Developer + SQL Plus problem: Oracle master service and listener service has been started, use SQL Plus to connect properly, use pl SQL Developer Connection reported error: ORA-12514: TNS: The Listener cannot identify the Service requested in the connection descriptor. Solution: open H: \ Oracle \ pr

Environment: Oracle 11g R2 + pl SQL Developer + SQL Plus

Problem: Oracle master service and listener service has been started, use SQL Plus can be connected normally, use pl SQL Developer Connection reported error: ORA-12514: TNS: the listener cannot identify the Service requested 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: