Oracle Exception Handling-ORA-12514: the service that the listener currently cannot identify requests in the connection Descriptor

Recently just learned Oracle11g, after installation is complete directly use, today with PLSQL link suddenly reported an error, the error code is: ORA-12514: The Listener is currently unable to identify the connection description

Recently I just learned Oracle 11g, after installation is complete directly use, today with PLSQL link suddenly reported an error, the error code is: ORA-12514: The Listener is currently unable to identify the connection description

Recently just learned Oracle 11g, after installation is complete directly use, today with PLSQL link suddenly reported an error, the error code is: ORA-12514: The Listener is currently unable to identify the Service requested in the connection descriptor. The solution to this exception is found on the Internet, which is recorded here.

This problem may occur in two situations.

First, you have not configured the listener after installation (I have forgotten whether to configure the listener after installation );

The second is that the listener is configured but the system is not written to the listener. in the ora file (I have not figured out when to write), so you only need to write the configuration parameters in the file.

Solution:

1. Open the listener. ora file.

Locate the location where the listener. ora file is stored and open it. My local file directory is under D: \ app \ iLife1988 \ product \ 11.2.0 \ dbhome_1 \ NETWORK/ADMIN. This file must be found based on the actual installation directory. (Note: The Oracle10g and 11g directories are not the same ). The file content is as follows:

We can see that I have configured a listener, but the error is that the Oracle address is not written to SID_DESC. Here we can write this.

2. Modify the listener. ora File

Append the following content to the SID_LIST node of the file.

(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = D: \ app \ iLife1988 \ product \ 11.2.0 \ dbhome_1)
(SID_NAME = orcl)
)

Note: The red part is modified according to the installation directory of your machine.

3. After the modification is completed on this local machine, I always prompt that I cannot save the file, prompting that the file has been opened elsewhere. So I saved another copy and directly overwritten the original file. As shown in figure:

4. Restart the listening service. OK !!