数据库教程:数据库报ORA-12514

listener refused the connection with the following error: ora-12514, tns:listener does not currently know of service requested in connect descriptor.

原因：监听器配置问题，具体没搞懂，猜测是sid链接不匹配，监听器无法监听到orcl。

修改oracle安装目录下d:appxuannanproduct11.2.0dbhome_1networkadminlistener.ora文件

# listener.ora network configuration file: d:appxuannanproduct11.2.0dbhome_1networkadminlistener.ora
# generated by oracle configuration tools.

sid_list_listener =
(sid_list =
(sid_desc =
(sid_name = clrextproc)
(oracle_home = d:appxuannanproduct11.2.0dbhome_1)
(program = extproc)
(envs = “extproc_dlls=only:d:appxuannanproduct11.2.0dbhome_1binoraclr11.dll”)
)
(sid_desc =
(global_dbname = orcl)
(oracle_home = d:appxuannanproduct11.2.0dbhome_1)
(sid_name = orcl)
)
)

listener =
(description_list =
(description =
(address = (protocol = ipc)(key = extproc1521))
(address = (protocol = tcp)(host = localhost)(port = 1521))
)
)

adr_base_listener = d:appxuannan

加上这一段就好了

需要了解更多数据库技术:数据库报ORA-12514，都可以关注数据库技术分享栏目—计算机技术网(www.ctvol.com)!