blocks|key|2842737|text|我也有同样的问题，我通过更改密码和删除"@“字符来解决这个问题。对我起作用了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2842738|@是告诉SQL+%2B我们要连接哪个连接标识符(服务名/sid)。总之，避免在密码中使用此字符。|2842739|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I was having the same problem, I resolved it by changing my password and removing "@" character. It worked for me.

@ is to tell SQL plus which connection identifier (service name/sid) we want to connect. In short, avoid using this character in password.

blocks|key|2842760|text|我还面临着同样的问题ORA-12543:+TNS:无法到达的目的地主机。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2842761|我就这样解决了|2842762|开敞平地|2842763|连接|2842764|输入用户名:系统输入密码:+HHHHH@2014|2842765|然后引发以下错误|2842766|问题是我的密码包含@符号|2842767|通过将我的密码输入"HHHHHH@2014“来解决这个问题|2842768|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|V|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|W|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|X|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|Y|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|Q|$]]

I also faced the same issue ORA-12543: TNS:destination host unreachable

i resolved it in this way

open sqlplus

connect

enter user-name :system
enter password : HHHHH@2014

then the following error raised

the problem is my password contains @ symbol

resolved it by putting my password in "HHHHHH@2014"

blocks|key|239773|text|我也得到了ORA-12543+:TNS+:无法到达的目的地主机。但对我来说问题在于密码。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|239774|解决方案:需要从现有密码中删除"@“，因为@定义了用于在sqlPlus中连接的连接标识符。|239775|要更新密码，请执行以下步骤:登录到window+cmd，然后键入"sqlplus+/nolog“，然后输入"connect+/+as+sysdba”。连接后，将SYS密码更改为不带@：“new_password标识的用户系统；”|239776|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

I too got ORA-12543 :TNS :destination host unreachable. 
But for me the problem was in the password.

Resolution : Need to remove "@" from the existing password as
@ defines connection identifier being used to connect in sqlPlus.

To update the password , follow below steps :
Logon to window cmd then type "sqlplus /nolog"
then "connect / as sysdba" .
Once you are connected, change the SYS password to something without @: 
"ALTER USER sys IDENTIFIED BY new_password;"

blocks|key|1845634|text|(以sys+dba登录)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1845635|sql>conn+/+as+sysdba|blockquote|1845636|(然后更改用户)|1845637|sql>alter用户名由newuserName标识
sql>commit|1845638|(现在再次尝试使用相同密码登录新用户)单击1查看屏幕快照-+](https://i.stack.imgur.com/7fkRN.png)|offset|length|1845639|entityMap|0|LINK|mutability|MUTABLE|url|https://i.stack.imgur.com/7fkRN.png|1^0|0|0|0|0|L|1|0|W|Z|1|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|W|8|@]|9|@]|A|$]]|$1|E|3|F|5|6|7|X|8|@]|9|@]|A|$]]|$1|G|3|H|5|D|7|Y|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|Z|8|@]|9|@$K|10|L|11|1|12]|$K|13|L|14|1|15]]|A|$]]|$1|M|3|-4|5|6|7|16|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]|U|$5|P|Q|R|A|$S|T]]]]

(log in as sys dba) 

<blockquote>
 sql>conn / as sysdba 
</blockquote>

(then alter the user)

<blockquote>
 sql>alter user username identified by newuserName
 
 sql>commit
</blockquote>

(now again try to login with new user with the same password it will work)
click on <a href="https://i.stack.imgur.com/7fkRN.png" rel="nofollow noreferrer">1</a> to see the screenshot -- <a href="https://i.stack.imgur.com/7fkRN.png" rel="nofollow noreferrer">][1]</a>

blocks|key|239702|text|最近，我为测试目的安装了Oracle11g，在完成数据库11g速成版的安装后，在浏览器上启动了与系统和Pravin@01密码的成功连接。在尝试使用suddenly工具之后，它也运行得很好，但是当我尝试使用SQL命令行工具连接时，它突然给了我一个错误，|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|239703|ORA-12543:+TNS:无法到达的目标主机|blockquote|239704|研究了一个小时后，我得到了一个解决方案，甲骨文将密码中的@字符作为一个‘|239705|service+name+or+sid|CODE|239706|因此，解决此问题的方法是从密码中删除@字符。|239707|通过‘这里是您的新密码--应该包含字符和数字--只尝试删除特殊字符--标识的更改用户系统；|239708|我认为这篇文章可能对你有帮助。|239709|entityMap^0|P|9|2U|8|0|0|0|0|J|0|0|12|7|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@$9|W|A|X|B|C]|$9|Y|A|Z|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|10|8|@]|D|@]|E|$]]|$1|I|3|J|5|6|7|11|8|@]|D|@]|E|$]]|$1|K|3|L|5|H|7|12|8|@$9|13|A|14|B|M]]|D|@]|E|$]]|$1|N|3|O|5|6|7|15|8|@]|D|@]|E|$]]|$1|P|3|Q|5|H|7|16|8|@$9|17|A|18|B|C]]|D|@]|E|$]]|$1|R|3|S|5|6|7|19|8|@]|D|@]|E|$]]|$1|T|3|-4|5|6|7|1A|8|@]|D|@]|E|$]]]|U|$]]

Recently, I installed Oracle 11g for testing purpose and after completion of installation Database 11g Express Edition started on the browser with the system and Pravin@01 password it is connected successfully. After I tried using SQL Developer tool it was also working fine but while I tried to connect using SQL PLUS command line tool it suddenly gave me an error as, 

<hr>

<blockquote>
 ORA-12543: TNS:destination host unreachable
</blockquote>

<hr>

Then after research for an hour, I got a solution that Oracle treats @ character in the password as a `

<blockquote>
 <code>service name or sid</code>
</blockquote>

so the solution for this problem is to remove @ character from the password using 

<blockquote>
 ALTER USER system IDENTIFIED BY ' here is your new password which should contain character 
 and digits only try to eliminate special characters';
</blockquote>

I think this post may be helpful for you.

blocks|key|2842799|text|我已经用Oracle+18c+64位在Windows+2016环境中测试了这一点|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2842800|试图使用密码中的"@“登录时，请使用以下转义字符序列。|2842801|用户:+scott密码:+scott@test|2842802|sqlplus+scott/\”scott@test\”@TEST_DB|code-block|syntax|javascript|2842803|为了避免这种麻烦，请在登录sqlplus后，使用以下命令更改密码，不要使用@字符。|2842804|alter+user+scott+identified+by+"newpassword"+|2842805|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|S|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|T|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|H|7|V|8|@]|9|@]|A|$I|J]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

I have tested this in Windows 2016 environment with Oracle 18c 64-bit

Use this following escape character sequence when attempting to logon with an "@" in the password.

user: scott
password: scott@test

<pre><code>sqlplus scott/\”scott@test\”@TEST_DB
</code></pre>

In order avoid this annoyance, change password without an @ character using the following command once you have logged in to sqlplus.

<pre><code>alter user scott identified by "newpassword" 
</code></pre>

Last days i stay face to face with a strange oracle problem.
I have defined database in tnsnames.ora. Oracle client is installed , client and client/bin have been added to PATH.

<code>Ping</code> works, <code>tnsping</code> works, I can connect to host by database port with telnet.

When I try to run application that tries to connect to db I got 

<blockquote>
 ORA-12543: TNS:destination host unreachable
</blockquote>

It is the same situation when I try to connect by sqlplus

<blockquote>
 sqlplus username/password@TNSNAME
</blockquote>

Situation occurred only on one workstation, it's mean in common it should works.

WS is windows 7 64 bit. 
Database :

<blockquote>
 Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
</blockquote>

ORA-12543: TNS:destination host unreachable but telnet and tnsping works

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

最后几天，我面临着一个奇怪的神谕问题。我在tnsnames.ora中定义了数据库。安装了Oracle客户端，已将客户端和client/bin添加到PATH中。Ping工作，tnsping工作，我可以用telnet通过数据库端口连接主机。当我试图运行试图连接到db的应用程序时，我得到了ORA-12543: TNS:无法到达的目标主机当我试图通过sqlplus连接时，情况也是一样的。sqlplus用户

问ORA-12543: TNS:目标主机不可达但telnet和tnsping工作
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问ORA-12543: TNS:目标主机不可达但telnet和tnsping工作EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问ORA-12543: TNS:目标主机不可达但telnet和tnsping工作
EN