After a successful installation of Fusion Middleware 11g WebTier (11.1.1.2, 11.1.1.3, 11.1.1.4, 11.1.1.5 and 11.1.1.6) on Linux x86-64the tnsping command fails to show the correct message.CauseSign In To view full details, sign in with your My Oracle Support account. Register Don't...
1. 添加监听器配置,listener.ora文件默认包括: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL =TCP)(HOST = localhost)(PORT = 1521)) ) ) ADR_BASE_LISTENER = /opt/app/ora11g 为了新建监听器名称,添加如下: DCSOPEN = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(Host =...
getaddrinfo() failed with error -3 address for name "dcsopen" not found 直观看,没有识别出dcsopen监听。 后来查询MOS有篇文章(Client Connections Fail With TNS-12154 / ORA-12154 (文档 ID 1150680.1)) 说这个情况的原因可能是:This means Oracle Net isunable to read the filecorrectly or entry ins...
在工作站上,我安装了tnsname.ora指向oracle数据库的Oracle客户端。我可以ping到安装了oracle db的服务器。我可以使用sqlplus连接到数据库,甚至可以使用C#以编程方式连接到数据库。然而,我想不起来了。尝试执行此操作时,我收到错误消息3511 not found。所以我的问题是:在什么情况下使用tnsping,以及如何使tnsping工作?