远程连接时无法解决连接标识符错误
我有一个网络服务应用程序。服务器IP是.....216。它是一个数据库感知应用程序。数据库位于另一台IP为......217的服务器上。现在,当我从 216 运行应用程序时,它可以工作了,我可以向数据库发出请求。我也可以使用 SqlPlus 连接到数据库。所以没有错误。但是,当我尝试远程运行该应用程序(而不是从安装的服务器内运行该应用程序)时,出现 ORA:12154 无法解析连接标识符错误。这可能是什么原因。 所有计算机均处于内网。数据库服务器平台为Windows Server2008 R2,IIS服务器为Windows 2003 R2。远程计算机的平台是 Ubuntu 10.04 LTS x64
I have a web service application.The server ip is .....216. It's a database aware application. The database is in another server with ip ......217. Now when I run the application from 216 it works, I can make requests to the database.I can connect to the database with SqlPlus as well. So no errors. But when I try to run that application remotely, not from within the server it's installed, I get ORA:12154 could not resolve the connect identifier error. What could be the reason for this.
All the computers are in intranet.The platform of database server is Windows Server2008 R2 and the IIS server is Windows 2003 R2. The remote computer's platform is Ubuntu 10.04 LTS x64
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
另一台服务器上是否安装了oracle客户端?
另一台服务器上的 tnsnames.ora 中是否有相应的条目?
Is the oracle client installed on the other server?
Is there corresponding entries in tnsnames.ora on the other server?
我必须授予 Tnsnames.ora 文件所在文件夹的网络访问权限。而且我还必须在 IIS 中注册 asp.net。这样做之后就成功了。
I had to give network access permission to the folder where Tnsnames.ora file was. And I also had to register asp.net in IIS. After doing that it worked.