我是个菜鸟,大家帮帮忙! 很急的!
我用客户端连ORACLE服务器,其中经过了交换机和放火墙。
ping 服务器IP 可以通
但是telnet 服务器IP 1521 不能打开
tnsping 服务器IP
ORA-12535:TNS:操作超时以前在注册表上加过 HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEO中添加
use_SHARED_SOCKET字段 字符串型 值=TRUE
解决过一个月 后来又出现这个问题请高手帮帮忙
我用客户端连ORACLE服务器,其中经过了交换机和放火墙。
ping 服务器IP 可以通
但是telnet 服务器IP 1521 不能打开
tnsping 服务器IP
ORA-12535:TNS:操作超时以前在注册表上加过 HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEO中添加
use_SHARED_SOCKET字段 字符串型 值=TRUE
解决过一个月 后来又出现这个问题请高手帮帮忙
007 10:49:25Copyright (c) 1997 Oracle Corporation. All rights reserved.已使用的参数文件:
D:\oracle\ora92\network\admin\sqlnet.ora已使用 HOSTNAME 适配器来解析别名
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=10.101.9.2
0))(ADDRESS=(PROTOCOL=TCP)(HOST=10.101.9.20)(PORT=1521)))
TNS-12535: TNS: 操作超时
请问:是不是一定要打开1521端口?
我查了下 listener监听的端口是采用缺省的1521)进行通讯。
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sky-mhg3puxo00f)(PORT = 1521))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = EBS)
(ORACLE_HOME = D:\oracle\ora92)
(SID_NAME = EBS)
)
)INTERPRD =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sky-mhg3puxo00f)(PORT = 1521))
)
)
)
# Generated by Oracle configuration tools.
# sky-mhg3puxo00f
EBS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = EBS)
)
)INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sky-mhg3puxo00f)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)inter =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.101.9.13)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = INTER)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)INTERPRD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.101.9.20)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = interprd)
)
)