==== [求助]远程连接外网的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_NAME=218.**.***.**))(ADDRESS=(PROTOCOL=TCP)(HOST=218.**.***.**)(PORT=1521)))
OK（10毫秒）
----------------------
问题描述
==========================================================
当连接远程ORACLE服务时出错.
我的操作为
----------------------
1.打开 ORACLE "Net Configuration Assistant "工具
2.选择 "本地NET服务名配置 "
3.选择 "添加 "
4.选择 "ORACLE 8i或更高版本数据库或服务 "
5.在[服务名:]输入 "SYNTEST "
6.选择 "TCP "
7.在[主机名:]输入 "218.**.***.** ",选择 "使用标准端口号1521 "
8.选择 "是,进行测试 "
出现错误提示: "ORA-12533:TNS:非法的ADDRESS参数 "
网上查阅资料,将本地tnsnames.ora文件中[标记(1)]处改为
(ADDRESS = (PROTOCOL = TCP)(IP = 218.**.***.**)(PORT = 1521))
再次测试
出现错误提示: "ORA-12541:TNS:没有监听器 "
==========================================================
弄了半天了,也查了些相关资料,但问题还是没能解决.
希望大家多多帮忙...先谢了...
[解决办法]
服务器上没有监听218.***那个IP？在服务器上cmd中执行netstat -an，看看218.***的1521端口是否监听了。还有客户端的sqlnet.ora文件的内容。
