- 首先准备个软件,去oracle官网下载instantclient-basic-nt-12.1.0.2.0.zip,一定要下载32位的哟
地址:http://www.oracle.com/technetwork/topics/winsoft-085727.html
下载plsql,这个百度找一下,很好找的
在instantclient-basic-nt-12.1.0.2.0.zip解压出来,放在一个目录下,笔者就假设放在d盘吧,路径为:d:/instantclient
在instantclient目录下面增加network/admin/目录,并在该目录下面增加个tnsnames.ora文件,内容如下:
orcl = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = name) ) )
同时创建sqlnet.ora,文件内容如下
SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
配置环境变量:TNS_ADMIN指向:d:/instantclient
- 打开PL/SQL,Tools–>Preferences,配置Connection的Oracle Home和OCI library,分别指向d:/instantclient和d:/isntantclient/oci.dll
- 重新启动plsql,登录