# tnsnames.ora Network Configuration File: d:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.LISTENER_PRIMARY =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
STANDBY_192.168.160.217 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.160.217)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = standby)
)
)HIS_ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.6)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)PRIMARY_192.168.160.103 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.160.103)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = primary)
)
)我的oracle版本是11.2.0,数据库服务器IP地址是192.168.160.103,我在服务器的命令提示框里边。。C:\Documents and Settings\Administrator>tnsping primary_192.168.160.103TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 30-8月 -
2013 09:22:35Copyright (c) 1997, 2010, Oracle. All rights reserved.已使用的参数文件:
d:\app\Administrator\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
尝试连接 (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.1
68.160.103)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = primary)))
TNS-12541: TNS: 无监听程序如果我把PRIMARY_192.168.160.103 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.160.103)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = primary)
)
)中的HOST的值改为localhost就ok了!!!!这是为什么?
C:\Documents and Settings\Administrator>tnsping primary_192.168.160.103TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 30-8月 -
2013 09:26:13Copyright (c) 1997, 2010, Oracle. All rights reserved.已使用的参数文件:
d:\app\Administrator\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
尝试连接 (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = local
host)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = primary)))
OK (30 毫秒)
192.168.160.103 localhost
试试
看来还是IP和localhost的转换问题
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = d:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:d:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(GLOBAL_DBNAME = PRIMARY)
(ORACLE_HOME = d:\app\Administrator\product\11.2.0\dbhome_1)
(SID_NAME = PRIMARY)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.160.103)(PORT = 1521))
)
)ADR_BASE_LISTENER = d:\app\Administrator