==== [求助]远程连接外网的ORACLE出现问题,各位帮忙. ====
连接外网的ORACLE出现问题..
远程ORACLE数据库相关配置
==========================================================
tnsnames.ora
----------------------
# TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
SYNTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.4)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SYNTEST)
)
)
listener.ora
----------------------
# LISTENER.ORA Network Configuration File: D:\oracle\ora92\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.4)(PORT = 1521))
)
SID_LIST_LISTENER =
(SID_DESC =
(GLOBAL_DBNAME = SYNTEST)
(ORACLE_HOME = D:\oracle\ora92)
(SID_NAME = SYNTEST)
)
)
本地ORACLE客户端相关配置
==========================================================
tnsnames.ora
----------------------
# TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
SYNTEST =
(DESCRIPTION =
(ADDRESS_LIST =
# 标记(1) 阅读时请注意这里[问题描述]中将有此处说明
(ADDRESS = (PROTOCOL = TCP)(HOST = 218.**.***.**)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SYNTEST)
)
)
说明
==========================================================
1.远程主机无防火墙
2.本地执行 tnsping 218.**.***.** 结果
----------------------
TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 18-7月 -2
007 10:38:25
Copyright (c) 1997 Oracle Corporation. All rights reserved.
已使用的参数文件:
D:\oracle\ora92\network\admin\sqlnet.ora
已使用 HOSTNAME 适配器来解析别名
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAM