admin管理员组文章数量:1566666
1) show us ORACLE_HOME/network/admin/sqlnet.ora
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES = (NTS)
2) show us ORACLE_HOME/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ACB_PRD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ACB15)(PORT = 16979))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ACC_PRD)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ACB_LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ACB15)(PORT = 16979)
)
)
3) show us the output of tnsping
C:\>tnsping ACB_PRD
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 20-MAY-2
009 14:51:44
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
C:\oracle\product\10.2.0\db_4\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ACB15)(
PORT = 16979)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ACB_PRD)))
TNS-12543: TNS:destination host unreachable
本文标签: ORAHostUnreachabletnsdestination
版权声明:本文标题:新建oracle11 ora12543,ORA-12543: TNS:destination host unreachable 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://www.elefans.com/dongtai/1726604268a1077388.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论