Tns名称未找到 [英] Tns name Not Found

问题描述

我是Oracle的新手。当我尝试登录Sql * Plus时，它要求输入USername和密码，我把这些信息。它问我主机字符串..我应该放在那里。当我放在那里127.0.0.1它说Tns name not found。什么是Tns的概念它代表什么。


当我尝试登录PLSQL开发人员来完成我的工作时，我发现了同样的错误。


任何人都可以帮助我。

解决方案

您需要验证您提供的凭据是否与oracle目录中tnsnames.ora文件中的凭据相匹配。如果您有SQL Net Easy配置向导，则运行它以更正并验证您的配置。

@ r035198x


然后是什么主机字符串代表..？

@madankarmukta


大家好，


感谢您给我解决问题的时间。


Anyways madankarmukta，

当我们尝试登录sql * plus时，我在上下文中询问Hoststring

Hi,

I am new To Oracle.When I am trying to log in Sql* Plus , There It is asking for the USername And Password,I Put that Information .After that it ask me Host string.. What should I Put there.When I put there 127.0.0.1 it says "Tns name Not found". what is the concept of Tns what does it represents.

I found the same error when i try to login in PLSQL developer to do my work.

Can anyone help me.

解决方案

You need to verify that the credentials you are providing match the ones in the tnsnames.ora file in your oracle directory. If you have the SQL Net Easy Configuration wizard then run it to correct and verify your configuration.

@r035198x
Then what does the host string represents ..?

@madankarmukta
Hi All,

Thanks for the time you gave to resolve my question .

Anyways madankarmukta,
I am asking Hoststring in the context when we try to login in sql* plus .

这篇关于Tns名称未找到的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！