tns-03505: failed to resolve name 是一个常见的网络错误,通常与数据库连接(特别是Oracle数据库)时无法解析主机名或IP地址有关。这个错误可能由多种原因引起,以下是一些解决步骤和建议,我将按照您的提示进行分点回答: 1. 确认错误的具体环境和上下文 首先,需要明确这个错误是在什么环境下发生的,比如是在尝试连接...
TNS-03505 Failed to resolve name Cause:The service name you provided could not be found in TNSNAMES.ORA, an Oracle Names server, or a native naming service. Action:Verify that you entered the service name correctly. You may need to ensure that the name was entered correctly into the network...
1 步骤一:登录ORACLE数据库,在服务器使用tnsping gshx2cs(实例名)来测试你的实例能够解析,出现如下图报错。2 步骤二:根据报错,是tnsping无法解析oracle数据库实例对应的的ip和端口,怀疑TNS配置问题。TNS的配置文件为tnsnames.ora,目录一般为$ORACLE_HOME/network/admin 3 步骤三:按照如图格式修改TNS串,配...
/opt/oracle/product/11g/network/admin/sqlnet.ora TNS-03505: Failed to resolve name 1. 2. 3. 4. 5. 6. 7. 8. 乍一看,问题出现原因清楚明了。就是orcl服务名无法解析。但是我在本局域网使用其它windows系统中的pl/sql可以连接。 因为对Linux系统认知甚少,所以一头雾水。去网搜一下很多,大约有这么几...
TNS-03505: Failed to resolve name [oracle@db01 admin]$ sqlplus system/oracle@pri SQL*Plus: Release 11.2.0.4.0 Production on Mon Jun 15 21:58:48 2015 Copyright (c) 1982, 2013, Oracle. All rights reserved. ERROR: ORA-12154: TNS:could not resolve the connect identifier specified ...
Oracle Forms for OCI - Version 12.2.1.3.0 and later: Tnsping Fails with "TNS-03505: Failed To Resolve Name" when trying to resolve database name in LDAP
How to Resolve TNS-03505: Failed to resolve nameEvery now and then when I created a new Oracle database in an existing Oracle base (be it 11g or 12c) – I get the error “TNS-03505: Failed to resolve name” whenever I try to do tnsping on a new database. You may receive this...
TNS-03505: Failed to resolve name 乍一看,问题出现原因清楚明了。就是orcl服务名无法解析。但是我在本局域网使用其它windows系统中的pl/sql可以连接。 因为对Linux系统认知甚少,所以一头雾水。去网搜一下很多,大约有这么几种解决方案: 一是文件配置错误; ...
TNS-03505: Failed to resolve name http://lib.csdn.net/article/oracle/24615
tnsname TNS-03505: Failed to resolve name Sqlplus 用户/密码@servername ORA-12154: TNS: 无法解析指定的连接标识符 解决思路: 解决思路: 1、tnsnames.ora 文件中 TNS 名字前不能有空格 2、sqlnet.ora 文件中添加 NAMES.DIRECTORY_PATH = (TNSNAMES, ONAMES, HOSTNAME) 实例: 实例: Oracle 数据库连接错误...