1.将客户端程序解压到电脑中
2.配置环境变量:
ORACLE_HOME=F:/instantclient_10_2/client
Path加上%ORACLE_HOME%/bin;
NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
3.修改
%ORACLE_HOME%/network/admin下的tnsnames.ora文件
dev = # <--自己取得名字
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.50)(PORT = 1521)) # <--IP数据库名
)
(CONNECT_DATA =
(SERVICE_NAME = test) # <--实例名
)
)
4.运行PLSQL