论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2012-07-17 15:29 |只看该作者 |倒序浏览

SQL> conn qml/qml@MIS
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

根据错误在网上查询貌似是配置问题
以下是我的 tnsnames.ora，请各位大侠帮忙看看

[oracle@localhost admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /home/ora10g/product/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

MIS =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.15.14)(PORT = 1523))
(CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = mis)
)
  )

LISTENER_MIS =
  (ADDRESS = (PROTOCOL = TCP)(HOST = rhe15.5)(PORT = 1523))

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
(ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC3))
)
(CONNECT_DATA =
   (SID = PLSExtProc)
   (PRESENTATION = RO)
)
  )

文库|博客

godymoon

小富即安

论坛徽章:: 3

2楼 [报告]

发表于 2012-07-18 13:00 |只看该作者

tnsping MIS ?

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

Minsic

大富大贵

论坛徽章:: 1

3楼 [报告]

发表于 2012-07-18 14:21 |只看该作者

为什么tnsnames.ora中有监听的配置？

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

三鹰情报中心

白手起家

论坛徽章:: 0

4楼 [报告]

发表于 2012-07-19 10:26 |只看该作者

监听出现的位置很奇怪
listener.ora 也贴出来看一下吧

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

luailinyy

白手起家

论坛徽章:: 0

5楼 [报告]

发表于 2012-07-20 11:52 |只看该作者

回复 4# 三鹰情报中心

listener.ora内容如下

[oracle@localhost admin]$ strings listener.ora
# listener.ora Network Configuration File: /home/ora10g/product/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =
   (SID_NAME = MIS)
   (ORACLE_HOME = /home/ora10g/product)
   (PROGRAM = MIS)
)
LISTENER =
  (DESCRIPTION_LIST =
(DESCRIPTION =
   (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC3))
   (ADDRESS = (PROTOCOL = TCP)(HOST = rhel5.3)(PORT = 1523))
)