配置了几次还是老忘记在此做个记录.
1.首先下载需要用的instantclient_11_2: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
2.在环境变量中配置:
NLS_lANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK(注意中间有空格,这个如果不设,toad查询中文会是乱码)
TNS_ADMIN=D:\oracle\instantclient_11_2
Path=...;D:\oracle\instantclient_11_2
3.在把你上面下载的instantclient_11_2解压假设解压在D盘目录是:D:\orcle\instantclient_11_2新建目录network,在network目录下再新建admin目录,在admin目录下新建文件tnsnames.ora,使用文本编辑器打开写入如下内容:
MWDB=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.58)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = MWDB)
)
)
HOST是远程ip地址,PORT是端口号,SERVICE_NAME 远程实力名.
以上步骤做完就到配置PL/SQL打开PL/SQL Developer
到工具找找到首选项配置连接配置Oracle主目录名与OCI库就是按照目录的解压进行配置.
配置后重启PL/SQL Developer 输入用户名密码.