admin管理员组文章数量:1635678
【Oracle问题集3】ORA-12543: TNS:destination host unreachable
说明:【oracle问题集】是博主平时操作数据库遇到的问题以及解决方案。
执行语句:表示操作数据库过程
出错现象:表示操作数据库过程出现错误现象
出错原因:表示出现错误的原因
解决方法:表示解决错误的方法
相关知识:表示与这个主题相关的知识
====================================================================
执行语句:
连接数据库:connect sys/oracle@192.168.135.243/orcl as sysdba
出错现象:
ORA-12543: TNS:destination host unreachable
错误原因:
sqlnet.ora文件中的NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT),添加ezconnect参数值,所以如果指定数据库实例,必须要跟上主机ip地址。请参考【Easy Connect Naming】。因此正确的写法是:CONNECT username/password@host[:port][/service_name]
例如connect sys/oracle@192.168.135.243/orcl as sysdba
解决方法:
连接数据库时需要指定主机ip地址:connect sys/orcl@192.168.135.243/orcl as sysdba
相关知识:
以下知识来源于oracle官方文档
Naming MethodDescription
Local Naming
Resolves a net service name stored in a tnsnames.ora file stored on a client
Local naming is most appropriate for simple distributed networks with a small number of services that change infrequently.
See Also: "Configuring the Local Naming Method"
Directory Naming
Resolves a database service name, net service name, or net service alias stored in a centralized LDAP-compliant directory server
See Also: "Configuring the Directory Naming Method"
Easy Connect Naming
Enables clients to connect to a database server without any configuration. Clients use a connect string for a simple TCP/IP address, consisting of a host name and optional port and service name:
CONNECT username/password@host[:port][/service_name]
This method is recommended for simple TCP/IP environments.
See Also: "Using the Easy Connect Naming Method"
External Naming
Resolves service information stored in an a third-party naming service
See Also: "Configuring External Naming Methods"
相关监听配置测试工具命令:lnsrctl、tnsping
listener.ora文件内容:
# listener.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=orcl)
(ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST=192.168.135.243)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /home/oracle/app/oracle
tnsnames.ora文件内容
# tnsnames.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.135.243)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.192.168.132.243)
)
)
sqlnet.ora
# sqlnet.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
ADR_BASE = /home/oracle/app/oracle
http://www.dengb/oracle/481454.htmlwww.dengbtruehttp://www.dengb/oracle/481454.htmlTechArticle【Oracle问题集3】ORA-12543: TNS:destination host unreachable 说明:【oracle问题集】是博主平时操作数据库遇到的问题以及解决方案。 执行语句:表示...
版权声明:本文标题:oracle客户端报ora12543,【Oracle问题集3】ORA-12543: TNS:destination host unreachable 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://m.elefans.com/dianzi/1729214509a1190262.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论