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