Oracle精简版客户端,有需要的朋友可以下载。异地公司的电脑上用TNSPING测试一下网络状况,可是却发现如果不装ORACLE客户端,TNSPING根本就无法执行。而要在异地装个ORACLE客户端,又谈何容易,几乎就是恶梦,安装程序压缩后是453MB,安装过程也是费时费力,我仅仅想测试一下网络,需要这么大费周张吗?以后这种需求还多,所就决定把客户端程序重新
安装之后请修改你的tnsnames.ora文件的内容 如:
# TNSNAMES.ORA Network Configuration File: C:oracleora90networkadmintnsnames.ora
# Generated by Oracle configuration tools.
#sample
#DATABASENAME =
# (DESCRIPTION =
# (ADDRESS_LIST =
# (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
# )
# (CONNECT_DATA =
# (SERVICE_NAME = servicename)
# )
# )
ORACLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.17.107)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = nobody)
)
)
ORACLEBCV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.140.188)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = msf)
)
)
REPORT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 9.83.70.14)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = report)
)
)