因为plSql 是32位,所以InstantClient也要用32位的,不管你的系统是32位还是64位!!!!!!
安装完InstantClient后,在安装目录如:E:\app\Administrator\product\11.2.0\client_1中建立NetWORK文件夹,再在该文件夹下建立ADMIN文件夹,在该文件夹下建立文件:tnsnames.ora
内容位:
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.65)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
结合本配置修改!