监听问题

luailinyy 发表于 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，请各位大侠帮忙看看

$ 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 发表于 2012-07-18 13:00

tnsping MIS?

Minsic 发表于 2012-07-18 14:21

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

三鹰情报中心 发表于 2012-07-19 10:26

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

luailinyy 发表于 2012-07-20 11:52

回复 4# 三鹰情报中心

listener.ora内容如下

$ 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))
)

litaisheng001 发表于 2012-07-22 15:41

你把tnsnames.ora中的监听去了，然后重启下监听看看呗，实在不行直接netca重建监听和本地服务名呗

flutter 发表于 2012-07-24 14:03

两个LISTENER争用1523，LSNRCTL看看监听的状态，楼上的建议可以一试

页: [1]

Chinaunix's Archiver

监听问题