ORA-12514 The TNS listener is currently unable to identify the resolution of the request service in the connection descriptor

Reprint Address: http://blog.sina.com.cn/s/blog_5007d1b10100oqo8.html

Thanks Ealge

I. in PL/SQL connection Oracle Error: ORA-12514 The TNS listener does not currently recognize the request service in the connection descriptor, such as:

Second, the solution

Specifying instances in Listener.ora (database)

1. Locate Listener.ora in the Oracle installation directory

2. Open for modification: When configuring Oracle my database name is not Oracle default ORCL, but MYORCL, it should be caused by ORA-12514 error, now change it to MYORCL

3. Restart the monitor, then you can.

Attached: If not resolved, see: http://blog.sina.com.cn/s/blog_5007d1b10100oqo8.html

ORA-12514 The TNS listener is currently unable to identify the resolution of the request service in the connection descriptor