oracle 之客户端配置
1.拷贝客户端文件
拷贝instantclient_11_2文件夹至某目录我这里直接放在d盘为例
?
2.配置客户端的环境变量
TNS_ADMIN
D:\instantclient_11_2
?
3.配置sid文件
instantclient_11_2/tnsnames.ora
其中第一个dev名称是本地的名称
第二个dev则是远程数据上的实例必须匹配
dev =
?(DESCRIPTION =
???(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.3.243)(PORT = 1521))
???(CONNECT_DATA =
?????(SERVICE_NAME = dev)
??? )
? )
?
4.tnsping
Ping远程的oracle数据库实例 其中ais192为本地的实例名称
[quee@localhost ~]$ tnsping ais192
TNS Ping Utility for Linux: Version10.2.0.1.0 - Production on 12-OCT-2012 15:25:15
Copyright (c) 1997, 2005, Oracle.? All rights reserved.
Used parameter files:
/home/quee/oracle/product/10.2.0/db_4/network/admin/sqlnet.ora
?
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS= (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521)) (CONNECT_DATA =(SERVER = DEDICATED) (SERVICE_NAME = ais192)))
OK (10 msec)
