ChinaUnix.net
相关文章推荐:

ora-12514

大家好 当我在客户端有ie,用isql *plus 链接数据库时,提示如下错误,请帮忙分析下,是什么原因,谢谢 oracle 主机 Solaris 10 oracle 版本 10.2 客户端 : windows pc ERROR - ora-12514: TNS:listener does not currently know of service requested in connect descriptor tnsnames.ora 文件内容 EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = zch08view19)(PORT = 1521)(...

by huizzz - Oracle - 2010-05-24 19:39:28 阅读(4152) 回复(9)

error

相关讨论

我在数据库shutdown 的情况下修改了表空间的名字, 结果我从oracle enterprise manager 进去报错: ora-12514监听进程不能解析在连接描述符中给出的server_name 哪位大哥能帮帮我!

by ldpunix - Oracle - 2004-05-25 17:05:30 阅读(817) 回复(1)

oracle 9+solaris8 启动lsnrctl start 后,始终没有监听到服务 如下图 $ lsnrctl status LSNRCTL for Solaris: Version 9.2.0.3.0 - Production on 11-12月-2003 17:44:54 Copyright (c) 1991, 2002, oracle Corporation. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR f...

by orange - Oracle - 2012-08-26 22:04:53 阅读(3391) 回复(12)

本帖最后由 fly_hxiao 于 2010-09-10 14:32 编辑 help ... OS:win xp,装的 oracle 8.17 版本的客户端,服务器也是8.17 测试服务时,老提示这种错误... tnsnames 如下: ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.21.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) -----------------------------------------------------------...

by fly_hxiao - Oracle - 2010-09-10 13:30:06 阅读(2987) 回复(4)

O817 FOR LINUX已经装好运行,OMS 也OK, 怎么第二天重启后NET 8 CONFIG里SERVICE TEST 报告? ora-12514, TNS could not resolve SERVICE_NAME given in connect descriptor 检查了listener.ora和TNSNAME.ora 也匹配, 找到了一篇文章: http://www.ifreethinking.com/html/modules/newbb/viewtopic.php?topic_id=61&forum=2 还不很明白。我应该设置GLOBAL_DBNAME 吗? 我成功运行的两次在NET 8 CONFIG里SERVICE NAME 都用or...

by 小帅哥飞飞 - Oracle - 2004-01-15 10:09:16 阅读(969) 回复(0)

平台linux +oracle 10g 作测试 shutdown immediate 后startup mount 老是提示ora-12514: TNS:listener does not currently know of service requested in connect descriptor这个错误 检查了tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora # Generated by oracle configuration tools. ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP...

by cd_songkun - Oracle - 2008-03-13 17:00:54 阅读(3784) 回复(2)

ora-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor 经过几个回合,我终于在下午能够连结我的数据库。下班回来,又无法连接。 昨天刚装上8i时,也是这个问题,可是在下午,我就重新设了一个服务命名就ok,可是晚上重设了n个也不行,怎么解决

by skywards - Oracle - 2003-11-26 23:21:59 阅读(969) 回复(0)

:?:  环境W2K pro ,装了oracle8i的服务器端,本机测试和连接都是可以的,但其它机器用net8 easy config测试时可以测通,而用sql plus却不能连接,出现错误:ora-12514:message 12514 not found;product=RDBMS80;facility=ora,这是怎么回事,服务器端是815的,客户端是805,不应该有什么问题的呀,这种环境我以前连接过的没问题的,可现在--- 哪位仁兄给个建议!

by zllimit - Oracle - 2003-02-21 16:39:50 阅读(2641) 回复(1)

配置data guard网络监听的时候,连接测试报错如下:

ERROR:
ora-12514: TNS:listener does not currently know of service requested in connect
descriptor

出错原因是由于,在修改init$oraCLE_SID.ora文件时,在主库里面新添加了一项db_unique_name=10gpri;

备库上...

by vcdog - Oracle - 2011-12-22 08:54:04 阅读(1076) 回复(0)

应用不能连接数据库了。应用日志里发现如下错误:

ora-12514: TNS:listener could not resolve SERVICE_NAME given in connect。

解决办法如下:

$ tnsping arsprd.emea.net

TNS Ping Utility for Solaris: Version 9.2.0.7.0 - Production on 22-JUN-2010 04:07:53

Copyright (c) 1997 oracle Corporation.  All rights reserved.

Used parameter files:
/global/oracl...

by ebayboy - Oracle - 2011-12-20 09:48:16 阅读(747) 回复(0)

昨天在做Data guard 的时候老是出现ora-12514,经过分析和处理终于解决了,现整理一下,供大家参考

1.防火墙(iptables)
iptables 没有开通1521的端口对外
解决方法:增加开通1521端口的策略,或者直接停止iptables服务。

2.监听配置不正确(建议手工配置监听,不要用自动的)
处理方法:
1)删除$oraCLE_HOME/network/admin/listener.ora
2)启动netmgr,再点绿色的按钮+

by linuxboy823 - Oracle - 2011-12-19 13:56:42 阅读(671) 回复(0)