Question

求助，Oracle本地网络服务名配置的时候测试未成功，如图，来大神帮帮忙

Answer 1

Ora-12514：TNS：监听程序当前无法识别链接描述符中请求的服务
该问题是由于缺少监听器的SID_LIST描述项引起的，采用netca进行配置的时候经常会遇到该问题，listener.ora示例如下
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/9.2.0.4)
(PROGRAM = extproc))
(SID_DESC =
(GLOBAL_DBNAME = SAMPLE.COM)
(ORACLE_HOME = /opt/oracle/product/9.2.0.4)
(SID_NAME = SAMPLE)))LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tcy.com)(PORT = 1521)))

上面是个正确的样板，要把你自己实际的实例和服务配制成这样，然后重启监听就可以了

追问

我在安装目录D:\app\Sin\product\11.2.0\dbhome_1\NETWORK\ADMIN\SAMPLE找到listener.ora，然后具体怎么改，新手不懂。。谢谢

追答

http://www.linuxidc.com/Linux/2012-09/69678.htm
你参考下这个，我复制的那个完全乱了