Resolution: The ORA-12514 TNS Listener currently does not recognize the request service in the connection descriptor
Or you can't go to the console Enterprise Manager (OEM) graphical interface after restarting your computer (add an injection listener on the line file listener.org)
Another situation is the way to show this error after shutdown immediate has been executed.
Here's how to solve the idea:
The client does not hear the instance service name according to the error message
1. Start the database by restarting the service, and again the connection is still unable to connect to the server.
2, since the first method does not solve the problem, then the second method. Consider listening Listener.ora
You may not have to specify the service name for the listener in the Listener profile Listener.ora (which is not specified after installing oracle10g). Normally, as long as the database starts, the client connects to the database with no problems, but sometimes a ORA-12514 error occurs when a recurring startup is turned off.
Since no listener is specified in the Listener.ora, we can specify the listener instance name in the Listener.ora file so that the problem should be connected. Re-register the listener information.
The steps are as follows:
在oracle服务器Oracle安装目录(我的在D:\app\qichunlin\product\11.2.0\dbhome_1\network\admin
Display content is
# listener.ora Network Configuration File: D:\app\qichunlin\product\11.2.0\dbhome_1\network\admin \listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:\app\qichunlin\product\11.2.0\dbhome_1) (PROGRAM = extproc) ) //add code from here (SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME = D:\app\qichunlin\product\11.2.0\dbhome_1) (SID_NAME = ORCL) ) //end here )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) )
Callout//For the Part I added, ORCL is the instance name of the listener.
Then restart the Listener service (WIN+R input services.msc Some systems do not use this command for my Professional Edition) or where Cortana searches below for input services
启动监听器/ 打开监听服务C:\LSNRCTL START
打开数据库服务C:\ORACLE ORCL //orcl 是我们需要打开的数据库
Oracle Client Net Cofiguration assistant correctly add or reconfigure instance names
2018.5.6 Resolution: Oracle------ORA-12514 TNS Listener does not currently recognize the request service in the connection descriptor