3,494
社区成员
发帖
与我相关
我的任务
分享oracle两个实例，连结其中一个报12514错误
我的两个实例名分别为hmis和circ，listener.ora为：
# listener.ora Network Configuration File: /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1522))
)
)
lsnrctl status也只显示了hmis，那我要连入circ，需要做什么呢？谢谢！
# listener.ora Network Configuration File: /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1522))
)
)
lsnrctl status也只显示了hmis，那我要连入circ，需要做什么呢？谢谢！
...全文
请发表友善的回复…
发表回复
RunCanRun 2010-05-13
- 打赏
- 举报
你的网络服务名配置是什么样子的？就是tnsnames.ora配置文件。把这个文件中的内容贴出来看看
碧水幽幽泉 2010-04-10
- 打赏
- 举报
把localhost.localdomain换成IP地址试试看！
chl_seu 2010-04-10
- 打赏
- 举报
用服务器端数据库配置工具重配置下实例
看看可不可以
看看可不可以
liuyong1352 2010-04-02
- 打赏
- 举报
飘过 苗一眼 学习
friendjin 2010-03-29
- 打赏
- 举报
把客户端tns配置贴出来啊
liuyi8903 2010-03-27
- 打赏
- 举报
show parameter listener
remote和local有没有设置？
另外，tns 和listener都怎么设置的？
remote和local有没有设置？
另外，tns 和listener都怎么设置的？
qicai841125 2010-03-21
- 打赏
- 举报
学习中
friendjin 2010-03-21
- 打赏
- 举报
检查服务器端的监听啊
neverland_83 2010-03-18
- 打赏
- 举报
tnsname.ora中怎么配的？
verysorrow 2010-03-18
- 打赏
- 举报
这种官方的解释就免了吧，呵呵
suiziguo 2010-03-18
- 打赏
- 举报
12514, 00000, "TNS:listener does not currently know of service requested in connect descriptor"
// *Cause: The listener received a request to establish a connection to a
// database or other service. The connect descriptor received by the listener
// specified a service name for a service (usually a database service)
// that either has not yet dynamically registered with the listener or has
// not been statically configured for the listener. This may be a temporary
// condition such as after the listener has started, but before the database
// instance has registered with the listener.
// *Action:
// - Wait a moment and try to connect a second time.
// - Check which services are currently known by the listener by executing:
// lsnrctl services <listener name>
// - Check that the SERVICE_NAME parameter in the connect descriptor of the
// net service name used specifies a service known by the listener.
// - If an easy connect naming connect identifier was used, check that
// the service name specified is a service known by the listener.
// - Check for an event in the listener.log file.
// *Cause: The listener received a request to establish a connection to a
// database or other service. The connect descriptor received by the listener
// specified a service name for a service (usually a database service)
// that either has not yet dynamically registered with the listener or has
// not been statically configured for the listener. This may be a temporary
// condition such as after the listener has started, but before the database
// instance has registered with the listener.
// *Action:
// - Wait a moment and try to connect a second time.
// - Check which services are currently known by the listener by executing:
// lsnrctl services <listener name>
// - Check that the SERVICE_NAME parameter in the connect descriptor of the
// net service name used specifies a service known by the listener.
// - If an easy connect naming connect identifier was used, check that
// the service name specified is a service known by the listener.
// - Check for an event in the listener.log file.
